D365 Finance & Operations and Dynamics AX Forum

 View Only
  • 1.  To Quantity & To Date in Trade Agreements

    Posted Nov 02, 2021 08:01 PM
    Hello, I would like to ask is this a default behaviour of the system to ignore the upper limit i.e. To Quantity & To Date in the trade agreement when trying to get prices on purchase Lines & Sales Lines?
    I set up the Purch(price) for Item A as From Quantity = 0 and To Quantity = 100 and amount as 25. this is working from 1 to 99 but when I input quantity as 100 it is making the unit price zero(there is no price defined elsewhere for this item)
    thank you!!!!

    Ali Asghar
    Rapiscan Systems

  • 2.  RE: To Quantity & To Date in Trade Agreements

    Posted Nov 03, 2021 12:07 PM
    Hi Ali,

    Yes, the from quantity value is inclusive and the to quantity value is exclusive.

    Originally, these values were both treated as inclusive and would expect a gap in your trade agreement journal lines for tiered pricing e.g.: 1-100 $2, 101-500 $1.

    This behavior changed around May 2020 in version 10.0.6 or 10.0.7 and D365 will no longer allow you to post your trade agreement journal if there are gaps. So you'd have to use: 1-101 $2, 101-500 $1

    I only know this because we had to update a bunch of tiered pricing during a version upgrade when this change hit and I had logged a ticket with Microsoft to confirm the expected behavior.

    Kirk Anger
    London ON

  • 3.  RE: To Quantity & To Date in Trade Agreements

    Posted Nov 03, 2021 06:56 PM
    Thank you Kirk.

  • 4.  RE: To Quantity & To Date in Trade Agreements

    Posted Nov 04, 2021 05:29 AM
    Pretty awful behaviour for a price book! Microsoft again adding complexity where it is not needed.

    Joe Hailey
    Mibis Solutions Ltd

If you've found this thread useful, dive deeper into User Group community content by role