CounterPoint SQL V8.3.5 Release Notes
The Advanced tab allows you to define the remaining import parameters.
Under Quantity, select one of the following options from the Assume 1 field to specify when you want to automatically set the Quantity for an imported adjustment to 1:
y Always – Select this option to always use a quantity of 1 for each adjustment, regardless of the quantity values in the import file.
Never – Select this option to always use the quantity value in the specified field in the import file for each adjustment.
y When blank – Select this option to use a quantity of 1 only for adjustments that do not have a quantity value in the import file.
If you select the Always option, the Quantity field in the Field number column becomes unavailable.
Under Cost, select the appropriate option from the Use Default field to specify when you want to automatically set the Cost for an imported adjustment to the default cost for the corresponding item (i.e., Always, Never, or When blank).
If you select the Always option, the Cost field in the Field number column becomes unavailable.
Select the number of Implied Decimals in the import file’s Quantity and Cost fields.
Select the Treat as negative check box to automatically treat all quantities in the import file as negative values. This option allows you to easily create a series of negative import adjustments from an import file that contains positive values.
In the Field number column, specify which fields in the import file contain the Item number, Serial number (if applicable), Quantity, and Cost values for each inventory adjustment.
If you use serialized items, each row in the import file that references a serialized item should include a Quantity of 1 and a single Serial number value. If the import file includes a row for a serialized item with a Quantity greater than 1, you must add the additional Serial number values to the resulting adjustment before posting.
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.Adjustments.ini file.