How to Enter Physical Inventory Quantities in Sage 300 Inventory Control


  1. Open Inventory Control > I/C Physical Inventory > Physical Inventory Quantities or
    Inventory Counts.
  2. Enter a location code and starting item number for the worksheet.
  3. If you use optional fields, click the Zoom button to edit optional fields that apply to the whole worksheet.
  4. Enter or edit inventory quantities and other information.
    • Note: If you selected the Default Quantity On Hand option on the I/C Generate Inventory Worksheet screen, the current quantities on hand are inserted for each item in the Quantity Counted column, but you can change the figures.
      • The information you enter may vary depending on the screen you’re using:
        • I/C Physical Inventory Quantities screen. Enter or edit the physical count, adjustment cost, and status for each item on the worksheet.
        • I/C Inventory Counts screen. Enter the physical count or edit the count in the Quantity Counted column.
      • You can also assign serial/lot numbers to items, and/or enter item quantities in multiple units of measure.
        1. On the detail table, click the Zoom button or press F9.  The I/C Quantities screen appears.
          • Note: This screen also appears after you specify a quantity counted for items that are serialized and/or lotted.
        2. On the I/C Quantities screen:
          • For serialized/lotted items, assign serial/lot numbers.
          • If more than one unit of measure is defined for an item, enter new counts for each unit of measure. (Each unit of measure is displayed, and you can enter counted quantities in any unit or combination of units.)
        3. Click the navigation buttons to move to another item.
        4. Click Close to save your changes and close the I/C Quantities screen.
  5. If you use optional fields for item details, use the Zoom button to edit detail optional fields.
  6. When you are finished, click Close to save your changes and close the screen.


If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.