Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Missing Invoices

Posted on by Microsoft Employee

The SmartList shows about 20 invoices open with no payment applied, however I am not able to locate them in the select checks window.

How do I investigate and resolve this issue?

*This post is locked for comments

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Missing Invoices

    Hi,

    You mentioned that you could find the invoices in the PM20000 table. What is the value of the CURTRXAM field for the invoices in question? If the value is zero, them the document will not show up in the apply window because the system thinks the invoice is paid. I would search the database for the occurrence of the document number in all of the database tables to make sure there isn't an entry or fragment of an entry hanging out someplace.

    If the CURTRXAM is not zero, then I would also search the database for the invoice number to see which tables contain that string.  The free tool that I use is called Apex Search, from Apex. Specifically, I would be looking for data in the PM10200 (Apply To Work/Open) and/or the PM10201 (Apply Work Table). There are other 'search' sql statements written by those much smarter than I that the author has written and shared with the Community. They work well, but I really like the User Interface and flexibility of Apex search. My favorite thing about it is that it's FREE ! And it is also a high quality program created by one of the stalwarts of SQL tools.

    Please let us know about the CURTRXAM field value in the PM20000 table.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Missing Invoices

    Thank you all, I will open up a ticket with Microsoft.

  • Tim W Profile Picture
    Tim W 2,925 on at
    RE: Missing Invoices

    This one seems interesting, reminds me of my consultant days with select customers.

    A few questions:

    When you run the smartlist and doubleclick on one of the 20 rows does the Transaction Inquiry window open and if so what shows when you click the apply button.

    You say you don't find these in PM20000 or PM10000 so can you query PM30200 for these? 

    select * from pm30200 where vchrnmbr = <your voucher number>

    If you find the record what is the DOCAMNT and CURTRXAM?


    Assuming you find it similar query in PM30300 to see what had 'paid it'

    Also, what value is in the Keys table?

    select * from pm00400 where cntrlnum = <your voucher number>

    or

    select * from pm00400 where vendorid = <your vendor id> and docnumbr = <their invoice number>

    what is the DCSTATUS and DOCTYPE?

    Seems possible to me that they were paid and moved to history but the process had some error and so the keys table was not updated and the inquiry window is not showing correct state. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Missing Invoices

    Is there a column in one of these tables that I can either reset or update to make them available in "Select Checks" window?

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: Missing Invoices

    Maybe you should open a ticket with MS

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Missing Invoices

    I do see records in the following tables:

    GL20000

    PM00400

    PM10100

    PM20000

    PM80600

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Missing Invoices

    The "Open Payable Documents for Vendor xxxx: By Document Number" won't list any records

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: Missing Invoices

    what do you see in Apply Payables Documents?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Missing Invoices

    Please see my previous response

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Missing Invoices

    PURCHASING - TRANSACTION ENTRY

    from Vendor

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