Posting Physical Inventory Quantities

The physical inventory posting process posts the quantities of all physical inventory counts to the Quantity On-Hand field for each inventory item, as well as creating entries to the journal for any adjustments.

Before Posting Count Quantities

Before performing this activity, we recommend that you run the following reports/activities to generate an accounting audit trail for visibility for count discrepancies:

Records must be approved before they can be posted. Once approved, they can no longer be updated or voided.

Accept the default selection criteria on each report.

Running the Physical Inventory Count Posting

NOTE: The system does not allow you to post physical inventory records if the reserved quantity is greater than the physical count for that record. If this occurs, the system displays an error message during the posting process. You then have the option to continue with the physical inventory posting process or quit.

The records do not post until the reserved quantity is reduced either by the Reserve/Unreserve Inventory Utility or manually, using the Reservations For Item form or the Reservations For Order form.

  1. Open the Physical Inventory Count Posting utility.
  2. Verify that you have the correct Warehouse selected.
  3. To update the quantity on hand and create journal entries for adjustments, click Process.
  4. Upon completion, review any records that remain either on the Input/Update Tag or on the Input/Update Sheet form. These indicate records that did not post due to errors.
  5. To purge any records that were not posted, open the Physical Inventory Records Purge form.

If only zero balance or invalid physical inventory records remain, you can use this alternative to purge inventory records.

NOTE: Remember to unfreeze the inventory after posting.

Related Topics

Physical Inventory Count Posting utility

Doing a Physical Inventory