Sales Order Stuck at In Process

(0) Share

Report

Posted on by Community Member

I have a sales order that has been transferred to an invoice and the invoice has been paid. However, the sales order is still showing "In Process". All the line are showing as having been invoiced, nothing back-ordered. I have tried Check Links and Reconcile - Remove Sales Documents but it still shows "In Process".

Any suggestions?

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi George,

Have you tried the following, please take a backup before doing this.

SELECT * FROM DYNAMICS..ACTIVITY

SELECT * FROM DYNAMICS..SY00800

SELECT * FROM DYNAMICS..SY00801

SELECT * FROM TEMPDB..DEX_LOCK

SELECT * FROM TEMPDB..DEX_SESSION

If you get answers / results to any of the above, make sure everyone is in fact logged out of GP and then run the following scripts to clear the tables.

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_LOCK

DELETE TEMPDB..DEX_SESSION

Then run the following against the company database:

UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB=’XXX’

(Where ‘XXX’ is the batch ID of the batch that is stuck in posting / Reeiving / Busy / Marked etc.)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Babu,

Thank you for the suggestion. Though the process you outlined is typically used for orders stuck in posting, I gave it shot. Unfortunately, it did not work.

Was this reply helpful? Yes No
Tim Foster 8,515 on at

Like (0)

Report

Can you try transferring to Invoice or Back Order again? Don't really transfer it - just preview to confirm there aren't any remaining quantities.

Tim

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Tim,

I have tried that, and nothing transfers.

There was a deposit on the order, and I thinking something may have happened to the cash receipt that is hanging it.

Was this reply helpful? Yes No
Suggested answer

Tim Foster 8,515 on at

Like (0)

Report

Follow this article and check the value?

dynamicsgpblogster.blogspot.ca/.../sales-order-processing-posting-statuses.html

Tim

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Posting status set to 0.

Was this reply helpful? Yes No
Tim Foster 8,515 on at

Like (0)

Report

I think you're on to something:

dynamicsgpblogster.blogspot.ca/.../defaulting-include-totals-and-deposits.html

Did the Deposit carry to the Invoice?

Tim

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No, the deposit did not transfer. I'm not sure if that was due to the user not checking the box or system hiccup.

My only resolution is to remove the deposit from the order, then I can move the order to history. I've looked high and low for the cash receipt, but cannot find it anywhere other than on the order.

Was this reply helpful? Yes No
Suggested answer

Tim Foster 8,515 on at

Like (0)

Report

Correct. Remove the Deposit. Reconcile-Remove Sales Document. If the deposit is in a previous period you may get a Fiscal Period warning. You will have to re-open to remove it.

Tim

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes, that works. Thanks.

Was this reply helpful? Yes No