The debt closing window sorts records by Due Date. The due date is specified according to the due dates on the lines of the payment plan used. In checks and promissory notes, the due date of the check or P. Note, or the average due date of the slip is processed depending on the parameter.
The Prepayment and Delayed Payment interest rates specified in a payment plan are the monthly interest rates to be applied when the AR/AP debit is paid before or after the specified due date.
The Week Days on the payment plan indicate payment or collection days. If the date resulting from the payment plan is an unchecked day, the payment is done at the next checked day.
Number and amount of payments for the transaction related to the payment plan can be entered on the lines of the payment plan as fixed amounts, or depending on certain parameters. Due dates can be specified for these amounts.
The discount to be applied for payments done before the due date specified in the payment plan is specified on the Discount Rate field of the related line.
Certain numeric functions can be used on the Formula column of the payment plan in addition to parameters and fixed amounts. This column indicates the amount to be paid.
The Condition column can also be used on plan lines in addition to the formula. This column is used to specify the validity conditions of the related line. Parameters, arithmetical and logical functions can also be used on this field.
Functions and parameters can be specified on the window accessed by pressing the F10 key on the Formula and Condition fields. Available functions and parameters are:
Numeric Functions
Name |
Description |
MIN ( , ) |
Returns the parameter with the lower value. |
MAX ( , ) |
Returns the parameter with the higher value. |
DIV ( , ) |
Indicates the integer part of the division result. |
MOD ( , ) |
Displays the remainder of the division. |
Abs ( ) |
Shows the absolute value of the number. |
Logical Functions (Conditions)
Name |
Description |
And |
AND (If all the conditions are true) |
Or |
OR (If at least one of the conditions is true) |
> |
Greater than |
< |
Smaller than |
>= |
If greater or equal |
<= |
If smaller or equal |
= |
If equal |
<> |
If different (not equal) |
Available Parameters
Name |
Description |
P1 |
Transaction Amount (VAT incl.) |
P2 |
Transaction Amount (VAT excl.) |
P3 |
Total VAT |
P4 |
Remaining Amount |
P5 |
Paid Amount |
P6 |
Surcharge Amount |
P7: Transaction Day |
For example, generates the value 31 for the invoice dated 31/12/94 |
P8: Transaction Month |
For example, generates the value 12 for the invoice dated 31/12/94 |
P9: Transaction Year |
For example, generates the value 94 for the invoice dated 31/12/94 |
P10: Transaction Date |
For example, generates the value 941231 for the invoice dated 31/12/94 |
Attention: The invoice date format is yy/mm/dd (year/month/day), and brackets are not used. Comparisons should be made using appropriate values such as <, > and =.
Attention: New parameters and functions are not displayed on the window accessed by pressing the F10 key on the Formula field.
Example:
If the invoice amount is greater than 10.000.000 TL, 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.)