/
Tire Service - RIM

Tire Service - RIM

Owned by Lango: Language and translation manager
Last updated: Sept 05, 2024Version comment
7 min read

The Tire Service – Rims is defined in the Rim price list, where the prices for individual rims are also listed. The rim is identified by its technical data and according to this technical data, the correct rim from the price list is searched for in the calculation, i.e. the technical parameters from the price list are paired with the technical parameters of the object tire. In the definition of the tire service – Rim, it is possible to define discounts from suppliers according to individual types of rims, which are added to the rim price list.

Rim Type

Field:

  • Code

    • The user enters a unique brand code of the rim type

  • Description

    • The user enters a description of the rim type

  • Rim Category

    • The user assigns the rim type to one of the categories Basic, Premium

  • Imported

    • If the leasing company has integrated the import of catalogue data, then this field can be used

    • For manual management of the dial, the value of this field is always NO and cannot be changed

Rim Discounts

Field:

  • Rim Type Code

    • The user selects the rim type from the rim type dial

  • Rim Vendor Code

    • The user selects the rim vendor code from the vendor code list

  • Rim Vendor Name

    • The system fills in the name of the rim vendor automatically after filling in the Rim Vendor Code

  • Rim Discount %

    • The user enters a discount in % for a given rim type and supplier

  • Valid From

    • The system will automatically fill in the current system date and time

    • The user can't change the value

  • Valid To

    • When a new row is created, the system automatically fills in the values in the Rim Type and Rim Vendor No. fields with the same value as the value of the Valid From field in this new row

    • The user also has the option to fill in this field using the Add valid to button, but only to the row where the value of this field is Blank

Automatic price list update

Whenever a record is changed (adding a new one, changing an existing one (any field), deleting an existing one) in the Rim Discounts code list, an automatic function is triggered that pulls the current discount from the Rim Discounts dial list to the Rim Pricelist code list, i.e. it sets the current value in the "Rim Discount in %" field, depending on the rim type, supplier and discount validity for those Rim Pricelist items that have the value of the field Do Not Offer=NO.

At the same time, the value of the field is calculated:

  • Discount Price Excl. VAT =List Price Excl. VAT * Rim Discount % / 100

Rim Pricelist

The Rim Pricelist is used to record suppliers' price lists with rim technical data and price. The records are then used to calculate the rim service.

