How to effectively reconcile your inventory in VISUAL ERP

How to effectively reconcile your inventory

In my experience, I found that there is a misconception related to inventory and WIP reconciliation process. This is why I want to provide more information on how Visual works in this area. I believe it will give you the knowledge on how to take the right approach in order to validate your published numbers.

The core of your Visual inventory resides in the accumulation of transactions. This happens to be in the Manufacturing side of the system. Typically, raw material is purchased and it is then used in the manufacturing process before being received into inventory and finally sold or shipped to consumers. The sequence of entering these transactions is critical for the guarantee of a proper cost allocation. When the sequence of this order is broken, discrepancies between the different Visual reports appear. This is when the confusion begins and you are left wandering which report has the correct numbers.

Let’s review the proper steps to take in order to validate those values:

Infor VISUAL ERP Inventory Valuation ReportThe Inventory Valuation Report will contain the most accurate picture at month-end. You may, however, encounter errors if there is an incorrect FIFO layer or if a part has a negative quantity on hand at month-end. These issues must be fixed because it is crucial to have a trustworthy Inventory Valuation report at month-end in order to progress to the next step.

Infor VISUAL ERP Inventory Balance ReportThe Inventory Balance Report is a secondary table that is updated when Costing Utilities is run and MFG Journals are prepared. I often see a tendency for users to adjust the GL to the numbers shown in this report and this is incorrect. You should keep in mind that, according to the first step, the correct values are already in the Inventory Valuation report. Once you have verified that the Inventory Valuation report has no issues, you can compare it to the Inventory Balances Report. This allows you to identify any parts that are not displayed correctly in the Financial Subledger. Any differences must be fixed before progressing to the next step.

Infor VISUAL ERP Inventory Control Account BalancesThe GL (Inventory Control Account Balances) should reflect what is happening on the Manufacturing side. The GL almost always contains the correct values and should not be adjusted to the Inventory Balances too quickly, unless you have proven that the Inventory Valuation and Inventory Balances Subledgers are in sync. There might be times where the GL reports incorrect postings. These may include when a GJ has been posted to control accounts, if the inventory control account has been used in the wrong journal or if a change in product codes at Part ID level occurs without following the proper process. These issues are, however, a topic for a future blog.

Stay tuned, as I continue onto the next topic. Month-end quality: How fast can you close the month?

Valeria Vicco, CDDP – Financial Consultant, is our special guest author at visualnuggets.com and is an active participant in the VISUAL community.  Valeria is part of BMS Business Monitoring Systems Inc (BMS 365) – who focus on Innovative solutions that move Visual ERP users forward.

Connect with Valeria online at LinkedIn and BMS365.com

 

Copyright 2019 visualnuggets © All Rights Reserved