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