Teams Collaboration

GL Summary Balances not accurate

Sometimes in Dynamics-GP you will notice that the GL Summary balances for either historical years or current hears are not accurate.  You run reconcile but the amounts don’t appear in the Inquiry Summary window.  You can try this tip to correct the problem.

  1. Launch Query Analyzer or Studio Manager depending on which version of SQL Server you are using
  2. Create a new query window

  3. Change to the company database you are having an issue with

  4. Execute the following scripts to save your data

    1. select * into GL10110_BACK from GL10110

    2. select * into GL10111_BACK from GL10111

  5. Execute the following scripts to delete the data.  Don’t worry we just saved the data
    1.  delete GL10110
    2. delete GL10111
  6. Log into Dynamics-GP and run reconcile for General Ledger by going to Tools->Utilities->Financial->Reconcile.  Reconcile data for each of your historical years Starting with oldest year.  Then reconcile data for your open years starting from the oldest year.

Share this post

Related Posts

KTL Solutions Makes Inc. 5000 List for 2022

Each year, Inc. Magazine comes out with its list of the fastest-growing private companies in the nation. The 2022 list includes 131 Maryland businesses, with 11 of them making the prestigious Top 500. Those 131 MD-based businesses represent $2.7 billion in total revenue and more than 10,500 jobs added.

Read More »