Recurring Frequency Field, Item Journal Line Table

Specifies a recurring frequency if it is indicated in the Recurring field of the 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
Document Line No. Field, Item Journal Line Table Inventory
Item Journal Line Table Inventory
Item Journal Line Table Inventory

See Also

Reference

Item Journal