Transactions Workbench: Line Level Adjustment On Invoice Causing Incorrect Line Level Balances
(Doc ID 1391125.1)
Last updated on FEBRUARY 11, 2019
Oracle Receivables - Version 12.0.0 and later Information in this document applies to any platform.
Form:ARXTWMAI.FMB - Transactions
Nav=>Transactions=>Transactions Query or Enter an invoice, Save and Complete. Actions=>Adjust
Create a line level adjustment for a specific transaction line, allocates the adjustment amount incorrectly to all the lines instead of the specified line. This happens only when the adjustment is created with status 'Waiting for Approval' ie. adjustment amount is outside approval limits and then approved later by another user.
Line level balances are correct if the adjustment is created with status 'Approved' ie. adjustment amount is with in the limits.
Steps to Reproduce:
Transaction Source setup: ========================== Source: Manual-Consult Generate Line Level Balances = Y
1.Created invoice# 505274 with 2 lines, 100$ and 200$ 2.Created line level adjustment for Line#1 for $25.00 with status 'Waiting for approval'. 3.Then approve the adjustment by logging as as another user.
Line level balances in ra_customer_trx_lines_all shows :