Export stock item suppliers

Find this screen

Open: Export Records > Stock And Prices > Export Stock Item Suppliers

How to

Export stock item suppliers

Use this to export stock item suppliers to a CSV Comma Separated Value (CSV) file format. Sage 200 can import and export data in the CSV file format. file.

You can make changes to your stock item suppliers using an external tool (such as Excel), and then import your updated information back into Sage 200.

Open: Export Records > Stock And Prices > Export Stock Item Suppliers

1. Choose whether to export details for hidden suppliers and inactive stock items.

   • Enable Include hidden supplier accounts if you want to export details for suppliers that have an Active status of Hidden.

   • Enable Include inactive stock items if you want to export details for stock items that have an Current status of Inactive.

   Note: Suppliers that have an On Hold status are included in the export.

2. Choose the stock item supplier details to export.

   • Single stock item: Export supplier details for a particular stock item.

   • Single product group: Export supplier details for all stock items that are in a particular product group.

   • Single supplier account: Export details of all stock items for a particular supplier.

   • All stock items: Export supplier details for all stock items.

3. Select OK and confirm that you want to export.

4. Enter a name for the export file, then select Save.

---

Useful info

About exporting stock item suppliers

You can export supplier details for all stock items, a single stock item, stock items in a product group, or stock items for a single supplier. Stock item supplier details are exported to a CSV Comma Separated Value (CSV) file format. Sage 200 can import and export data in the CSV file format. file format.

Note: Landed cost details for a stock item supplier will only be included in the export file if Use Landed Costs is enabled in Stock Control Settings.

After you export stock item suppliers, you can use the file to import and update stock item suppliers, or to delete stock item suppliers.

Exporting and updating information

Some information can be exported to a CSV file, which can make updating the information easier if you need to make a lot of changes.

The information is exported to a CSV file in the same format used for an import. This means you can export information and make changes to it using an external tool (such as Excel), and then import your updated information back into Sage 200.

For details of which records you can export and update, see What can I import, export and update?

Updating information

• An import file can include information for both new records and existing records that you want to update. You can choose whether or not to update existing records when you import.

• Check the import format spreadsheet (XLS/XSLX file) for details about each import format.

• Not all fields need to be included in the import file. You only need to include the mandatory fields.

  • If you do not want to include a field for a particular record, just leave that field blank.
  • If you do not want to include a field for any of the records in your import file, then you can remove the field altogether (including the heading).