Enter Quantities Using the Physical Inventory Quantities Form

Sage ERP Accpac Inventory Control 6.0

Enter Stocktaking Quantities Using the Physical Inventory Quantities Form

Overview

Inventory Control has two different forms for entering physical inventory counts:

  • Physical Inventory Quantities form

The Physical Inventory Quantities form lets you enter quantities, and it also lets you compare calculated quantities to actual counts during entry, and enter adjustment unit costs or change the posting status for individual items.

  • Inventory Counts form

The Inventory Counts form is a simpler form designed just for entering item quantities.

Before you start

  • Use the Generate Inventory Worksheet form to create inventory worksheets.

  • Optionally, print inventory worksheets for recording inventory quantities.

  • Count inventory quantities, check unit costs, and determine whether you want to place any items "on hold." (Use the Inventory Worksheet form if you want to print worksheets on which to record counted quantities, unit costs, and posting status.)

To enter physical inventory quantities using the Physical Inventory Quantities form:

  1. Open Inventory Control > I/C Physical Inventory > Physical Inventory Quantities.

Click here for help on Physical Inventory Quantities fields.

  1. Enter the location code or use the Finder to select the code

  2. Enter the starting item number or use the Finder to select the starting item number for the worksheet.

  3. If you use Optional Fields, use the Zoom button () to edit optional fields that apply to the whole worksheet.

  4. Enter or edit the physical count, adjustment cost, and status for each item on the worksheet. (If you selected the Default Quantity On Hand option in the Generate Inventory Worksheet form, the current quantities on hand are inserted for each item in the Quantity Counted column, but you can change the figures.)

If you are working with serialized and/or lotted items, a form will appear after you specify a quantity counted, prompting you to assign numbers to the items. You can also display this form by pressing the Zoom button or pressing the F9 key with your cursor in the Quantity Counted column.

If you have more than one unit of measure defined for an item, you can enter quantities in any unit, or combination of units, by following these steps:

  1. Press F9 in the detail grid to open the Quantities detail form that displays the units of measure defined for the item.

  2. Enter new counts in the Quantity Counted columns beside each unit of measure.

  3. Click the navigation buttons to move to another item.

  4. Click Close to save your changes. This closes the Quantities detail form and returns you to the Physical Inventory Quantities form.

  1. If you use optional fields with item details, use the Zoom button () to edit optional fields information.

  2. When you are finished, click Close to save your changes and close the Physical Inventory Quantities form.

 

Importing and Exporting from the Physical Inventory Quantities Form

You can use the Import and Export commands under the File menu of the Physical Inventory Quantities form to import and export data from/to your inventory control system. The procedure is slightly different from the way most Sage ERP Accpac forms import and export data. Instead of one file, the import/export process involves two files. The first file contains the worksheet and optional fields data, while the second file contains all other data.

When exporting, make sure you use two different file names when prompted to do so. When importing, make sure you select the file with the worksheet and optional fields data first, then the second file.

After entering inventory counts

  • Use the Inventory Reconciliation form to print the Inventory Reconciliation report, then check the report before posting the reconciliation (optional).

  • Use the Post Inventory Reconciliation form to post the inventory reconciliation.

Related topics