Transactions Not Included In Generate Balance Forward Billing
(Doc ID 1470119.1)
Last updated on FEBRUARY 03, 2019
Oracle Receivables - Version 12.1.3 and later Information in this document applies to any platform.
Attempting to run the Generate Balance Forward billing program for Jan-12 after an upgrade to 12.1.3.
Some customers (23 customers) e.g., 32ZJOH000001, 46ZBAR000003, all the transactions during the period are not included. There were two customer accounts identified with the differences.
Customer # 46ZBAR000003 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!