Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / AP Invoice in HISTORY ...
Microsoft Dynamics GP (Archived)

AP Invoice in HISTORY but not apply to any credit note or payment.

(0) ShareShare
ReportReport
Posted on by Wong Henry 1,070

Hi,

I have an AP invoice that I inquired where the status is HISTORY but it is not apply to any credit note payment.

The apply information is blank and the unapplied amount is showing 0.

Is there any way I can move the AP invoice back into OPEN from HISTORY?

Thanks.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AP Invoice in HISTORY but not apply to any credit note or payment.

    Hi,

    We are always facing this same issue. We have a payment that was applied against 3 invoices which is netting it out whereas when we look at Payable Apply there are just 2 invoices and third one is missing.

    Any help in this will be highly appreciated.

    We are using GP 2016 R2 16.00.0579

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: AP Invoice in HISTORY but not apply to any credit note or payment.

    Hi Kirsty

    If I am reading this right, you are not seeing a record of the payment at all (except PM00400).  Does that mean you can't see it against the supplier either?  And it isn't sitting in one of the posting areas (Check Posting, Remittance Printing etc).

    Did it appear in Bank Reconciliation?

    If the payment is almost entirely missing, I think I would be more tempted to delete what you can find for the payment and move the voucher that it should have been applied to back to Open.

    Then redo the payment.

    These things are entirely situation dependent.  Always take a backup and if it is an area you haven't really done before, you might want to test your solution on a copy of the Live database to ensure it all works before then applying the fix to Live.

    Cheers

    Heather

  • Kristie McNulty Profile Picture
    Kristie McNulty 977 on at
    RE: AP Invoice in HISTORY but not apply to any credit note or payment.

    Hi Soma - our situation is eerily similar to this one.  It appears the apply information was corrupted just before the connection between the payment and the voucher could be completed.  User did report being dropped from GP at the time the payment batch was being posted.  There is no record of the payment record itself, other than what was in the PM00400 table where the CNTRLNUM and DOCNUMBR existed, but no VENDORID was populated and the DOCDATE was 1/1/1900.  The voucher the payment was intended for is in HISTORY with an open amount of $0.00.  Because there is no "actual" payment number associated to this voucher, we are unable to VOID the payment so the voucher can then also be voided (we've already created the replacement records so we could pay our vendor).  The invoice continues to report in our HATB and the general ledger is out of balance with payables.  Would it make sense to reintroduce the missing payment record and join it back to the invoice/voucher record so that we could then go through the VOID steps?

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: AP Invoice in HISTORY but not apply to any credit note or payment.

    We can apply payments to this invoice if this document is on open status. Can't apply to history invoice. If you really want to apply payments to this invoice, we can do this on back end(SQL side). But this is not an advisable. First you need to check the Account Payables trail balance and Vendor Balance. If everything is fine, then we can plan to update the apply details to this invoice via SQL.

    Hope this helps!!!

  • Wong Henry Profile Picture
    Wong Henry 1,070 on at
    RE: AP Invoice in HISTORY but not apply to any credit note or payment.

    Hi Soma,

    Are there any other ways that I can proceed with this transaction?

    As there is a payment that needs to be apply to this invoice.

    Thanks.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: AP Invoice in HISTORY but not apply to any credit note or payment.

    Wong Henry,

    Surely, this invoice was fully applied to some document. Because the date field DINVPDOF(the date an invoice was fully applied) from the below query is 2014-02-27.

    select DINVPDOF, *From PM30200 where VCHRNMBR='SINV0029040' and DOCTYPE='1'

    After fully applied this invoice, this document went to history. But the related applied details for this invoice is not available in GP(both open and history).

    Cause: May be the applied details for this invoice was deleted from back end.

    For this scenario: Bringing invoice from history to open is not a advisable solution. Because the invoice already applied and distribution for this accounts was affected. Better check with the vendor for the invoice and get the details about the same.

    Note: No option available for bringing back invoice from hist to open.

  • Wong Henry Profile Picture
    Wong Henry 1,070 on at
    RE: AP Invoice in HISTORY but not apply to any credit note or payment.

    Hi Soma,

    Attached please find the SQL query result

    dl.dropboxusercontent.com/.../SQL_AP_2_201404011513.rpt

    Thanks.

  • soma Profile Picture
    soma 24,406 on at
    RE: AP Invoice in HISTORY but not apply to any credit note or payment.

    Some correction in above queries. Please run the blow queries in SQL again the company database and reply the result to me.

    select *From PM30300 where APTVCHNM='SINV0029040' and APTODCTY='1'

    select *From PM10200 where APTVCHNM='SINV0029040' and APTODCTY='1'

    select *From PM30600 where VCHRNMBR='SINV0029040' and DOCTYPE='1'

    select *From PM10100 where VCHRNMBR='SINV0029040' and DOCTYPE='1'

  • Wong Henry Profile Picture
    Wong Henry 1,070 on at
    RE: AP Invoice in HISTORY but not apply to any credit note or payment.

    Hi Soma,

    Attached please find the SQL script result.

    dl.dropboxusercontent.com/.../SQL_AP_1_201403271947.rpt

    Thanks.

  • soma Profile Picture
    soma 24,406 on at
    RE: AP Invoice in HISTORY but not apply to any credit note or payment.

    Run the blow queries in SQL again the company database and reply the result to me.

    select *From PM30300 where APTVCHNM='SINV0029040' and APTODCTY='1'

    select *From PM10200 where APTVCHNM='SINV0029040' and APTODCTY='1'

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans