/
Creation Calculation With Services

Creation Calculation With Services

Owned by Lango: Language and translation manager
Last updated: Sept 16, 2024 by Tomas Nagy
15 min read

You can create a calculation or contract with services by using the Create Calculation with Services Wizard.

Location:

OneCore - Financing (All products) ->Action/Create Offer Services

When you click Create Calculation with Services Wizard to open a window Step 1 To enter:

  • Financing Type

    • The user can change it by selecting from the options Operative leasing or Fleet management (i.e. only financing types where Financing with services=A). Can only select from those types for which the user has permissions in User Settings

  • Legal Form Code

    • The user selects from the code list of legal forms, the system will then filter the Customer No. to this value

    • If the value of this field is changed, then the value in the field will be deleted

      • Customer No.

      • Financing Product Type Code

      • Financing Product No.

      • Financing Template No.

  • Customer No.

    • Selects a user from the customer directory, which is filtered to the selected legal form, where it is possible to select not only by number, but also by other customer data.

    • Optional field, it is possible to create an offer even without selecting a customer number

    • If the value of this field is changed, then the value in the field will be deleted

      • Financing Template No.

  • Customer Name

    • Completes OC automatically if Customer No. has been selected

    • To be completed manually by the user, if the Customer No. has not been selected (it is not located in the customer directory)

    • Required field, without entering the user, the user cannot continue

  • Customer Business Place No.

    • Selects a user from the business location directory of the selected customer.

    • Optional field, it is possible to create an offer without entering the customer's business location number

  • Customer Business Place Name

    • Completes the OC automatically after selecting the customer's Business Place No.

    • Non-editable field

  • Currency Code

    • Default value is blank (= local currency)

    • Selects the user from the currency table if they want to create an offer in a foreign currency

    • If the value of this field is changed, then the value in the field will be deleted

      • Financing Product No.

      • Financing Template No.

  • Commodity Code

    • Selects the user from the Catalogue Card Commodity table, which is filtered to valid and active records. The field is mandatory to select the right product

    • If the value of this field is changed, then the value in the field will be deleted

      • Group Code

      • Financing Product Type Code

      • Financing Product No.

      • Financing Template No.

      • Catalogue Card No.

  • Group Code

    • The user selects valid and active records from the Catalogue Group table, which is filtered to the selected commodity. The field is mandatory to select the right product

    • If the value of this field is changed, then the value in the field will be deleted

      • Financing Product Type Code

      • Financing Product No.

      • Financing Template No.

      • Catalogue Card No.

  • Framework Agreement No.

    • Selects the user from the customer's Master Agreements, which is filtered to

      • Customer No.

      • Frame Status. Contracts=Active

  • Used Financed Object

    • Editable field, default value N

    • Changes user to A if the calculation is based on a used object

  • Object ESG

    • Editable field, default value N

    • Change user to A if creating a calculation with green financing

  • Salesperson Code

    • The system pre-fills with the value from the user settings

    • The user can change by selecting from the Salesperson/Purchaser table

  • Financing Product Type Code

    • After selecting "Catalogue Card Groups", the system filters the "Financial Product Type" code list according to the following filters:

      • Financing Type

      • Legal Form Code

      • Commodity Code

      • Group Code

      • Contract with services=YES

      • Valid From <= Calculation Starting Date <= Valid To

        • If there is one matching record, then the system will automatically fill it in

        • If there are multiple matching records, then the user must select one

    • If the value of this field is changed, then the value in the field will be deleted

      • Financing Product No.

      • Financing Template No.

  • Financing Product No.

    • Selects the user from the Financing Products table.

    • When you click on the lookup, you will see a tab to select a financing product. The card consists of two parts: Financing Product Identification (selection field) and Financing Product subform.

    • In the Financing Product Identification tab, there are the following selection fields:

      • Commodity Code

        • OC pre-fills automatically, not editable.

      • Group Code

        • OC pre-fills automatically, not editable.

      • Used Financed Object

        • OC pre-fills automatically, not editable.

      • Financing Product Type Code

        • OC pre-fills automatically, not editable.

      • Currency Code

        • OC pre-fills automatically, not editable.

    • The Financing Product subform contains lines that are automatically filtered to:

      • Type = Financing Product

      • Status = Active

      • Financing Product Type Code – Filter for a given value

      • Legal Form Filter – filter for a given value and empty (system filter)

      • Valid from<= today <= Valid To

      • Commodity filter – filter for a given value and blank

      • Group filter – filter for a given value and blank

      • Valid from<= today <= Valid to (today adds to the filter on the open page, system filter)

      • Used Financed Object – filter for given value and empty

      • Currency code – filter in the table Currency and calculation parameters, where Type=Financing Product and the given currency

    • The user selects the relevant subform row by clicking and the Financing Product is selected. Subsequently, after clicking on the OK button, the form closes. The OC writes the Financing Product No. into the wizard field. Double-clicking on a given row has a similar effect.

    • Selection of the Financing Product No. is mandatory, it is not possible to proceed without selecting/completion. In case the user wants to continue without entering the Financing Product Number, the OC will display the error message "Please enter the Financing Product Number." and will not allow the process to continue.

    • If the value of this field is changed, then the value in the field will be deleted

      • Financing Template No.

      • Updated fields in downstream steps

  • Financing Product Name

    • Completes the OC automatically based on the Financing Product No.

    • Non-editable field

  • Financing Template No.

    • Selects the user from the Financing Templates table.

    • A financing template is not required to create a calculation.

    • After clicking on the lookup, you will see a tab to select a financing template. The card consists of two sections: Financing Template Identification (Selection Field) and Financing Template Subform.

    • In the Financing Template Identification tab, there will be the following selection fields:

      • Customer No.

        • OC pre-fills automatically, not editable. (there will also be a filter on empty, i.e. it will fill in the value from the wizard and empty)

      • Branch Code

        • OC pre-fills automatically, not editable. (there will also be a filter on empty, i.e. it will fill in the value from the wizard and empty)

      • Salesperson Code

        • OC pre-fills automatically, not editable. (there will also be a filter on empty, i.e. it will fill in the value from the wizard and empty)

      • Financing Product No.

        • OC pre-fills automatically, not editable.

      • Commodity Code

        • OC pre-fills automatically, not editable.

      • Group Code

        • OC pre-fills automatically, not editable.

      • Subgroup Code

        • Selected by the user

        • lookup into subgroups, which will be filtered to Catalogue Group

      • Type Code

        • Lookup into species, selected by the user

      • Make Code

        • lookup into tags, selected by the user

      • Model Line Code

        • lookup to model lines, filtered to Make, selected by user

      • Model Code

        • lookup to models, filtered to Model Line and Make

    • The Financing Templates subform will contain lines that will be automatically filtered to:

      • Type=Financing Template (system filter)

      • Status = Active (System Filter)

      • Valid from<= today <= Valid to (today adds to the filter on the open page, system filter)

      • Legal Form Filter – filter for a given value and empty (system filter)

      • Customer No. – filter for a given value and blank

      • Branch code – filter for a given value and blank

      • Salesperson code – filter for a given value and blank

      • Financing Product No. – Filter for a given value

      • Commodity code – filter for a given value

      • Group code – filter for a given value

      • Subgroup Code – Filter for a given value

      • Type code – filter for a given value

      • Brand code – filter for a given value

      • Model Line Code – Filter for a given value

      • Model Code – Filter for a given value

      • Currency code – filter in the Currency and calculation parameters table, where Type=Financing Template and the given currency (system filter)

    • The user clicks to select the relevant subform row and the Financing Template is selected. Subsequently, after clicking on the OK button, the form closes. The OC writes the Financing Template No. into the wizard field. Double-clicking on a given row has a similar effect.

    • If the Financing Template No. is empty, when you click on the Next button, the system will display the message: "The Financing Template No. is not filled in. Do you wish to continue?"

      • If the user confirms Yes, they can continue.

    • If the value of this field is changed, then the value in the field will be deleted

      • Catalogue Card No.

      • Updated fields in downstream steps

  • Calculation Template Name

    • To be completed after selecting Financing Template Numbers

    • Non-editable

