If you have a Parts File, you can upload this file via menu via Sundry > Down Load Data Files > Load Parts File (AU) or via Down Load Data Files > Load Parts File (NZ).
This option is also available from the Supplier Invoice and Pre-Job Supplier Invoice Options menu.
The format for the CSV file is configured in this screen.
Select the pre-existing template for the load file or create a new template. The templates must include all the mandatory columns, which are indicated with a ‘*’ in the name.
The columns can be in any order. The file does not require column headings in the first row.
Once loaded the Import Log will display a summary of the details loaded. Use
to see more in depth information.
|
Field Name |
Description |
Validation |
Default |
|
Data File Location |
User the Browse button to locate the file in your system |
Mandatory |
Blank |
|
Column No |
This indicates where the column is found in the file. Select from the pull down list. |
Mandatory |
Blank |
|
Field |
This is the information contained in the column. Select a column from the pull down list. ‘*’ indicates that the column must be included in the file template. |
Mandatory |
Blank |
|
Templates |
This is the list of available templates. If you want to set up a new template enter the name of the new template in the field below and |
Mandatory |
Default |
. Use
to remove unwanted templates.