Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Void Payment - Allocat...
Microsoft Dynamics GP (Archived)

Void Payment - Allocated Credit Note "Creditor not found"

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi All,

I have stumbled across an  issue this morning with a payment that I have voided.:

I had entered a Supplier payment that I had posted by accident a couple of months ago. I realised there was a mistake and voided it on the same month.

The I posted it again the following month and tried to apply it to the relevant invoices/debit notes. I noticed while doing this that certain debit notes had a zero balance  and some were showing a balance.

I have a credit note that I can search "Transaction by Document" for by number: XYZ123. When I search for it, it is returned in the grid showing against Creditor ABC.  When i drill into the detail of the note, it shows "Creditor not found".  

When I search for "Transaction by Creditor" for Creditor ABC, the credit note XYZ123 doesn't appear in the results. 

I have run a Checklinks and it picked up an issue with the credit note, the message was something along the lines of: "The Tax rows have been removed for this transaction". But it hasn't resolved the issue with the note.

Any assistance would be greatly appreciated and as always, thanks in advance.

Alex

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Void Payment - Allocated Credit Note "Creditor not found"

    Hi,

    One risk is that dynamics may have so other code running for those delete/update procedures that you aren't aware of.  Just be sure you have a complete backup of your database Just in case it doesn't turn as we expect. If you have found the record and can complete the missing codes, that could be the best answer. You could potentially get the document pack in a Work state.

    Kind regards,

    Leslie

  • Mick Egan Profile Picture
    Mick Egan 3,557 on at
    RE: Void Payment - Allocated Credit Note "Creditor not found"

    Should be fine to reset. Just check the record isn't in history.  Sounds like it wont be in the PM30200.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Void Payment - Allocated Credit Note "Creditor not found"

    Hi Mick,

    Thankyou for your suggestion.

    I managed to find the record in PM20000 by VCHRNMBR. It seems like there are other fields missing from the record such as:

    - DOCNUMBR

    - BACHNMB

    The CURTRXAM Amount is also set to 10.60 however the DOCAMNT is 0.

    The reocrd just seems corrupt to me. Are there any implications with repopulating that table with the correct details?

    Many Tanks

    Alex

  • Suggested answer
    Mick Egan Profile Picture
    Mick Egan 3,557 on at
    RE: Void Payment - Allocated Credit Note "Creditor not found"

    You would most likely find the VENDORID is missing in the PM20000 Table for that record.

    The reason it displays on the Transaction By Document Window, is that detail comes from the PM00401 Table.

    UPDATE PM20000 SET VENDORID ='ABC' WHERE DOCNUMBR = 'XYZ123' AND VENDORID = ''

    Mick

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans