Unit Quantity Is Worngly Calculated In ALC Component Screen
(Doc ID 2877742.1)
Last updated on JANUARY 15, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version NA and laterInformation in this document applies to any platform.
Symptoms
While reviewing ALC, In the ALC Component Screen under components, the quantities are wrongly calculated.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create or find existing import order and use from existing
In Order Country if sourcing is "US"
Currency = NZD
Import Country = NZ
Frieght Terms = 03 (FOV)
Lading Port = AHK - Airfrieght Hong Kong
Discharge Port = AKL - Auckland, NZ
Partner = 10077 (<PARTNER_NAME>)
Order Details
1 Item
Qty = 100
unit cost = 10
Total Ord Cost = 1000
Order Expenses
2 components
Per Unit Count = CBM (usually container)
Based on item dimensions it has volume and sets the Value (seen below)
Value is: 0.0387 and 2.2219 which equals 0.0606
Because there are 100 items, and Value is .0606.
Expenses are then 6.06
Also has Duty of 10.00
Approve the Order
2) Ship Order fully
3) Create Transportation (Import Management / Transportation)
Shipment method = Vessel, Container
Vessel V_605121
Voyage/Flight = F_605121
Enter Delivery Date (2/1/2022)
Container = C_605121
Order = 605121 (was order number customer used)
Input Item
Input Qty as 100
Enter any value for Commercial Invoice - Customer used - CINV_605121
Enter Date - 2/1/2022
Click on Calculate for Amount Value (customer value = 1000)
Click OK button
Now at Transportation Screen
Select "More Options", and choose "Shipment"
At Transportation Shipment Screen
Click "+"
Window pops us, select row and click OK button
Save and Close
4) Create Obligation (Import Management/ Import Financials)
Select Level = Trans Vessel/Voyage/ETD
Select Vessel value used prior
Select Voyage/Flight used prior
Select EST. Departure Date
Expand Invoice and Payment section
Invoice = NM_605121
Invoice Date = 2/1/2022
Partner = 10077 (same as order)
Currency = NZD (New Zealand)
Exchange Rate = 1 vs NZD
Components Section
Click "+" to add component
Select Same component as was in Expenses
Defaults all by Amount, enter 5 for Amount (remember at Order level this was 3.00 for 100 qty) - So on Invoice instead of estimated 3.00, it will be 5.00 as that is the actual value
Again Select next same component as was in Expenses
Defaults all by Amount, enter 5 for Amount (remember at Order level this was 3.00 for 100 qty) - So on Invoice instead of estimated 3.00, it will be 5.00 as that is the actual value
Now can see total expense is 10.00 in Component Section
Click Approve Button
then click Save and Close
5) Go to Review ALS (Import Management/ Import Financials)
Have not received as of yet, but can still review ALC
Select Order Number, click Search Button
Click On Order No Link
Opens ALC Screen
All totals are correct , except for values within Transportation Related Obligations/ Entries
Quantity - 0.192 - This is incorrect should be 100
Because of this
Variance is incorrect
Unit Actual is Incorrect
Unit Estimated IS correct
System Options:
Under Import Management
Allocate Shipment Level Obligations Using = ASN
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 |
Cause |
Solution |
References |