How to Zero Out Inventory Quantity for all Items in Sage 100

Summary

How to zero out quantity on hand for all items

Resolution

The quickest way to make all on hand quantities zero is to use the Physical Count feature in Sage 100

Since this update cannot be undone, it is recommended to have a full back-up of your company data before performing these steps:

  1. Open Inventory Management, Physical Count, Physical Count Worksheet
    • Report Options, Freeze Items Only
    • Click, Print (nothing will print)
  2. Open Inventory Management, Physical Count, Physical Count Variance Register
    • Confirm Posting Date
    • Print/preview, physical counts variance register
    • Click, proceed with all settings as All
    • Confirm the total for Quantity Counted at the bottom of the Physical Count Variance Register is zero.
      • If it  is not then, answer No to update and go to Physical Count Entry to make sure quantity counted is zero
    • Click, Yes, Do you want to update the Physical Count Variance Register?
  3. Click, Yes,  Do you want to print the Daily Transaction Register?
    • Print/preview Daily Transaction Register
    • Click, Yes, Do you want to update the Daily Transaction Register?