Price lists

Management of Price Lists

On this help page you will find documentation on Price List Management.

Manual update of a part's sales price

Sometimes it is necessary to modify the sales price of a specific part, to do this we do the following steps:

  • We open the Customer Prices, which is located in the following path: [Parts Module -> Parts tab -> Rates Section -> Customer Rates option]
  • Right-click on the tariff to be updated and select the option View current prices.
  • The Maintenance of current prices in customer sale tariffs window will appear.
  • Select the part to be modified and click on the Search button.
  • Click on the button
  • Modify the field Price
  • Confirm the changes by clicking on the button.

In the Price history button we can search all the price changes made to the part.

Updating the sales price of several parts using an Excel file

Sometimes it is necessary to modify the sales price of one or more parts. To do this, follow the steps below:

  • Create an Excel file with the necessary data:
  • Brand
  • Part
  • Supplier
  • Sales Price
  • We open the Customer Prices.
  • Right-click on the tariff to be updated and select the option View current prices.
  • The Maintenance of current prices in customer sales tariffs window will appear.
  • Click on the Import Excel button.
  • The Excel file import wizard will open.
  • Click on the Next button.
  • Select a previously created import template with the option From a template or create a new one with the option New source
    Check the option Interpret the first row of the file as the row of column names
  • Click on the button and browse to the Excel file created earlier.
  • Click on the Finish button.

Manual update of the purchase price of a part number

Sometimes it is necessary to modify the purchase price of a specific part, to do this we perform the following steps:

  • We open the Supplier Rates, which is located in the following path: [Parts Module -> Parts Tab -> Rates Section -> Supplier Rates Option]
  • Right-click on the tariff to be updated and select the option View current prices
  • The window Maintenance of current prices in purchase tariffs to suppliers will appear.
  • Select the part to be modified and click on the Search button.
  • Click on the button
  • Modify the field Price
  • Confirm the changes by clicking on the button.

In the Price history button we can search all the price changes made to the part.

Updating the purchase price of several parts using an Excel file

Sometimes it is necessary to modify the purchase price of one or several parts, to do this we carry out the following steps:

  • Create an Excel file with the necessary data:
  • Brand
  • Part
  • Supplier
  • Purchases price
  • We open the Supplier's prices.
  • Right-click on the price to be updated and select the option View current prices.
  • The Maintenance of current prices in purchase tariffs to suppliers window will appear.
  • Click on the Import Excel button.
  • The Excel file import wizard will open.
  • Click on the Next button.
  • Select a previously created import template with the option From a template or create a new one with the option New source
    Check the option Interpret the first row of the file as the row of column names
  • Click on the button and browse to the Excel file created earlier.
  • Click on the Finish button.

Reports

When importing a price list and before confirming it, we must check that the amounts are correct. To do this we have two reports in the Price List Follow-up:

