PHYSICAL INVENTORY AND CYCLE COUNT MODULE

Selecting the option, "Physical Inventory" in the Partmaster Menu will allow that module to be selected. If the Physical Inventory option is selected, the Physical Inventory Menu shown below will appear.

6.1.1 Generate Blank Physical Inventory Forms

This selection uses the partmast.dbf file to generate blank physical inventory forms (blankinv.frx) for inventory teams to take the inventory count. Generate as many blank Inventory Forms as there are inventory teams. It is important to remember that each team takes inventory in its own area and not the area of another team as this would result in a double count of the same items. Both areas can contain parts with the same part numbers as in the other areas. The "Total the area counts and print out a variance report" option will total the count for each part number. It is important to note that WIP quantities should be corrected using the Audit WIP function (section 5.1.12) prior to entering the physical inventory in stores. Since pc/MRP decrements WIP based on stock transactions issued to manufacturing for specified sales orders it is best to correct WIP first using the Adjust WIP quantity function and not to include WIP when taking the above physical inventory.

6.1.2 Enter Physical Inventory Count

Allows you to enter the count from each area into the partmaster's physical inventory fields (invarea1-invarea6) without altering or disturbing your present inventory (onhand, area2qty-area6qty). The counts for each area may be entered manually or imported from a comma delimited ASCII file. If you select to enter the count from an ASCII file, the ASCII file must have the part number and quantity as the first two data elements within the file. Any additional data elements will be ignored. If you select to enter the counts manually, pc/MRP will prompt you to enter the counts in the order you selected (by part number or by location). In either case, the counts are entered into the partmasters invarea1 through invarea6 fields. pc/MRP will allow you to add or replace the current count for that partnumber. Once again we recommend correcting the WIP quantity using the Audit WIP function and not entering WIP counts from this module.

6.1.3 Total The Inventory Counts And Print Variance Report

This report (costinv.frx) sums the area counts (invarea1-invarea2) and places the totals into the partmaster's invtot field. It also sums the current quantities (onhand,area2qty-area6qty) and places the total into the partmaster's prevqty field. This report allows you to compare the current counts with the current quantity in inventory. This report is designed to help locate any abnormal deviations in individual stocking levels and provide a dollar value for the physical inventory count with sub- totals by product type. Once this report has been approved as to its accuracy THEN AND ONLY THEN should you run the option "UPDATE THE ONHAND QTY AND ZERO OUT THE TEAM COUNTS". If you do not run this report before updating the onhand quantities, no damage will be done. However, you will miss your chance to compare your pc/MRP's on hand quantities.

The deviation values represent the difference in dollars and quantity that pc/MRP calculates you should have as compared to the audit's count. These deviation figures would only be accurate if you had used all of pc/MRP's modules (Invoice, Receiving, Purchasing, Stock Transaction, and Sales) and the previous physical inventory had been accurately taken with pc/MRP. If you do not use the Receiving and Stock Transaction Modules which adjust the Onhand Quantities, the deviation values represent the change in quantity and value of each part number from the last physical inventory. We recommend not including WIP with this function.

6.1.4 Update The Onhand Qty And Zero Out The Team Counts

Replaces the present onhand inventory quantities (onhand,area2qty-area6qty) with the new count from the physical inventory count (invarea1-invarea6). It stores the count in the lastqty1-lastqty6 fields and zeros out the inventory count fields (invarea1-invarea6) for the next count. This should be done only after the "Total The Inventory Counts And Print Variance Report" option has been run and approved. One last time, we recommend not including WIP with this function as WIP counts were corrected using the Audit WIP function. As of pc/MRP Versions 7.01L and 7.02Q and higher, the Update option will only run if the user has inventory delete rights (provided the password module has been activated).

6.1.5 The Inventory Movement Report (Parmovp.frx)

The inventory movement report will list all inventory movements during a specified period of time based on the last physical inventory count, receivers, issues, adjustments, and invoiced sales orders. The report will compare the theoretical count with the physical inventory count. pc/MRP versions 6.82AG, 6.80AE, 6.87D, and higher will provide the correct starting and ending balances after you have taken a physical inventory. With this report you should check the include WIP check box.