/
Calculation_Tab

Calculation_Tab

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

The Calculation tab contains the following fields:

  • Always Calendar Month

    • flag, which, in combination with the flag Calculation start=handover date, determines whether payments will be calculated for calendar months, technical months or aliquot.

    • adds the system automatically from the Financing Model of the given contract

    • non-user-editable field

  • Calc. Start=Handover Date

    • flag, which, in combination with Always Calendar Month, determines whether payments will be calculated for calendar months, technical months or aliquot

    • adds the system automatically from the Financing Model of the given contract

    • non-user-editable field

  • Payment term - At the beginning/At the end

    • This field determines whether the system will calculate pre-term interest (at the beginning) or post-term interest (at the end) on the contract

    • completes the system automatically from the Financing Product Type

    • User-editable

  • Repayment Period

    • Takes OC from wizard to create calculation/contract

    • The user selects from the following options:

      • Moon

      • Quarter

      • Half a year

      • Year

      • Irregularly

  • Financing Period in Months

    • Pre-populates OC from wizard.

    • To change the value:

      • Before activating the contract:

        • Field is non-editable for calculations/contracts with Financing with Services=A.

        • The user can make a change of value by using the AssistEdit button to open the dialogbox Change Financing Period. The user enters the new financing value, then confirms the Execute button. The system then executes:

          • Checks against the values on the financing product/template:

            • New Financing Period (in Months)>=Financing Period-min and at the same time

            • New Financing Period (in Months)<=Financing Period-max and at the same time

            • New Financing Period (in Months)/Financing Period-step=is an integer

            • If any condition is not true, the system displays an error message and the user cannot continue.

            • If all conditions apply, the system continues.

          • Recalculates Yearly or Contractual Mileage (depending on the parameter in Contract with Service Settings). If the value of the Contractual Distance has been recalculated, the following will check:

            • New value Contractual Distance=<Contractual Mileage-max on template/product:

            • If it doesn't, it displays the error message "Contractual Distance cannot be higher than .. value from template/product)." (EN: A contractual raid can't be more like..." ̈). The changed value of Distance per Year and Contractual Distance is not allowed to be saved. After confirmation by the user, it closes the message and leaves the Contractual distance form open.

            • If true, it stores the Financing Period (in Month) and Contractual Distance values without a message. Subsequently, it continues according to the current functionality (recalculates the necessary services).

        • If the Financing Product Type is Financing Optional=N, the REFI check will perform:

          • checks if the Base Rate and Cost Interest comply with the contract's REFI code for the new duration:

            • The Reference Date must be between Valid From and Valid To at both rates

            • Note: Reference Date is not updated, it is based on an existing value

            • The new Financing Period (in Months) value must be between Min.Leas.Contr.Time From and Max.Leas.Contr.Time To at both rates

          • If the rates are satisfactory, it will leave them unchanged in the lease agreement

          • If the rates are not suitable, the OC will search for new suitable rates within the given REFI code. If it finds them, it adds them to the contract and recalculates the Calculation Interest (% p.a.) (Calculation Interest Rate % (p.a.) while maintaining Interest Margin %.

          • If the REFI code does not match both rates, OC will find a new matching REFI code:

            • The currency code in the contract must be the same

            • The type of interest rate in the contract must be the same

            • The reference date of the contract must be between Validity From and Validity To on the REFI code.

            • The REFI code must have a compliant Base Rate and Liqui Cost (conditions as above).

          • Subsequently, he adds the REFI code and the new rates to the contract and recalculates the Calculation Interest while maintaining the Interest Margin.

          • If it does not find a matching REFI code, it displays an error message and does not continue.

        • It then updates all services, if they exist in the contract:

          • Updates Valid To and Valid To after Extension, then recalculates the details

          • Service Rates

          • Maintenance

            • finds a new rate when it depends on the duration

          • Fee/Service

            • recalculates the detail without updating the rate

          • Highway Ticket

            • recalculates the Quantity without updating the price and then the detail

          • Fuel Card

            • recalculates the detail without updating the rates

          • Replacement Car

            • recalculates Service Duration, then detail without updating price

          • Road Tax (only for CZ and SK)

            • deletes the service and re-establishes it for a new contract term, using the rate valid on the Reference Date

          • Tire

            • recalculates Tire Quantity only if there is a change in Contractual Distance

          • Tire Change

            • recalculates the Number of Tire Changes, resp. detail without updating rates

          • Tire Storage

            • recalculates the detail without updating the rates

          • Ledges

            • The total value does not change, it only recalculates the monthly value

          • Rim Accessories

            • The total value does not change, it only recalculates the monthly value

          • Recalculates service/calendar details

        • Updates insurance contracts

        • Performs contract recalculation in relation to Complete Calculation=N/Y.

      • After the contract is activated

  • Number of Payments

    • Replenishes the system automatically according to the financing period and the repayment period

    • The field is not user-editable

  • Entry Fee %

    • The system automatically fills in the value entered in the Create Contract Wizard. Based on this value, the system creates a calculation input for the entry fee according to the system settings.

    • The user can change the value only if the Contract Status is <Effective. If:

      • The entry fee existed before, the OC will update the calculation input according to the new value

      • the entry fee did not exist before, the OC bases the calculation input on the value entered by the user in the contract

      • if the initial fee or calculation input existed in the contract, but the user deletes the value, the OC only updates the existing calculation input to zero value. The user should manually delete the zero calculation input.

  • Initial Fee excl. VAT

    • The system automatically fills in the value entered in the Create Contract Wizard.

    • The user can change the value, using the same mechanisms as when changing the Entry Fee % (see above).

  • Purchase Price excl. VAT

    • the system automatically completes the sum of the values of the Base Amount field from the contract calculation inputs:

      • To Acquisition=A

      • Calc. Input Variant=Purchase Price or Change of Purchase Price

      • Calculation Enter Date=Expected Handover Date, resp. Handover Date (after activation)

  • Input Price Excl. VAT

    • fills in the system automatically, as the sum of the Calculation Amount fields (filled in if the calculation input is To calculation=A) from calculation inputs that have parameters

      • To Acquisition=A

      • Calculation Enter Date=Expected Handover Date, resp. Handover Date (after activation)

  • Amount Paid By Customer %

    • The field is non-editable.

    • The field is used only for loans (not for OL and SVP).

    • Changing the amount is only possible on the calculation input for the entry price for the loan.

    • It fills in the system automatically from calculation inputs, where:

      •  To Acquisition=A as follows:

        • The system sums the value of the "Amount incl. VAT" field from all calculation inputs of the contract. It then takes the value of the "Amount paid by customer" field from the financing contract. To calculate the "Amount paid by customer %" field: "Amount paid by customer" * 100 / total "Amount incl. VAT"

  • Amount paid by customer

    • The field is non-editable.

    • The field is used only for loans (not for OL and SVP).

    •  Changing the amount is only possible on the calculation input for the entry price for the loan.

    • completes the system automatically, as the sum of the Amount paid by customer fields from calculation inputs, which have parameters:

      •  To Acquisition=A

  • Down Payment %

    • The system automatically fills in the value entered in the Create Contract Wizard.

    • Editable according to the settings of the Financing Model

    • When changing, the down payment is recalculated

  • Advance payment

    • The system automatically fills in the value entered in the Create Contract Wizard. After changing the value in the Down Payment % field, the system automatically calculates the absolute value of the down payment from the input price

    • Editable according to the settings of the Financing Model

  • Financed Value

    • Non-editable for all types of financing

    • The system will automatically fill in the value:

      • Financial Leasing, Operational Leasing, Instalment Sale, Fleet Management: Input Price Excl. VAT-Down Payment

      • Credit: from the calculation input from the Calculation Amount field

    • The value enters the calculation Annuity excl. VAT resp.do Financial Calculators

  • Financed VAT Value

    • The field is used in financial leasing with the delivery of goods

    • The field is calculated by the system and contains the financed value of VAT in the case of payment on the contract, i.e. the sum of the amounts from the payment calendar in the field VAT Payment upon Delivery of Goods (see the field in the addition of table 4026398)

    • Non-editable

  • Total Financed Value

    • The field is used in financial leasing with the delivery of goods

    • The field is calculated by the system and contains the total financed value on the contract, i.e. the sum of the Financed Acquisition Value and the Financed VAT Value

    • Enters the calculation of the annuity through the financial calculator (not through formulas)

    • Non-editable

  • Calculation Residual Value %

    • Financing with services=N:

      • Fills in the system automatically according to the residual value entered in the Create Contract Wizard

      • The user can change the value of the field only if the value of the "Allow residual value amount to be entered" field is equal to YES on the financing model. Otherwise, the system will display an error.

      • Each time the value in the Residual Value field changes, the calculation system updates the value in this field

    • Financing with services=A:

      • fills in the system automatically according to the residual value of the entered Object Prices and the field is always non-editable (regardless of the financing model settings)

  • Calculation Residual Value

    • Financing with services=N:

      • Fills in the system automatically according to the residual value entered in the Create Contract Wizard

      • The user can change the value of the field only if the value of the "Allow residual value amount to be entered" field is equal to YES on the financing model. Otherwise, the system will display an error.

      • Each time the value in the Residual Value field changes, the calculation system updates the value in this field

    • Financing with services=A:

      • fills in the system automatically according to the residual value of the entered Object Prices and the field is always non-editable (regardless of the financing model settings)

  • Purchase Price Change

    • The field is non-editable. The system automatically calculates the entry price of the financing contract from the calculation inputs of the contract. It is the sum of all calculation inputs with the "To procurement" and "To calculation" flags and the calculation input type "Input Price Change".

  • Selling price

    • This is the amount that the client pays at the end of the contract in addition to the entry price on the financing contract. Also known as the selling fee.

    • user-editable field Editable according to the settings of the Financing Model

  • Interest Rate Type

    • The system will fill in from the wizard if there is a flag Optional financing=N on the Financing Product Type

    • The field is editable according to the flag on the Contract Product Type:

      • Optional financing=N – editable (i.e. it is allowed to change the interest rate type during the contract term to another one such as on the product/template)

      • Optional financing=A – non-editable (typically for fleet management when the subject is not financed)

    • When the value is changed manually, the system updates the value of the Reference Date field

    • After updating the Reference Date, it will also try to find the new REFI code:

      • If it finds it, it will add the Base Rate and Cost Rate rates.

      • If it does not find it, it deletes the original REFI code, but keeps the interest rates (for technical reasons it is not possible to delete them).

  • REFI Code

    • For calculation with Financing Product Type that has Optional Financing=A is empty and uneditable

    • For calculations with Financing Product Type that has Financing Optional=N, the system automatically fills in the value entered in the contract creation wizard and is editable

    • If it is editable, the user can change the default value. When changing the REFI code manually, the system will update the Reference Date in order to search for rates to the current date.

    • When changing the REFI code, the system filters according to the following filters:

      • Currency

        • There must be the same currency code in the calculation/contract as on the REFI code

      • Valid From

        • The "Valid from" date must be equal to or less than the Reference Date

      • Valid To

        • The "Valid To" date must be empty, equal to or greater than the Reference Date

      • Interest Rate Type

        • Fixed, variable

        • The interest rate type must match the interest rate type of the REFI code.

      • Active=Yes (on REFI code)

        • If no REFI code matches, it will not allow anything else to be selected.

        • If the user selects a matching REFI code, they proceed to check the REFI code rates:

          • For the REFI code, there must be Base Rate and Cost Ratethat have:

            • Valid From

            • The "Valid From" date must be equal to or less than the Contract Reference Date

            • Valid To

            • The "Valid To" date must be empty, equal to or greater than the Contract Reference Date

            • The base rate must have a value greater than 0.00, check when the rate is applied

            • Financing Period (Month) must be Min. Leas.Contr.From<=Financing Period<=Max. Period leas.sml.do

            • Active=A

          • If the Base Rate and Cost Rate are suitable, then it will take them into the wizard fields:

            • Basic Rate

            • Cost Rate

          • If there is also a valid Special Liquidity Cost:

            • Rate Type=Special Liqui Cost

            • Validity From/Validity To

            • the lease term is between Min.Leas.Contr.Time From and Max.Leas.Contr.Time To

            • has Active=Y

            • then its Rate is used in the calculation of the Reference Interest%.

          • Then calculates:

            • Reference Interest=Base Rate+Cost Rate+Special Interest Expense

            • Calculation Interest = Reference Interest + Interest Margin (Takes Margin from Product/Template)

            • If the user enters the Calculation Interest value, he calculates the value of Interest Margin%=Calculation Interest%-Reference Interest

  • Calculation Interest %

    • the system automatically fills in the value entered in the Create Contract Wizard

    • The user can change it if the Interest Rate Type is Fixed. In the case of the Variable interest rate type, the system automatically calculates the calculation interest after entering the interest margin and the field is not editable by the user

    • The calculation interest can also be zero, even for Optional Financing=N. If the input price is non-zero and the calculation interest is zero, the system calculates the annuity payment by dividing the financed value by the number of installments – in this case, the annuity payment is even.

  • Interest Margin %

    • Adds the system from the wizard to create a calculation/contract (it is taken over to the wizard from the financing product/template).

    • Editable for Interest Rate Type=Variable

    • When the Calculation Interest is changed, the system calculates automatically.

  • Reference Interest %

    • refills the system automatically according to REFI code=Base Rate %+Cost Interest %.

  • Cost Interest %

    • fills in the system automatically according to the REFI code, the field is not user-editable.

  • Base Rate %

    • fills in the system automatically according to the REFI code, the field is not user-editable.

  • IRR%

    • It will refill the system automatically. The field is non-editable.

  • APR % (APR %)

    • It is an indicator of the annual percentage rate of charge. The system calculates it automatically when generating a payment calendar on the financing contract. The field is non-editable.

  • Annuity Excl. VAT (Annuity Excl.VAT)

    • calculates the OC automatically after creating the calculation using the PMT formula without creating a contract payment calendar. Rounding according to the Part Payment Rounding Code on the Financing Model. Recalculation is possible using the Calculate Payment button.

    • If a contract payment calendar is created, the OC will update this field when deploying the payment calendar from the Annuity Excl. VAT field from the payment (line) that matches:

      • the first unposted (Posted=N) and

      • regular (Aliquot Payment=N, Downpayment Line=N, Recalculation Settlement=N and Partial Payment Credit=N)

      • if the contract flag is Financing with Services=N, then also the non-zero Payment Amount (Amount<>0) of the payment from the Financing with Services GC. If Y, don't check the Amount. 

  • Insurance Excl.VAT (Insurance Excl.VAT)

    • calculates the OC automatically after creating a calculation using a formula without creating a contract payment calendar. The recalculation is possible using the Instalment Calculation button (in the case of standard insurance and in the case of simple insurance separately) – for the calculation, see the Instalment Calculation chapter.

      • In the case of simple insurance, it is rounded separately according to the Insurance Rounding Code on the contract model.

      • In the case of standard insurance, it is rounded according to the insurance settings.

    • If a contract payment calendar is created, the OC will update this field when deploying the payment calendar from the Insurance field from a payment (line) that matches:

      • the first unposted (Posted=N) and

      • regular (Aliquot Payment=N, Downpayment Line=N, Recalculation Settlement=N and Partial Payment Credit=N)

      • if the contract flag is Financing with Services=N, then also the non-zero Payment Amount (Amount<>0) of the payment from the Financing with Services GC. If Y, don't check the Amount.

  • Services Excl.VAT (Services Excl.VAT)

    • calculates the OC automatically after creating a calculation using a formula without creating a contract payment calendar. Recalculation is possible using the Calculate Payment button.

      • Rounding according to the Service Rounding Code on the financing model, in the case of standard services also simple services.

    • If a contract payment calendar is created, the OC will update this field when deploying the payment calendar from the Services field from the payment (line) that matches:

      • the first unposted (Posted=N) and

      • regular (Aliquot Payment=N, Downpayment Line=N, Recalculation Settlement=N and Partial Payment Credit=N)

      • if the contract flag is Financing with Services=N, then also the non-zero Payment Amount (Amount<>0) of the payment from the Financing with Services GC. If Y, don't check the Amount.

    • Without a separate rounding setting – is the sum of already rounded values. 

  • Payment Excl. VAT (Payment Excl.VAT)

    • calculates the OC automatically after creating a calculation using a formula without creating a contract payment calendar. Recalculation is possible using the Calculate Payment button.

    • If a contract payment calendar is created, the OC will update this field when deploying the payment calendar from the Payment Excl. VAT field from the payment (line) that matches:

      • the first unposted (Posted=N) and

      • regular (Aliquot Payment=N, Downpayment Line=N, Recalculation Settlement=N and Partial Payment Credit=N)

      • if the contract flag is Financing with Services=N, then also the non-zero Payment Amount (Amount<>0) of the payment from the Financing with Services GC. If Y, don't check the Amount. 

    • Without a separate rounding setting – is the sum of already rounded values.

  • Payment Incl. VAT (Payment Incl.VAT)

    • calculates the OC automatically after creating a calculation using a formula without creating a contract payment calendar. Rounding according to the Total Rounding Code on the Financing Model. Recalculation is possible using the Calculate Payment button.

    • If a contract payment calendar is created, the OC will update this field when deploying the payment calendar from the Payment Amount from Payment (Line) field that matches:

      • the first unposted (Posted=N) and

      • regular (Aliquot Payment=N, Downpayment Line=N, Recalculation Settlement=N and Partial Payment Credit=N)

      • if the contract flag is Financing with Services=N, then also the non-zero Payment Amount (Amount<>0) of the payment from the Financing with Services GC. If Y, don't check the Amount. 

  • Simple Fee % (Simple Fee %)

    • Adds wizard to create calculation/contract automatically if there is Use simple fee=Y on the Financing Product Type (not possible for contracts with Financing with Services=Y) from the financing product or financing template (if the calculation was created from a template) from the field of the same name from the Currency and calculation parameters subform.

    • Editable If the Product Type is Financing Use Simple Fee=Y and Status<Active otherwise not (not even on the change copy), Simple Fee and Simple Fee Sum are automatically recalculated when changing

    • When the Simple Fee value changes, it is calculated automatically:

      • Simple Fee %=round(Simple Fee*100/Financed Amount (4047245),2)

  • Simple Fee

    • Adds wizard for creation automatically according to Simple Fee %

    • Editable is on the Financing Product Type Use Simple Fee=Y and Status<Active (not even on the change copy) otherwise. When changing, Simple Fee % and Simple Fee Sum are automatically recalculated

    • Value enters into repayment

    • It counts:

      • Simple Fee=round(Financed Amount (4047245)*( Simple Fee %/100),2)

  • Simple Fee Sum

    • calculates OC automatically

    • It counts:

      • Simple Fee Sum = Simple Fee * No.of Payments (24)

  • Simple Service Code

    • Adds wizard to create the calculation automatically if there is flag Use simple service=Y on the Financing Product Type (not possible for contracts with Financing with Services=Y), otherwise not. Searching for the code is the same as described below as filtering during lookup.

    • Editable only if it is on the Financing Product Type Use Simple Service=Y and Status<Active (even on the change copy) otherwise not

    • Lookup to a new Simple Service table (see PD Business Settings) with the following filters enabled:

      • Fuel Type = same as on the subject of the contract

      • Engine

      •  Displacement From<Engine CCM (72) on Subject<=Engine Displacement To (Incl.)

      • Valid From<workdate<=Valid To

  • Simple Service

    • The field will be editable only if it is on the Financing Product Type Use Simple Service=Y (not possible for contracts with Financing with Services=Y) and Simple Service Code<>blank and Status<Active (not even on the change copy).

    • Value enters into repayment

    • After selecting Simple Service Code, the value is filled in automatically from the Simple Service Rate table as follows (filters):

      • Code Same

      • Duration From<Financing Period (23) from the contract<= Duration To (Incl)

      • Valid From<workdate<=Valid To

  • Simple Insurance Code

    • Adds wizard to create calculation automatically if there is flag Use simple insurance=Y on the Financing Product Type (not possible for contracts with Financing with Services=Y), otherwise not. Searching for the code is the same as described below as filtering during lookup.

    • On the editable tab, only there is on the Financing Product Type Use Simple Insurance=Y and Status<Active otherwise not, add after Service Payment Period

    • The user can change the lookup to the Simple Insurance table while the filters are turned on:

      • Duration From<Financing Period (23) from the contract<= Duration To (Incl)

      • Valid From<workdate<=Valid To

  • Simple Insurance

    • The field will be editable only if it is on the Financing Product Type Use Simple Insurance=Y and Simple Insurance Code<>blank and Status<Active (not even on the change copy).

    • Value enters into repayment

    • After selecting Simple Insurance Code, the value is filled in automatically from the Simple Insurance Rate table as follows (filters):

      • Code Same

      • Valid From<workdate<=Valid To

  • Paym. calendar is a tax document

    • completes the system automatically from the Currency and calculation parameters subform from Financing Product/Template

    • If A – it is not necessary to print installment invoices from the payment calendar

    • If N – it is necessary to print invoices for installments from the payment calendar (typically for foreign exchange contracts)

  • VAT Special Mode

    • YES/NO

    • For SK legislation – the calculation of instalments is carried out according to par. 66 of the VAT Act (second-hand goods)

    • For CZ legislation – detto.

  • Releasing Excluding VAT (VAT)

    • YES/NIE

    • The field is non-editable.

    • The field is filled from the financed object.

  • Leasing with delivery of goods

    • The flag is calculated from the Financed Object from the flag of the same name to the contract.

    • Indicates a contract that is in financial leasing mode with delivery of goods and is non-editable.

The technique of using flowfield is here to ensure that the solution is database-compatible with Leaseback and Special Tax Regime.

  • VAT Financing

    • In the case of Leasing with delivery of goods, a field indicating whether the customer requires payment of VAT in instalments or will pay VAT according to the issued tax document

    • The field is relevant only for Financial leasing in the Delivery of goods mode, it is editable if Leasing with delivery of goods=A and Status=Active

    • The change drops the Calculation Lines – Updated flag if it is a change in the contract; The status of the contract is also checked in the event of a change