CounterPoint SQL V8.3.5 Release Notes
Before you start the import process, you can click Verify to test the import process and display a log of the results.
The log identifies any errors that will occur during the import, allowing you to modify the import file or revise your import settings before you start the import process.
For example, this log indicates that line 31 in the import file references an item number (msr123) that CounterPoint does not recognize.
The log also indicates that the import file does not include enough serial numbers for the quantity of serialized items for which adjustments will be created.
When you are satisfied with your import settings, click Import to start the import process. CounterPoint creates separate inventory adjustment transaction for each row in the import file, as follows:
If a single item number appears on multiple rows in the import file, a separate adjustment is created for each instance (i.e., they are not consolidated).
If a row in the import file references a cell-specific barcode, an adjustment is created for that cell of the corresponding gridded item. If multiple cell-specific barcodes for a single gridded item appear in the import file, a separate adjustment is created for each cell.
To import adjustments for gridded items, you must use cell-specific barcodes in the import file. If a row in the import file references the primary item number for a gridded item, it will not be imported and an error will be logged for that row.
If a row in the import file references a unit-specific barcode, the resulting adjustment is created in the corresponding unit. Otherwise, each adjustment is created in the stocking unit for the item.
A progress indicator keeps you apprised of the status of the import process. When the import is finished, a log of the results appears. This log indicates the number of lines and the quantity imported and details any errors that occurred. By default, this log is saved in the \Import subdirectory of your company directory with the same name as the import file (e.g., C:\CounterPoint\MyCompany\Import\InvAdjustments.log).
If you selected the Prompt to delete file after import check box on the Advanced tab of the Import Adjustments dialog, the following message appears when you close the import log, prompting you to confirm that you want to delete the import file.
Click Yes to delete the import file or No to retain it.