The payment calendar can be opened with the Payment Calendar from the button bar. After pressing the button, the contract payment calendar opens:
The functions (Post, Cancel, Posting Preview, Navigate, Split Down Payment) of the payment calendar are described in Invoicing Sales.
Field:
Payment No.
Sequential Payment No. (Three-Digit)
The down payment is number 000
Instalments subsequently with an increment of +1
Date From
Start of Payment Period
Fills the system automatically
For the down payment: it is the handover date of the object
For First Payment=Contract Calculation Start Date
Subsequent Payments Contract Model Setup
Date To
End of repayment period
Fills the system automatically
For the down payment: it is the handover date of the object
It is determined in relation to the peridity of repayments
Posting Date
Fills the system automatically according to the contract model settings
For the down payment: it is the handover date of the object
VAT Date
To give VAT payments, the system fills the contract automatically according to the contract model settings
Maturity date
Does the system fill automatically:
For down payments: Due Date=Posting Date
For installments: Billing Date+Date Formula from Contract Payment Terms Code
For Sales Line: Posting Date+Date Formula from Contract Sales Price Payment Terms Code
Document No.
Does the system fill automatically when a payment is posted
Document No. under which the payment was posted
Mass invoicing
Fills in the system automatically if the payment is invoiced via mass invoice (e.g. Per Customer, Utilisation in OL and GMP)
It is used in operational leasing/fleet management
Charged
Does the system fill automatically when posting a payment to A
Canceled
Does the system fill up automatically when cancelling an installment on A
Blocked
The hidden field is only mentioned for the sake of completeness. If an accrual line is posted and a due payment has not yet been posted, the system will block this payment.
Locked
The hidden field is only included for the sake of completeness. Through the calculator lines, it is possible to block unposted lines so that they are not recalculated.
Individual Tax Document
It is filled to A if part of the down payment is posted by an individual invoice (used in financial leasing).
Instalment Amount
Fills up the system automatically
Payment to be paid, the sum of all payment items
Rounding according to the Total Rounding Code on the Contract Model
Amount Excl. VAT (Amount Excl. VAT)
Instalment Value Excl. VAT
It is not a physical field in the table, but a variable on the pagi (overview)
It fills in the system automatically by adding values to the variable:
Amount Exl. VAT= Principal + Interest + Insurance + Deposit + Service + Selling Price + Simple Fee
Payment Balance
Fills up the system automatically
Payment Balance Value, displays the Balance of the given payment from Customer Ledger Entries
When clicked, an overview of customer entries opens with a filter for the given document number, Open=A and Posting date of the payment.
Annuity Excl. VAT
Fills up the system automatically
Sum of Principal+Interest
Principal
Fills up the system automatically
Principal Payment in the Given Monthly Payment
Rounding according to the Part Payment Rounding Code on the contract model
Interest
Will the system automatically add VAT
Interest Payment in Given Monthly Payment
Rounding according to the Part Payment Rounding Code on the contract model
VAT Amount Principal
Will the system automatically add VAT principal
Amount VAT Interest
Will the system automatically add VAT interest
Insurance
Fills up the system automatically
For insurance via the insurance module: value=Liability insurance amount + Accident insurance-amount + Other insurance-amount
For simple insurance: the value is calculated from the contract header and rounding according to the Insurance Rounding Code on the contract model
Liability Insurance Amount
Fills up the system automatically
From the client payment schedule of the third-party liability insurance contract
Accident Insurance-Amount
Fills up the system automatically
From the client's payment schedule of the accident insurance contract
Other Insurance-Amount
Fills up the system automatically
Sum of Client Payment Schedules of Supplementary Insurance Contracts
Services
Fills up the system automatically
For services via Service Contracts: value=sum of the payment schedules of the applicable services in the given month
For simple insurance: the value is calculated from the contract header
Rounding for standard and simple service according to Service Rounding Code on contract model
After clicking, the Service Payment Line report opens with a filter for Financing Payment No. – the user can see the structure of the total amount of the Service.
Circuiting Differences
It fills the system automatically if Total Rounding Code=not empty is set on the Contract Financing Model:
Rounding differences = Amount (i.e. rounded payment to be paid) – with accounting for non-rounded payment items ( Principal + VAT Principal + Interest + Amount VAT Interest + Insurance + Amount VAT Insurance + Deposit + Amount VAT Deposit + Service + Amount VAT Service + Selling Price + Amount VAT Selling Price)
Principal Balance (Begin)
Calculated using calculation lines
Principal Balance (Trailing)
Calculated using calculation lines
Debt Balance
Calculated using calculation lines
Principal Balance
Calculated using calculation lines
Change in Purchase Price
To be completed by wizard during technical evaluation in financing
Basis for VAT Special Regime
Fills in the system automatically if the calculation is in a special VAT mode
It is used in financial leasing
VAT Amount for VAT Special Mode
Fills in the system automatically if the calculation is in a special VAT mode
It is used in financial leasing
Selling price
Fills in the system automatically if the sales price is included in the calculation
It is used in financial leasing
Amount VAT Selling Price
Fills in the system automatically if the sales price is included in the calculation
It is used in financial leasing
Financing Contract No.
The system will automatically fill in the contract number
Calculation Interest Rate % (p.a.)
When creating or recalculating the contract, the system automatically fills in the currently valid value of the calculation interest from the contract header for unposted installments
Interest Margin %
Adds OC automatically when creating a Payment Accrual Contract from an equal field from a leasing contract for unposted payments
Interest Margin
It calculates the OC when creating (deploying) the contract payment calendar, or recalculates it each time the payment calendar is recalculated on unposted installments:
Interest Margin = (Interest Margin % / Calculation Interest Rate % (150)) * Interest (16)
Gen. Prod. Posting Group
Completes the system automatically from the financing contract
VAT Posting Group Principal
Completes the system automatically from the financing contract
VAT Posting Group Interest
Completes the system automatically from the financing contract
Number of Assigned Advances
Not used
Currency Factor
Hidden field, filled by the system automatically when deploying the contract payment calendar on unposted lines of type Payment (a Posted=N)
Currency Factor = 1/Contract Exchange Rate
Lease Payment Total (hidden technical field)
The hidden field is filled in automatically by the system after the validation of the Amount field, which occurs during the validation of every single field that enters the calculation of the Amount field
Lease Payment Total = Principal + Interest + Insurance + Service + Simple Fee + Selling Price
It is used to calculate the calculated field 400 "Lease Payment Total" in the contract header – it calculates the value from all lines of the Contract Payment type. The field from the header is then used on the Contract Statistics page and in the Master Agreement table, where it calculates how much is the total amount for all installments of the customer.