web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Sales Prices - Customer Discounts

(0) ShareShare
ReportReport
Posted on by 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

I have the same question (0)
  • Community Member Profile Picture
    on at

    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"

  • Suggested answer
    Aleksandar Totovic Profile Picture
    16,765 on at

    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.

  • Ian Fletcher Profile Picture
    2,445 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans