E1: 03B: Voids, Zero Open Amounts, And Data Selection On Statement Notification Refresh (R03B500X)
(Doc ID 1995523.1)
Last updated on DECEMBER 27, 2019
Applies to:JD Edwards EnterpriseOne Accounts Receivable - Version XE and later
Information in this document applies to any platform.
The goal of this article is to show you how you can take out the default data selection on the void flag, or any data selection you may have added to exclude paid invoices, and what steps you need to take after changing these data selections.
The default data selection on Statement Notification Refresh (R03B500X) is the following:
Void Flag (F03B) (VOD) [BC] not equal to “1”
In addition, you can implement either of the following data selection to exclude paid invoices from appearing on statements:
- Amount Open (F03B11) (AAP) [BC] not equal to Zero
- Pay Status (F03B11) (PST) [BC] not equal to “P”
Note: the recommended data selection to exclude paid invoices is the second, as the first might also exclude zero amount open invoices that you may want to show on statements.
If for whatever business reason you need to remove any of the above-mentioned data selections, please be aware that this will cause all records that were previously excluded from the customers’ statements (from inception) to now appear.
However, this will happen only the first time you run R03B500X after changing the data selection(s). This is because the Control/Statement (CTL) and Statement Date (SMTJ) fields in the Customer Ledger (F03B11) and in the A/R Check Detail (F03B14) tables have blank values for these records. This will cause the Amount-Previously Due (PAD) value in the A/R Notification History (F03B20) and A/R Notification History Detail (F03B21) tables for the statement to be incorrect.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document