/
Calculation Inputs

Calculation Inputs

Calculation inputs are used to enter and record values that may affect the financial part of the payment (the so-called annuity) or are only record-keeping.

Calculation inputs parameterization – Calculation input types

Parameterization of calculation input types is done by the user in the settings table (code list) Calculation Input Types, which is described in Finanční produkty a ceníky služeb.

Creation of a calculation input

The Complete confirmation system on the Price and Equipment tab automatically creates a calculation input on the purchase price with the calculation input type according to the settings in the Purchase Price Calculation Input Type Code on the financing product of the calculation.

In some cases, it may also be necessary to set up another calculation input – e.g. for commissions, if the leasing company has paid it for mediation, etc.

Manual creation of the calculation input is possible:

  • from the Object card using the Calculation Inputs button and the New button on the Contract Calculation Inputs form

  • from the menu tab using the Calculation Inputs button and the New button on the Contract Calculation Inputs form. The difference from method 1 is that the user on the calculation input has to select the financing object number manually and cannot create the calculation input without the object number if the selected Calculation input type contains the flag Mandatory from object = A.

The calculation input card opens for the user.

General tab:

  • Financing Contract No.

    • Automatically fills in the OC with the number of the offer from which the entry is based

  • Object No.

    • Fills in the OC automatically if the input is created in method 1 or 2 (from the item card)

    • If the input was created in way 3, the user selects. It is mandatory if the flag Mandatory from Subject = A was on the calculation input type

  • Row No.

    • Fills in OC automatically, system data

  • Calculation Input Type Code

    • Selects the user from the types of calculation inputs

    • After selecting the Calculation input type code, the preset parameters of the calculation input from the Calculation Input Types are downloaded (see Calculation Input Code). Produktový management )

  • Description of calc. type Vstupu (Calculation Input Type Description)

    • fills in the OC automatically according to the code of the calculation input type as an informative value

    • non-editable

  • Calc. input variant

    • Adds OC automatically according to the type of calculation input

    • Values = empty, Purchase price, Purchase price change, Grant, Fee, Commission, VAT - delivery of goods

    • Non-editable

  • Calculation Input Type

    • Fills in OC automatically according to Calc. Input Type Code

  • Base Amount

    • Does the user manually enter the value of the calculation input in the contract currency without VAT

    • Required field

  • VAT Amount

    • It calculates the OC automatically according to the VAT settings

  • Amount Incl. VAT

    • completes the system automatically as Base Amount + VAT Amount

  • Amount Paid By Customer %

    • editable only if Financing Type is equal to Loan

  • Amount Paid By Customer

    • editable only if Financing Type is equal to Loan

  • Financed Amount

    • It calculates OC automatically if To Calculation = A

    • It counts:

      • Financing Type=FL, OL, SP: Base Amount

      • Financing Type=Credit: Amount incl. VAT-Amount Paid by Customer

  • Insurance Amount

    • It calculates OC automatically if To Insurance = A and depending on the parameter Sum insured without VAT = Y/N

  • Calculation Amount

    • It calculates OC automatically if To Calculation = A

  • To Acquisition

    • Tightens the OC automatically according to the Calculation Input Type Code

    • if A (in combination with To Calculation=A and Local Calculation=A), the given calculation input enters the principal

    • if N (in combination with To Calculation=A and Local Calculation=A), the given calculation input enters into the contract interest (the calculation is functional only via the contract payment calendar). The effective interest rate is then higher than the Calculation Interest % of the contract.

  • To Depreciation

    • tightens the OC automatically according to the Calculation Input Type Code

    • if A, the system will use the calculation input marked with this flag when using special tasks to create property cards

  • Integration Date

    • Fills in the OC automatically Expected Handover Date

  • To Insurance

    • Completes the OC automatically according to the Calculation Input Type Code. If A, the value specified in the Sum insured field will be used in property insurance as the basis for the calculation

  • Insurance Amount Incl. VAT

    • Default value: No. Editable if To Insurance = A

    • If Yes, the sum insured will be calculated including VAT

  • To Calculation

    • Fills in OC automatically according to Calc. Input Type Code

    • Flag whether the calculation input should enter any calculation within the offer (e.g. calculation of financial indicators, annuity, etc.)

  • Local Calculation

    • Fills in OC automatically according to Calc. Input Type Code

    • Flag whether the calculation input should be entered into the annuity calculation, when posting CI, the system then looks for posting settings in the table OneCore Posting Setup for the accounting area Local (the description of HF posting is in PD Finance)

  • IFRS Calculation

    • Fills in OC automatically according to Calc. Input Type Code

    • Flag whether the calculation input should be entered into the IFRS calculation, when posting CI, the system looks for posting settings in the table OneCore Posting Setup for the IFRS accounting area (the description of CI accounting is in PD Finance)

  • APR (APR)

    • Fills in OC automatically according to Calc. Input Type Code

    • Flag whether the calculation input should be entered into the APR calculation

  • Calculation Enter Date (Calc. Enter Date)

    • Fills in the OC automatically Expected Handover Date

  • Blocked

    • Changes OC automatically to YES after contract activation. The calculation input is blocked after activation so that it cannot be changed

    • The field is not user-editable

