You’re offline. This is a read only version of the page.
Announcements
5
I have a customer that pays all invoices from a two week period, 8 days later.
For example:
Invoices dated 3rd Jan - 16th Jan are paid 24th Jan
Invoices dated 17th Jan - 30th Jan are paid 7th Feb
Is there a date formula i could use as payment terms to reflect this?
Hi, just add some information.
https://yzhums.com/1517/ (sorry it's japanese)
Hope this will help.
Thanks.
ZHU
Hi
Kim provided out of the box solution but it requires user manual entry.
To automate the process you need development. Something like a code that knows the beginning of 2 weeks and end of it. Then adjust the due date based on these date.
Another method is not invoice them and wait for the last day of period then change the date on all and invoice. Or look into Power Automation for auto invoice/post. Something like https://joshanglesea.wordpress.com/2020/07/31/business-central-batch-post-and-e-mail/ that can run every other week then change the date and invoice this customer (if you have shipped SO)
This one is hard, each payment terms can only provide you with one due date calculation.
You would have to manually chose your due date for either the first timeframe or the second because only one can be a default.
Payment Terms Options, the closest that I could get, setting the due date calculation.
CM-7D would give you the 24th for the 7 months with 31 days but the 25th for the 4 with 30 days
CM+7D calculates for the 7th of the next month - so this works always.
Not the answer you were looking but maybe it helps.
Another thought is to setup a payment terms that does something really bizarre to the date as an indicator for the user to change to the 24th of the month.....
Good luck
#1
André Arnaud de Cal...
294,110
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
