Announcements
Hi,
I'm helping the implementation process on my workplace for Nav 2016, and we're facing a huge problem on which our consultant says that there's no way to solve this.
First let me explain with details what we're trying to setup;
Let's imagine that I'm charging the customer for a service performed for import license for of goods, and as per my price list I've established that, a Min and Max price will be applied depending on the commercial value of the goods being imported...
So let's say that for every goods importation I want to charge my client for license issuance with Min Price of $150 and Max of $1000, calculating this by taking only 0.25% of commercial declared value of the cargo;
So lets say the cargo value is $20'000; it will be $20'000 x 0.25% = $50, meaning that Min Price will be applied, so on my Invoice I'll charge $150 to my client.
Now let's see if the cargo has another value, let's say $200'000, it will be $200'000 x 0.25% = $500, meaning that Min Price is not applicable and we will charge on my Invoice $500.
Finally if the cargo has a value of $430'000, it will be $430'000 x 0.25% = $1'075, meaning that, we'll not apply this value, neither the min Price, but the Max Price will be applied ($1000), considering that it exceeded the margin of minimum and maximum values that I established to be charged to the customer on the price list for this specific item.
Considering the examples above, our consultant said that Nav 2016 can't do these calculations, and that the columns Min. Price and Max. Price on the Sales Price List are just for information purposes... I think that he's very wrong, and I attempted to insert the data on the columns myself and the results were sadly not the expected ones... Our consultant also
says that "%" as a unit of measure is also for information purposes, and that the system doesn't consider % as a unit of measure itself...
I really don't know what to do anymore, and I really need some help !
Thank you
*This post is locked for comments
Hi,
I believe your requirement is doable in NAV, however it really depends on your current setup and process.
It is hard to give recommendation because we don't know your daily operation, your business, or how you use NAV.
This is why it is quite important to have a good partner who understands your business well.
Is this consultant / developer a partner or your company in-house developer ?
If he is an in-house developer, he might not have proper knowledge or NAV developer license to do this.
Hello
Thanks for replying to me; where and how can we develop such function? I can ask to our consultant/developer @ my workplace, because he will claim (lie) that it is not possible at all, so I have to give him a firm answer and show him that I know where and how our consultant can do this!
Please can you give me instructions?
Thank you
Hi Filipe86,
The Min and Max price in your NAV are not available in standard NAV. It is a customization, so it's hard to tell what the Min and Max price doing in your system without actually looking at your system.
Looking at your requirement, I don't think there is any standard function in NAV that can help you with this. You will need to do customization for it.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156