Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Dynamics GP2015 Purchasing Invoice still open by $215 and Unapplied is $0.00 and payment show in the trial balance by $215 Net $0.00

(0) ShareShare
ReportReport
Posted on by 365

Good evening,

       I have a purchasing invoice still open by $215 and Unapplied is $0.00 and payment show in the trial balance a payment by $215 Net $0.00, this invoice should be in history but still open. I run check link and reconciliate process but still open, I have another invoices in the same conditions. I check the PM20000, PM20100 (TEMPORARY) and PM20200 (NO records).

Any SQL scripts suggestion is welcome.

Thanks a lot,

  Mr. García

*This post is locked for comments

  • Verified answer
    mgarcia Profile Picture
    mgarcia 365 on at
    RE: Dynamics GP2015 Purchasing Invoice still open by $215 and Unapplied is $0.00 and payment show in the trial balance by $215 Net $0.00

    Good evening,

     The problem has been solved.

     check this link

     evarsys.com/dynamicsgp

    Thanks a lot for your help

  • mgarcia Profile Picture
    mgarcia 365 on at
    RE: Dynamics GP2015 Purchasing Invoice still open by $215 and Unapplied is $0.00 and payment show in the trial balance by $215 Net $0.00

    In the Trial balance showing the below message for this Payment

    “the Aged Trail indicates an unposted credit document that has been applied, yet there is nothing to post”

    but In the Inquiry option – Purchasing by Vendor this payment not showing, I review the temporary table PM20100 and this payment is here.

    I don’t have pending batchs, remittance or batch to recovery pending, all look good.

    Thanks

  • mgarcia Profile Picture
    mgarcia 365 on at
    RE: Dynamics GP2015 Purchasing Invoice still open by $215 and Unapplied is $0.00 and payment show in the trial balance by $215 Net $0.00

    Good morning,

     

                    Yes i ran Purchasing Reconciliate and Purchasing Check link but don’t work, any other suggestion is welcome.

    Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics GP2015 Purchasing Invoice still open by $215 and Unapplied is $0.00 and payment show in the trial balance by $215 Net $0.00

    Are you sure that the check was applied to this invoice?  Is the check void, maybe?

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,054 Super User 2024 Season 1 on at
    RE: Dynamics GP2015 Purchasing Invoice still open by $215 and Unapplied is $0.00 and payment show in the trial balance by $215 Net $0.00

    Hi Mr. Garcia,

    Before trying to run any SQL scripts to fix the issue, have you attempted to run a reconcile in the POP module ?

    Purchasing >> Utilities >> Reconcile

    Also, alternatively if this doesn't fix the problem, you could run a check-links against the PO's.

    Microsoft Dynamics GP menu >> Maintenance >> Check Links

    Select the 'Purchasing' module and than in the bottom list 'Purchasing Transactions'.

    Don't forget to do a full company backup before you do that, and it's best that no one else is in the company while you run those steps. In case something goes wrong, you can always go back & restore the 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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans