My Oracle Support Banner

Unit Quantity Is Worngly Calculated In ALC Component Screen (Doc ID 2877742.1)

Last updated on JUNE 20, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information 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


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