Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Error With Cash Application Batch

Posted on by Microsoft Employee

So I received a request from a user and this is what she said.

"

I was entering a cash batch (PMT0192262). After I applied all the cash I had to review it for a problem. While reviewing, the whole screen froze (all of Dynamics froze) When I was able to use Dynamics again, the payment batch was gone. If I look up one of the invoices that I applied cash to it shows the invoice as paid on PMT0192262. I never posted this payment batch, and I cannot find it in inquiry or on the customer's account.

Can you please locate the batch so it can post properly against A/R?

CashAppBchError.png

But once you click the Blue Document No to see the document it give the following error.

CashAppBchError2.PNG

Any help will be greatly appreciated.

Thank you,

Eleazar

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error With Cash Application Batch

    Harry,

    The post on running check links helped a lot. The fix was :

    deleted all of the records in:

    tempdb.DEX_LOCK

    tempdb.DEX_SESSION

    dynamics.sy00800

    dynamics.sy00801

    And ran check links on Receivables Open Transaction Files. Thanks again for all your help.

    Eleazar

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Error With Cash Application Batch

    Eleazer,

    In situations like this it is a good idea to make a backup before attempting to diagnose and fix the problem.  I would suggest running Microsoft Dynamics GP > Maintenance > Check links on the Sales Series Tables and for good measure the Financial Series too.

    Then I would recommend running Sales > Utilities > Reconcile once Check Links is complete.

    Here is a good post on running Check Links and Reconcile:

    community.dynamics.com/.../check-links-amp-reconcile

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans