Text files can be imported to any worksheet type.
The information that is read from the text file is item and quantity, see file format details below. The receiving worksheet journal is filled according to worksheet settings.
1. Open Store Inventory Worksheets: and Select the Store Inventory Worksheet that you want to Import your data into.
2. Click on Actions menu then Actions, then Import.
3. The Store Inventory Import page is displayed, click on three ... to select the csv file and enter the Posting Date.
4. In this example a Stock Counting worksheet was selected, and the destination location was specified in the worksheet.
5. Click OK to start the import.
When the import is finished a message is displayed:
Tip: Import File Duplication
The import file is duplicated if it is processed again on the same worksheet. If a file has been imported to the wrong worksheet, use the “Copy Lines” or “Move Lines” actions to transfer the lines to the correct worksheet.
See imported file format below.
The import file should be in a CSV format and only contain item identification and quantity. The item identification can be either the Item number or Barcode. Variant items must be entered by using barcodes. Quantity is either interpreted as Quantity or Amount (Price Check). Here is an example of an import file:
10010;10
10020;20
30000;30
30030;33
100050;1
43900;23
0200000003142;12
5690575102015;4
30030;asdfa
asdfa;asdfkl
11111111;11111111
562314589621;5
5690530122713;70
100040;15
After this file has been imported, these journal lines are displayed:
Note: All lines are imported, even those that have an error. Lines in error have the errors logged and can be viewed in the Error Log FactBox. The lines in error are selected in the page above. Here is the error log:
If this worksheet is processed, only the error-free lines would be processed while the other lines would be omitted, either to be corrected or deleted.