Note.:

Creating an empty calculation input is not permitted. Closing the tab (Ok button and "cross" button) has been modified as follows:

  • After pressing the button, OC checks the Calculation Input Type Code and Base Amount fields so that the Calculation Input Type Code field must be filled in and the Base Amount must be <>0.00. Subsequently:

    • If the conditions are valid, the OC closes the calculation input card without a message (i.e. the calculation input is not empty)

    • If at least one of the conditions is not true, the OC will display the message "In order to be able to close this page, the fields Calculation Input Code and Base Amount cannot be empty." After pressing the OK button (in the message), the OC closes the message and leaves the calculation input card open.

If the user wants to cancel the empty calculation input, they press the Delete button. Subsequently, after confirming the info query (Delete...) by pressing the Yes button, the OC deletes the already created values (Contract number, Object number, Line number) and closes the calculation input card.

Invoicing tab:

  • Posting Date of Contract Calc. Input (Calc. Input Posting Date)

    • it is possible to add the date with which the specific CI is to be posted, if posting is required (link to the setting of accrual posting in the table Calculation Input Types -> Relations of General Posting Groups and CI Type – the description of the setting is in the Nastavení Business; and in the Accruals Calculation Method Settings table – the setting is described in the Nastavení Finance). Once the contract has been activated, the posting date can no longer be entered or changed.

  • Calculation Input Posted (Calc. Input Posted) and Document No.

    • it is automatically added after posting a specific CI.

  • VAT Prod. Posting Group

    • Used in Leasing with Delivery of Goods

    • Relation to VAT Product Posting Group (T 324 VAT Product Posting Group)

    • The field is populated by the system when generating calculation inputs for VAT upon delivery of goods

    • Non-editable

    • Invoicing, for the Source Data field IFRS

  • Delivery Calculation Input Type

    • System hidden field for distinguishing the calculation input with VAT upon delivery of goods

    • ENUM=empty, Credit Memo for Termination (return in case of early termination of the contract), Reverse (in case of cancellation of the posted VAT document upon delivery of goods)

  • Reversed upon delivery of goods

    • System Hidden Field

    • Sets up posting of documents for Leasing with delivery of goods in case of reverse

  • Reverse Record Line No.

    • System Hidden Field

    • Sets up posting of documents for Leasing with delivery of goods in case of reverse

  • Payment Reference No. (Invoicing)

    • System Hidden Field

    • Uses Posting Documents for Leasing with Delivery of Goods in Case of Contract Transfer (Assignment)

 

The other fields are of an informational nature, where the related settings are displayed from the table Relations of General Posting Groups and CI Type and from the table Accrual Calculation Method Settings (link to the Calculation Input Type Code and the Calc. Input Variant assigned to it).

Accruals button

Below this button, the accrual lines of a specific CI are available (if HF accrual posting has been set up in the table Calculation Input Types -> Relations of General Posting Groups and CI Type – the setting description is in Nastavení Business; and in the Accruals Calculation Method Settings table – the setting is described in the Nastavení Finance). The lines themselves are then summed into the Accrual Calendar, which is available in Financing Contract -> Related -> Calendars -> Contract Accrual Schedule.

Choosing an action (Actions)

Under the Actions option, the posting buttons are available: Posting Preview, Post, Cancel.

The description of CI posting is in Nastavení Finance.