Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Problem with line discount

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi All,

I have a question in regard to trade agreements in AX12 R3 CU10.

We normally set the discounted sales price for a particular customer and item through posting trade agreement journals. We also use line discount percent for customer groups. In case there is no discounted sales price in trade agreement, the system should apply the discount percent to the item base price.

All products and variants in our system have base sales price which is also posted as a trade agreement journal (blanket TA).

The line discount trade agreement, associates the item line discount group to customer line discount group.

There is an issue with how the line discount percent applies to sales order line:

When adding sales lines, the system always applies the customer discount percent, regardless of whether a special sales price for that customer exists or not. The discounted sales price in trade agreement is supposed to override the line discount percent. However, the system applies both discount percent and discounted sales price to the order line.

The logic says where there is a discounted sales price for a customer against an item, the search for a lower price should stop once the trade agreement is found. I have tried various combinations of “Find Next” flag in trade agreements, but to no avail.

We need to apply the line discount percent to group of items and link that to customer groups. It makes the changes much easier when updating the discount levels.

Any other combinations in “Activate price/discount” works just fine, but item group to customer group.

Any help with this, would be highly appreciated.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Problem with line discount

    Thanks guys. We’re not utilising retail pricing because we have no retail store.

    The only solution I can think of would be this:

    If the account code in price agreement which has been found for that specified item in sales line is equal to “All”, then apply the line discount percent to the sales line. Otherwise, do not apply the line discount percent.

    Any idea how I can achieve that through coding?

  • Guy Terry Profile Picture
    Guy Terry 28,638 Super User 2024 Season 2 on at
    RE: Problem with line discount

    I do not believe it is possible to direct AX to use a particular Line discount, based upon the sales price it has decided to use. At least, I don't know of a way to do this in the sales module. It might be possible using Retail pricing.

  • Mark Prouty Profile Picture
    Mark Prouty 1,310 on at
    RE: Problem with line discount

    The sales price record is processed first, followed by line discounts, followed by multiline, finally total discount. The "Find next" should be on the sales price record. This should stop the pricing logic chain there. If no sales price record, the next available record for processing should be Line discount.

    I wonder if you have pricing tables cached (preloaded)? They should not be, but I otherwise don't know why changing discount settings would not be effective.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,661 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,379 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans