This is from a shipment with two lines on it
Line 1 Product A Quantity Received 320 Rate 36 Amount 11520 (USD)
Line 2 Product B Quantity Received 525 Rate 18.40 Amount 9660 (USD)
Exchange rate used on both lines is 1.7415
I have two landed cost lines on the shipment
Freight 660 NZD
Import Costs 9271.57 NZD
Total Landed costs of 9931.57 both lines are associate to Product A and B using an allocaiton method of Value.
When i look at the landed costs that have been assigned to the Receipts the value is $5712.73 which with the exchange rate of 1.7415 equals $9948.72
I cannot work out if Netsuite is using a different exchange rate and if so where is it getting it from
Anyone able to provide the calcuation that is being done in the allocation of landed costs with currencies so i can confirm the numbers
