The Physical Inventory Manager allows you to view and manage all physical inventories for your location and the status details for each one. It will help you execute the overall inventory process as you complete the physical counts and enter the quantities as needed.
As you progress through your inventory process the Status will change to indicate the step you are on. This Status determines what functions are available on the screen during that step of the process.
Inventory Statuses:
Processing - the Inventory count is being created in the system based on the configuration of the ID on the Create Count screen.
Selected - the Inventory count is completed, Inv ID is ready for the next step, Create the Count Sheets.
In Progress - The Count Sheets are being used to complete the manual counts and the results can be entered on the Enter The Count screen or Uploaded. After the count is entered, the Variance Report can be run.
Variance Printed - the report has been run, it is used to identify adjustments.
Variance Print (recount) - additional run of the Variance report after recount.
Adjustment Scheduled - The Physical Inventory batch process is scheduled.
Select the row that contains the physical inventory to be processed. This activates the option buttons. Different buttons are available during different status stages:
Create Count Sheet Button - The next step is to generate the count sheets. The count sheets can be printed and given to the people counting the inventory. The count sheets must be created whether they are printed or not in order for the physical inventory to go into the next status which is In Progress.
Upload Count Button - If you are using a handheld device to complete your count use this to upload the text file your device creates.
Enter Count Button - The enter count button will take you to the enter count page to enter the quantities that have been counted. You will be prompted to either enter the counts manually or upload the inventory from a handheld device. The enter count page can also be accessed directly from the menu so the enter count button does not have to be used from the physical inventory manager frame.
Variance Report - Once the counts have been entered, the variance report needs to be run so the parts counted can be reviewed for discrepancies in quantities.
Adjust Count - The adjust count is the last step in the physical inventory process. Once all of the parts have been counted, the inventory can be adjusted to match on-hand quantities to M5 book quantities. This step should be done once the variances are within an acceptable amount.
2020 - Close-part Inventory (Y) or Open-Part Inventory (N)? - This flag indicates whether the Physical Inventory process will be performed using an Open or Closed parts room scenario,i.e. will the user allow parts to be issued and processed while the Physical Inventory process is going on?
5059 - Upload Physical Inventory Count? (Y/N) - This flag indicates if a remote processing device will be used to upload data from handheld devices in the physical inventory process.
5132 - Physical Inventory Count Sheet Line Items (9 to 20) - Choose the amount of line items per page for a Physical Inventory count sheet. Value range is between 9 and 20 inclusive.
INV CYCLEDATE SPREAD - Allows a user to spread physical inventory cycle count dates.
MOBILE - PHYS INVTRY - Allows a user to conduct Physical Inventory activities with a mobile device/handheld.
For more details see the Inventory Application User Training Guide.
Last Updated: 03/28/2017
NOTE: To view a list of System Flags and Role Privileges that may impact this screen, hover over the screen title in M5 to display the bubble help/tooltip. At the bottom of the bubble help/tool tip, there is a Settings hyperlink. Click that hyperlink to display the list of flags and privileges.
Additional training and technical documents on this subject may be available in the Resource Files area.