Inventory Count - Reports

Use the Inventory Count - Reports screen to run and print selected inventory reports.

The Inventory Count - Reports screen is accessed from the Inventory Count screen by clicking the Click here to print count, variance or inventory value reports link.

Fields on the Inventory Count - Reports screen are:

Field Description
Select Report Type Select an inventory report type from the drop down list (e.g. Count Listing, Variance, or Inventory Value).
Calculate Variance Using When Variance or Inventory Value are selected as the Report Type, select the method of calculation. Options include: Current CostClosed Original cost plus any additions (frieght, pre-delivery, repairs, etc.) less any removals, rental costing. Original cost + all capitalized entries (work orders that hit the inventory account), Average CostClosed The average cost is automatically updated whenever parts are receipted in the system (either through inventory adjustments or parts orders). When a part is returned, the system uses the Average cost to return that part to Inventory. To calculate Average Cost, assume a part is added to the system with a cost of $10.00 and 2 parts are receipted. The average cost is $10.00 for each of these 2 parts. Now assume the cost increases to $12.00 later in the year and 1 additional part is receipted after that cost has increased. The new average cost is calculated as follows: (Old Avg Cost x Old on Hand) + (New Cost x Number of Parts Receipted at New Cost) / Old on Hand + Number of Parts Receipted OR (10.00 x 2) + (12.00 x 1) / (2 + 1) = $10.66, and Landed CostClosed The Landed Cost of a part is the final cost of the part on an order after all applicable Order Creation and Order Update cost code factors have been applied to the Current Cost of the part. Cost factors are applied when the part is ordered and receipted into the system based on the order Type (eg. SO: Stock Order, MD: Machine Down, FI: Fill In, etc.) The Landed Cost of a part will, in turn, be factored into the Average Cost of a part (as specified in the Average Cost field of the Parts Profile tab.) For details regarding cost code logic, please see the Cost Code Logic topic in the FAQs and Troubleshooting section of the online help. For details regarding the Average Cost of a part, please see the Average Cost definition in the Glossary section of the online help..
Select Sort Order When Inventory Value is selected as the Report Type, select the method of sorting to be applied to the generated report information. Options include: Sale Account, Vendor within Sale Account, Class within Sale Account, Vendor, and Class.
Select Printer Select a printer to print the selected inventory report.
or PDF Creates a PDF file of the inventory report, which can be viewed via the PDF Viewer.

Reports produced are:

Count Listing
PAR138 Inventory Count Report
Variance
PAR138 Inventory Variance Report
Inventory Value
PAR144 Inventory Value Report
PAR144S Inventory Value Report

Buttons on the Inventory Count - Reports screen are:

Button Description
Continue Submits the inventory report to a batch.
Close Closes the Inventory Count - Reports screen and returns to the Inventory Count screen.

Revision: 2026.01