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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans