Generate
Inventory Worksheet
Use this form to generate worksheets of item quantities on hand for all inventory locations for which you are taking inventory.
You can optionally print worksheets to use for recording your physical inventory counts prior to entering the data in the Physical Inventory Quantities form and posting it to your Inventory Control system.
You can create inventory worksheets for a range of items sorted by item number, category, item segment, picking sequence, or any optional field names defined for Inventory Control. You can choose to include:
-
Only the items in the specified item range that are assigned to the location(s) for which you are generating worksheets.
-
Only the items in the specified item range that are assigned to and have been used in one or more transactions at the location(s) for which you are generating worksheets.
-
All the items in the specified item range, regardless of whether they are assigned to the location(s) for which you are generating worksheets.
Note: Items are included regardless of whether they are currently allowed to be used in Inventory Control transactions.
If you generate an inventory worksheet for a location that already has a worksheet, the program replaces the old worksheet with a new one. The program warns you if there are existing worksheets for locations and lets you choose whether to replace them.
Warning! To ensure quantities and costs on worksheets are current, do not post transactions (receipts, shipments, transfers, adjustments, or assemblies) then run Day End Processing between the time you generate inventory worksheets and the time you the post the inventory reconciliation.
Before generating an inventory worksheet
Generating an inventory worksheet
After generating an inventory worksheet
Click the following links for more help, and click the Field List button at the top of this topic for information about fields on the Generate Inventory Worksheet form.
Click here for hints on using forms.
See also
Inventory reconciliation report