The payment date information is recorded on the day, month and year columns of payment plan lines. These fields are used as follows.
They can be left blank: In such cases, the Day, Month and Year information at the invoice date is applied. All three columns or one column can be left blank. In such cases, the invoice date is applied only for the column(s) left blank. In other words, if the Month column is blank, the month of the invoice is applied.
A fixed value can be entered: Fixed values can be entered into the all or each of the Day, Month and Year columns. If a fixed value is entered, the column is no longer variable. For instance, if "12" is entered on the Month column, the date of the plan line is fixed on December. Day and Year information can be changed.
A number can be entered along with a "". Entering a "" character on a column means that the number typed after the + will be added to the Year, Month or Day of the transaction date. For example, if "+5" is entered into the day column, it indicates five days after the invoice date.
Likewise, if "+1" is entered into the month column, it indicates one month after the invoice date.
A number can be entered along with a "". Entering a "" character on a column means that the number typed after the - will be subtracted from the Year, Month or Day of the transaction date. For example, if "-15" is entered into the day column, it indicates fifteen days before the invoice date. Likewise, if "-6" is entered into the month column, it indicates six months before the invoice date.
Week information can be entered using the "H" character (on the DAY column): The number entered after the "H" indicates the day of the week, and the number entered before indicates the week of the month. For example, "H2" is entered for Tuesdays. "3H4" indicates the 3rd Thursday of the invoice month. Entering +2H1 indicates the Monday two weeks after the transaction date (including the invoice date if it's Monday).
The usage examples of the Day, Month and Year columns are provided below:
Description | Day | Month | Year |
|---|---|---|---|
30 days after the invoice date | +30 | ||
15th of the month following the invoice date | 15 | +1 | |
One year after the invoice date | +1 | ||
The first Tuesday after two months from the invoice date | H2 | +2 | |
The second Wednesday after the invoice date | + 2H3 | ||
The last Friday of the invoice month | 4H5 | ||
The second Thursday of April | 2H4 | 4 | |
The third week of the invoice month | 3H | ||
On Monday of the 3rd week after the invoice date | + 3H | ||
20th of the month before the invoice date (Invoice date included) | 20 | -1 |