Dynamics Recurring Journal Tips/Tricks

Recurring Journal Tips/Tricks

Use one of the following methods to post an entry on the last day of every month after the current month:

• Post the first entry on the last day of a month and enter the formula
1D+1M-1D (1 day + 1 month - 1 day). With this formula, the
program calculates the date correctly regardless of how many days
are in the month.

• Post the first entry on any arbitrary day of a month and then enter the
formula: 1M+CM. With this formula, the program calculates one full
month plus the remaining days of the current month.

NOTE: If posting monthly accruals that must be reversed the following month (Reversing Fixed, Reversing Variable, and Reversing Balance methods), post them on the last day of each month. The first entry must be posted on the last day of the current month and the Recurring Frequency must be either 1D+1M-1D or 1M+CM. This makes sure the reversal is always posted on the first day of the following month.
 
Document Number Formulas

Instead of using a number series to determine the Document No., Microsoft Dynamics provides the option to enter a formula to create a document number for each posted entry that is then automatically updated every time that the recurring journal is posted.

NOTE: Posting No. Series specified on the batch overrides manual document numbers. To use the formulas, make sure that the Posting No. Series field on the batch is empty.

Simple text can be combined with the following text codes to form a number series:

• %1 - The current day number
• %2 - The current week number
• %3 - The current month number
• %4 - The current month name
• %5 - The current accounting period name

For example, if the entry's document number is R (rent) + current month, enter
R%3 in the field. The document number for January will then be R1.

NOTE: The Document No. field supports up to 20 alphanumeric characters.
Consider this limitation when creating formulas.