Share via


Recurring Frequency Field, Gen. Journal Line Table

Specifies 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.

Tip

For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.

Parent Tables

Table Location
Gen. Journal Line Table General Ledger
Posting No. Series Field, Gen. Journal Line Table General Ledger
Posting No. Series Field, Gen. Journal Line Table General Ledger
Posting No. Series Field, Gen. Journal Line Table General Ledger
Gen. Journal Line Table General Ledger
Posting No. Series Field, Gen. Journal Line Table General Ledger

See Also

Reference

General Journal

Other Resources

How to: Enter Dates and Times
CALCDATE Function (DATE)
Work with General Journals