Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
What is the calculation to determine Landed cost by Value?
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
0