Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Lost the Manual Payment after internet disconnected

    Yes Josey

  • joseytang Profile Picture
    joseytang 1,800 on at
    RE: Lost the Manual Payment after internet disconnected

    Do I need to clear the activity table and temp table before running the below UPDATE statement script?

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

    XXXX - pass your batch id.

    Please advise

    THanks,

    Josey

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Lost the Manual Payment after internet disconnected

    Hi Josey,

    Soma recommendation is absolutely correct which I missed on my original post.  If you do the above it should resolve your problem.  

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Lost the Manual Payment after internet disconnected

    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!!!

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Lost the Manual Payment after internet disconnected

    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.

  • joseytang Profile Picture
    joseytang 1,800 on at
    RE: Lost the Manual Payment after internet disconnected

    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... on at
    RE: Lost the Manual Payment after internet disconnected

    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
    RE: Lost the Manual Payment after internet disconnected

    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

  • joseytang Profile Picture
    joseytang 1,800 on at
    RE: Lost the Manual Payment after internet disconnected

    Thanks Babu,

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

    Thanks for your help

    Regards,

    Josephine

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Lost the Manual Payment after internet disconnected

    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.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans