Share
ReportAn SOP document has been transferred to an invoice after being fulfilled.
The document status still shows as In Process
How can I change this?
*This post is locked for comments
You’re offline. This is a read only version of the page.
170
An SOP document has been transferred to an invoice after being fulfilled.
The document status still shows as In Process
How can I change this?
*This post is locked for comments
Angel - root cause of issues like this could be anything. Where you see issues like this crop up and they are anomalies rather than happening all the time I wouldn't worry too much.
When GP does a posting routine, it writes data to the new tables and then goes back and deletes from the old. There is a huge amount of traffic that goes between the workstation and the database. Things like power / connection fluctuations can interrupt these processes. More often than not these will resolve themselves but sometimes you do have orphan data sitting in places. The reconcile and check links tools are there to help resolve any of these issues. Sometimes we have to do direct updates in the tables because even the tools can't sort the issue.
If the issue crops up lots, then you would need to look further into connectivity etc. For example, I had a client yesterday who had installed the GP client on a remote computer that was just using an internet link back to the office - consequently, GP performance was awful and she was constantly finding issues. Link via a Terminal Server, problem solved.
Cheers
Heather
The problem is solved after running Reconcile-Remove Sales Documents -->Remove Complete Documents.
But I still would like to know the root cause of the issue.
I'm facing exactly the same situation with two orders already fulfilled, payment applied and invoices posted.
Orders still sitting on SOP10100 with SOPSTATUS = 8.
Will run checklinks tonight, but would rather try a different solution.
Are you using Fulfillment Invoices? The document status is only used in Fulfillment Invoices.
Our book, Understanding Sales Order Processing, is one of the only texts that properly discusses Fulfillment Invoices. You might want to get a copy.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,436
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
