Recurring Frequency field formula(s)

what date formula do i enter in the recurring frequency field if i want to post a recurring journal entry on the first day of each month? or first day/ last day for every 2 months?

Help Says:

Enter a recurring frequency if it is indicated in the Recurring field of the General Journal Template table that the journal is a recurring journal.

The contents of the Recurring Frequency field determine how often the entry on the journal line will be posted. The field must be filled in.

The recurring frequency formula can contain a maximum of 20 characters, consisting of numbers and the letters, that the program recognizes as abbreviations for time specifications.

For example, if the journal line must be posted every month, enter “1M”. After every posting, the date in the Posting Date field will be updated to the same date in the next month.

If you want to post an entry on the last day of every month, you can do one of the following:

  • You can 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 there are in the month.

  • You can post the first entry on any arbitrary day of a month and then enter the formula: 1M+CM. With this formula, the program will calculate one full month + the remaining days of the current month.

Appreciate this Mohana…:slight_smile: thnx