SOP Order Not Moving to Invoice when Complete

(0) Share

Report

Posted on by Jim Lines

Greeting,

I’ve got a situation that has now happened 2 times in the last two weeks. An invoice gets posted and moved to history but the order remains open even though it’s 100% complete. Our process is pretty simple in that we create the order, ship, invoice and post all in the same day/same time. We process thousands of invoices per day and this has only happened 2 times, so it’s not consistent. When I drill into the invoice, it has a status of “In Process.” I changed that to complete in SQL and reconcile the document which just reverted it back to In Process. I’ve covered all the basics – reviewing all the SOP open and history tables, running reconcile and checklinks, etc. and the order remains. Also I did not find any similarities between the two documents (i.e. different customer, different inventory items).

Has anyone seen this? Any suggestions on where to look?

Thanks in advance.

Jim

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Jim Lines 4 on at

Like (0)

Report
Copy link

Link copied!

OK... so I found out that the 2nd issue was just a user error. However, I still have a problem with 1 invoice not moving to history. Any help is appreciated.

Was this reply helpful? Yes No
Verified answer

DinB 4,085 on at

Like (0)

Report
Copy link

Link copied!

You could try following to investigate this issue:

1) For each line item in that Sales Order, check the "Sales Quantity Status" window to see if it has anything under "Remaining Quantity" or anything unusual about Quantities.

2) In the SOP10100, for that Sales Order, look to see if there is any amount in fields such as "REMSUBTO", "OREMSUBT",
In the SOP10200, look to see if there any amount in the fields such as "REMPRICE", "OREPRICE".

3) You should try this in Test Company first (if you have not already tried):
Open the "Reconcile - Remove Sales Documents"
Microsoft Dynamics GP >> Tools >> Utilities >> Sales >> Reconcile - Remove Sales Documents
Check the report using following options. This is to see if the process will move that Order to History. If the Order is fully completed, then this process should move it to history.

Let us know how it goes.

Was this reply helpful? Yes No
Jim Lines 4 on at

Like (0)

Report
Copy link

Link copied!

Hey Max,

Thanks for the response. I found that I needed to run the Remove Completed Documents function to fix it. Thanks!

Was this reply helpful? Yes No