R12: AP/ZX: Tax Line Amount is Not Calucalated as Expected Amount When Using Control Amount
(Doc ID 2556235.1)
Last updated on JANUARY 30, 2023
Applies to:
Oracle Payables - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
When using CONTROL_AMOUNT in invoice header, one of tax line is not calculated as expected amount.
Example)
Invoice is created with Tax Rate 8% and CONTROL_AMOUNT 79 JPY like below.
Invoice Header
Amount: 1041 JPY
Tax Control Amount: 79 JPY
Invoice Lines
Line #1: 251 JPY
Line #2: 250 JPY
Line #3: 231 JPY
Line #4: 230 JPY
Item Lines Total: 962 JPY
When Control Amount field is entered for an invoice, the tax rounding rule is recorded as 'NEAREST' regardless of the Rounding Rule setup.
And the tax amount(UNROUNDED_TAX_AMT) is calculated as ( LINE_AMT * (CONTROL_AMOUNT / LINE_AMT )).
Hence, as per the above rule, tax lines should be calculated with NEAREST rounding rule like below.
Line | LINE_AMT | ( LINE_AMT * (CONTROL_AMOUNT / LINE_AMT )) | UNROUNDED_TAX_AMT | Rounded Tax Amount (NEAREST) |
1 | 251 | 251*(79/962) | 20.612266... | 21 JPY |
2 | 250 | 250*(79/962) | 20.530146... | 21 JPY |
3 | 231 | 231*(79/962) | 18.969854... | 19 JPY |
4 | 230 | 230*(79/962) | 18.887734... | 19 JPY |
However, actually those tax lines are created in ZX_LINES and Tax distributions with the following amount.
Tax Line #1 20 JPY
Tax Line #2 21 JPY
Tax Line #3 19 JPY
Tax Line #4 19 JPY
Why the tax amount for Line #1 is calculated as 20 JPY which is different from expected amount: 21 JPY.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |