Purchase Order Import Tool
Overview
A Tab separated format allows users to import purchase Orders into Khaos Control from a file. When Importing .tsv files which have multiple Purchase Order codes for a supplier, the system will create a Purchase Order for each unique Purchase Order code.
Configuration
- In order to prepare the data for import, the file should be saved with a .txt or .tsv extension.
- The top line of the file may be a header containing the specified field names.
Mapping Table
Usage
Once a Purchase Order file has been created it can now be imported into Khaos Control. Use the following steps to do so.
- Open the
Purchase Order List
screen. - From the Other Actions menu Select Import > Import TSV Purchase Orders.
- Select the Purchase Order import file and press OK.
- Given no errors occur, a Purchase Order will be created for each line in the tsv file with a unique Purchase Order code.
Notes:
- SKUS must exist in the system, or the lines will skip.
- SUPPLIER_CODE must exist in the system, or the line will skip.