Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

Dynamics NAV 2016 Sales Price List - Min. Price and Max. Price not working on Planning Lines

Posted on by 15

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

  • TeddyH Profile Picture
    TeddyH 12,861 Moderator on at
    RE: Dynamics NAV 2016 Sales Price List - Min. Price and Max. Price not working on Planning Lines

    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.

  • Filipe86 Profile Picture
    Filipe86 15 on at
    RE: Dynamics NAV 2016 Sales Price List - Min. Price and Max. Price not working on Planning Lines

    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

  • Suggested answer
    TeddyH Profile Picture
    TeddyH 12,861 Moderator on at
    RE: Dynamics NAV 2016 Sales Price List - Min. Price and Max. Price not working on Planning Lines

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans