Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP shut down during ch...
Microsoft Dynamics GP (Archived)

GP shut down during check processing causing out of balance between ATB and PM

(0) ShareShare
ReportReport
Posted on by lrecker 200

Yesterday when I was running a zero check to clear the prepayments  and invoices on a vendors account I  got and error message something about SQL, and that the program was ending.  When I signed back in to GP and checked the account it is not correct.  Looks like it has to do with this CM for $6221.56, the trial balance shows a balance of $(2302.80) but the in the PM for that vendor it shows a balance due of $3918.76.  Added together these equal the CM that  is showing as unapplied, but it will not let me apply any of it to open invoices.   I am not sure what I can do to correct this vendors account and get the two ledgers back in balance. I would appreciate any suggestions.

*This post is locked for comments

  • lrecker Profile Picture
    lrecker 200 on at
    RE: GP shut down during check processing causing out of balance between ATB and PM

    Yes our IT dept used this to get the totals corrected.

    Thanks

    Lisa

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,267 on at
    RE: GP shut down during check processing causing out of balance between ATB and PM

    Yes. Goto -- Dynamics GP Menu--->Maintenance-->Check Link-->Select Purchasing Series. I think you select there  Payable Transaction Logical file' and Payable History also.

    Tools-->Utilities>>Purchasing-->Reconcile. Select Vendor and Process.

    Before doing above task keep good backup of your production Database.

    Thanks

    Sandip

  • lrecker Profile Picture
    lrecker 200 on at
    RE: GP shut down during check processing causing out of balance between ATB and PM

    Is this a GP tools option?

    Lisa

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,267 on at
    RE: GP shut down during check processing causing out of balance between ATB and PM

    Did you try CheckLink,Reconciliation ?

    Thanks

    Sandip

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans