The system creates a calculation input for the purchase price automatically according to the value entered in the Input Price field in the Create Contract Wizard. In the same way, it will also create a calculation input for the entry fee according to the value in the Entry fee excl. VAT field.
Additional calculation input (e.g. commissions) is created by the user in the following ways:
from the course card using the Calculation Inputs button (Elements section) and the New button on the Contract Calculation Inputs form
from the menu tab using the Calculation Inputs button (Elements section) and the New button on the Contract Calculation Inputs form. The difference from method 1 is that the user has to select the financing object number manually on the calculation input and cannot create the calculation input without the object number if the selected Calculation input type contains the flag Mandatory from object = A.
Calculation Input Card:
General tab:
Financing Contract No.
Automatically fills in the OC with the number of the contract from which the input 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 is based in Method 3, the user selects. It is mandatory if the flag Mandatory from Subject = A was on the calculation input type
Row No.
Fills up the system automatically
Calc. Type Code Entry
The user selects the code of the calculation input type from the Calculation Input Types code list. After entering the code, the system fills in the default settings from the calculation input type.
Description of calc. type Entry
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 the OC automatically according to the type of calculation input as an informative value
Non-editable
Base Amount
The user manually enters the height of the calculation input without VAT
In case the financing product of the contract from which the contract was created is set to Max. Loan to Value (LTV) %, system for the calculation input type, specified in the LTV field for the calc type. input in the financing product table, checks whether the amount of the financed value is within the limit. If the condition is not met, the system displays an error message and does not allow the calculation input to be saved
VAT Amount
Fills in the system automatically when creating a calculation input (description in wizard)
Amount incl. VAT
Completes the system automatically as Base Amount + VAT Amount
Amount Paid By Customer %
Editable only if Financing Type = Loan
Fills in the system automatically from the wizard
The user can change and then the system automatically recalculates Amount paid by customer = Purchase price incl. VAT x (Amount paid by customer % /100)
Amount paid by customer
Editable only if Financing Type = Loan
Fills in the system automatically from the wizard
The user can change and then the system automatically recalculates Amount paid by customer % = Amount paid by customer x 100 / Purchase price incl. VAT
Financed Value
It fills in the system automatically when creating a calculation input (description in the wizard) or when changing the input if To calculation=YES
Non-editable for all types of financing
It counts:
Financing Type = FL, OL, SP: Base Amount
Financing Type = Credit: Amount incl. VAT - Amount paid by customer
Sum Insured
It calculates OC automatically if To Insurance = A and depending on the parameter Sum insured without VAT = Y/N
The user can change the amount
Calculation Amount
It calculates OC automatically if To Calculation = A
To Acquisition
Tightens the OC automatically according to the Calculation Input Type Code
If the value is:
Yes (in combination with To Calculation=A and Local Calculation=A)
The given calculation input goes into the principal
No (in combination with To Calculation=A and Local Calculation=A)
The given calculation input is entered into the interest of the contract (the calculation is functional only via the contract payment calendar)
To Depreciation
Tightens the OC automatically according to the Calculation Input Type Code
If the value is
Yes
When using special tasks to create property cards, the system will use the calculation input marked with this flag
Inclusion 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 calculating premiums
Insurance Amount Incl. VAT
Default Value No
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 Posting setup OneCore for the accounting area Local (the description of CI posting is in 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 then looks for posting settings in the table OneCore Posting Setup for the IFRS accounting area (the description of CI posting is in the Finance)
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
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 a tab (Ok button and "cross" button) has been modified as follows:
When the OC button is pressed, it 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:
Pays
OC closes the calculation input card without a message (i.e. the calculation input is not empty)
At least one of the conditions does not apply
The OC displays the message "In order 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, he presses the Delete button. Subsequently, after confirming the info query (Delete ...) by clicking on the Yes button, the OC deletes the already created values (Contract No., Object No., Line No.) and closes the calculation input card.
Invoicing tab:
Posting Date of Contract Cal. Input
When creating a CI, it is possible to add the date with which a particular CI is to be posted, if posting is required (link to the HF Accrual Posting setup 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 and Document No.
Is automatically completed 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.
Choice of action
Under the Actions option, the posting buttons are available: Posting Preview, Post, Cancel.
The description of CI posting is in Finance.
CZ localization (luxury tax)- Change in the value of the purchase price and the impact of the consolidation package
If the user needs to change the value of the Base Amount in the calculation input to the purchase price, then he proceeds as follows:
Opens the calculation input to the purchase price, in which he changes the value of the "Base Amount" field
Closes the calculation input card to the purchase price
On the list of calculation inputs, it starts refreshing the page using the standard Update function (F5). Subsequently, the system evaluates whether it is necessary to establish/delete a calculation input for the unclaimed part of VAT. The criteria for the unclaimed part of VAT are as follows:
System Work Date=> "VAT Limitation Valid From" (set in OneCore Settings) and
Financing Type= Operative Leasing and
Catalogue Group Code of the course has "Maximum price for VAT"<>0 (this value is then compared with the purchase price, if the purchase price is higher than the setting in the category of the card, then it meets the criterion for the unclaimed part of VAT) and
The value of the "Calculate limitation for VAT" field in the Financed Object Metod Usage table
Subsequently, recalculate the contract payments
This procedure can only be used for calculations/contracts that are in a lower status as Active.