...
Payment No.
Payment Sequence 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 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 Payment Period
Fills the system automatically
For down payment: it is the handover date of the object
It is determined in relation to the peridity of the instalments
Posting Date
Fills the system automatically according to the contract model settings
For down payment: it is the handover date of the object
VAT Date
The system pays VAT payments automatically according to the settings of the contract model
Maturity date
Does the system fill automatically:
For down payments: Due Date=Posting Date
For installments: Posting date+date formula from Contract Payment Terms Code
For Sales Line: Posting Date+Data Formula from Code Payment Terms of Sales Price with Contract
Document No.
Does the system fill up automatically when a payment is posted
Document number 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, Used in OL and GMP)
It is used in operational leasing/fleet management
Charged
Does the system fill up automatically when posting a payment to A
Canceled
Does the system fill up automatically when cancelling an installment on A
Blocked
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
We only list the hidden field for 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 (Amount)
Fills up the system automatically
Instalment value to be paid, sum of all instalment items
If there is the Contract Header contains flag Leasing with delivery of goods = Yes on the Contract header, the field amount is calculated as Principal+ Interest + Insurance + Deposit+ Services+ Sales Price + Simple Fee + VAT Payment payment upon Delivery delivery of Goodsgoods
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 Part Payment Rounding Code on the Contract Model
Interest
Will the system automatically add VAT
Interest payment in the given monthly payment
Rounding according to Part Payment Rounding Code on the Contract Model
VAT Amount Principal
Will the system automatically replenish the VAT principal
VAT Amount Interest
Will the system automatically add VAT to 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 calendar of the third-party liability insurance contract
Accident Insurance-Amount
Fills up the system automatically
From the client payment calendar 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: value 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 to Financing Payment No. – the user can see the structure of the total amount of the Service.
Circuiting Differences
Fills the system automatically if Total Rounding Code=nonempty is set on the Contract Financing Model:
Rounding Differences = Amount (i.e. rounded payment to be paid) – 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 (End)
Calculated using calculation lines
Debt Balance
Calculated using calculation lines
Principal Balance
Calculated using calculation lines
Purchase Price Change
Adds wizard during technical evaluation in financing
Basis for special VAT regime
Fills in the system automatically if the calculation is in a special VAT mode
It is used in financial leasing
VAT Amount for Special VAT Mode
Fills in the system automatically if the calculation is in a special VAT mode
It is used in financial leasing
Selling price
Fills up the system automatically if the sales price is included in the calculation
It is used in financial leasing
Amount VAT Selling Price
Fills up 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 a contract, the system automatically adds the currently valid value of calculation interest from the contract header for unposted installments
Interest Margin %
Adds OC automatically when creating a payment agreement from an equal field from a leasing contract for unposted payments
Interest Margin
It calculates the OC when the contract payment calendar is created (deployed), or recalculates it each time the payment calendar is recalculated on unposted payments:
Interest Margin = (Interest Margin % / Calculation Interest Rate % (150)) * Interest (16)
Gen. Prod. Posting Group
Replenishes the system automatically from the financing contract
VAT Posting Group Principal
Replenishes the system automatically from the financing contract
VAT Posting Group Interest
Replenishes the system automatically from the financing contract
Number of Assigned Backups
Not used
VAT Payment for Goods Delivery
Amount of VAT to be paid if the Financing VAT flag is set = Yes on the contract header. See below for a description.
Balance of unpaid VAT on delivery of goods
The amount of the balance of the VAT amount to be remitted if the VAT Financing flag is set = Yes on the contract header.
Currency Factor
Hidden field, the system fills in automatically when deploying the payment calendar of the contract to unposted lines of the Payment type (a Posted=N)
Currency Factor = 1/Contract Exchange Rate
Lease Payment Total (hidden technical field)
The hidden field is populated automatically by the system after the validation of the Amount field, which occurs when each and every field that enters the calculation of the Amount field is validated
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 header field is then used in 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
...
Check if the sum of the Amounts is the same as the total down payment (principal).
If not, it will display the message "The sum of the amounts of the new down payment distribution ..... is not equal to the total amount of the down payment ....". And they won't allow it to go any further.
If so, it continues and the lines from the wizard are posted=N inserted into the contract payment calendar:
The line number in the payment calendar is set to be numbered according to the Due Date ascending.
Individual Tax Document=A sets to lines where VAT Date is the previous month, such as Expected Handover Date.
If it is a contract with the Leasing mode active with delivery of goods, the message "After Down payment splitting contract (Leasing with goods delivery)" will be displayed.
At the same time, the Calculation Lines – Updated flag will be set to No