Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Payables Apply Include...
Microsoft Dynamics GP (Archived)

Payables Apply Includes Blank/Odd Payment Not Related to Vendor

(0) ShareShare
ReportReport
Posted on by Jim Lines 2

Greetings,

I couldn't even figure out what search terms to use to even begin looking for answers on this one!  

See image below.  I've got a historical AP transaction that was paid in full via check.  However, when we do an inquiry on the documents applied to the invoice, we see the correct payment, and then another corrupt looking entry that is not related to the vendor (missing information).  I've run all reconciles and checklinks on AP with no success.   I've queried the PM tables using the voucher number and see entries for another vendor, but not this one.  I've also queried the PM tables for records missing dates or document numbers with no luck  Does anyone know how I can remove this bad record?  I thought this was going to be an easy one, but I guess not.

Thanks in advance!

2016_2D00_09_2D00_21_5F00_15_2D00_41_2D00_43.jpg

*This post is locked for comments

  • Suggested answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: Payables Apply Includes Blank/Odd Payment Not Related to Vendor

    Jim,

    For what it's worth, if the issue is simply a reporting issue, the easiest thing may be to exclude that transaction from showing up on the report(s). I know I have done that before on custom reports I've created. If you're using the out of the box reports, it may be a bit more challenging, but might still be easier than fixing 6 year old data.

  • Jim Lines Profile Picture
    Jim Lines 2 on at
    RE: Payables Apply Includes Blank/Odd Payment Not Related to Vendor

    Victoria,

    This is was before my time with the company so I don't know if the data was imported.  If they were, it would have been via IM.  

    I agree with you on doing any via directly via SQL.  I tried a couple things on my test server with no success and it doesn't seem like it's worth spending any more time on that just to cause more problems.  I always chuckle when our accounting department requests to fix something that is 6-7 years old... If they determine this is really necessary, I'll open a case with Microsoft.  But at this point, the ROI to fix is is much greater than seeing $4 on an aging report.  

    Thanks so much for taking a look at this for me, I truly appreciate it.  

    Best,

    Jim

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: Payables Apply Includes Blank/Odd Payment Not Related to Vendor

    Hi Jim,

    Wow! It does seem like the wrong vendor is somehow on some records. Do you know if these records were manually entered or imported (and if imported, how)? In either case, since they're so old, at this point, it's going to be very difficult to unravel how this happened.

    I still am very hesitant to suggest a SQL fix because there are many other related pieces of data in these and other tables that we're not seeing with the queries you posted. It might seem like you can change the vendor ID on some of the records, but that can easily mess up other things and get reversed back or cause further issues when you do another check links or reconciliation. This is really something I would recommend getting either Microsoft support or a knowledgeable consultant (hopefully your GP partner has one?) to help you with. 

    Sorry to be so overly cautious, but that's usually best with situations like this. 

  • Jim Lines Profile Picture
    Jim Lines 2 on at
    RE: Payables Apply Includes Blank/Odd Payment Not Related to Vendor

    Hi Victoria!

    Thanks for responding!  I think I'm headed in the right direction, but just can't get there.  In the PM30300 table, when I query on the ...2331 voucher I see the record, but it belongs to a different vendor (FRONTIER).  The line does not seem to be  missing any information, but oddly enough, I do not see this document when I do a Payables Inquiry for the vendor.  It's a PIP transaction (Payroll to Payables) and it's missing from the sequence of invoices (PIP...214, PIP...216 and mine is PIP...215).  

    Now, if I run a query PM30300 using the APTVCHNM = '000004830', I get two results:  The invoice from AWA with the phantom/corrupt payment and the one from FRONTIER, both in the correct amounts.  I'm thinking this may be the problem. 

    When I query PM00400 where CNTRLNUM = '000004830' I see the AWA vendor with the Doc Number that belongs to FRONTIER (PIP...215).  So is the vendor wrong on the doc number wrong? 

    Below is a screen shot of the queries and results (I removed columns that were not relevant to fit it all in one image).

    2016_2D00_09_2D00_22_5F00_12_2D00_42_2D00_48.jpg

    Missing from sequence:

    2016_2D00_09_2D00_22_5F00_12_2D00_42_2D00_48.jpg

    Thanks so much for helping!

    Jim

     

    Thanks!

    Jim

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: Payables Apply Includes Blank/Odd Payment Not Related to Vendor

    Hi Jim,

    I am usually not crazy about recommending deleting data directly out of SQL without seeing it myself, but most likely that is going to be the fix.

    Typically that 'extra' apply record will be in the PM30300 or PM10200 table. Can you check? Also, is there actually a payment with voucher number  ....2331 anywhere in your tables? PM00400, PM20000, PM30200? It would be CNTRLTYP = 1 or DOCTYPE = 6. I suspect no, since there is no Doc Number.

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