Feature - Allow Physical Count Tag Import Without Serial Number

Feature - Allow Physical Count Tag Import Without Serial Number

Released Date: 10/25/2010

In I/M -> Processing -> Physical Count Processing -> Utility -> Import Physical Count Tag, we will require the user to provide a CSV file with the following columns:
  • (A) Location (Can Be Blank)
  • (B) Bin Number (Required If Location Uses Multi-Bin)
  • (C) Count Tag Number (Can Be Blank)
  • (D) Item Number
  • (E) Quantity
  • (F) Job Number (For Multi-bin only)
  • (G) Serial No.
See sample screen below:



In the past, the serial number column was required as long as the item was a serialized item.

In this update, we made the serial number column optional if you specify "N" to "6. All Ser. Items Have Ser# in CSV ?" The idea is to provide you with two different count modes for serialized items:
  • Quick Count Mode - Only count and compare the quantity of the serialized items.  No serial number comparison.
  • Comprehensive Count Mode - Will count and compare the serialized item.  When serial number is mismatched, then it is an error, and the count tag will not be posted.
Below are details of the changes made in this update
  • In the tag import program, a serialized item doesn’t require a serial number in CSV as long as the user selects “N” for “6. All Ser. Items Have Ser# in CSV ?”
  • In the tag import program, the program can consolidate sequential records with identical tag numbers, item numbers, job numbers, bin numbers and locations into one tag record, no matter whether it is a serialized item or not. If records are consolidated, the program will print additional information, like total consolidated records and total serial numbers, related to this tag.
  • In generating the tag work file program (for Warehouse/Variance Amount report, Item/Warehouse report and Tag Reconciliation list), if a count tag for a serialized item has no serial number record, the program will not check missing or extra tag serial numbers.
  • In the physical tag posting program, if a count tag for a serialized item has no serial number record, the program will not check missing or extra tag serial numbers.

Modified Programs: IMTAGIMP, IMTAGIMS, IMGTGWRK, IM10P2

CHK



    • Related Articles

    • Elliott Physical Count Processing

      Q. How can we process physical count with Elliott using a spreadsheet export and import method? We are prefer to have a variance report before posting to inventory. A. Elliott provides a verify efficient tool to create a worksheet with a spreadsheet ...

    • Multiple Users Entering Physical Count Tag at the Same Time Issue

      Q - We think we have found a scenario where two different users could enter and use the same physical tag number with Auto Entry Mode. When both users used the F1 key to get the next tag number, as each tags are added, system automatically assign the ...

    • IM1000 Inventory Management Physical Count Processing

      Physical Count Processing Application Overview In just about any Inventory Management package, it is necessary to physically count inventory items periodically to ensure that the theoretical quantity on‑hand figures being used in the package are ...

    • WMS Physical Cycle Count Processing

      Two Approaches Supported for Physical/Cycle Count The goal of this application is to make the physical/cycle count process paperless. To do this the application needs to be able to generate the count records for a physical or cycle count so that they ...

    • Feature - Multi-Bin Physical Count Enhancement

      Release Date: 10/31/2022 Version: 8.5 & Up This project enhances the physical count processing for multi-bin users. It is not applicable to non-multi-bin users. Multi-bin users can now perform the following two new functions: Cycle Count by Bin ...