AR9.2.Collection Workbench Doesn't Show Balance Forward On Statement PDF For An Item That Has An Activity On It And A Balance Forward (Doc ID 3008834.1)

Last updated on MARCH 06, 2024

Applies to:

Symptoms

When creating a Customer statement and Printing It for an item that has an activity on it and a Balance forward and then going to check it to Collection workbench >Correspondence tab , the Statement image PDF report showed for that statement doesn't show the balance forward amount.


The issue can be reproduced at will with the following steps:

1. Create a new customer 0000050046( Customers> Customer information>Create customer information) and set the Statement ID Model on Correspondence options.

2. Go to Setup Financial>Product Related>Receivables>Payments>define statement ids for Model and set the Type=Bal Fwd .

3. Create a new item for the customer ( AR>Pending Items>Online items>Online Item group entry ) and set it to Batch priority .Item has item date and accounting date of 22 sep 2020.

4. Run Ar update process (Ar>Receivables Update>Request Receivables Update).

5. Check item in customer account ( AR>Customer Accounts>Item Information>item list).

6. Run customer statement with a new run control , with As of date 30 sept 2020 and balance forward date of 30 sept 2020.

Only check Balance forward and choose Ps/AR Statement Preprocessor. (AR>Customer Interactions>Statements>Create customer statements).Statement 86 generated.

7. Run Print Statement with the same run control as above and choose XMLF Balance froward statement Bi Publisher ARX32001(AR> Customer Interactions>Statements>Print Statement).The item created above appear as it has it due date expired.

8. Run 2nd customer statement with a new run control, but with As of date 31 dec 2020 and balance forward date of 30 sept 2020.

Only check Balance forward and choose Ps/AR Statement Preprocessor. (AR>Customer Interactions>Statements>Create customer statements). Statement 87 generated.

The customer should not have any activity on items happened after the 1st run of customer statement.

9. Print the 2nd statement with the same run control as above and choose XMLF Balance froward statement Bi Publisher ARX32001(AR>Customer Interactions>Statements>Print Statement). Balance forward appears.

10. Pay the item on October-Create a deposit ( AR>payment>online payments>regular deposit) .

11. Apply worksheet ( AR>Payment>Apply payments>Apply payment worksheet) and set to batch priority.

12. Run AR update ( AR>Receivable Update>Request receivable update).

13. Check Customer account ( AR>Customer Account>Account overview).

14. Run Customer statement with As of date 31 dec 2020 and Balance forward due date as 31 oct 2020.

15. Print statement .Notice that the report is showing both the balance forward and the activity of the item .

16. Go to AR>Collection workbench and search for the customer 0000050046.

17. On correspondence section, check the last statement 88 on Statement Image.

Balance forward is not showing as it is appearing in the PDF file generated by Print Statement XMLP Balance Forward Statement ARX32001.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.