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

[David Ortiz]

Hello… We are on GP 18.3.1200……Reconciliation for this checkbook already has been started. If the process was interrupted, use the check links window to check links on the CM logical files.

Any recommendations to resolve this would be appreciated.

Thanks,

David

——————————
David Ortiz
Tamarac FL
——————————

[Greg Wahl]

This was given to me a while back from Microsoft when we had an issue with reconciling and needed to restart the process…

select RECOND, RECONUM, clearedate, ClrdAmt, * from CM20200 where CMTrxNum = ‘xxx’
—where xxx is the check number you are focusing on

4. In the results above, if the 4 fields in the script are already marked off, then this item has already been reconciled. If some, but not all of the 4 fields are marked off, then someone already tried to reconcile these and it failed.

RECOND
0 = not reconciled
1 = reconciled

5. Usually, if they all have the Reconcile Number (RECONUM) filled in, then you can use this field to query and see all the transactions that were included in this failed reconciliation:

select RECOND, RECONUM, clearedate, ClrdAmt, * from CM20200 where RECONUM = ‘yyy’
—where yyy is the reconcile number

6. Determine if the reconciliation is valid or not.

• If it is not a valid recon and you want to free these transactions up, you can run a script like this to unmark these 4 fields, and delete the header record for it in the second script below:

update CM20200 set RECON = ‘0’, RECONUM = 0, clearedate = ‘1900-01-01’, ClrdAmt = 0.00 where RECONUM= ‘yyy’
—where yyy is the reconcile number

delete CM20500 where Chekbkid = ‘zzz’ and RECONUM= ‘yyy’
—where yyy is the reconcile number and zzz is your checkbook ID.

——————————
Greg Wahl
IT Applications Supervisor
Owensboro Municipal Utilities
Owensboro KY
——————————
——————————————-

[David Ortiz]

Greg…Thank you for your assistance.

David

——————————
David Ortiz
Purosystems, LLC
Tamarac FL
——————————
——————————————-