PI-F  Physical Inventory Report

Purpose of Program

Use this program to get a printout of your physical inventory.  The report can be run in summary, which provides a count and cost summary for each item number, or in detail, which lists the information collected on each numbered tag.  It can also be run as an uncounted parts exception report.

At the end of the report are totals showing the current inventory value, the physical inventory value, and the difference between the two.

Normally this report provides the final review of the physical inventory before PI-G  Update Actual Inventory is run.

General Program Operation

Enter the Year and the Phys Inv No.  These fields default to the latest physical inventory on file.

In the Report Type section choose whether you want the standard physical inventory report or an uncounted parts exception report.  Uncounted parts are items that were frozen with units showing on-hand, but have not received a tag record.  Most likely there is no on-hand quantity and therefore zero quantity tag records need to be entered for these items in a Type 1 inventory.  Physical Inventory Value report includes the total value of counted items, frozen items and the value of the adjustment.

Enter a P if you want the report sorted by item number and a C if you want it sorted by item class.

Enter an F if you want unposted parts to be printed at frozen cost or enter a C if you want them printed at current average cost.  Items already posted through PI-G  Update Actual Inventory will always print at frozen cost.  If you are on FIFO or LIFO costing, items will always print and post at current average cost to avoid discrepancies between the average cost and the calculated costs of the FIFO/LIFO cost buckets.

Enter a Y if you want tag detail printed, N if not, and an L if you want the detail confined only to lot and serial controlled items.

Enter a Y if you want detail of corrections made to lot and serial items printed.

Finally, enter a Y if you want uncounted parts included on the report.  If uncounted items have no quantity on-hand, a zero quantity tag record should be entered.

After completing the selection criteria, you are presented with a Locations listing that allows you to tag which Locations are to be included on the report.  After tagging the appropriate Locations, click on the Go button to begin printing.