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
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
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
Thank you all, I will open up a ticket with Microsoft.
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.
Is there a column in one of these tables that I can either reset or update to make them available in "Select Checks" window?
Maybe you should open a ticket with MS
I do see records in the following tables:
GL20000
PM00400
PM10100
PM20000
PM80600
The "Open Payable Documents for Vendor xxxx: By Document Number" won't list any records
what do you see in Apply Payables Documents?
Please see my previous response
PURCHASING - TRANSACTION ENTRY
from Vendor
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,214 Most Valuable Professional
nmaenpaa 101,156