When Using Tax Control Amount And Entering Multiple Item Lines, Click Calculate Tax Between Item Line Entry: The Tax Amount Is Prorated Wrongly And Invoice Goes On 'Tax Amount Range' Hold (Doc ID 1569193.1)

Last updated on AUGUST 31, 2016

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Goal

When creating a Payables invoice with a Tax Control Amount AND midway through entering the lines, the tax amounts do not get prorated as expected. So when the invoice is validated, it goes on 'Tax Amount Range' hold.

Steps of scenario
1 - Create Invoice num XXX of amount 200.04 with Tax Control Amount 15.04.
2 - Enter one Item line of amount 100.00 with TCC '10% AP' (rate amount 10%)
3 - Hit 'Calculate Tax'; this creates one Tax line (Line 2) of amount 15.04.
4 - Enter two more Item lines: one of amount 50.00 with with TCC '10% AP', the other of amount 35.00 with TCC 'Free AP' (rate amount 0%).
5 - Hit 'Calculate Tax':
- Line 2 (the tax line) disappears
- Two new Tax lines created: one of amount 11.29, the other of amount 3.75. Both are stamped with Tax Rate Name '10% AP' but the Tax Rate values show 11.2875049900... and 7.504990019960...
Customer advises "...the tax amounts are not prorated correctly"
6 - Validate the invoice: it goes on 'Tax Amount Range' hold (Invoice tax amount does not fall within range)


Solution

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