web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Data Cleanup
Microsoft Dynamics GP (Archived)

Data Cleanup

(0) ShareShare
ReportReport
Posted on by Community Member

AR has come to me with an issue. Within the bank deposit screens there seems to be old data from previous years they would like that gone. The transactions go back as far as 2010. Through further conversation the data is a remnant of an old integration that flooded the SOP10100 table with transactions. Is there a way to clean/remove the data?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    Are there only records in the SOP10100 table, or are there corresponding line records in the SOP10200 table? Is there an easy way to identify and group these transactions?

    In most every case, I counsel users not to use SQL to manipulate data in their production environment unless absolutely necessary.  

    I will start with the admonition to back up and test thoroughly.

    The preferred method, should these transactions be complete transactions, accessible in Sales Order Processing Entry, would be to create a batch, then move these transactions to this batch, and delete the batch.

    Alternatively, should these transactions be incomplete transactions, inaccessible in Sales Order Processing Entry, would be to delete them using SQL.

    Either way it is paramount only the records that should be deleted are deleted. My strong recommendation would be to create/refresh a test database for this purpose, work to create the process, then execute the process. Only then should it be executed in the Production environment.

    Finally, do your self a favor and document, document, document.

  • Verified answer
    Justin Thorp Profile Picture
    Justin Thorp 2,265 on at

    Hi,

    From your description is sounds like in the Bank Deposit Entry window, you still some very old Receipts.

    You can remove these receipts by going to the Bank Deposit Entry window, and set the TYPE = 'Clear Unused Receipts', mark all Receipts you want to clear, then post the Deposit.  A Deposit to clear unused receipts doesn't update the checkbook balance or GL (it simply prevents those receipts from appearing as available receipts).

    Thanks,
    Justin

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans