Entering Physical Inventory Quantities

After counting inventory, you enter physical inventory quantities on one of the following screens:

  • I/C Physical Inventory Quantities screen. On this screen, you can enter item quantities and adjustment unit costs, compare calculated quantities to actual counts during entry, and change the posting status for individual items.
  • I/C Inventory Counts screen. This screen is a simplified version of the I/C Physical Inventory Quantities screen, designed just for entering item quantities.
  • Count inventory quantities, check unit costs, and determine whether you want to place any items on hold. (Use the Inventory Worksheet screen if you want to print worksheets on which to record counted quantities, unit costs, and posting status.)
  • Use the Generate Inventory Worksheet screen to create inventory worksheets.
  • Decide on the inventory locations, account sets, and items for which you want to generate worksheets.
  • Decide on the sorting order in which to list items on the worksheets.
  • Run Day End Processing to update the company's Inventory Control data if you have posted transactions since the last time you ran Day End Processing.
  • Make sure no other users are working with the Inventory Control database and no other Inventory Control screens are open on your computer.

To enter physical inventory quantities:

  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 Zoom button 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. More...

    1. On the detail table, click the Zoom Zoom button 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 Zoom button button to edit detail optional fields.
  6. When you are finished, click Close to save your changes and close the screen.
  • Use the Inventory Reconciliation screen to print the Inventory Reconciliation report, then check the report before posting the reconciliation (optional).
  • Use the Post Inventory Reconciliation screen to post the inventory reconciliation.