web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Lost the Manual Paymen...
Microsoft Dynamics GP (Archived)

Lost the Manual Payment after internet disconnected

(0) ShareShare
ReportReport
Posted on by joseytang 1,800

 Our GP is on web-based cloud.  We had an internet outage while our user applied a manual payment for $ 150,000 and applied an AP invoicing.  After the internet was back to normal,  user logged back to Great Pains and found out AP invoices are fully applied.  However, user don’t see the payment $150,000 anymore. 

 

By the way, we ran the checklinks and reconcile in AP module.  However, the payment $150,000 could not be appeared in system as well as applied invoices.

 

One thing we noticed that there was a batch in Payable batch window.  However, the Status = Posting.  We would like to change the Status = available.  Is there a SQL script to release this batch status to "available"?  That could be $ 150,000 payment in this batch.

 

Please advise how we resolve this issue in order to show $ 150,000 payment in Manual Payment window.

 

Thanks,

Josey

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi Josey,

    Please take a backup before running the following on the SQL and log out all users.  The first query will show any users still logged in GP.

    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

  • joseytang Profile Picture
    joseytang 1,800 on at

    Thanks, Babu.

    If we have copied the issue from Production company to TEST company. Currently, we want to try the solutions in TEST company.  

    My question is we still need all users logoff from Great Plain in production to run the these scripts?

    SELECT * FROM DYNAMICS..ACTIVITY

    SELECT * FROM DYNAMICS..SY00800

    SELECT * FROM DYNAMICS..SY00801

    SELECT * FROM TEMPDB..DEX_LOCK

    SELECT * FROM TEMPDB..DEX_SESSION

    DELETE DYNAMICS..ACTIVITY

    DELETE DYNAMICS..SY00800

    DELETE DYNAMICS..SY00801

    DELETE TEMPDB..DEX_LOCK

    DELETE TEMPDB..DEX_SESSION

  • joseytang Profile Picture
    joseytang 1,800 on at

    Thanks, Babu.

    If we have copied the issue from Production company to TEST company. Currently, we want to try the solutions in TEST company.  

    My question is we still need all users logoff from Great Plain in production to run the these scripts?

    SELECT * FROM DYNAMICS..ACTIVITY

    SELECT * FROM DYNAMICS..SY00800

    SELECT * FROM DYNAMICS..SY00801

    SELECT * FROM TEMPDB..DEX_LOCK

    SELECT * FROM TEMPDB..DEX_SESSION

    DELETE DYNAMICS..ACTIVITY

    DELETE DYNAMICS..SY00800

    DELETE DYNAMICS..SY00801

    DELETE TEMPDB..DEX_LOCK

    DELETE TEMPDB..DEX_SESSION

    By the way, running the above script, will the manual payment be appeared in the payment window?

    Please advise

    Thanks,

    Josephine

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Yes Josey this will release the stuck records so that you can re-do the payment again. Yes its better to logout everyone for doing this and make a backup.

  • joseytang Profile Picture
    joseytang 1,800 on at

    Thanks Babu,

    We will run the scripts tomorrow during system downtime.  I will let you know the result.

    Thanks for your help

    Regards,

    Josephine

  • joseytang Profile Picture
    joseytang 1,800 on at

    Hi Babu,

    We ran the 4 SQL Scripts in dynamics database.  The batch status still shown as "Posting".  The applied AP documents cannot be re-displayed.

    What are the other suggestion?  When we tried to click those AP document, it said those document are fully applied.  We need to re-call back the payment document as well as the applied invoices.

    Which AP tables we can look up the Payment dollars amount.  At least we need to know where the manual payment transaction was?

    Please advise

    Thanks,

    Josephine

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi Josey,

    Did you run the delete statement.  Have you tried go to batch directly by going to

    Purchasing >> Transactions >> Batches

    can you please share the screen shot.

  • joseytang Profile Picture
    joseytang 1,800 on at

    Hi Babu,

    Yes, we did run all 4 delete statements.  I cannot see this forum allow me to attached a file.  So I couldn't attached the Purchasing batch window.  But I can let you know that one of the batches in purchasing batch window, it shows as Posting status.  When you try to select this batch, the system will not allow you to open this batch.

    My question is how I can bring back the Payment $150,000 as well as the applied invoices.    I think the transactions were in the middle of posting.  That was the reason why we couldn't re-open the Payment $150,000 and applied invoices?

    Please advise

    Thanks,

    Josey

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi Josey,

    To attach the screen shot after you press reply button on the community below the box please select Use rich formatting in this you have button for attach pictures.  Can you please check the following.

    1) Purchasing >> Inquiry >> Transaction by Vendor - in this window please select your Vendor/Creditor ID and select document by type and filter by payment and check whether you are able to see your payment posted.

    2) Purchasing >> Reports >> Trial Balance >> New or Modify button - in the trial balance give ranges with the credit ID and check whether the payment is appearing or not.

    3) Administration >> Routines >> Batch Recovery - Go to this and see any batch is on the recovery and recover the same in order to post it.

    4) Purchasing >> Utilities >> Reconcile - Give the range for the particular Creditor/vendor ID and process it.

    Please let me know how you get on with the above.

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    Josey,

    Use the below query to change your batch status from posting to available.

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

    XXXX - pass your batch id.

    After running the above script, you can post the batch from payable batch window. If this working fine on test environment, try the same in live as well.

    For your reference, please have a look on the below link.

    dynamicsthoughts.wordpress.com/.../user-idbatch-id-stuck-while-postingreconcilingdeleting-etc-in-dynamics-gp

    Hope this helps!!!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans