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
Armaninos 10th Anniversary Reception in Chicago
Live Event
Rooftop reception to celebrate Armanino’s 10th anniversary with the firm’s supporters and friends.

September 29, 2022 | 02:30 PM - 05:30 PM PT
Nonprofit Symposium 2021
Live and Virtual Event
Nonprofits - Get Back to [Focusing on] the Future

September 29, 2022 | 08:00 AM - 12:00 PM PT
Workday Adaptive Planning 2022 R2 Release
Webinar
Learn about Workday’s newest features and enhancements.

August 30, 2022 | 10:00 AM - 11:00 AM PT