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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Invoice has $0 unappli...
Microsoft Dynamics GP (Archived)

Invoice has $0 unapplied balance, but nothing was applied to it. How to void on AP only?

(0) ShareShare
ReportReport
Posted on by Community Member

Invoice is showing a $0 unapplied balance on the payables side however this was never applied. We tried to void it on the payables side but the system will not let us. Please advise on how this invoice can be voided on AP only?

*This post is locked for comments

I have the same question (0)
  • drummerboy_10 Profile Picture
    drummerboy_10 on at
    RE: Invoice has $0 unapplied balance, but nothing was applied to it. How to void on AP only?

    Hi T -

    Have you tried running Check Links for Payables Historical Logical or Transaction Logical files?  Make sure you have everyone exit Dynamics GP and make a backup of your database before running this.

    --Sean

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Invoice has $0 unapplied balance, but nothing was applied to it. How to void on AP only?

    Hello

    This seems definitely one of the glitches encountered due to various reasons. The initial prerequisite is to run the reconciliation and check links for the payable series. Supposedly, if there are no apply records in the apply tables, the system shall recalculate the current transaction amount, applied and unapplied amount and get them updated accordingly.

    If this has not been resolved, let us know so that we dig into further details.  

    Your feedback is highly appreciated,

  • Community Member Profile Picture
    Community Member on at
    RE: Invoice has $0 unapplied balance, but nothing was applied to it. How to void on AP only?

    I've tried to run it, but it took an hour and the program froze up.  Is there any way to tell if check links is running?  It seemed odd that the Error File checkbox was grayed out on top of the window when it asked if I wanted the results to go to screen, printer, or file.

  • Community Member Profile Picture
    Community Member on at
    RE: Invoice has $0 unapplied balance, but nothing was applied to it. How to void on AP only?

    Ok, it ran overnight on the historical links, only affected a handful of current batches.  

    It did give an error about the stored procedure pmCLTransactionLogicalTableGrp returned the following results: DBMS: -127, Microsoft Dynamics GP: 0

    I tried searching for what that error means, but could not find.  Has anyone seen a DBMS -127?

  • Community Member Profile Picture
    Community Member on at
    RE: Invoice has $0 unapplied balance, but nothing was applied to it. How to void on AP only?

    CheckLinks moved the one document from PM Transaction OPEN to History.  It is still listed as $0 available balance with no transactions. I am told this morning that, when it was in open, gp generated a 'Cannot void a partially or fully applied document' error.  I am only seeing option to void historical transactions, but there are no transactions listed against this document to void.  

  • Community Member Profile Picture
    Community Member on at
    RE: Invoice has $0 unapplied balance, but nothing was applied to it. How to void on AP only?

    What resolution did you come up with on this?  I am having the same problem on a vendor but there are about 150 invoices affected.  It appears that the payment that was to clear these out applied on the AP side but the payment is not showing on the vendor and it is not reflecting on the bank account and there is no open batch or recovery batch for this.  

  • Community Member Profile Picture
    Community Member on at
    RE: Invoice has $0 unapplied balance, but nothing was applied to it. How to void on AP only?

    I'm sorry, I don't remember.

  • Community Member Profile Picture
    Community Member on at
    RE: Invoice has $0 unapplied balance, but nothing was applied to it. How to void on AP only?

    Thanks...it was worth a try.

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,146 on at
    RE: Invoice has $0 unapplied balance, but nothing was applied to it. How to void on AP only?

    You may find that there are orphan apply records in PM30300.  You may need to delete those and then run check links to tidy everything up.  Obviously, test environment or full back up before trying anything like that.

  • Basil Ismail Profile Picture
    Basil Ismail 226 on at
    RE: Invoice has $0 unapplied balance, but nothing was applied to it. How to void on AP only?

    So, was anyone able to get this resolved? I have the same issue on about 50 invoices and don't know what to do.

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans