DE-H-D Import Physical Inventory Counts

Purpose of Program

Use this program to import Physical Inventory Count data obtained from an external collection system such as a bar code data collection device.

General Program Operation

Indicate the Year and Quarter of the Physical Inventory and the count date.  Indicate the position of the data fields in the ASCII file following standard Data import rules for comma delimited or fixed length files as described in Importing Master Files   Tag Number (or incremental line counter number), Location, Part number and quantity counted are required fields.  Employee number and Bin Location are optional.  Press Enter or Tab through all the fields or press F10 to process.  You will be presented with a report listing the imported items and indicating any exceptions that need to be manually entered.

While manually entered PI Counts support Lot and Serial Control, the imported counts do not support Lot or Serialized items at this time.