For the complete documentation index, see llms.txt. This page is also available as Markdown.
physical inventory countcount filecount zonesMicrosoft Excelspreadsheet

Import physical inventory count results

This topic describes how to import physical inventory count results into a count sheet in RMH.

You must have a physical inventory count results file in a tab delimited or comma delimited file format.

  1. In the Physical Inventory window, double-click the physical inventory count file that you want to update with the count results.

  2. Click Import.

  3. Click Next.

  4. On the Select File to Import screen, select the File Type:

  • Tab delimited

  • Comma delimited

  1. Click Browse and select the file containing the count results.

  1. Click Open.

  2. Click Next.

  3. On the Select Import Options screen, specify how to import items and quantities:

  • Update matching items only: Select this option to import only the matching items in the batch. For example, if the import file has items that do not exist in the batch being counted, they will not be imported and updated. Only the matching items will be imported and updated.

  • Update matching items and add new items: Select this option to import matching item and add new items in the batch. For example, if the import file has items that do not exist in the batch being counted, they will be imported and updated in addition to all matching items.

  • Add existing counts: Select this option to add the item count from this import file to existing item count in the batch.

  • Replace existing count: Select this option to replace the existing item count in the batch with the item count from this import file.

  1. Click Next.

  2. If any errors are reported:

    1. Click Cancel.

    2. Fix the errors in the import file.

    3. Restart the import.

  1. Click Import. The physical inventory count file is updated with the count results.

Last updated