The payment calendar can be opened with the button Payment Calendar from the button bar. After pressing At the touch of a button, the contract payment calendar opens:
The functions (Post, Cancel, Preview Posting Preview, Navigate, Split Down Payment) of the payment calendar are described in Fakturace prodej
Field:
Payment No.
Sequential Payment 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 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 periodPayment 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 repaymentsthe instalments
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 The system pays VAT payments , the system fills the contract automatically according to the settings of the contract model settings
Maturity date
Does the system fill automatically:
For down payments: Due Date=Posting Date
For installments: Billing Date+Date Formula Posting date+date formula from Contract Payment Terms Code
For Sales Line: Posting Date+Date Data Formula from Contract Code Payment Terms of Sales Price Payment Terms Codewith Contract
Document No.
Does the system fill up automatically when a payment is posted
Document No. 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, Utilisation 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
The hidden 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 We only list 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 (Amount)
Fills up the system automatically
Payment Instalment value to be paid, the sum of all payment itemsinstalment items
If the Contract Header contains flag Leasing with delivery of goods = Yes, the field amount is calculated as Principal+ Interest + Insurance + Deposit+ Services+ Sales Price + Simple Fee + VAT payment upon delivery of goods
Rounding according to the Total Rounding Code on the Contract Modelcontract model
Amount Excl. VAT (Amount Excl. VAT)
Instalment Value Exclvalue 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 payment in the Given Monthly Paymentgiven monthly payment
Rounding according to the Part Payment Rounding Code on the contract modelContract Model
Interest
Will the system automatically add VAT
Interest Payment in Given Monthly Payment payment in the given monthly payment
Rounding according to the Part Payment Rounding Code on the contract modelContract Model
VAT Amount Principal
Will the system automatically add replenish the VAT principal
VAT Amount VAT 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 schedule calendar of the third-party liability insurance contract
Accident Insurance-Amount
Fills up the system automatically
From the client 's payment schedule 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: 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 to Financing Payment No. – the user can see the structure of the total amount of the Service.
Circuiting Differences
It fills Fills the system automatically if Total Rounding Code=not empty nonempty is set on the Contract Financing Model:
Rounding differences 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 (TrailingEnd)
Calculated using calculation lines
Debt Balance
Calculated using calculation lines
Principal Balance
Calculated using calculation lines
Change in Purchase Price Change
To be completed by Adds wizard during technical evaluation in financing
Basis for special VAT Special Regimeregime
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 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 up the system automatically if the sales price is included in the calculation
It is used in financial leasing
Amount VAT Selling Price
Fills in 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 the a contract, the system automatically fills in adds 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 payment agreement from an equal field from a leasing contract for unposted payments
Interest Margin
It calculates the OC when creating (deploying) the contract payment calendar is created (deployed), or recalculates it each time the payment calendar is recalculated on unposted installmentspayments:
Interest Margin = (Interest Margin % / Calculation Interest Rate % (150)) * Interest (16)
Gen. Prod. Posting Group
Completes Replenishes the system automatically from the financing contract
VAT Posting Group Principal
Completes Replenishes the system automatically from the financing contract
VAT Posting Group Interest
Completes Replenishes the system automatically from the financing contract
Number of Assigned AdvancesBackups
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, filled by the system fills in automatically when deploying the contract payment calendar on of the contract to unposted lines of the Payment type Payment (a Posted=N)
Currency Factor = 1/Contract Exchange Rate
Lease Payment Total (hidden technical field)
The hidden field is filled in populated automatically by the system after the validation of the Amount field, which occurs during the validation of every single 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 from the header is then used on 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
Calculation of the value of VAT payment upon delivery of goods:
Functions for calculating VAT in instalments:
Only lines of type Payment (Type = Payment) are selected
Amount is not counted towards down payment line (Down Payment = Yes) Outside the Special Tax Regime (par. 66), when the field is filled with the VAT amount for the given row from the APICZ VAT Amount Special Mode field; in this case, the ratio for dividing VAT (by default on the basis of principal and interest) will be adjusted in such a way that a proportional part of the principal converted to the amount of VAT from par will be deducted from the total base for down payment. 66:
Recalculated Principal = Principal / Principal VAT * VAT for Pair. 66
The amount is not counted towards the Selling Price Line (Selling Price Line = Yes)
Amount is not counted towards the extra payment line (Extra payment = Yes)
For a regular line, the fields are populated with an amount calculated as:
SUM(VAT amounts ... VAT Amount) from the contract inputs for the contract with the Type Code of KV = OneCore Setup.Calc. Input VAT Goods Delivery * Coefficient for given contract line
Where the coefficient for a given contract line:
Coefficient = (Principal + Interest + Deposit) from Contract Line / ContractPmtTotal
Where ContractPmtTotal = sum((Principal + Interest + Deposit) of all contract lines:
after deducting the Principal from the down payment lines
Excluding sales price lines
Split Down Payment Function
The Split Down Payment function is used if the customer pays the down payment in multiple amounts. If they pay part of the down payment in the previous month when the object is handed over, the leasing company issues an invoice (tax document) for the received part of the down payment.
The function is available via the Split Down Payment button. When pressed, the down payment wizard opens.
The Lines subform contains the following fields:
Row No.
Assigns the system automatically when the next line is created.
These numbers are transient.
Amount
The user manually fills in the amount for the given line.
VAT Date
The user manually fills in the VAT date for the given line.
Maturity date
The user manually fills in the due date for the given line.
Posted
Not manually editable
Adds the system automatically from the payment calendar if part of the down payment has already been posted.
Rows are editable if they have Posted=N, otherwise not.
At the bottom are the fields:
Contract No.
Non-editable
Fills up the system automatically
Total Down Payment (Principal)
Completes the system automatically from the contract header.
Contract Balance (LCY)
Calculated field from customer ledger entries.
When the Finish button is pressed, the system executes:
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