Hi,
I have a query on how the landed cost is calculated using weight allocation.
Consider a case where there are two purchase orders with 3 items.
We have created an inbound shipment for the same and added the landed cost.
NetSuite creates two item receipts.
One item receipt with item 1 and another with item 2 and item 3.
The details are below.
In the NetSuite Inbound Shipment record,
Only one landed cost category is given.
Total Landed Cost entered in one category = $1,634.02 in USD
Item 1: Qty = 120, Transaction Unit = 500/OUTER, Item Weight in item record in KG = 0.0281 kg, PO Rate = 49.25, Amount = 5,910.00, Currency = US Dollar (Purchase Order #1, item receipt #1)
Item 2: Qty = 97, Transaction Unit = OUTER, Item Weight in item record in KG = 0.043 kg, PO Rate = 65.00, Amount = 6,305.00, Currency = US Dollar (Purchase Order #2, item receipt #2)
Item 3: Qty = 121, Transaction Unit = OUTER, Item Weight in item record in KG = 0.035 kg, PO Rate = 52.00, Amount = 6,292.00, Currency = US Dollar (Purchase Order #2, item receipt #2)
In NetSuite inbound shipment record, the values calculated for Unit Landed Cost. Can you please check and let us know how the system calculates these values:
item 1: 0.60443973
item 2: 4.79499209
item 3: 3.90290075
The purchase order is in USD also.
But the Subsidiary base currency is NZD currency.
Please let us know If you guys need any additional information.
Thank you in advance for the help.
