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
Hello
I am afraid to tell you that there is a problem with your application. I think you must try latest service pack with your application and before this backing up data base.
Thanks
Travis,
You can go to GP > Tools > Utilities > Sales > Reconcile - Remove Sales Documents to move fully completed transactions to history. Check the Option to Remove Completed Documents and select your transaction in the From and To fields or leave them blank to evaluate all transactions. As with any utility, you may want to make a database backup beforehand, just in case (especially if you will be leaving the From and To fields blank).
[quote user="Muhammad Faisal Hussain Siddiqui"]I am afraid to tell you that there is a problem with your application. I think you must try latest service pack with your application and before this backing up data base.[/quote]
It is best to point out where you get this information from, for example, the KB article or the specific service pack that needs to be applied to fix the issue... but of course, this is not a bug, so I guess you will never find it.
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.
I presume that you have tried the usual maintenance routines (checklinks andd reconile)?
Jon.
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.
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.
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 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 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.
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 Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
