1,960
Hi, we have some SOP order documents that have been completely transferred to invoice, yet they are not going to history. Please advise any methods to fix this.
*This post is locked for comments
Hi Susan, Unfortunately not. Because the Order has a status of 'in process' the standard GP tools won't remove it.
I'm not too worried about getting rid of the orders - (ie to history), that I can do, more interested in if anyone had a reason why it occurs - other than a network glitch during the transfer process. Just wanted to make sure that its not some known issue.
Thanks to all.
You can try the Utlility>>Sales>>Reconcile - Remove Sales Documents. And use the Remove Completed Documents
From the Help section on the tool:
Use the Reconcile-Remove Sales Documents window to reconcile your sales records and to remove any documents that have no remaining quantities but haven't been moved to history. You may want to reconcile documents before you remove them to ensure the accuracy of the documents that are removed.
To add to how I solved it last time I posted the problem.
Since I didn't like the Status: In Process, I did a further step before running Reconcile. I first changed the quantity to Qty Canceled and then run Reconcile as Richard mentioned.
I only see this happening a handful of times per year for all of my clients. Usually results from a batch getting hung during posting or a power failure of any one of the other reasons for corrupt data. Sometimes people begin to manually adjust quantities after an order has been transferred to an invoice. There really is no pattern to it.
Hi Richard,
Yep, thats exactly what I'm doing. Its obviously just data corruption. No third parties involved. Its strange though that others above have the same issues. I was wondering if anyone had managed to debug the issue. Probably a glitch when the transfer to invoice process was being run.
Doesn't seem to be any logic to it. The docs are spread out over dates and batches. Suppose just fix these and monitor it...see if it recurs.
Thx. Ian.
I would have to research this further but the bottom line is that you need to adjust several of the quantity fields on the SOP10200 table so that when you do run GP > Tools > Utilities > Sales > Reconcile - Remove Sales Documents they will move to history. Hopefuly you have a test company. In that company enter a two line order. Then invoice just one of the lines. Now go into SQL and look at that line and all the quantity fields. Now come back to your production database and change those fields to match and then run Remove Sales Docs and they will go into history. Now the bigger question is why is this happening in the first place. Are these orders imported? Are there any third party products involved. I would work with your partner to find the reason.
Hi all,
I've come across a similar situation. 36 orders with a status of 'in process' even though they were fully transferred to Invoice and the invoices are in SOP history now.
I've run check links, and reconcile (document removal etc). No difference.
I do notice that the quantities on the Order are wrong - for example, one order line shows a back order quantity, even though the order is moved to invoice.
Any ideas how this could happen?
I presume my only option now is to edit the quantities in the SOP line work table...maybe edit the document status etc...and keep running check links after each change until it sorts it self out?
Anyone got a better suggestion?
Ian.
This forum is really amazing. As soon I hit the Submit button at mid-night (US), within minutes, I got replied. Now, I believe the World is Flat. :)
Jon, thanks for your quick response. No, I haven't run the Check Links and am holding off the Reconcile process until I really understand what has caused it. I've read Victoria's instructions above and will do that.
I presume that you have tried the usual maintenance routines (checklinks andd reconile)?
Jon.
We're currently experiencing the same problem. The Sales Order's status is In Process. And when the items got transferred to the Invoice, the Qty. of one of the items printed 0 instead of 1, for instance, or 1 instead of 16, on the Ordered column. However, the Qty. on the Shipped column seems to be fine.
Another strange problem as we've noticed that if we print a mentioned (in-process) Sales Order on a standard (non-modified) SOP Order Blank Form, the Qty of the items that got changed to 0 or 1 on Invoice seems to be correct on both Ordered and Shipped columns. However, all other items that were printed correctly on the Invoice would be 0 on the Shipped column. See example below.
(In-Process) and (Standard Form) Sales Order Invoice
Ordered Shipped B/O Ordered Shipped B/O
3 0 0 3 3 0
16 16 0 1 16 0 (wrong)
(Modified Form) Sales Order
Ordered Shipped B/O
3 3 0
16 16 0
Really interesting. I guess we'll never know what happened during the transfer process. Hope MSFT can.
Hint: When we upgraded from v9 to v10, the update of Reports and Forms reported lots of problems but it seemed to print fine then until we upgrade to GP 2010.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,399
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
