E1: 47: EDI Invoice Additional Header (F470461) Tax Fields Are Incorrect Populated For Multiple Tax Rates in Sales Order (Doc ID 2925853.1)

Last updated on SEPTEMBER 19, 2024

Applies to:

Symptoms

EDI Invoice Additional Header - Outbound (F470461) fields:
Tax Auth 3 (TA3), Tax Auth 4 (TA4), Tax Auth 5 (TA5),
Tax Rate 2 (TXR2),
Sales Tax Total 1 (TAX1) and Sales Tax Total 2 (TAX2)
are incorrect populated when multiple tax rates are used in one sales order.

Steps:
1. Set in P4008 2 taxes with the same name and Tax Authority but different values and different item numbers (one with blank and one with 6).
2. Set one item with Sales Taxable = 6 and one with 'Y' in P41026
3. Create sales order with P4210 and add this tax
4. You may check P4210 - Row Exit - Online Invoice - Form Exit Tax Summary that taxes are added OK
5. Create shipment confirmation
6. Enable EDI in R42565 and execute. Check F470461:
All Tax Auth have been populated instead of only 1 and 2
Only Tax Rate 1 has been populated with one of the values, Tax Rate 2 should also be populated with second tax rate
Only Sales Tax Total 1 was populated with the sum of both taxes. Sales Tax Total 1 and Sales Tax Total 2 should be populated with each tax amount, not summed up.

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.