Two Currency Rates - Sell Rate and Purchase Rate

Business Central/NAV
1

Hello!
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?

image
image926Ɨ311 65.6 KB

2

Mia,

Base NAV 2009 does not have a field called Purch. Currency Code. This was a customization by your NAV Partner who implemented you. I would contact them to correct the issue.

Thanks,
Steve

2 Likes
3

Welcome to the forum, @Mia_Ball!

1 Like
4

So is ā€œPurchase Currency Codeā€ just renamed? Should the field function as the buy currency code, vs the Sell currency code?
Does Microsoft have ā€œgoodā€ documentation on the fields and their functions for any version of NAV/BC?
Iā€™m finding it impossible to find good docs on functionality for any version of NAV.

thank you, Mia

5

Mia,

The image you provided looks like a custom field and functionality. Base BC/NAV does not have these field. Do you know your Partner to ask about the fields?

As for Microsoft and currency documentation, basic FX processing and fields there are good manuals and if needed I can send you one.

Thanks,
Steve

1 Like
6

I verified that nav 2009 does have this field. It does not appear to be custom. Any other thoughts?

7

Mia,

Do me a favor and tell me what screen (page) you are on in your pic? I know in the Vendor Pricing you can define Currency Code for an Item/Vendor combination.

Thanks,
Steve

8

Hi Steve,

Itā€™s in the data exchange process card for what we call the price tape catalog upload. On the details tab there is a currency code field and a purchase currency code filled both Fields have a base now have identification number. I canā€™t get to my 2009 database at the moment Iā€™ll try to follow up when I can

9

Mia,

OK, now Data Exchange Definition is a standard feature but since you said ā€˜What we call the Price Tape Catalog Uploadā€™, that is a customization. Your upload must use these fields to populate or calculate values that are stored in Base NAV, the Vendor Catalog price or Sales Price (Customer).

You might to contact the Partner who installed NAV for you to discuss this customization. If you want to chat on Teams, feel free to email me at steven.chinsky@wipfli.com

Thanks,
Steve