You’re offline. This is a read only version of the page.
30
I am rather new to NAV and we sell products that are offered to 3 Customer price groups. Also in 2 currencies. In short every product have 6 prices. Set up in Special prices.
My question is how does one work with price lists with this setup, the easiest way?
Our goal is to create on demand price list for one Currency and one Customer price group.
For example. We want to create a price list for a RESELLER with their specific prices. But in the list we would like a column with Recommended Retail price. Same way most prices lists to resellers will look. How can we create that?
Using Export to Excel by filtering two different Customer price groups and then pasting them together after splitting merged sells is just not a simple way and very time-demanding.
Any help in how to work with price lists in a good way will be appreciated.
Thanks,
Fredrik
*This post is locked for comments
I have the same question (0)
Our company generate a lot of special prices, mostly customer specific but we do have some group-based ones also.
Especially for the customer-specific ones we have a similar requirement to generate a report (for the customers) to show the special price against what would have been the RRP (and RRP less standard discount). There's no standard NAV report which would do this but I've achieved it through Jet Reports. It would be possible to replicate the functionality directly in NAV or with another reporting tool.
However it's done, the report needs to read the Sales Price table (7002) for the Customer (or group) pricing and then for each line it needs to read the same table again for the 'RRP' prices which apply for the same date range.
Currency hasn't been a concern for me so far but as it's a column in the Sales Price table it wouldn't be difficult to consider that too.
If you use (special) price discounts as well then you're adding another layer of complication of course but the same logic would apply.
Share
Report
All responses (
Answers (
