Physical Inventory and Cycle Count Module

You are looking at an old Manual of pc/MRP,
the Complete MRP Inventory/Accounting Package.

Please click below for
the latest pc/MRP Manual

Please click below to
reach the pc/MRP Main Page

Manual Logo

Main Page Logo

 

Selecting the option, "Physical Inventory" in the Inventory 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.

6.1.2 Enter Physical Inventory Count

Allows users to enter the count from each area into the inventory 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. (file structure must be: part number comma space quantity)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 inventory invarea1 through invarea6 fields. pc/MRP will allow you to add or replace the current count for that part number.

pc/MRP versions 7.54 and higher will ask users if they wish to pre-load the physical inventory team counts with the current inventory quantities.† (Option 76 in the settings and utilities must be set to yes.)† If any quantities exist within the team count fields greater than zero, the pre-load function will not load the inventory quantities.†

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 inventory invtot field. It also sums the current quantities (onhand, area2qty-area6qty) and places the total into the inventory 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 QUANTITY 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 Quantity 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.

6.1.6 Physical Inventory History

pc/MRP version 7.50F and higher have a Physical Inventory History Option. Selecting this option will bring up a screen with the following screen.

Physical Inventory History

Selecting H, History Reports & Process Reversal will display all prior physical inventories. You can then display, print, and/or restore past physical inventories. This option will restore the last physical inventory quantities, date, team counts, and areas 1-6 quantities. It will not change WIP quantities. If existing part numbers no longer exist after restoring, pc/MRP will give you an error message and add the part numbers without any quantities.

This option is great for restoring a physical inventory count if you have hit the U button twice and deleted your inventory and team counts.

6.1.7 Pre-seed Physical Inventory

Option 76 in the settings and utilities, in pc/MRP version 7.54 and higher allowes users to load current inventory quantities into the physical inventory team count fields.† The pre-seed selection will only function if all team counts in all inventory areas are zero.† If all team counts are zero and this option is set to yes, when a user selects to enter a team count quantity for the first time in areas 1-6, the physical inventory team counts will be pre-seeded.† If the pre-seed fails, make sure all of the team counts are zero.

 

6.1.8 Cycle Count Options

Selecting the Cycle Count Option will display the menu below:

CYCLE COUNT MENU

6.1.9 Generate Blank Cycle Count Forms

Generates a blank Physical Cycle Count Form. The form will contain 1/20th of all of the class A parts, 1/60th of all the class B parts, and 1/120 of all the class C parts. The above figures were derived from 20 working days/month, 60 working days per quarter, and 120 working days per 1/2 year. The second time the form is printed it will contain the second set of class A, B, C parts. In this manner all class A parts will be inventoried at least once a month, all class B parts once a quarter.

6.1.10 Enter Cycle Count

Allows users to rapidly enter the cycle counts into the inventory ONHAND QUANTITY field for each part number counted. The counts may be entered manually or imported from a comma delimited 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.

This option allows you to enter the count for each part number for all areas in one screen. pc/MRP stores the new quantities in the stores areas (onhand, area2qty-area6qty, and wipqty). In addition pc/MRP also updates the last physical date and quantity fields (lastphydate, lastqty1-lastqty6, lastqtywip) similar to the physical inventory program. This provides another opportunity for pc/MRP to establish base line inventory quantity and dates allowing the pc/MRPís Inventory Movement Report to calculate and print out inventory quantities on a given date based on inventory movements prior to or following the base line date and quantities.

6.1.11 Automatically Fill Class Fields For All Parts

This selection will ask you to enter the dollar amount used per week to classify a part as a class A part. pc/MRP will then automatically determine the class of each part based on cost and usage.

If the cost of a part is greater than $4.99 or it's cost x usage/week exceeds the dollar amount you entered above it will become a class A part.

If the cost of a part is less than $5.00 and greater than $0.49 and it's cost x usage/week is less than the dollar amount you entered above it will become a class B part.

If the cost of a part is less than $0.49 and it's cost x usage/week is less than the dollar amount you entered above it will become a class C part.