Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / This document has been...
Finance | Project Operations, Human Resources, ...
Suggested answer

This document has been removed from Sales Order Processing

(0) ShareShare
ReportReport
Posted on by Jen Sohl 5

Having an issue with GP today. It seems that a user had went to post a batch last night and it stalled out. So she had to go in and do a Batch Recovery. The batch was then available and she said she was able to post it. Today another user was trying to access a document in Sales Transaction Entry and she was receiving an error message that the document already existed. We went into Sales Inquiry-Transaction by Document to view the detail on this document, and are getting an error message "This document has been removed from Sales Order Processing" . 

Not sure what is going on? I've done some searching and someone suggested the description needed to match the invoice number , which it does. 

I tried running a Sales reconcile using both options to reconcile and remove completed documents - This turned up no results. 

The document is in SOP10100 and SOP10200. No records in SOP30200 or SOP30200. 

Any ideas what to check next? Still learning GP (Took over for a colleague who left the company), so I'm sure there is something I'm missing! 

Any help is MUCH appreciated!

Categories:
Microsoft Dynamics GP
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,134 on at
    RE: This document has been removed from Sales Order Processing

    If you are comfortable with SQL compare the values of the document that is giving the "..removed from Sales Order Processing" message with a similar document in SOP10100.  (For example, if it is an invoice, compare it with another invoice.)

    The main culprit I run into is with voids.  Because GP doesn't finishing processing the void until the Sales Transaction Entry window is open, the user who posted the batch that "stalled out" may also have had a void pending.  There are a bunch of columns in SOP10100 that will point to this (BACHNUMB is the user's name, VOIDSTTS=1, TRXSORCE is a SLSVT code are three good indicators.)  Comparing the data for the problem document and a non-problem document.

    [If you aren't comfortable with SQL, you can use SmartList > Sales > Sales Transactions to look at these columns but someone will need to get into SQL if the void is the problem as there is clean-up to be done in multiple tables.]

  • Jen Sohl Profile Picture
    Jen Sohl 5 on at
    RE: This document has been removed from Sales Order Processing

    Thanks for the reply! I ran Check Links on Sales Work and Sales History, and it still did not resolve the issue.

  • Jen Sohl Profile Picture
    Jen Sohl 5 on at
    RE: This document has been removed from Sales Order Processing

    Thanks for the reply Craig! I checked the BCHSOURC and it currently shows "Sales Entry".

  • Craig Fuller Profile Picture
    Craig Fuller 409 on at
    RE: This document has been removed from Sales Order Processing

    I'm not sure if this has been resolved but just throwing this out there to check...does the SOP10100.BCHSOURC record show "Sales Entry"? If not, change it to "Sales Entry" without the quotes.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: This document has been removed from Sales Order Processing

    You can download this script from Winthrop Development.

    winthropdc.wordpress.com/.../

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: This document has been removed from Sales Order Processing

    Document has been removed from Sales Order Processing Would love to have a copy of the "locator" tool. They then ran check links on Sales Work and then reconciled the item again.

    mypennmedicine

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: This document has been removed from Sales Order Processing

    The first thing you can do tonight after everyone has exited GP is too perform a backup and then run check links on the sales series.

    Tools->Maintenance->Check Links and choose sales as the series and insert Sales Work and Sales History

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans