Skip to content

Suppliers Price List

Introduction

Please see our Quick Tutorial on downloading, amending and updating supplier price lists from Sage 200 to Microsoft Excel.

The Suppliers Price List Excelerator allows Sage 200 Supplier's Price Lists to be maintained from Excel.

Features include:

  • Suppliers' price lists can be created and amended from Excel.
  • Flexible design for the spreadsheet templates.
  • Existing price lists can be downloaded, including the order history information visible in Sage Suppliers Price list entry.
  • Single or multiple price lists can be entered, downloaded and amended.
  • Browse Sage data and pick from browse to enter on the sheet.
  • The usual Excelerator features, as described in Introducing Excelerator.

The typical workflow will be either to enter new price lists for a supplier and then save them or to download an existing price list (or lists) and then amend those lists.

To use this Excelerator module, you must have Sage permissions to access the "Supplier Stock Items" feature.

Standard Templates

Codis provides the template S200SupplierPriceList.xlsx. You can, of course, amend this template or create your own. (See Designing Templates ).

The S200PLPaymentTemplate.xlsx includes sheets which allow:

Download and Populate

Downloading Suppliers' Price Lists

You can download Suppliers' Price Lists using Excelerator.

Single or multiple price lists can be downloaded depending on how you have designed your template.

The download will first show you a browse of suppliers. You will be allowed to select multiple suppliers if your template allows this.

Populate

This will populate the sheet with suppliers' price list values for the entered supplier for stock codes already entered on the sheet.

Saving and Amending Suppliers' Price List

To save or make changes to a supplier's price list, you can enter a new price list, or download and amend an existing one. Before saving, you have the option to validate your data to ensure it conforms to Sage's business rules, or you can directly save it which will automatically check the rules.

If you're amending a price list, please note that only the stock items included on the sheet will be affected. Any items previously saved but not on the sheet will remain unchanged, and if you wish to delete any stock items from the price list, use the Delete ribbon button. Additionally, ranges that are not included on the sheet will not be affected when you save the price list. To save or make changes to a supplier's price list, you can enter a new price list, or download and amend an existing one. Before saving, you have the option to validate your data to ensure it conforms to Sage's business rules, or you can directly save it which will automatically check the rules.

Delete

Suppliers Price List - Delete Items