Unified Operations & Dynamics AX Forum

Expand all | Collapse all

Help Needed Setting Up Odd Payment Terms

  • 1.  Help Needed Setting Up Odd Payment Terms

    TOP CONTRIBUTOR
    Posted 17 days ago
    ​Good morning friends!

    I need some help. We have a customer who has gone to an odd payment terms scheme and I am having trouble determining how to set it up in AX 2012 so we get their invoice due dates to calculate correctly.

    Essentially, they are taking all invoices from the 16th of month 1 to the 15th of month 2 and paying them on the 5th WORKING day of month 4.

    For example, invoices from 16 March 2019 through 15 April 2019 will be due 7 June 2019.

    The attached chart may help explain it.


    So, I need to figure out how to group the invoices correctly to calculate the due date and I need to figure out how to exclude weekends and holidays from the possible due dates (the latter is less concerning - we can live with it if the due date happens to fall on non-business day if we have to). Right now, we aren't even getting it to calculate very close.

    ------------------------------
    Steve Latta
    Accountant
    Ortec, Inc.
    Easley SC
    ------------------------------


  • 2.  RE: Help Needed Setting Up Odd Payment Terms

    GOLD CONTRIBUTOR
    Posted 17 days ago
    have you tried combination of both payment calendar and terms of payment with payment days?
    what's your existing setup?

    ------------------------------
    Regards
    Rahul Mohta
    Advisor - #D365FO
    Real Dynamics
    California, USA
    ------------------------------



  • 3.  RE: Help Needed Setting Up Odd Payment Terms

    GOLD CONTRIBUTOR
    Posted 16 days ago
    Hi Steve,

    The issue with the fixed due date based in time frame is that this feature can be set but only for payment dates, not for due dates. Is such a strange scenario because normally the vendor determines the due dates, not the customer. The only solution is assign the due dates manually or develop a job to apply those parameters according to that calendar. 


    ------------------------------
    Michael Gonzalez
    Account Executive
    Dynamics Resources
    Venon Hills IL
    ------------------------------



  • 4.  RE: Help Needed Setting Up Odd Payment Terms

    TOP CONTRIBUTOR
    Posted 16 days ago
    ​Michael, that's the normal scenario. However, we are seeing more and more instances where larger (think Fortune 500) customers are dictating their terms to the vendors - take it or leave it. In most cases so far, it's merely been extending terms from 30 to 60 to 90 days. However, we have a couple who are doing either something like this or where the terms are nominally Net 60, but they only make payments twice per month. That doesn't really change the due date from our perspective, though it does impact our cash flow planning.

    In this example, their terms are actually driving the due date to this schedule and we'd like to find a way to make it accurate without a manual process or customization. That doesn't seem like a possibility, but I never hurts to ask.

    ------------------------------
    Steve Latta
    Accountant
    Ortec, Inc.
    Easley SC
    ------------------------------



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