Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Steve Latta]

?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
——————————

[Rahul Mohta]

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
——————————
——————————————-

[Michael Gonzalez]

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
——————————
——————————————-

[Steve Latta]

?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
——————————
——————————————-