1. They Can Be Left Blank: In such cases, the day, month and year information at the transaction date is applied. All three columns can be left blank, or one or two of them can be filled in. In such cases, the transaction date is applied only for the column(s) left blank.
For instance, if the month column is blank, the month of the invoice is applied.
2. A Fixed Value Can Be Entered: Fixed values can be entered into 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. However, the day and year information can be changed.
3. 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 instance, "+5" entered on the day column indicates 5 days after the transaction date. Likewise, +1 entered on the month column indicates 1 month after the transaction date.
4. 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 instance, "-15" entered on the day column indicates 15 days before the transaction date. Likewise, -6 entered on the month column indicates 6 months before the transaction date.
5. Week Information Can Be Entered On The Day Column Using "H" Character: The number entered after the "H" indicates the day of the week, and the number entered before indicates the week of the month. For instance, H2 is entered for Tuesday, while 3H4 is entered for the 3rd Thursday of the month. Entering +2H1 indicates the Monday two weeks after the transaction date (including the transaction 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 December |
2H4 |
12 |
|
The third week of the invoice month |
3H |
|
|
The third Monday after the invoice date |
+ 3H1 |
|
|
20th of the month before the invoice date |
20 |
|
|
Payment / Collection Plan Line Examples
Example 1:
If the invoice amount is greater than TL 10.000.000, and if the invoice is issued before the 5th of the month, the following information should be entered into the related fields to collect the invoice amount at 60 days:
The Formula field: P1
The Condition field: (P1>10.000.000) AND (P7<5)
The Day field: +60 (This number is explained in the following section.)
Example 2:
If the invoice amount is smaller than TL 20,000,000, and if the invoice is issued on the 15th of the month, the following information should be entered into the related fields to collect the invoice amount after 3 months:
The Formula field:P1
The Condition field:(P1<20.000.000) AND (P7=15)
The Month field: 3
Example 3:
If the invoice amount is greater than TL 5,000,000, and if the invoice is issued before the 5th of the month, the following information should be entered into the related fields to collect the surcharge amount on the second Wednesday after the invoice date:
The Formula field:P6
The Condition field: (P1>5.000.000) AND (P7<5)
The Day field + 2H3