Previous Topic

Next Topic

Book Contents

Book Index

IC Import Count

Navigator > Tasks > Inventory Control > Stocktake Processing > Import Count - OR -

Navigator > Tasks > Inventory Control > Stocktake Processing > Generate Stocktake > Run > BatchGenerate Generate Counts - OR -

Navigator > Tasks > Inventory Control > Stocktake Processing > Stocktake List > Open Stocktake > BatchGenerate Generate Counts

For Single and Additive Stocktakes only, selected in IC Settings - Stocktake tab.

Imports and inserts a new count and lines. The count will be imported with a Status of Counted. Any lines with the same Product (and UOM code, if UOM is active) will be consolidated. This avoids having several lines where products have been counted individually with a scanner.

Store Person

The Store Person associated with the Count

Location

The Count Location.

 

Import Format

You can import stocktake quantities from a file, rather than keying them in manually. Defaults from IC Settings - Stocktake tab or IC Location.

The format of the file can be:

  • Standard - use with tab delimited or comma delimited (.csv) files. format is:

    Product Code, Quantity

  • Standard with Bin - use with tab delimited or comma delimited (.csv) files. format is:

    Product Code, Quantity, Bin Code

  • Opticon - standard Opticon laser terminal format.
  • UOM - only valid for Additive Counts. File format is:

    Product Code, UOM Code, UOM Quantity Counted - OR -

    Product Code, UOM Code, UOM Quantity Counted, Bin Code

  • Detailed - only valid for Detailed Counts. File format is:

    Product Code, UOM Code, UOM Quantity Counted , Bin Code, Serial No, Lot No, Lot Date, Expiry Date

In all formats Barcode can be substituted for Product Code.

For non UOM leave UOM Code empty.

File Name

Select the file name and location to import from. Defaults from IC Settings - Stocktake tab.

Excel Worksheet

If the file entered in File Name is an Excel file, select the Excel Worksheet to be imported from.

Note: Do not use apostrophes (') in worksheet names, as this can cause problems.

Details

Enter details, if required, to be applied to the count header.

Open Count After Import

Selected, the count will open in the IC Stocktake Count form after import.

Run (F9)

Import the Count, based on the selections. A message box showing the Count ID Number, number of lines imported and number of errors will be displayed. If errors exist, you can select to print an error report.