Finance | Project Operations, Human Resources, ...

This document has been removed from Sales Order Processing

(0) Share

Report

Posted on by Jen Sohl

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

I have the same question (0)

All responses (7)

Answers (0)

Richard Wheeler 75,850 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

You can download this script from Winthrop Development.

winthropdc.wordpress.com/.../

Was this reply helpful? Yes No
Craig Fuller 411 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Jen Sohl 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Jen Sohl 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Lisa at AonC.com 937 Super User 2025 Season 2 on at

Like (0)

Report

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.]

Was this reply helpful? Yes No