RE: Trade Agreement Price Issue
1. AX searches for Trade agreement lines in a special way. First, it looks if the customer has a price for that item, then (if the customer has a price group) it looks if that customer price group has a price for the item. Finally, it looks if there is an All customer price for the item.
Around this, there are some other rules.
- It only looks for prices which are active in the 'Activate price/discounts' form.
More on these two topics here: technet.microsoft.com/.../aa575310.aspx
- The inventory dimensions of the order line must match the trade agreement line (controlled by the setting 'For sales prices' on the dimension group setup form)
technet.microsoft.com/.../hh209317.aspx
- The currency of the order must match the currency on the trade agreement line.
- The quantity on the order must be between the From and To quantity on the trade agreement line (I can't remember if the unit is important too, or if AX converts the price appropriately).
- The date of the sales order must fall between the From and To date of the Trade agreement line (and the A/R parameter 'Date type' is important for this).
If you're not using quantity breaks, or the dates are blank, then these rules don't apply.
At some point, though, could find multiple records that apply (e.g. if you have two 'All' customer prices for an item, with no quantity breaks or Dates set). In this case, AX will find the 'first' one it comes to. This could be the one that was created first. And then it looks at the 'Find next' tick box. If it is not ticked, it uses that price. If it is ticked, it keeps looking. If the next record has a lower price, it will use that one. And if that record has 'Find next' ticked, it will keep looking....
2. If you have multiple records which could apply, but the newer one's should apply in preference to the older one's, you need to set a 'To' date on the older records so that they expire.
3. Because 'Find next' will always allow AX to find the lowest price.
Share
Report
All responses (
Answers (
28,638
