Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Clearing Electronic Re...

Clearing Electronic Reconcile transactions

(0) Share

Report

Posted on by Community Member Microsoft Employee

Is it possible to clear a previous electronic reconcile run ? A ownlod was done and som transactions were manually marked and that reconciliation is complete. However, whenever I go into Reconcile Bank Statement, the unprocessed transactions report keeps printing. How do I clear this ?

*This post is locked for comments

All responses (1)

Answers (0)

Brian Wick on at

Like (0)

Report

Re: Clearing Electronic Reconcile transactions

Hi Tracy,

Thanks for your post.

If you would like to get rid of old data on the "Unprocessed Transaction" report, I would try the following:

*Please try the following steps in a TEST company or with a restorable backup in place*

1. Have all users out of GP

2. Execute the following scripts against the company database in SQL Management Studio:

select MEARDLID, * from ME142804

select MEARDLID, * from ME142806

select MEARDLID, * from ME142807

select MEARDLID, * from ME142815

select MEARDLID, * from ME142818

3. Review the data and then run the following:

delete ME142804

delete ME142806

delete ME142807

delete ME142815

delete ME142818

For your reference, these are the table names:

- ME142804 ME_Unprocessed_TextFile_Line

- ME142806 MEDownload Summary

- ME142807 ME Download Transactions

- ME142815 ME_Download_HDR_FTR

- ME142818 ME_Unprocessed_Dwnld_Trx

Let me know if you have questions.

Thank you,

Brian Wick

Microsoft Dynamics GP Support