You’re offline. This is a read only version of the page.
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
Yes, that works. Thanks.
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
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.
I think you're on to something:
dynamicsgpblogster.blogspot.ca/.../defaulting-include-totals-and-deposits.html
Did the Deposit carry to the Invoice?
Tim
Posting status set to 0.
Follow this article and check the value?
dynamicsgpblogster.blogspot.ca/.../sales-order-processing-posting-statuses.html
Tim
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.
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
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.
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.)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (