/
Payments_Calendar

Payments_Calendar

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

The payment calendar contains a detailed breakdown of contract payments (posted and unposted), including their detailed structure (VAT bases, VAT, auxiliary field, etc.).

It can be opened with a 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, Split Down Payment) of the payment calendar are described in Fakturace prodej

Field:

  • Part 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 Starting Date

    •  Subsequent payments according to the contract model settings

  • Date To

    •  End of Payment Period

    •  fills the system automatically

    •  For down payment: it is the handover date of the object

    •  Stipulates in relation to the periodicity of instalments

  • Posting Date

    •  The system fills the contract automatically according to the settings of the contract model

    •  For down payment: it is the handover date of the object

  • VAT Date

    •  The VAT date of the payment, the system fills it automatically according to the settings of the contract model

  • Due Date

    • Does the system fill automatically:

      • For down payments: Due Date=Posting Date

      • For payments: Posting Date + Date Formula from Contract Payment Terms Code

      • For Sales Line: Posting Date + Date Formula from Sales Price Payment Terms Code with Contract

  • Document No.

    •  Fills the system automatically when a payment is posted

    •  Document No. under which the payment was posted

  • Mass Invoice

    •  Fills in the system automatically if the payment is invoiced via mass invoices (e.g. Per Customer, Used in OL and GMP)

    •  It is used in operational leasing/fleet management

  • Billed (Posted)

    •  Does the system fill up automatically when a payment is posted 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 (Closed)

    • We only mention the hidden field for the sake of completeness. Through the calculator lines, it is possible to block unposted lines so that they are not recalculated.

  • Unposted Credit Memo

    • It is used in contracts with services when the payment has been credited and the credit note is waiting for mass posting

  • Contract Extension

    • It is used in contracts with services if the contract has been automatically extended and the payment is within the period of automatic deferral

  • Recalculation Settlement

    • It is used in contracts with services if the contract has been recalculated (i.e. the contract duration or mileage has been changed) in a retroactive manner and after this recalculation a so-called recalculation settlement was created (special line in the payment cal.).

    • The line is created by wizard for recalculation (change of time and mileage)

  • Partial Payment Credit

    • It is used in contracts with services. If the contract was terminated (exceptionally or properly) on a different day, such as the last day of the last posted month, a partial credit will be created (special line in repayment cal.)

    • A line is created by a wizard to change the detailed status of the contract

  • 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

    •  The value of the 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) 

    • fills in the system automatically by summating the values into 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

    •  After clicking, a list of customer entries opens with a filter for the given document number, Open=A and Posting date of payment.

  •  Annuity Excl. VAT

    •  Fills up the system automatically

    •  Sum of Principal + Interest

  •  Principal

    • Fills up the system automatically

    •  Principal repayment in the given monthly instalment

    • Rounding according to Part Payment Rounding Code on the Contract Model

  • Interest

    •  the system will fill in the VAT automatically

    •  Interest payment in the given monthly payment 

    • Rounding according to Part Payment Rounding Code on the Contract Model

  • VAT Amount Principal

    •  The system will automatically replenish the VAT principal

  • VAT Amount Interest

    •  The system will automatically add VAT to the 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 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 the contract model 

    • after clicking, the Service Payment Line overview opens with a filter to Financing Payment No. – the user can see the structure of the total amount of the Service.

  • Rounding 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) – sum of unrounded 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 (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

    •  Completes the system automatically if the calculation is in a special VAT mode

    •  It is used in financial leasing

  • VAT Amount for Special VAT Mode

    •  Completes 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 fills in 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 even field from the lease agreement to unposted installments

  • Interest Margin

    • It calculates the OC when the contract payment calendar is created (deployed), or it is recalculated each time the payment calendar is recalculated on unposted payments – for calculation, see chapter Contract Profitability.

  • Amount Excl.VAT Aliquot

    • The system will automatically fill in the aliquot part of the Total Excl. VAT value attributable to the number of days of the contract duration in the given month:

      • Amount Excl.VAT Aliquot= ((Contractual End Date+1)/Actual Days in Month)*Amount Excl.VAT

  • Principal Aliqout

    • The system automatically adds an aliquot part of the Principal value attributable to the number of days of the contract duration in the given month

      • Principal Aliquot= ((Contractual End Date-Given Month's 1st+1)/Actual Number of Days in Given Month)*Principal

  • Interest Aliqout

    • The system automatically adds an aliquot part of the Interest value attributable to the number of days of the contract duration in the given month,

      • Interest Aliquot= ((Contractual End Date+1)/Actual number of days in a given month)*Interest

  • Insurance Aliquot

    • The system automatically adds an aliquot part of the Insurance value attributable to the number of days of the contract duration in the given month

      • Insurance Aliquot= ((Contractual End Date-1.of the given month+1)/actual number of days in the given month)*Insurance

  • Services Aliquot

    • The system automatically fills in the aliquot part of the Service value attributable to the number of days of the contract duration in the given month

      • Services Aliquot= ((Contractual End Date-1.of the given month+1)/actual number of days in the given month)*Service

  • 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 

  • Advance

    •  Not used

  • Number of Assigned Backups

    • Not used

  • Currency Factor

    • Hidden field, the system fills in the contract automatically when deploying the payment calendar to unposted lines of the Payment type (a Posted=N)

      • Currency Factor=1/Contract Exchange Rate

  • Lease Payment Total (400)

    • 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