/
Payments Calendar

Payments Calendar

Owned by Lango: Language and translation manager
Last updated: Dec 16, 2024Version comment
8 min read

The payment calendar can be opened with the button Payment Calendar from the button bar. At the touch of a button, the contract payment calendar opens:

The functions (Post, Cancel, Preview Posting, Navigate) of the payment calendar are described in Fakturace prodej

Field:

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

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