Infor Visual ERP Delivery Partner


Infor Services Partner


Inventory Deep Dive – Reconciliation Tool

What are customers saying?

We have been using Visual since 2015. Reconciling inventory at the end of every month was a guessing game at best. Finding “issues” was usually by luck and not by any methodical process. It was also consuming a good deal of time and many times resulted in adjusting entries to tie reports to the general ledger. It was very frustrating. One of our staff had received an email about Deep Dive. I reached for information and decided to do a trial. What could it hurt, right? It was truly amazing! We quickly upgraded from the trial to the full version of Deep Dive. With the software, we have been able to go back and remove all manual entries from 2015 to present and actually fix the underlying issues. I now have the ability to drill down to the work order level to find an issue. I can give feedback to the users on processes that lead to issues. Most importantly, I can do this all in a timely manner with results! I am amazed at how quickly the software can find the issues and lead me down the path to solving the underlying issue. Many times, this can be done with the “fix button”, which takes literally seconds. If this option is not available, I can drill down to the work order and the type of issue involved and find the help to fix the issue. I am very satisfied with the results of Deep Dive and highly recommend taking a look if reconciling your inventory is a monthly source of frustration. Thanks again!!

Melissa Kelly, Controller, Timberlyne

What is Inventory Deep Dive?

Have you ever tried to reconcile your Inventory Balance Report to the General Ledger but had trouble finding the cause of the imbalance? Do you find there are lots of things to do to keep your inventory in line? Well, you are not alone. Inventory Reconciliations can be complex and sometimes time consuming. So, we have developed an easier and faster solution.

The Inventory Deep Dive Reconciliation application dives into the Visual database to find what has caused differences between the General Ledger and the Inventory Balance Report. Is there a problem in your general ledger? Or is it a problem with your costing layers? Not only will it create the reconciliation within seconds, it can find the records creating the imbalance quickly.

Have you ever wanted to take the postings to the General Ledger by Part ID and compare the postings to the Inventory Balance Report? Click one button in the Inventory Rollforward and you will see which parts are causing the inconsistences. From there you can dive into the actual transactions for those parts to see the exact transactions that are causing the differences. Just imagine. Not only will it find the differences but it will also provide you a button to fix them.

The tool provides options to find:
  • One button to show General Ledger and Layer problems.
  • Comparison of the Inventory Valuation to the Inventory Balance Report. You can even run it after month-end. Again, Deep Dive will find the part and the transaction differences.
  • Inventory Transactions that don’t contain the final costs.
  • Mismatches between the postings and the inventory transactions for all 5 journal types.
  • Instances where the Product Code has been changed, thus putting costs in the wrong inventory buckets.
  • Data problems and inconsistencies.
Advantages of Using Inventory Deep Dive
  1. Focused reports to show inventory differences by specific part ID.
  2. You will save time because you can focus on the problems parts. It will no longer be necessary to run the Visual audit tools on your entire database (i.e. Cost Distribution and Cost Analysis Tools).
  3. Detailed help guides for each window.
  4. Drill down capabilities to WO, CO, PO and transactional details.
  5. Ability to send the information to Excel.

Investment in Inventory Deep Dive (one time)
  • Inventory Deep Dive is compatible from Visual Version 6 to 10
  • There is no annual maintenance fee
  • The tool can be used on all sites within a database
  • Compatible with all versions of Microsoft Windows

“Can I just say how much I love Deep Dive!!! I haven’t even been able to dive that deep yet with month end/year end duties, but it has already been a tremendous help. By far favorite so far is Rollback and Inventory Balance vs G/L.  Oh, and the Product Code Changes! Saved me so much time.  I can’t even express the words.  So, thank you:) Very happy Customer!”

Diane McMillin, Controller, Abrasive Technology

“Firstly, DeepDive is simply wonderful. I’ve been working through inventory reconciliation on all 3 businesses and I would never have been able to get to the point where I am at. It’s amazing at identifying the needles in the haystack.”

Brendan Thompson, Phoenix Electrotek

With the reconciliation tool, I was able to find my lost inventory from earlier this year and it’s helping me keep the inventory on track. As of my last posting, I’m off by $11.86, and I know why!”

Vicky Turgeon, Controller, Mitotec Precision

I would rather watch a 3 minute video to get a better understanding.