Stock item settings can be extracted from the Stock Control module into a CSVComma Separated Value (CSV) file format. Sage 200 can import and export data in the CSV file format. or XMLExtensible Markup Language (XML) file format. Sage 200 can import and export data in the XML file format. file format. You cannot export stock transactions (movement history) or bill of material (BOM) details.
The settings are exported in the same sequence as the import file format.
Information not exported covers the stock type, search categories, units of measure, costing method, locations (warehouses and bins), attachments or the current status of the stock item (active or inactive).
You can export the settings for all stock items, by product group or a single stock item.
Where a stock item has more than one supplier, the name of the preferred supplier is exported. Where the item has more than one alternative, the code of the preferred alternative item is exported.
Open: Stock Control > Utilities > Import and Export > Export Stock Records.