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

[Steve Latta]

Good morning!?

I’m trying to learn how to use the vendor payment proposal process and I have a question.

We have a Method of Payment-Check set up. The Check method of payment has the period set to Total.

This means, when I generate a payment proposal, the payment date is based on the invoice due date. For example, if I run the proposal with the following parameters:

From date: (blank)
To date: August 8, 2018
Minimum date: August 3, 2018

The payment proposal generated includes dates 8/3/18, 8/4/18, 8/5/18 and 8/6/18. The 4th and 5th are Saturday and Sunday, so it really doesn’t make sense to generate additional checks for due dates which fall on weekends, but I otherwise DO want payments to be generated by vendor based on their due date, so anything due 8/3 or earlier would be on the 8/3 line of the proposal and the items from 8/4 – 8/6 would be on the 8/6 line of the proposal for that vendor, if that makes sense.

Is there a setting somewhere to set working days for AP that the payment proposal will use and whether it rounds the due date up or down to a working day?

#AX2012 #Finance #UnifiedOperations
???

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

[Ludwig Reinhard]

Hello Steve,
Have you tried implementing payment calendars?
See e.g. https://technet.microsoft.com/en-us/library/jj677355.aspx
Best regards,
Ludwig

——————————
Ludwig Reinhard
Sycor
Goettingen
——————————
——————————————-

[Steve Latta]

?Ludwig,

Thank you! That is exactly what I was looking for.

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

[Steve Latta]

?Well, that was a bit of short-lived excitement.

I do not have Payment Calendars as a menu item in either Accounts Payable or Accounts Receivable.

There is a Calendars menu item under Organization Administration>Common>Calendars, but this seems to be exclusively for setting up working days.

Under Accounts Payable>Setup>Payment, I have the following menu items:

• Terms of payment
• Cash discounts
• Payment schedules
• Payment days
• Payment fee
• Methods of payment

We’re on AX 2012 R3 CU 11, so the TechNet article seems to imply we should have it, unless it was depreciated with one of the CU’s. It’s also remotely possible I don’t have a role required to see it. That seems unlikely. I have verified with one of our system admin’s, and she does not have that menu item visible either.

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

[Steve Latta]

It seems I’m not the first to have this problem. Payment calendars are only available for certain countries, and United States is not among them.

https://community.dynamics.com/ax/f/33/t/245231

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

[Ludwig Reinhard]

Hello Steve,
The thing with the country limiatation seems right for AX2012.

In D365FO payment calendars seem to be available for all countries.
Probably talk with a dev colleague to assess whether you can make this feature generally available.
There do not seem to be too many country-restrictions in place on the underlying tables and methods and it seems feasible to make payment calendars available also for your country environment.
Yet, a detailed analysis is certainly necessary.
Best regards,
Ludwig

——————————
Ludwig Reinhard
Sycor
Goettingen
——————————
——————————————-

[Zvika Rimalt]

Steve, I am curious to learn the reason printing a cheque for a non-working day presents an issue?
My assumption is that cheques never gets cashed anyway on the way that they were issued, hence the original cheque date carries little importance?

——————————
Zvika Rimalt
Functional Consultant
Vancouver BC
——————————
——————————————-

[Steve Latta]

?Zvika,

A bit of this is simply for my own understanding of the process and the options available, so that I can present workable options to my decision makers. The more automation we put into place in the payment process, the smarter we need the system to be in grouping invoices for payment. Currently, that is done 100% manually. It is time consuming and open to errors. I do not want to present a solution which solves one issue while creating another.

In actual use, without Payment Calendars, my current test settings would take 4 invoices with one due each day for a Friday, Saturday, Sunday and Monday and would generate 4 separate checks. It makes no sense for our business process to generate extra checks for Saturday and Sunday if rules can be put into place to round to working days. I’ll concede that printing checks with weekend payment dates doesn’t harm anything, but it doesn’t help in our case, causes additional work for the check signers and could raise questions with our auditors.

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