🔹 Report Totals Miscellaneous:

  • Amount of total lines: Total number of lines in the price list.
  • Number of parts (Definitive Lines): This section is useful in those markets where the same partcode may be supplied by different suppliers. Here the definitive lines will be shown even if the partcodes are repeated, applying priority rules.
  • New parts (Non-existent in SIMA): New parts, which do not exist in the SIMA master catalog.
  • Duplicate parts: This section shows duplicate partscodes because they are provided by more than one supplier.
  • Proposed parts to remove: Parts marked for deletion in the price list.
  • Parts removed from SIMA, and included in the List: Parts that have been removed in SIMA, but are included in the price list.
  • Parts with Purchase Price <= 0: Parts with zero or negative purchase price.
  • Parts with replacement cost <= 0: Parts with zero or negative replacement cost.
  • Parts with Definitive RRP <= 0: Parts with zero or negative sales price.
  • Parts with Purchase Price = Replacement Cost ... Without Sales Purchase Conditions: Parts with purchase price equal to the replacement cost, and which have no purchase conditions associated with them.
  • Parts with Purchase Price > Previous Purchase Price: Parts with purchase price higher than the previous purchase price that was set in the parts control board.
  • Parts with purchase price < Previous purchase price: Parts with purchase price lower than the previous purchase price that was set in the parts control board.
  • Parts with Purchase Price = Definitive RRP ... Without Factors to calculate its RRP: Parts with purchase price equal to final sales price because they have no factor to calculate their sales price, so both prices are equal.
  • Parts with Definitive RRP < Purchase Price: Parts with final sales price lower than purchase price.
  • Parts with Definitive RRP < Replacement Cost: Parts with final sales price lower than replacement cost.
  • Parts with Definitive RRP > Previous RRP: Parts with a final sales price higher than the previous sales price.
  • Parts with Definitive RRP < Previous RRP: Parts with a final sales price lower than the previous sales price.
  • Parts with manual RRP: Parts for which the sales price has been set manually in the price list.
  • Parts with manual RRP <> Definitive RRP: Parts with manually sales price different from final sales price.
  • Parts with Net RRP <= Replacement Cost: Parts with net sales price equal to or lower than replacement cost.
  • Parts with Purchase Price > Previous Purchase Price (> 1 HUF): The purchase prices are received with decimals, but these are rounded off when importing the price list. In this section, decimals are ignored and partcodes whose purchase price in the list is higher than the previous purchase price are displayed.
  • Parts with Purchase Price < Previous Purchase Price (> 1 HUF): The purchase prices are received with decimals, but these are rounded off when importing the price list. In this section, decimals are ignored and partcodes whose purchase price in the list is lower than the previous purchase price are displayed.

🔹 Report Grouped Totals:

This report shows price list information grouped by items, some of which are:

  • Supplier
  • Brand
  • Discount group
  • Purchase Packaging Unit
  • Sales Packaging Unit
  • Transaction Object
  • By margin

Creation of Price Lists with an Excel File

The following videos explain how an Excel price list can be imported into SIMA.

The import of this type of price lists is based on a basic Excel template that must contain, as a minimum, the following fields:

  • Brand
  • Part Code
  • Part name
  • Supplier Id
  • Purchase Discount Group
  • Sales Discount Group
  • Purchase Price
  • Sales Price

We have divided the import into the 4 steps:

  • Video PriceList-Step01:
    • Explains how to import the Excel file in SIMA.Link
  • Video PriceList-Step02:
    • Explains how to create the unified price list in SIMA.Link
    • Important: Before confirming the price list, we have to check purchase prices, sales prices, etc. For this purpose, the reports explained in the Reports section of this page should be used.
  • Video PriceList-Step03:
    • Explains how to modify data, add rate and set the effective date. Link
  • Video PriceList-Step04:
  • Explains how to confirm cost and sales price. Link

🚩 Hungary Market

Creation of BIR-FRP file

The BIR-FPR file is the price list file that is generated by the importer and must be sent to the dealers.

Important: The BIR-FPR file can only be generated from confirmed price lists.

To generate it, we must do the following:

  • Open SIMA
  • Go to the Price list follow-up, located in the path: [Parts Module -> Parts Tab -> Price Section -> Lists Option]
  • Click on the Search option in the left menu General, to display the price lists
  • Right-click on the price list from which we want to generate the BIR-FPR file
  • Select the option Show list to open it
  • The price list will open
  • Click on the Export files button at the top of the window
  • The After-Sales Parts window will be opened
  • In this window, set the following values:
  • Field Rate: drop down the list and choose General rate
  • Field format: drop down the list and choose RENAULT IS1
  • Field Change factor: set the factor to be applied to the dealer's price list
  • This field indicates the multiplication factor to be applied to the sales price.
  • For example, if the sales price is 20,00 and 1.5 is specified in change factor then the final sales price will be 30,00, i.e. the multiplication (20,00 * 1.5).
  • The Export path field will indicate the path where the BIR-FPR file will be generated
  • Click on the Accept button and SIMA will inform us when it has finished generating the file


Was this article helpful?

English
Powered by Product Fruits