My Oracle Support Banner

Intrastat - Wrong Amount Calculation (Doc ID 2344695.1)

Last updated on JANUARY 02, 2018

Applies to:

Oracle Supply Chain Globalization - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Inventory Transactions

ACTUAL BEHAVIOR
---------------
Intrastat - Wrong amount calculation

We have an issue with the Intrastat, for the IR-ISO shipment. We have the IR and ISO created in Eaches and the shipment and the receipt is done in CTN UOM, where we have an UOM conversion setup for the item.
Now for this transaction, the Intercompany Invoices are created in Eaches.

But the issue is that for the Intrastat transactions, it uses the "CTN" from the material transaction and the unit price from the Intercompany invoice, and hence cause the issue.
The material transaction is in CTN, while the Intercompany Invoice is in EA. The system does not convert the unit price in EA to CTN before getting the amount.
 
EXPECTED BEHAVIOR
-----------------------
Expect the system to convert the unit price in EA to CTN before getting the amount.
 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create IR / ISO. ISO with UOM Each
2. Shipment and Receipt to be done in CTN
3. Intercompany Invoices are created in Eaches.
4. Run Movement statistics processor > Check Intrastat > System uses the UOM "CTN" from the material transaction and the unit price from the Intercompany invoice for Each.

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


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