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