Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Sales Prices - Custome...
Microsoft Dynamics NAV (Archived)

Sales Prices - Customer Discounts

(0) ShareShare
ReportReport
Posted on by Ian Fletcher 2,445

Nav 2009 R2

We have had a request that for a certain customer for them to have an a 5% discount on all orders that they place from today until the end of 2013, but not to change any existing Orders.

This customer currently receives discounts anyway which are entered at the Sales Line level depending on what has been agreed with that customer and their Account Manager.

As example, Item A they currently receive a 20% line Discount for this item, but for the rest of the year they require a 25% discount.

What is the best way of doing this?

I have looked at Customer Item Discounts - but this does not add up correctly when also used with a Line Discount as it treats them separately & calculates this as 20% discount & then 5% of the discounted price rather than 25% of the unit price

Is the only way for this just to add 5% manually to whatever discount has been agreed?

The Account Manager did ask if this extra 5% discount could be showed separately to identify the extra discount

Any suggestions?

 

*This post is locked for comments

  • Ian Fletcher Profile Picture
    Ian Fletcher 2,445 on at
    RE: Sales Prices - Customer Discounts

    Hi, we cant make customisation, as we are an end user so do not have the permission to do this.

    We are going to use the Comment Line, but also go with the route of applying the Line Discount first of all, to bring their opriceto the normally agreed Price & then use the Customer Item Discounts to show then the extra discount

    Thanks

  • Suggested answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at
    RE: Sales Prices - Customer Discounts

    As Savatage said, this is not possible as you want. If you want you have to make some customization.

    You need to remove two lines from OnValidate on 'Line Discount Amount' and 'Line Discount %' fields for 'Inv. Discount Amount' calculation. Also, you need to modify next Code Units (remove 'Inv. Discount Amount' calculation):

    -Release Sales Document

    -Sales-Post

    After that you can first run Function->Calculation Invoice Discount and after that add Line Discounts.

    Or you can create completely new functionality.

    But I think, it is the best solution to use standard NAV functionality and explain to your customer process of discount calculation in NAV.

  • Community Member Profile Picture
    Community Member on at
    RE: Sales Prices - Customer Discounts

    Unfortunately I think you have to add the 5% to the existing line discount.

    Line & invoice discounts don't appear to play well with each other.

    $1.00 * with 25% line discount = $0.75

    ($1.00 * with 20% line discount) * additional invoice discount of 5% = $0.76

    You can always add a comment line that says "Additional %5 Discount has been applied to this order"

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans