D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Terms of Payment - Seasonality

  • 1.  Terms of Payment - Seasonality

    Posted May 03, 2018 10:29 AM
    Hello AXUG Peeps,

    I have a client who has seasonal terms.  We have been able to resolve the terms when it is 5 days past the year end but we have a term that is due the 11th period on the 5th day.  I have tried using Year, Month and Net but have not figured out the combination.  Do any of you have similar terms setup?

    I know we can have the term date set on the Sales order but they would like to remove the 'Human" interface with the terms.

    Thank you in advance!


    Stacy Black
    Senior Application Consultant
    MCA Connect
    Denver CO

  • 2.  RE: Terms of Payment - Seasonality

    Posted May 04, 2018 01:55 AM
    Hello Stacy,
    Not sure if I got this right.
    If I invoice a customer let's say on Jan 1st 2018, then the due date should be Nov 5th 2018?
    And if the invoice is posted on Jan 20th 2018, then the due date should also be Nov 5th 2018?
    Is that right?
    Would be great if you can share the one or the other example.
    Many thanks and best regards,

    Ludwig Reinhard

  • 3.  RE: Terms of Payment - Seasonality

    Posted May 04, 2018 05:10 AM
    Hi Stacy,

    I have not seen an option for this. What is a 11th period here? Is it the same as calendar months or an own definition (e.g. periods of 4 weeks)?
    I'm afraid, you have no option out of the box. Consider a customization or leave it as a manual task to update the correct date.

    kind regards,

    André Arnaud de Calavon [Designation]
    Kaya Consulting
    The Netherlands

  • 4.  RE: Terms of Payment - Seasonality

    Posted May 08, 2018 01:17 PM

    Hi Stacy,

    Unfortunately, what it sounds like you're looking for out of standard AX's Terms of payment, is a date range (= window for seasonal purchases) with a fixed due date. There's no oob combination, that I see, that gives you that flexibility. You could certainly set up a series of prox terms to calculate to a payment due date of 11/5 (if that is what is meant by "11 period") and select the next subsequent one as the transaction dates progress from one month to the next, but then you'd probably do just as well to enter the due date per order.

    So, if I'm interpreting your issue correctly, what you really need to satisfy your client's seasonal purchase requirement is a mod to the Terms of Payment that allows for the selection of a "Fixed due date". Its probably not that complicated of a mod and, if this requirement is part of their continuing business design, it would be well worth the investment.

    Would be interesting to know if you find an alternative solution.

    Randy Alexander
    Credit & Accounts Receivable Manager
    Tyler Pipe Co. a Div. of McWane, Inc.
    Tyler TX

  • 5.  RE: Terms of Payment - Seasonality

    Posted May 07, 2019 09:09 AM
    Hello Ludwig,

    Yes, you have that correct.  The clients fiscal year starts March 1st.  Their requirement would be to have the invoices that are issued prior to November 5th of any year, be due on November 5th of the following year.

    Invoice date               Due
    3/1/19                        11/5/19
    10/1/19                      11/5/19
    11/6/19                       11/5/2020

    Thank you,

    Stacy Black
    Senior Application Consultant
    MCA Connect
    Denver CO

  • 6.  RE: Terms of Payment - Seasonality

    Posted May 08, 2019 08:18 AM

    This is indeed a modification.  I also had a similar one to handle ProxTerms which is not doable natively in AX/D365..  I actually designed and had Both coded last year for several customer running AX2012 with different business requirements.  It is definitely something that MSFT should consider as I am seeing it more and more.

    I would also advise you to consider a modification around the vanilla payment schedule logic.  Also, you will want to consider a modification aspect to the cash discount whereas in some cases the cash discount logic is an element to the PROX and the seasonal schedule that makes this a bit more complicated.  Bit it is all doable,

    Hope that helps.

    Troy Jones
    Functional Systems Architect / Consultant
    Hi-Vue Solutions, LLC
    Akron OH

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