Transactions Workbench: Invoice Applied to Deposit Created 3 Adjustments Only One Is Used To Calculate The Balance of Invoice
Last updated on OCTOBER 05, 2017
Applies to:Oracle Receivables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Deposit was a migrated Transaction that was generated prior to the implementation of ccid_change_flag
Invoice that is applied to a Deposit Generates three (3) Adjustments. Only one (1) is applied to the Invoice Balance.
Steps to Reproduce:
Responsibility: Receivables Manager
1. Generate Deposit : Transactions > Transactions
Enter in Deposit Type Transaction for 1000.00 and Save.
2. Post Transaction to General Ledger.
3. Access Deposit via Transactions > Transactions Form > Query Deposit
Click on Distributions Button at bottom of Form.
Change the CCID of the Revenue Line to a new value and Save.
4. Post Transaction to General Ledger.
The deposit will show three (3) Revenue Lines with the changes that were made.
The following query will show the record details:
From the script above you will see that the ccid_change_flag will have two (2) records with 'N' Value and one (1) record with 'Y' value.
The 'N' Values are what it use to be and the offset accounting Entry and the 'Y' flag will be the current value.
When the invoice is applied to a Deposit that does not have these flags populated, it will generate one (1) adjustment record under the Invoice for each of the Revenue Rows of the Deposit that has either null or 'Y'.
Since the migrated deposit did not have these flags populated, it generated three (3) rows.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms