Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Accounts Payable invoice unable to apply,void

Posted on by Microsoft Employee

How do i get rid of an open invoice that cannot be applied against or voided?

Whenever i try to do any of the above i get message saying ' Invoice cannot be applied or voided as it is partially or fully applied '.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Accounts Payable invoice unable to apply,void

    I'm not sure how to check that.

    Payables Transaction Inquiry window:

    Original Amount $715.60

    Unapplied Amount $0

    Payables Transaction Inquiry Entry Zoom window:

    Purchases $729.40

    Trade Discount $14

    Total $715.60

    Total Payments $0

    Terms Disc Taken $0

    On Account $715.60

    When I click the Apply button:

    Document Amount $715.60

    Amount Remaining $0

    but no transactions are listed

    When I click the Distrubtions button:

    Functional Amount = Originating Amount = $715.60

    PURCH Debit $729.60

    TRADE Credit $14

    PAY Credit $715.60

    Functional Totals Debit = Credit = $729.60

    Originating Totals Debit = Credit = $0

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Accounts Payable invoice unable to apply,void

    Do you know or can you tell if someone might have done - started - a quick pay on this invoice?

    When you open the invoice in the Payables Transaction window, do you see an ending balance for the invoice?  Do you see any payment information entered against the invoice.

    Let us know.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Accounts Payable invoice unable to apply,void

    I am having this exact same issue. The document is in AP with no transactions applied against it, but with $0 balance left. It cannot be voided, nor can any transactions be applied to or voided from it. In PM20000, the CURTRXAM field is 0.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Accounts Payable invoice unable to apply,void

    If you have access to SQL, look in the PM20000 table and the PM10200 tables. In the PM20000 table, look at the CURTRXAM field, that should be equal to the balance of the outstanding invoice. Also, look in the DINVPDOF field, it should be empty. Look in the HOLD field, it should be 0 if the document is not on hold.

    Next, look in the PM10200 table and look for your open document in the APTVCHNM field. If you cannot apply anything to this document, the system must think it is fully applied or on hold.

    If you bring the document up in the payables transaction inquiry window and then drill back on Unapplied Amount, what do you see?

    Kind regards,

    Leslie

  • soma Profile Picture
    soma 24,406 on at
    RE: Accounts Payable invoice unable to apply,void

    Have you tried to run the Reconcile or Checklinks for Vendor and Payables information?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Accounts Payable invoice unable to apply,void

    Mahmoud, I read the response  from your link but that will not solve my problem as i cannot apply anything to that invoice at all. What i did was to do a JV to cancel the GL effect but the invoice is still open in payables.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Accounts Payable invoice unable to apply,void

    Check this out  Voiding a partially applied Payables transaction in Dynamics GP

    Your feedback is highly appreciated,

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans