AM SQL/Express 13 Sample Reports
Inventory Control – Physical Inventory Count Reports
The Physical Inventory Count Reports provide information on various activities that take place during a physical inventory count process. Each of the Physical Inventory Count Reports is especially designed to provide several options so you can narrow down data to the specific information needed. Read the information below to get a closer look at each of the Physical Inventory Count Reports available in AccountMate. Physical Count Worksheet
The Physical Count Worksheet is a listing of inventory items that have been frozen in preparation for a physical count. The report shows the inventory item, its bin location, and a space for manually recording the item’s quantity per count. This report is useful in facilitating the physical count and serves as a basis for updating inventory items’ quantities and serial numbers after performing the count. You can select to show in the report only inventory items assigned with active status, only items with inactive status, or all items. You can further select to print the worksheet with double spaces, to show items' on-hand quantities, and to show the item
specifications, if any.
Physical Count Variance Report
The Physical Count Variance Report provides information on the differences in the inventory quantities before and after the physical count. The report shows the frozen inventory items and their adjusted quantities. This report is useful for verifying the reasonableness of any physical inventory count variances. You can generate this report to show only inventory items assigned with active status, only items assigned with inactive status or all items. You can select to include in the report only items with physical inventory count
variances, only bins with physical inventory count variances, or all
items. You can also opt to show on the report the item specifications, if any, and the counted inventory items' average costs and total variance amounts.
Physical Count Serial # Report
The Physical Count Serial # Report provides information on the serial numbers of inventory items to be included in the physical count. This report is useful for reconciling the serialized inventory item quantity variances before and after the physical count. You can filter the report to show only inventory items assigned with active status, only items with inactive status or all items. You can also show on the report the item specifications, if any.
Physical Count Log
The Physical Count Log provides summarized information on the physical inventory count results. It lists the inventory items included in the physical count, the date when the inventory balances are updated based upon the physical count results, among other information. This report is useful for reviewing the physical count results and for determining when the inventory quantity balances are last updated. You can generate the report to show only inventory items assigned with active status, only items assigned with inactive status or all items.
|