Transactions Not Included In Generate Balance Forward Billing
(Doc ID 1470119.1)
Last updated on JULY 10, 2020
Oracle Receivables - Version 12.1.3 and later Information in this document applies to any platform.
Attempting to run the Generate Balance Forward (BFB) billing program for Jan-12 after an upgrade to 12.1.3.
Some customers (23 customers), all the transactions during the period are not included. There were two customer accounts identified with the differences.
Example: Customer # XX outstanding balance as per Aging report is <19,894.39> But the outstanding balance in Consolidated Billing is <4,790.25> The total difference is <15,104.14>
The number of credit memo transactions included in BFB invoice is 17, but actually during Jan-12 for the customer there were 23 Credit Memos created. Six (6) credit memos are not included.
The total of the six (6) credit memos is <28,437.04>. But there are three (3) RECEIPT_ADJUST tranaction types created in the AR_CONS_INV_TRX_ALL table that amount to <13,332.90>. The net difference is exactly <15,104.14> (28,437.04-13,332.90)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!