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