Prices in £ and $ from single Trade Price in NAV

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi all,

I hope some can assist me.

I have a Trade Price in NAV, from a Unit Cost with an added profit percentage. From this Trade Price I can apply a 'Customer Discount Group' for example 30% discount and this will rightly take 30% from my Trade Price for that particular customer.

For example: my item costs £100 and after discount £70.

Now, this customer wants to begin trading in US dollars. I have a GBP/USD conversion rate in NAV (for arguments sake and wishful thinking 1.5 means the customer will pay $150 USD for my £100 item). I want to apply a further customer discount group to this dollar price (say 10%) but unsure how I would do this, and how NAV would pick that up from my Trade Price (which is in GBP). Any help is appreciated. Thank you.

I am using NAV 2013 R2 and do not have access to the back-end of the software.

*This post is locked for comments

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Prices in £ and $ from single Trade Price in NAV

Thank you Suresh,

I will give this a go.
Verified answer

Suresh Kulla 44,614 on at

Like (1)

Report

RE: Prices in £ and $ from single Trade Price in NAV

You can use Sales Prices and Sales Line Discount functionality which you can set it on Item -> Sales Prices/Sales Discounts on those pages the currency code by default is not visible but can add that field and specify different prices or discounts based on the currency.

Check this link to check how to set prices/discounts

www.softwareanswers.co.uk/.../set-item-sales-prices-and-discounts-in-microsoft-dynamics-nav-2015.html