We have a NAV 2009 DB and we have two currency exchange rates we use.
We have a Sell Rate and a Purchase Rate.
The problem: The system is double applying both currency rates and giving BOTH rate adjustments to our customers. This is not good.
- The Parts Sell rate is what we sell to the customer at, for example USP of 1.2866 - the adjustment is applied to the sell amount at the time of sale.
- And a Purchase Rate that we purchase parts at of USD of 1.27 (We purchase parts at this rate) for example, when we purchase parts from the US we apply the 1.27% rate.
Example: When we import the parts catalog with pricing, the system applies either a Sell or Purchase rate when we sell or buy a part. We don’t know when but the system started applying BOTH rates when we sell, in effect giving US customers a double discount.
If the part list price is $19.15 it would apply the USD rate of 1.27% and then the USP rate of 1.2866% for a total price of $11.71. But the price should only be $14.88.
Does anyone know how this should work, or why it’s applying both the Sell Rate and Purchase rate on the parts catalog pricing?