For a recent training session on the general ledger in Microsoft Dynamics 365 Business Central, I covered recurring journals with the client. One of the requirements, for accruals, is that the journal be posted on the last day of the month.
If every month was of an equal length this would be quite easy to do using a date formula of 1M, but they aren;t so a more complex date formula is required.
To post the journal on the last day of a month, every month, the date formula required is 1D+1M-1D, which means add 1 day, add 1 month and subtract 1 day from the posting date. With this formula Business Central calculates the date correctly regardless of how many days are in the month.
What should we write about next?
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.