At the end of step 1, the user has the following buttons:

  • Back – inactive button

  • Next – Move to the next step using the Next button, where the required fields will be checked, see above.

  • Finish – inactive button

  • Close – after pressing the Close button, the OC displays the message "Do you really want to close the calculation without saving?" If the user confirms Yes, the OC closes the window without saving the record to the database. If he confirms No, then the user can continue entering data into the wizard.

After clicking on the next option, Step No. 2 will be displayed

  • Catalogue Card No.

    • Selects the user from the Catalog table.

    • After clicking on the lookup, a card for selecting a catalogue card will appear. The card consists of two parts: Catalogue Card Identification (Selection Field) and Catalogue Cards Subform.

    • If only Financing Product has been entered, then the field will be added to the filter tab as follows:

      • Object Category

        • Fills in OC automatically according to the commodity, not editable.

      • Commodity

        • Adds OC automatically from the wizard, not editable.

      • Group

        • Adds OC automatically from the wizard, not editable.

      • The other fields will be selected by the user

    • If the Financing Template has been entered in the wizard, then the field is added to the filter tab as follows:

      • Object Category

        • Fills in OC automatically according to the commodity, not editable.

      • Commodity

        • Adds OC automatically from the wizard, not editable.

      • Group

        • Adds OC automatically from the wizard, not editable.

      • Subgroup Code

        • If there is a non-empty value on the financing template, then it will be filled in and the field is non-editable. Otherwise, the user selects whatever

      • Type Code

        • If there is a non-empty value on the financing template, then it will be filled in and the field is non-editable. Otherwise, the user selects whatever

      • Make Code

        • If there is a non-empty value on the financing template, then it will be filled in and the field is non-editable. Otherwise, the user selects whatever

      • Model Line Code

        • If there is a non-empty value on the financing template, then it will be filled in and the field is non-editable. Otherwise, the user selects whatever

      • Model Code

        • If there is a non-empty value on the financing template, then it will be filled in and the field is non-editable. Otherwise, the user selects whatever

      • The other fields will be selected by the user

      • The subform contains a list of catalogue cards that:

        • If no catalogue cards have been entered in the Financing Template, the list of catalogue cards in the subform will be filtered to the values entered in the Object identification tab

        • If catalogue cards have been entered on the Financing Template, there will be a list of them in the subform

        • If exactly one catalogue card has been entered on the Financing Template, OC will automatically fill in its number in the wizard.

    • The Catalogue Card No. field is mandatory, it is not possible to continue without selecting/completion. If the user wants to continue without entering the Catalogue Card Number, the OC will display the error message "Please enter the Catalogue Card Number" when moving to the next step (the "Next" button) and will not allow the process to continue.

  • Catalogue Card Name

    • The system will be completed according to the catalogue card number

  • Financed Object Metod Usage

    • The default value is filled in from the API Fin. Object Usage Method (4047061) from the line Default=Y (similarly the Financed Object Metod Usage field (4047100) is filled in on the subject

    • The user switches to a different type of usage manually if it is a special type of item

  • Vendor No.

    • Selection of suppliers

  • Vendor Name

    • The system will be completed according to the vendor number

    • Field is non-editable

  • Vendor Business Place No.

    • Selection of suppliers

  • Vendor Business Place Name

    • The system will be completed according to the number of the supplier's cost center

    • Field is non-editable

  • Operating Unit

    • If only the Financing Product No. has been entered, the OC will be completed automatically according to the financing product.

    • If the Financing Template No. has been entered, the OC will be completed automatically according to the Financing Template No.

    • Editable

  • Initial Pointer Status

    • Does the user manually enter the initial status of the pointer

    • Default value 0

  • First Registration Date

    • The OC will be completed automatically as it sets the Expected Handover Date in the background according to the settings on the Financing Model Default date assumed. Handover=First Day of This Month, Current Date, or First Day of Next Month.  

      • Note: this ensures that the same dates are added for new courses after the calculation is created. Also, if the user does not change the First Registration Date for a used item, the same dates will be added to the calculation.

    • Editable if in the first step is Used Financed Object=A

    • Non-editable for new subjects, i.e. Financed Object Used=N

  • Financing Period

    • If only the Financing Product No. has been entered, the OC will be automatically completed according to the Financing Product No. from the Financing Period – default field from the financing product.

      • The user can change between Financing Period-min and Financing Term-max in increments according to Financing Term-step, according to the values set on the financing product.

        • If the Financing Period value is > Financing Period-max, the OC will display the message "The maximum financing period on the financing product has been exceeded. Do you wish to continue?" If the user confirms, they can continue with the process.

        • If the Financing Period value is < Financing Period-min, the OC will display the message "The Financing Period on the financing product has not been reached. Do you wish to continue?" If the user confirms, they can continue with the process.

    • If the Product Template No. has been entered, the OC will be filled in automatically according to the Financing Template No. from the Financing Period – default field from the calculation template.

      • The user can change between Financing Period-min and Financing Term-max in steps according to Financing Period-step, according to the values set on the product variant.

        • If the Financing Period value is > Financing Period-max, the OC will display the message "The maximum financing period on the financing template has been exceeded. Do you wish to continue?" If the user confirms, they can continue with the process.

        • If the Financing Period value is < Financing Period-min, the OC will display the message "The minimum financing period on the financing template has not been reached. Do you wish to continue?" If the user confirms, they can continue with the process.

    • An editable field.

  • Contractual Mileage

    • Does the user manually enter the contractual mileage for the duration of the contract

    • Field editable, optional.

    • If Yearly Mileage has been entered, Contractual Mileage will be calculated automatically

    • If it is not filled in, the OC will display the message "Contractual mileage has not been entered. Do you wish to continue?" Once confirmed, the user can continue without entering a value.

  • Yearly Mileage

    • Editable.

    • If a Contractual Mileage has been entered, it will be calculated automatically according to the current functionality in the Contractual Mileage table.

At the end of step 2, the user has the following buttons:

  • Back – active button, can return to step 1

  • Next – continues to step 3 of the wizard

  • Finish – inactive button

  • Close – after pressing the Close button, the OC displays the message "Do you really want to close the calculation without saving?" If the user confirms Yes, the OC closes the window without saving the record to the database. If he confirms No, then the user can continue entering data into the wizard.

After clicking on the next option, Step No. 3 will be displayed.

  • Payment Period

    • If only the Financing Product has been entered, the OC will be completed automatically according to the Financing Product Number.

    • If a Financing Template has been entered, the OC will be completed automatically according to the Financing Template No.

    • Only Period=Monthly is used for calculation with services

  • Interest Rate Type

    • If only the Financing Product has been entered, the OC will be completed automatically according to the Financing Product No. and Currency Code from the table Currency and calculation parameters:

    • If Blank and the Financing Product Type contains parameter Optional Financing=N, the user can choose from Fixed, Variable values

    • If the value is different from Blank, not editable.

  • If a Financing Template has been entered, the OC will be completed automatically according to the Financing Template No. and Currency Code from the table Currency and calculation parameters:

    • If Blank and the Financing Product Type contains parameter Optional Financing=N, the user can choose from Fixed, Variable values

    • If the value is different from Blank, not editable.

  • If the values were taken from a product/template, the system will try to find the REFI code automatically (description below)

  • If it was not taken from a product/template and the user selects it manually, the system will try to find the REFI code automatically (description below)

  • When changing the value manually, the system will also try to find a new REFI code:

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

    • 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).

    • When changing to an empty value, the original REFI code deletes but keeps the interest rates (for technical reasons it is not possible to delete them).

  • REFI Code

    • It is an optional field for the parameter Optional REFI code=A according to the Financing Product Type Code and the OC does not search for the REFI code.

    • If the parameter REFI code =N Optional on the Financing Product Type Code, then the system will find the REFI code as follows:

    • According to the following filters, it will find a matching REFI code:

      • Currency Code

        • 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 (when creating a calculation, the Reference Date is filled with workdate)

      • Valid To

        • The "Valid To" date must be blank, 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 it does not find a matching REFI code, it displays a message and does not continue.

    • If it finds exactly one matching REFI code, it proceeds to check the REFI code rates:

      • For the given 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 Reference Date of the contract

        • 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. Contract From<=Financing Period<=Max. Leas. Contract To

        • Active=A

      • If the Base Rate and Cost Rate are suitable, then they are taken into the wizard fields:

        • Basic Rate

        • Cost Rate

      • Then calculates:

        • Reference Interest=Base Rate+Cost Rate

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

    • If the system finds more than one matching REFI code, then it ends and the user has to select on their own, with the same conditions as described above.

  • Basic Rate %  

    • completes the system automatically according to the selected REFI code as described above

    • Non-editable field

  • Cost Interest %

    • completes the system automatically according to the selected REFI code as described above

    • Non-editable field

  • Reference Interest %

    • Fills in the system automatically:

      • Reference Interest=Base Rate+Cost Rate

    • non-user-editable field

  • Interest Margin %

    • If only the Financing Product has been entered, the OC will be completed automatically according to the Financing Product No. and Currency Code from the table Currency and Calculation Parameters

    • If a Financing Template has been entered, the OC will be completed automatically according to the Financing Template No. and Currency Code from the table Currency and Calculation Parameters

    • Editable if the interest rate type is equal to Variable, the system then calculates the Calculation Interest %

  • Calculation Interest Rate % (p.a.)

    • The system calculates

    • Editable if the interest rate type is equal to Fixed, the system then calculates the Interest Margin %.

At the end of step 3, the user has the following buttons:

  • Back

    • active button, it may return to the previous screen

  • Next

    • Inactive button

  • Finish

    • After confirming Finish, the wizard will perform a flag check on the Contract Financing Product Type

      • If REFI code=N is Optional and the REFI code field is empty, it will display an error and will not allow you to continue. If the REFI code is entered, it continues to create the calculation.

    • If REFI code = Optional, it does not perform the check and continues and displays the message:

      image-20240617-081433.png

    • User confirms No:

      • The OC does not open the created calculation, the user can return to it later

    • User confirms Yes:

      • The OC automatically opens the offer card, the item card and then the Price and Equipment form so that the user can configure the item (described in the next chapter)

  • Close – after pressing the Close button, the OC displays the message "Do you really want to close calculations without saving?" If the user confirms Yes, the OC closes the window without saving the record to the database. If it confirms No, it can continue with the entry.