Armanino Blog
Article

Dynamics GP Inventory Reconcile to GL

June 10, 2013

Dynamics GP Inventory Reconcile to GL allows you to quickly reconcile your inventory records in GP to your general ledger.

The reconciliation of inventory to the general ledger can be complicated because you may have several general ledger accounts that represent the valuation of your inventory. And there are a lot of transaction types that effect inventory, e.g. purchase orders, cycle counts, sales invoices, quantity/value  adjustments. And if you then use the customer and inventory masterfile to select different GL accounts based on specific customers and items, you can have a real mess if everything isn't set up correctly.

To run the Dynamics GP Inventory Reconcile to GL process, navigate to the Finance Area Page >> Routines >> Reconcile to GL:

The key with this window is to correctly and completely identify the general ledger accounts that represent your inventory value. Once you've selected the appropriate dates, click on "Process" to view the results in Excel.

This is an example of what you'll see:

The "Unmatched Transactions" are the ones that you'll want to investigate. There are links to the underlying transactions in GP from the Excel results report that will help you identify and correct the problems.

The "Potentially Matched Transactions" are transactions that do not match on these criteria:

  • Transaction Source
  • Journal Entry Number
  • Document Number
  • Date
  • Amount

You will want to analyze these to see how your records can be adjusted to fix the problems.

The "Matched Transactions" are good and you don't have to worry about them.

After you have made your changes you can run a new reconciliation to see the results.

Here is a quick video that shows this functionality:

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Resources
Related News & Insights
General Contractor Trends to Consider in 2022 Webinar
Webinar
Hear from experts how you can better manage your subcontracts — and more.

December 16, 2021 | 10:00 AM - 11:00 AM PT
Women in Nonprofit Leadership Panel
Webinar
Aspiring nonprofit leaders should hear the insightful stories of these women industry leaders to empower their journeys.

December 14, 2021 | 10:00 AM - 11:00 AM PT
The Evolution of Gaming Companies
Webinar
From seed-funding to acquisition, position your gaming company for success.

December 9, 2021 | 01:00 PM - 02:00 PM PT