CounterPoint SQL V8.3.5 Release Notes
Select the Prompt to delete file after import check box to prompt the user to remove the import file when the import process is finished.
When you have defined your import settings, you can click the Save parameters button to save them for future use. Click the Load parameters button and select a saved import parameter file to re-use those import settings.
You can save multiple import parameter files with different names to retain multiple sets of import parameters. If you do not specify a file name when you save an import parameters file, CounterPoint automatically saves your settings to the Default.Receivings.ini file.
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 receivings will be imported.
When you are satisfied with your import settings, click Import to start the import process.
If you chose the Receive a PO option, CounterPoint creates a new receiver, and then receives the items in the import file, as follows:
The quantity of each item in the import file is applied to the corresponding line as the quantity received.
If a single item number appears on multiple rows in the import file, each imported quantity is added to the quantity received for that item.
If a single item appears on multiple receiver lines, imported quantities are applied to those lines in the order in which they appear. Any excess quantity is applied to the last receiver line for the item.
If a row in the import file references a cell-specific barcode, the imported quantity is applied to that cell of the corresponding gridded item.
To import transactions 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 an item that isn’t on the receiver, the item is added to a new receiver line or skipped, depending on the Items not on PO option you selected (i.e., Add lines or Skip lines).
If the imported unit for an item is different from the unit specified on the original PO, the imported quantity is converted into the unit on the original PO.
For example, if the imported unit for an item is EACH and the unit on the receiver is DOZEN, an imported quantity of 24 will be converted into a quantity received of 2 (i.e., 24 of EACH equals 2 of DOZEN).