Incorrect Tax Amount In India Tax Details Form At Shipment When Delivery Is Completed in LOT (Doc ID 3036137.1)

Last updated on SEPTEMBER 18, 2024

Applies to:

Symptoms

Tax Amount is getting mismatched at Shipment when Freight Line is used in Taxes with Tax Type as Unit of Measure which is different from the Unit Of Measure (UOM) used in the Sales Order and Shipment is done in lots whereas it is expected that Tax Amount should be same as what has been calculated at Sales Order.

The issue can be reproduced at will with the following steps:
1. Navigate to India Local Order Management->Oracle Management->Order/Returns->Sales Order->Create Sales Order.’
2. Create Sales Order with UOM as Dozen (DZ) instead of Primary UOM which is Each (Ea).
3. Go to India Tax Details and apply taxes to it which includes Freight Tax with Tax Type setup as UOM.
4. Book the Sales Order.
5. Go to Shipping Transaction Form and Launch Pick Release. This will be shipped in Lot so next step is to Transact Move Order.
6. Go to Inventory Responsibility->Move Order->Transact Move Order.
7. Select the Line and allocate it.
8. Select the Line and click on View/Update Allocations. After that click on Lot/Serial.
9. Give the Lot Details and click on Done. Create 2 lots each with 120 quantity in Ea(10 in DZ).
10. Transact the Order.
11. Go to Shipping Transaction Form in Order Management Responsibility.
12. Go to Delivery->View->India Tax Details Page and verify that 2 Det Factor Lines are coming both with 20 qty but line amount is showing as 300. For first line price is also showing as 25 instead of 300.
13. Ship Confirm the Delivery and verify India Tax Details Page again. Price is changed to 300 for first line but the issue is quantity should show as 10 only in both the lines.
Since quantity is showing as 20 in both lines, freight amount is showing as 2400 for both det factor lines instead of 1200. So the tax amount which was 2880 in Sales order showing as 5880 in India Tax Details of Shipment.
14. Run Workflow Background Process and Auto Invoice Master Program which will create AR Transaction.
15. Go to Transaction Workbench and verify the data in India Tax Details Page. Everything is correct and same as Sales Order which is expected behavior.

Cause

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