Performing a physical inventory allows you to count every part that is in your dealership. This is essential to keep accurate counts of the parts that are on hand and ensures that the part costs are correct.
Before Beginning a Physical Count
Check the Parts Inventory Value
Before Beginning a Physical Count
There are tools in the MotilityAnywhere program to help when performing a physical count.
- Open any module.
- Click over the icon of a person in the upper right of the screen.
- Choose the Settings option from the menu.
- Verify that you are viewing the Company Settings tab.
- Click the Accounting subtab on the left side of the screen.
- Check the Auto Post Physical Variance box. This will automatically create a variance accounting transaction after the physical count.
Access Physical Inventory
- Open the Parts & Service module.
- In the Tools menu in the lower left of the screen, expand the Parts Maintenance section.
- Select the Parts Physical Inventory option.
- Choose the Physical Inventory option. This will open the Physical Inventory Main Screen. It will show a list of physical inventories. You can recall a previous physical inventory count by double clicking on the row or start a new count by clicking on the button in the bottom left of the screen.
Start a New Physical Count
- Choose to start a new physical count. The New Physical Count window will open.
- Select the type of count. The options are:
- Full Count - allows for a full End of Year(EOY) count of the parts inventory
- Cycle Single Bin Parts Count - loads parts assigned to the single bin selected in the bin location filter
- Cycle Multi Bin Parts Count - loads the parts that exist in more than one bin
- Parts Not Counted Since - will initially load parts that haven't been counted since a specified date
- Parts Sold During Count - loads parts that were sold during a prior parts physical inventory count
- Top N% Gross Profit Count - pre-loads parts that have a specified percentage of gross profit
- Cycle Specific Class/Source - will initially load parts assigned to the specified Class or Source
|
This example is:
|
Once you choose the type of count, the description will default to a name that combines the type of count and date/time stamp. You can edit this, if desired.
Optionally, you can filter based on part numbers or bin locations to give you a more specific range of inventory parts.
If you wish to start the physical count with no parts displayed to allow manual entry, check the option to start with a blank screen.
It is a good idea to run a parts variance report both before and after you post your physical inventory count. Click on the Print Variance button at the bottom of this window to print the Physical Inventory – Variance Report.
Enter Count
- Click Save. This will start the physical and open the physical count window. The relevant parts will show based on the criteria selected from the previous screen.
- Enter the quantities on hand into the Count Qty column.
Optionally, you can update the bin location of parts by selecting the Bin from the drop down.
Resolve Errors
Be sure to address any messages that appear in the Messages field. Critical Messages that must be addressed are the “Multi Bin Part” and “Has Activity.
- Multi Bin Parts – All bins that are listed under that part number need to be inventoried and included with the count. It is strongly suggested that users filter for this message using the blue filter bar at the top of the cycle count screen and review all parts that are marked as multi-bin parts to ensure that all bins have been included.
| IMPORTANT: Failure to include a bin on a multi bin part can result in the quantity of that part doubling once you post your count. |
- Has Activity - Parts that have activity during a count will need to be recounted. You can post the current count and run another cycle count to track all parts that were sold during the count. Activity can include Parts Ordered, Received, Invoiced, Sold and/or basic information on the part being changed.
Note: All errors must be resolved before the final counts can be posted.
If you can’t finish your entries in one sitting, simply click the Save button. This will save what you have entered and exit out of the count. When you open the physical again, the values will still be saved and you can continue the input.
Additional Tools
At the bottom of the Physical Inventory window are two additional tools available to help with your physical inventory count.
- Set Quantity Count to Zero - If there are multiple parts that state "Count Field is Null" and those parts are not in inventory and should be set to zero, click this button and it will fill in "0" in the Count field for all parts that do not contain a numeric value.
- Set Bins to None - If a part does not have a bin assigned to it and the user does not wish to assign it during the count, they may click this button and the system will assign the bin “None” to it.
Post Count
- To push the part counts to the Master Inventory, click the Post Count button.
IMPORTANT- Once you post the count, it cannot be undone.
It is a good idea to run a parts variance report both before and after you post your physical inventory count. Click on the Print Variance button at the bottom of this window to print the Physical Inventory – Variance Report.
Check the Parts Inventory Value
After the Physical Inventory counts have been posted, you will need to update the accounting parts inventory value.
- Open the Reporting Module.
- Open the Accounting reports folder.
- Open the General Ledger reports folder.
- Select the Inventory Values by GL Number report.
This report will show the difference between your recently-updated parts inventory value and the accounting parts inventory value. Please be sure to consult with your accountant before making this entry to ensure it is the best course of action for your dealership.