Home > Inventory > Stock Control > Screen Shots/Explanations > Stock Entry Setup - Available Columns
This tab allows you to select which columns will be imported. The list on the left shows the columns that are available for importing. The list on the right shows the list of columns that are going to be imported. Use the arrow buttons to move columns between the two lists.
Figure: Example Stock Entry Screen
The following is a list of the columns that can be used in an import file. You will generally need the Item Number or Order Code and the Quantity column. If you are using a keyboard scanner, you don't need the Quantity as it is assumed to be one for each scan of the item.
EAN/UPC/PLU |
The barcode of the item. |
Batch Code |
If using FIFO, the batch code of the item. |
Cartons |
The number of cartons of the item. Usually the Quantity column would be used. |
Date |
The date the items were loaded. |
Expiry Date |
If using FIFO, the expiry date of the items being imported. |
Item Number |
The IPN of the item. |
Location |
The location the items are being imported for. Usually only required for transfers. |
Location From |
The location the items were transferred from. Usually only required for transfers. |
Order Code |
The order code of the item. |
Quantity |
The number of units of the item. |
Reference |
This is usually the carton number for an item. You would only use this if you record multiple cartons in your transfers. |
Serial Number |
If using FIFO, the serial number of the item being imported. |
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |