> Importing and exporting / Importing files / Commercials / Import selling prices

Import selling prices

Selling prices are imported according to the price band they belong to. This provides a means to import several selling prices for the same stock item. You must create a price band in Sage 200 before you can import prices into it. The price band name specified in the import file must match the price band name in the system.

The system displays the results of the import, providing the number of records imported and the number rejected. Selling prices for a stock item are rejected if:

The selling price has no value specified.
The selling price is negative.
The stock item code does not exist in the system.
The stock item is duplicated in the import file.

Rejected records can be viewed in the error log, accessed from the validation result prompt.

To import prices

Open: Price Book > Utilities > Import Prices.

Select the required import option.
- Validate only, to just check the data in the file.
- Validate and import records, to check and import the data from the file.
Click OK, and specify the path of the file that contains the transaction entries.