Notifications
Announcements
No record found.
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
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.
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.
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.
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
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
