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

All responses (10)

Answers (0)

Community Member on at

Like (0)

Report

RE: Sales Order Stuck at In Process

Yes, that works. Thanks.
Suggested answer

Tim Foster 8,515 on at

Like (0)

Report

RE: Sales Order Stuck at In Process

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
Community Member on at

Like (0)

Report

RE: Sales Order Stuck at In Process

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.
Tim Foster 8,515 on at

Like (0)

Report

RE: Sales Order Stuck at In Process

I think you're on to something:

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

Did the Deposit carry to the Invoice?

Tim
Community Member on at

Like (0)

Report

RE: Sales Order Stuck at In Process

Posting status set to 0.
Suggested answer

Tim Foster 8,515 on at

Like (0)

Report

RE: Sales Order Stuck at In Process

Follow this article and check the value?

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

Tim
Community Member on at

Like (0)

Report

RE: Sales Order Stuck at In Process

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.
Tim Foster 8,515 on at

Like (0)

Report

RE: Sales Order Stuck at In Process

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
Community Member on at

Like (0)

Report

RE: Sales Order Stuck at In Process

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.
Suggested answer

babubaskaran@outloo... 10 on at

Like (0)

Report

RE: Sales Order Stuck at In Process

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.)