Import lines from Excel file
You can import lines for the Inventory from a previously created Excel file.
Before the import process, you must first fill in the contents of the header of the document, determine the warehouse, and then save the document.
For complete content relevance, you must prepare the appropriate structure of the Excel file where at least the first two content columns must be completed.
Column A = Item
Column B = Quantity
Column C = Serial number (optional)
Column D = Serial number valid date (optional)
Example of creating Excel content for further import of the inventory of the stock into the program:
 |
For successful import of data, the items must be entered in the Item Register !
|
|
258 / 5000
Rezultati prijevoda
The first row of columns for importing the stock opening is for column names, so the program does not take it into account when importing. The name of the Excel file can be arbitrary (eg: Stock opening status). Use an Excel 97-2003 or less XLS file to work.
|