Here you enter the name of the file containing the serial number information. If you do not specify a path here or if the specified path is invalid, Maconomy shows a dialog where you can select the relevant file.
The import file must be a tab-separated ASCII file, structured as shown below. You can create tab-separated files by saving data in text format in a word processing program or a spreadsheet.
As shown in the example below, you must enter a tab to separate one field from another. This means that if you do not want to enter a value in a given field, you simply enter an extra tab. The import file must contain a tab for each field skipped on a line. When you import serial number information of the type “Purchase,” each line must therefore contain a total of 8 tabs and end with a carriage return.
Importing Serial Number Information of the Type “Purchase.”
If you import serial number information for the Item Purchase module, (that is, you have selected “Purchase” in the pop-up field “Type”), the import file must contain one or several blocks structured as follows:
Each block contains one header, one or several lines, and one footer. An example of this is shown below:
This example will look like the figure below when entered manually in a spreadsheet:
The order number in the header of each block must be an existing, non-closed item purchase order in Maconomy.
Importing Serial Number Information of the Type “Sales.”
If you import serial number information for the Sales Orders module, (that is, you selected “Sales” in the pop-up field “Type”), the file must contain one or more blocks, as shown below:
Each block has one header, one or more lines, and one footer. Below is an example:
This example will look like the figure below when entered manually in a spreadsheet:
The order number in the header of each block must be that of an existing sales order number. Also, there must be an active packing list for the sales order. The item numbers must exist in Maconomy and have serial number control.
|