Field:

  • Code

    • The user manually enters the unique Rim Code (unique in combination with the Vendor Number) or populates the system when importing from the Code column from the imported file

  • Service Type Code

    • The user selects Service Types from the code list or fills in the system during import

  • Rim Type Code

    • Is it selected by the user from the Rim Types code list or populated by the system during import

  • Rim Category

    • Completes the system automatically after selecting Rim Type Code from Basic, Premium

    • Non-editable field

  • Vendor No.

    • Can the user manually select it from the Vendor code list or fill in the system automatically during bulk import from the import filter

  • Rim Make

    • To be entered manually by the user or to be completed by the system when importing from the Rim Make column from the import file

  • Description

    • Completes the system automatically after selecting the Rim Type Code

  • Design

    • To be entered manually by the user or populated by the system when importing from the Design column from the imported file

    • Informative Field

  • Vehicle Make

    • To be entered manually by the user or to complete the automatic system when importing from the Vehicle Make column from the import file

    • Informative Field

  • Vehicle model

    • Is it entered manually by the user or the system is completed automatically when importing from the Vehicle Model column from the import file

    • Informative Field

  • Width

    • Selects by the user from the Rim Widths code list or from the Dimension when importing (e.g. 6.5 from dimension 6.5Jx18)

    • The system filters to the value of this field in Object Rims when searching for a price on the service

  • Suffix (Suffix)

    •  Can the user enter it manually or fill in the system from the Dimension during import (e.g. J from dimension 6.5Jx18)

    • The system filters to the value of this field in Object Rims when searching for a price on the service

  • Diameter

    • Does the user select from the Rim Diameters code list or populate the system from the Dimension during import (e.g. J from dimension 6.5Jx18)

    • The system filters to the value of this field in Object Rims when searching for a price on the service

  • Number of Holes

    • Can the user enter it manually or fill in the system automatically from the import file from the Number of Holes column.  E.g. 5

    • If a value different from zero is entered for this field in Object Rims, then when searching for a price on the service, it filters to the value of this field

    • If a value of zero is entered for this field in Object Rims, then it does not filter to this field when searching for a price on the service

  • Screw-Hole Circle (mm))

    • Can the user enter it manually in mm or fill in the system automatically from the import file from the Pitch column. E.g. 112

    • If a value different from zero is entered for this field in Object Rims, then when searching for a price on the service, it filters to the value of this field

    • If a value of zero is entered for this field in Object Rims, then it does not filter to this field when searching for a price on the service

  • Central Hole (mm)

    • Can the user enter it manually or fill in the system automatically from the import file from the Central Hole column. E.g. 57

  • ET (ET)

    • Can the user enter it manually or fill in the system automatically from the price list from the ET column. E.g. 45.5

    • If a value different from zero is entered for this field in Object Rims, then when searching for a price on the service, it filters to the value of this field

    • If a value of zero is entered for this field in Object Rims, then it does not filter to this field when searching for a price on the service

  • Colour

    • Can the user enter it manually or fill in the system automatically from the import file from the Disc Color column (e.g. titanium gloss)

    • Informative Field

  • Comment

    • To be entered manually by the user or populated by the system when importing from the Note column from the import file

    • Informative Field

  • List Price Excl. VAT (Pricelist Price Excl. VAT)

    • Does the user manually enter the price in the local currency or populate the system when importing from the column Price in Local Currency (LCY) excluding VAT from the imported file

  • Rim Discount in %

    • Fills in the system automatically according to the Rim Type Code, Vendor No. and Rim Discount Validity (according to the condition Valid From <= Current System Date/Time < Valid To) from the Rim Discounts table. The filter for discount validity is also applied when importing the rim price list.

  • Discount Price Excl. VAT

    • The system fills in the value of the field automatically by recalculation according to the formula:

      • List Price Excl. VAT * (100 – Purchase Discount in %) / 100

  • Import Date

    • The system will automatically fill in the date of import/input of the given rim after filling in the mandatory fields (Code, Rim Code, Vendor No.)

  • Do not Offer

    • The default value will be No (unchecked). When updating the data (re-importing), the box will be checked if the system does not encounter an entry in the Rim Pricelist with the same Rim Code and with the Vendor No. in the import file.

Working with Rims Pricelist

To import tires, in the Rim Pricelist window that opens, click on button Import.

When you click on the import function, a window will open Import Rim Pricelistto enter more detailed import information (Vendor No., Rim Code, Service Type).

Importing (updating) the price list will follow these steps:

  • After modifying the vendor price list into a universal import file, the user starts the import. Selects the Tire Vendor whose price list you want to import, Rim Code, and Service Type.

  • The system then fills in the Rim Pricelist table, which:

  • According to the supplier specified by the user and the Service Type, it determines the relevant valid purchase discount from the Rim Discounts table, which it uses to calculate and complete the Price Excl. VAT in the Rim Pricelist table

  • If it finds an entry in the Rim Pricelist table that has the same Tire Code as the Code from the imported price list in combination with the Vendor No., it will update the List Price Excl. VAT, Rim Discount % (depending on the validity of the discount), Price After Discount excl. VAT of the rim

  • If no such record is found in the Rim Pricelist table, the system creates a new record (rim) in the database

  • If the system does not find a record with the same Rim Code in combination with the Vendor No. that is located in the OC but is not listed in the import file, then the Do Not Offer field will be checked and it will not be used further (it will not enter the subject and therefore the calculation)

  • If the system does not find a record in the Rim Width or Rim Diameter code list, then the system will insert a new value from the import file into these code lists and add it to the price list after the record is created.

 

After successful completion/processing of the import, the system displays a message indicating how many new records have been inserted or updated.

IMPORT FILE TEMPLATE: