Transactions Workbench: Line Level Adjustment On Invoice Causing Incorrect Line Level Balances
Last updated on JANUARY 22, 2016
Applies to:Oracle Receivables - Version 12.0.0 and later
Information in this document applies to any platform.
Form:ARXTWMAI.FMB - Transactions
Query or Enter an invoice, Save and Complete.
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:
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
3.Then approve the adjustment by logging as as another user.
Line level balances in ra_customer_trx_lines_all shows :
amount_due_original amount_due_remaining acctd_amount_due_remaining
100 108.33 108.33
200 216.67 216.67
Line level adjustment is prorating adjustment amount to both the lines instead of
applying to Line 1. Expectation is that the adjustment amount should be applied against
Line#1 and not all the lines.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms