GL and Checkbook don't agree

(0) Share

Report

Posted on by jluna1110

Hello Group!

I am experiencing an issue since we upgraded from 2013 to 2016 two years ago. Now we are on 2018.

Before we converted our GL and Checkbook were off $34.58. Once we converted it is showing $146k off. The GL is correct and ties to the bank. The Checkbook is low. I was instructed to record a deposit in the checkbook. Once I did that, the checkbook and GL tied! Now there is an outstanding deposit in the reconcile that will never clear. Does anyone have any suggestions on how to adjust the checkbook balance without leaving a hanging adjustment that will never clear? Also, we went through the GL and the uncleared transactions in GP and don't have any issue that is unidentified.

Thanks so much in advance!

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Suggested answer

Cheryl Waswick on at

Like (0)

Report

RE: GL and Checkbook don't agree

If your checkbook balance is off, you can update it directly in the SQL table (CM00100 checkbook master), instead of keying a transaction that will never clear. This should only be a 'last resort' option however, after you have checked out all the data to look for the difference.

The bank reconciliation is comprised of calculations based on data. The upgrade would only update GP code. It would not change any of your data.

Thanks,

Cheryl Waswick

Microsoft Support