Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Open Return Stuck in GP10
Microsoft Dynamics GP (Archived)

Open Return Stuck in GP10

(0) ShareShare
ReportReport
Posted on by Community Member

I currently have an open return that does not come up in the transaction entry screen to allow me to delete or void it. We had an issue where an order number (ORD#####) was assigned to the return (instead of RTN#####) so it was not completed and remains open without any customer data, document date or details. I can find the return by searching for the document number in the Sales Documents Inquiry though. I have checked my configuration and it allows the deletion of return documents. The return appears on the SOP10100, SOP10101, SOP10102, SOP10105 tables but not the SOP10200 table. How do I go about removing the document from the system or getting GP to allow me to delete or void the document? I have tried to reconcile the document number without any results, I have also cleared the temporary tables to make sure no users were hanging up the transaction. Would something like the checklinks function fix the issue? If so, what series/tables would I run it for?

*This post is locked for comments

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Open Return Stuck in GP10

    Justin,

    I always run a SQL search of all of the tables in the database for the specific document number in question. It's the only way, in my opinion, that you can feel comfortable that you have all of the tables. Before deleting anything, you need to understand how the information flows through the system tables and what the existence of that record in that table means. I do not recommend blindly deleting every instance of the record. Many tables, that are related might not actually contain the document number, but are linked on another number, like the doc sequence number. I have done this many times, and each time it requires a careful analysis of which tables where impacted. After you perform your task, always run the Reconcile and Check Links routines. Run Check Links until no errors are presented, or you can determine that the errors are not critical.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member on at
    RE: Open Return Stuck in GP10

    Check links was unable to resolve the issue.

    If I go the route of deleting it from the work tables, is there any other tables outside of the SOP tables I mentioned that I should check for records of the transaction?

  • Community Member Profile Picture
    Community Member on at
    RE: Open Return Stuck in GP10

    Its worth running the checklinks against the entire sales module. Take a back up first of course. After that you may have to delete the transaction from the work tables.

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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans