Presetting Periods and Dates

The following date and period details can be preset for a journal line using Journal Presets (JNP):

  • accounting period
  • transaction date
  • value date
  • due date.

The period and dates can be preset on a journal line in three different ways:

  • as the current date or accounting period
  • as an absolute date (e.g. dd/mm/yyyy) or period value (ppp/yyyy)
  • as a relative value.
Note:  Absolute dates can only be used by Gregorian calendar users.

Using Relative Values

Relative values are calculated from the equivalent date or period that appears on the base line in the journal.

To preset a date or period using relative values, you can enter +nnn or -nnn in the date or period field, where nnn represents a number of days or periods before (-) or after (+) the base date or period.

For example, +002 would mean two days or periods after the date or period on the base line.

You can also preset the date or period using a combination of current and relative dates. For example:

  • C+003 would mean three periods after the current period
  • T-18 would mean 18 days before today's date.

Presetting Due Dates

The due date can be set in the same way as the transaction date. However, there is an additional option TD-Transaction Date. If this field is set to TD+nnn or TD-nnn, nnn days after or before the transaction date is used.

When presetting transaction and due dates, you can also use a suffix of M-Months to add or subtract months, and a suffix of N-Net to add and subtract months and adjust to the last day of the month. For example, if today's date is 17 January, then T+3M gives a transaction date of 17 April, whereas T+2N gives 31 March.

Note:  The due date can also be calculated from the payment terms associated with a debtor, creditor or client account.