How to Create and Update Contracted Prices in SIMS using Excel

Creating and Updating Contracted Prices in SIMS using Excel

Creating New Contacted Prices


Scenario 1: Adding a new contracted price for an existing client

  1. Go to Support > Clients and choose the client.
  2. Click on the Contracted Prices tab.
  3. Press + or 'Insert' on the keyboard.
  4. Enter the stock code and choose a fixed price or discount for the item, then save.


Scenario 2: Adding a new contracted price or prices for multiple clients

  1. Go to Support > Clients and choose a client.
  2. Click on the Contracted Prices tab and then click I. This brings up all clients' contracted prices.



  3. Click on the grid's menu and select 'Generate Microsoft Excel template'.



  4. In the resulting Excel template, fill in the required fields (Client, Stock Code, and either Selling Price or Discount) for as many new items as required.
  5. When the Excel sheet is ready, import it back into SIMS using 'Import from Microsoft Excel' in the grid's menu.



VIMP: The above method must be used only for new contracted prices.

Updating Contracted Prices


Amending Contracted Prices

  1. Go to Support > Clients and choose a client.
  2. Click on the Contracted Prices tab and then click I. This brings up all clients' contracted prices.
  3. Click on the grid's menu and select 'Export to Excel'.



  4. Update the discount and/or selling price.

     

  5. Import the file back into SIMS using 'Import from Excel' in the grid menu.
  6. The specific item or items will now be updated with the amended price or discount.



IMP: To make changes  to specific items, select all the fields except the replic id when exporting to Excel. If you leave out any of the required fields (see list under 'Fields to Export' below) and import back to SIMS, the original record will remain unchanged and a new record will be created instead.



If you export current contracted prices without the TranNum column and import the file back with changes, the system will create a new record instead of making the change.


How do I delete a record?

There are three ways to delete a record.

Option 1: Highlight the record and use the 'Delete' key on the keyboard.
Option 2: Enter a past date in the 'Date To' field for the item and then click Delete Expired Items. To add the 'Date to', enter the date you require after exporting to Excel, and then import the sheet back to SIMS.

Before deleting:


After deleting:



Option 3: Use the 'Range from' and 'Range to' fields to select specific items and then press Delete Current View.