E9.2: Statutory Report ARX80016 Is Displaying Incorrect Opening Balance Amount (Doc ID 2651191.1)

Last updated on SEPTEMBER 29, 2024

Applies to:

Symptoms

Statutory Report ARX80016 Is Displaying Incorrect Opening Balance Amount

Steps:

Set Up Financials/Supply Chain /  Install / Installation Options / Billing Integration Options / Billing - GL/AR Options BI Creates GL Acct Entries;
- Create invoice with accounting date 01/01/2018;
- Create second invoice with accounting date 02/03/2018;
- Create invoice with accounting date of 03/09/2018;
- Run Single Action Invoice;
- Create Deposit Payment with Accounting Date of 05/24/2018;
- Create payment worksheet and apply the deposit to first and second items
that come from BI system ;
- Create new Billing invoice and run Single Action invoice;
- Run Journal Generator for AR and BI transactions;
- Run Statutory Reports / Extract Data for Reports / Statutory Reports for
each period: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 for AR and BI;
- Run Statutory Reports/ Accounts Receivable / Transaction Detail by Customer for year 2018, Account 120000, Customer ID 0000050046; Ending Balance is 300 USD;
- Run Statutory Reports / Extract Data for Reports / Statutory Reports for
each period: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 for AR and BI, Year 2019;;
- Run Statutory Reports/ Accounts Receivable / Transaction Detail by Customer for year 2019, Account 120000, Customer ID 0000050046;
Beginning Balance is 600 USD which is different than Ending Balance 300 USD which is not correct.

Information used in the replication are demo values, not customer specific info.

Cause

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