Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 3 Next »

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, Posting Preview, Navigate, Split Down Payment) of the payment calendar are described in Invoicing Sales

Field:

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

    •  Subsequent payments according to the contract model settings

  • Date To

    •  End of repayment period

    •  fills the system automatically

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

    •  Determined in relation to the periodicity of instalments

  • Posting Date

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

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

  • VAT Date

    •  The VAT payment date is filled by the system automatically according to the contract model settings

  • Due Date

    • Does the system fill automatically:

      • For down payments: Due Date=Posting Date

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

      • 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 number 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 posting a payment to A

  • Canceled

    •  Does the system fill up automatically when cancelling an installment on A

  • Blocked

    •  The hidden field is only included 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 memo 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 period 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 note will be created (special line in the payable cal.)

    • The line is created by the 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

    •  Fills up the system automatically

    •  The value of the payment to be paid, the sum of all items of the payment

    • 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, an overview of customer items will open 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 repayment in the given monthly instalment

    • Rounding according to the Part Payment Rounding Code on the contract model

  • Interest

    •  The system will fill in the VAT automatically

    •  Interest payment in a given monthly instalment 

    • Rounding according to the Part Payment Rounding Code on the contract model

  • VAT Amount Principal

    •  The system will automatically replenish the VAT principal

  • Amount VAT Interest

    •  The system will 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 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: 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 overview opens with a filter for 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 Financing Model contract:

      • 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 (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 a contract, the system automatically fills in the currently valid value of the calculation interest from the contract header for unposted installments

  • Interest Margin %

    • Completes the OC automatically when creating a Payment Statement Contract from an even field from the lease agreement for unposted installments

  • Interest Margin

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

  • Total Excl. VAT Aliquot (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 Number of 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 a given month

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

  • Interest Aliqout

    • The system automatically fills in the 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 fills in the 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-1st 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 a given month

      • Services Aliquot= ((Contractual End Date-Given Month's 1st+1)/Actual Number of Days in 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 Advances

    • Not used

  • Currency Factor

    • Hidden field, filled by the system automatically when deploying the payment calendar of contracts on unposted lines of type Payment (a Posted=N)

      • Currency Factor=1/Contract Exchange Rate

  • Lease Payment Total (400)

    • 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 in the Contract Statistics page and in the Master Agreement table, where it is calculated how much is the total amount for all installments of the customer

  • No labels