E1: 76A: Incorrect Currency Code Used in Calculation of Tax on Last Line of Record Written to ARG Tax Amounts Table (F76A18) (Doc ID 2909599.1)

Last updated on APRIL 17, 2024

Applies to:

Symptoms

With AR localization active, a sales order is raised with ARS domestic and USD foreign currency. After the invoice process has executed (R42565 calling R76A565) the amount for domestic tax written to the F76A18 table is incorrect on 1 line only.

Steps to Duplicate:

1.  Configure the AR tax system with the required rates/groups/invoice letters etc – P76A10 and P76A15. Attach the tax rate defined in P4008 to a USD customer. The order will be raised in an ARS branch.
2.  Note: the client follows a special procedure with order entry and invoicing (in the standard software, no custom) to handle situations where payment is made in advance of product delivery.
3.  Sales order is generated with 3 lines of the same item. Line 1 represents the advance payment and is at 100% of the item price. Quantity used is +1 EA. Line 2 is raised the same way as line 1, the same item and also +1 EA. Line 3 is raised with +1 EA but the foreign unit/extended price   is changed to a negative value.
4. Once the order is saved, line 1 is invoiced alone through R42565/R76A565 and the invoice is sent to the customer.
5. Lines 2 and 3 are invoiced together, possibly weeks after the payment has been received from the customer. Same process in R42565 and R76A565.
6. Lines 2 and 3 effectively cancel each other out due to the amount being positive on line 2 and the same amount being negative on line 3.
7. Tax is calculated and recorded in F76A18. No issue in line 1 that was invoiced alone. F76A18 shows the incorrect value in the field for domestic tax amount on line 3.  The amount represents the correct tax percentage, and is negative (correct) but is in the USD (foreign) currency, when it is expected to be in the domestic currency ARS. As a result, the domestic and the foreign tax fields show the same amount.
8. The R76A566 PDF for lines 2 and 3 shows that tax is calculated on the net zero amount, and shows a figure equal to the ARS tax, minus the USD tax. For example, if the ARS tax figure is 10000 and the USD tax is 1000, the tax value would display as 9000.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.