Supplier Product - Bulk Update

An extension of Supplier Product settings, the Supplier Product - Bulk Update page allows you to activate, deactivate and change the Show On PO, Current Price and Sequence of multiple supplier products easily.

To access Supplier Product - Bulk Update settings:

Click on on the quick links bar from any page.
In the Settings window:

Settings associated to a page automatically show in the List box. If the setting that you want to access is in the List box, you can skip step a.
1. Select Inventory from the Filter drop-down list.
2. Click on Supplier Product - Bulk Update from the List box in the left pane.

The following information is displayed on the settings page for the Area* and Store selected using the filters at the top of the page:

Status: A checkmark in the column indicates that the supplier product can be ordered from the supplier using the Create Purchase Order page at present and can be included on invoices, while an empty box indicates that it cannot be ordered.
Show On PO: A checkmark in the column indicates that the item will show on the PO Product List when creating a PO for the supplier. An empty box indicates that the user will have to use the Quick Search bar on the PO Product List window to include the supplier product in the PO.
Description: The name of the supplier product.
Code: The product code used for the product by the supplier.
Pack size: Also referred to as Per Method #1 in Physical Counts, it is the size or quantity of the inventory item considered as one unit by the supplier (for example, large case, box, etc.).
Current Price*: The last invoiced price of the supplier product for the store selected.

The Current Price is automatically updated each time the price is updated on an invoice.
Latest Price*: The last updated price of the supplier product and may not be effective as yet.
Supplier Name: The name of the supplier that supplies the product.
Sequence: The order in which the product is displayed on invoices and when creating a PO for the supplier.

Update Multiple Supplier Products

If the effective date for a price change is different for some products, follow the process listed below to update the price of products that share the same effective date and then repeat the process for each different effective date.

Go to Supplier Product - Bulk Update settings.
Select the Area* and Store from the drop-down list(s).
Select the Supplier, Sub-Category and Status from the drop-down lists if required.
Enter the Description of the supplier product or the Product Code, if required.
Select whether you'd like to view the Current price or the LatestPrice.
- Current: Will display the current effective price of the supplier products.
- Latest: Will display the last updated price (which may not be effective as yet) of the supplier product.
Click on the Go button.
Place a checkmark in the Active column of a product or remove it to activate or deactivate it, respectively.
Place a checkmark in the Show On PO column of a supplier product to include it in the PO Product List by default, or remove the checkmark to remove the supplier product from appearing in the PO Product List by default.

Supplier products that are set not to Show On PO can still be added to the PO Product List by using the Quick Search bar on the page when creating the PO.
Enter the new price of the supplier product in the Current Price* or Latest Price* column to update it if needed.
Change the Sequence if required.
Select the Effective date for price changes from the drop-down calendar if you've changed any of the prices.
Click on the Submit button.
Click on the OK button in the confirmation pop-up box.

Related CLEARVIEW Pages

*optional section or field that may or may not be visible depending on the settings selected, whether the supplier is integrated or not, etc.