Change Suppliers

Contents of this Topic: Show

Overview

The Change Suppliers screen is used to add or alter existing supplier record(s) associated with inventory items. When making any mass changes, it is advisable to backup the store data file first.

To access this screen, go to Main Menu>Settings>Inventory Functions>Change Suppliers.

This screen can be used to designate the Primary Supplier for a group of products at once. To be the Primary Supplier of a product simply means the program uses that supplier record when automatically creating purchase orders to replenish inventory levels. It is possible to override that assumption and manually instruct the program to generate purchase orders for another secondary supplier if necessary.

You can set the Suppliers SKU field to the value of the Local SKU field for a group of inventory records (products), simultaneously, and the new supplier's Unit Cost for the products can be changed manually at this screen.

Use the controls on the left-hand side of the screen to select product records to change. Add the products to the right-hand pane of the screen and make any changes necessary there. Select Make Changes to put the changes into effect.  

Description of the screen

Change Supplier screen: Add a supplier to inventory records

Change Suppliers screen: Change products from one supplier to another supplier

 

Methods to filter for target product records

There are several ways to build a list of SKUs and make changes to them in a batch. Select the method that works for you.

Select SKUs that

Begin with
End with:
Build List

Select SKUs to modify

Another method is to add product records to the list box in the left-hand pane by using the Search, Show All or the SKUs letter and number buttons. Then select a record and select the Add to List button to move the product SKU to the right-hand pane.

While this pane may display more than one SKU at a time, it is not possible to move more than a single SKU to the right-hand pane at one time.

Search
Add to list
SKUs

Change Type  (not labeled as such in the program)

Add Supplier

Change Supplier

Set as Primary Supplier

Add:

From:

To: Drop-down List

The right-hand pane (not labeled)

This section of the screen contains the list of SKUs (inventory records) that are candidates for change.

Clear List

Delete

Make Changes

Local SKU

Supplier's SKU

Unit Cost

Add Supplier's SKUs

For use as Supplier's SKU Section

  1. This section of the screen allows you to make mass changes to the Supplier's SKU field for some or all of the records listed in the right-hand pane. Click Update List to see the new supplier's SKU in the right-hand pane. If this data is to be changed, do so before selecting Make Changes. Use a combination of the following buttons to make your changes.

Use supplier's own SKU
      • select this to enter the value of the Supplier's SKU field in the inventory record in the Supplier's SKU field in the right-hand pane

Use your Local SKU
      • select this to use the value of the Local SKU field in the inventory record as the Supplier's SKU field in the right-hand pane

For Selected Item
      • select this to limit the scope of the action of Use supplier's own SKU or Use your Local SKU to a single item when Update List is clicked

      • select the row of the single item in the right-hand pane

For Entire List
      • select this to change the value of the Supplier's SKU field to the value of the Local SKU field for every inventory record in the list when Update List is clicked

How to build a list of records to be modified

Method 1: Select SKUs that

  1. Select Begin with or End with from the drop-down list.

  2. Enter a string of characters in the adjacent text field.

  3. If adding a new supplier record to the product, select the Add Supplier radio button, and skip to step 5. Otherwise proceed with the next instruction.

  4. The Change Supplier radio button is selected by default when this screen is opened.

    1. Choose the supplier record to be replaced in the From: drop-down list.

    2. Choose the supplier record that is replacing the current supplier record in the To: drop-down list.

  5. Select Build List.

  6. A list of records (SKUs) matching the criteria in the text field appear in the right-hand pane.

  7. Continue adding records to the list or make the desired changes to the records in the right-hand pane.  

Method 2: Select SKUs to Modify

Scenario A: Using the Search button

  1. Select Search to open the Search Inventory screen. Refer to its Knowledge Base topic for information about using that screen.

  2. When a SKU (inventory record) is selected at that screen, it appears in the SKUs to Modify list box.

  3. Select the SKU in Select SKUs to Modify.

  4. Select Add to List and that record appears in the right-hand pane.

  5. Continue adding other records or proceed with making the desired changes to the records in the right-hand pane.

Scenario B: Using the SKU Starts With buttons

  1. Select a number or letter button to see a list of records starting with that character in Select SKUs to Modify.

  2. Select the row the SKU to be changed.

  3. Select Add to list to have this record appear in the right-hand pane.  

  4. Continue adding other records or proceed with making the desired changes to the records in the right-hand pane.

Method 3: Using the Add Supplier's SKUs button

  1. Select the Change Supplier radio button.

  2. Select a supplier in the From: drop-down list.

  3. Select the Add Supplier's SKUs button.

  4. All of the inventory records that are associated with the selected supplier appear in the right-hand pane.

  5. Continue adding other records or proceed with making the desired changes in the right-hand pane.

How to change supplier records for a group of inventory items

  1. Build a list of records to be changed by using one of the methods described elsewhere in this topic.

  2. Select the Change Supplier radio button. (selected by default when this screen is opened)

  3. Choose the supplier record to be replaced in the From: drop-down list.

  4. Choose the supplier record to replace the current supplier record in the To: drop-down list

  5. If the new supplier record should be designated as the Primary Supplier for the selected products, leave the check box marked. Otherwise, clear the box.  

  6. Optional: Select whether to use the suppliers own SKU as the Supplier's SKU in the inventory record or to use the value of the Local SKU field as the Supplier's SKU. Choose to make that change for a single record or all records in the right-hand pane.

  7. Optional: Edit the Unit Cost values of the records in the right-hand pane.   

  8. Select Make Changes.

  9. The program prompts for confirmation.

  1. Select OK to proceed with the change or Cancel to abort the changes.

  2. The program may prompt the user again if it detects other issues:

  1. Select OK to proceed with the change or Cancel to abort the changes and correct the other issues.

  2. Finally, the program prompts the user to acknowledge the completion of the changes.

  1. Select OK to end the dialog.

How to add a supplier record to a group of inventory items

  1. Backup the store data file as a precaution.

  2. Build a list of records to change by using one of the methods described earlier in this topic.

  3. Select the Add Supplier radio button.

  4. Choose the supplier record to associated with the product in the Add: drop-down list.

  5. If the new supplier record should be designated as the Primary Supplier for the selected products, leave the check box marked. Otherwise, clear the box.  

  6. Optional: Select whether to use the suppliers own SKU as the Supplier's SKU in the inventory record or to use the value of the LocalSKU field in the inventory record as the Supplier's SKU. Choose whether to make that change for a single record or all records in the right-hand pane.

  7. Optional: Edit the Unit Cost values of the records in the right-hand pane.   

  8. Select Make Changes.

Additional information

Backup Data File

Inventory

Advanced Inventory Search

 

Created: 7/12/11

Revised: 6/30/15

Published: 08/19/15