Order went to Invoice (and was posted) but still remains in Order

(0) Share

Report

Posted on by Community Member

An order was transferred to invoice but glitched out and did not take the freight. Moreover it didnt actually transfer but is sitting there as an Order that doesnt transfer again.

I was able to have the user add the freight to the Invoice and post it but that pesky order remains. I ran Reconcile - Remove Sales Documents but it doesnt show anything happening and the Order is still there.

Any ideas on how to remove it? I dont want to void it as a payment was applied to that Order and I dont want it refunded or any issues for accounting. Moving it to history seems to be the best option if I can do it.

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

coquisalsa 2,725 on at

Like
a
(1)

Report
Copy link

Link copied!
I came across this issue few times, it seems more common in GP 10. Most of the time the problem is due to the Quantity Remaining being greater than 0, this quantity should be 0 before you can move the order to history.

Most times, the "Reconcile Sales Document" tool fixes the problem, you will need to run it twice:

After entering the SOP Number, select "Reconcile Sales Document" and click process.

After entering the SOP Number, select "Remove Completed Document" and click process.

If the above steps don't correct the problem, you will need to amend the QTYREMAI (Quantity Remaining) in table SOP10200 using SQL. In orders, this quantity is calculated as follow:

Quantity Remaining = Quantity Ordered - Previously Backordered - Previously Invoiced - Canceled

Was this reply helpful? Yes No