Clearing Electronic Reconcile transactions

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (1)

Answers (0)

Brian Wick on at

Like (0)

Report

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

Was this reply helpful? Yes No