Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Mark Feldman]

We are trying to use the GP bank reconciliation feature, but we see a number of very old, stale transactions that should be disregarded. The question is, is there a way of deleting items from the bank reconciliation without affecting/impacting the book balance or the general ledger?

——————————
Mark Feldman
CFO
Piping Rock Health Products
Ronkonkoma NY
——————————

[Katie Graves]

What we have done is selected the items for reconcile, then make a reconciling adjustment for the total. We use the cash account GL for the adjustment, so it will make a debit and credit to cash and wash.  Not sure if that is the correct way, but it takes care of the issue. 

——————————
Katie Graves
Illinois Credit Union System
Naperville IL
——————————
——————————————-

[Bert Green]

That is the method that I used when we decided to start actually use that feature of GP. I had about 5 years of data that I had to clean out this way.

——————————
Bert Green
GP Developer/GP Administrator
Berger Transfer & Storage, Inc.
Saint Paul MN
GP2015/MR CU11
——————————
——————————————-

[Michael Taranto, CPA]

One way is to control the posting to general ledger.  This is done in the Administrative setup area. 
Change the series to financial and then the origin to bank transaction entry.  Uncheck the post to general ledger and save.  Go ahead and void your transactions in Bank rec.  Just remember to come back to this screen and check the boxes otherwise transactions will continue not to post.

Hope this helps!
Mike

——————————
Michael Taranto, CPA
ERP Consulting LLC
Pataskala OH 43062
740-951-0220
——————————
——————————————-