What a difference a year makes. Sorry, now you may have the song “What a difference a day makes” stuck in your head all day.
Last fall, our blog covered 5 things to do in Visual ERP to help make your physical count even more successful. The steps are:
- Ensure the On Hand Quantity reflects the sum of the Inventory Transactions.
- Ensure you don’t have any Bad FIFO layers.
- Eliminate out layers not costed.
- Ensure your standard costs are reasonable. Make sure there are no zero cost parts (unless they are free).
- Ensure the Inventory Balance Report equals the Inventory Valuation Report.
If you want to see the details on how to find these in Visual ERP, follow this link to last year’s blog.
https://backtobasics.ca/the-top-5-things-to-do-before-your-inventory-count-in-visual-erp/
Now I started thinking about how these tasks can be accomplished in Visual versus the Inventory Deep Dive application. For example, the 1st 2 steps above are accomplished in Visual with the following steps:
- Run Inventory Valuation – Neg Bal Cost Layers (I just timed it on a few databases, and it took about a minute but I have observed longer).
- Once you get the report, you have to determine whether the problem is #1 Bad On Hand Quantity or #2 Bad FIFO layers.
- Then you have to fix problem #1 by running VMFIXOHQ. Your IT department runs this when everyone is out of Visual. Sometimes easy. Sometimes it is hard to find a good time.
- For Problem #2, you run FORCE FIFO on the specific parts.
- After all of these steps costing needs to be run to pick up any changes.
Now, I would like to share what Deep Dive can do:
- Run the query for Incorrect On Hand Quantity. This can run in seconds and provides you the ability to fix the bad parts.
- Run the Bad FIFO query. Again, run in seconds and the fix is provided.
- After all of these steps costing needs to be run to pick up any changes.
I have to admit it is a big time-saver.
I know you are busy. That is why we would like to give you an opportunity to save some time. If you prefer to listen than read, feel free to check out the 3-minute video on how Deep Dive can help with your count.
Check out the highlighted menus below. These cover the steps that can be done in Visual ERP.
