95
Hi,
Does anyone know what information PM10200 contains? It appears that it is all of the payments and credits in the system (Doc Types of 5 and 6) is this correct? I am trying to generate a report that will show all of the payments that are in work status and the payables documents the payment has been applied to. If anyone has any input on how one might do this I would appreciate it.
Thanks,
Ben Parsons
*This post is locked for comments
Well, the issue is just a bit bigger but it can be done. Many of us have already. Here is what you need.
First, you need to know that you have work tables (PM1xxxx) where unposted transactions sit, open tables (PM2xxxxx) where posted transactions sit, and history tables (PM3xxxx) where transactions moved to history sit.
Transactions (all of them) are initially recorded in the PM10100 table and their relationships (apply payments to invoices) is stored in the PM10200 table.
When the transactions are posted (in most cases, almost immediately after they are entered), they move to the PM20000 table with the applications (payments, credit memos, etc applied to invoices) noted in the PM20100 table.
When the transactions are fully paid out and processed, they can move to the history tables where all of the invoices, payments, debit memos, credit memos, et cetera are stored in the PM30200 table and the application of documents to each other recorded in the PM30300 table.
Now if you only need Work, Open (posted but not fully paid), or History, you can simply use one pair of tables. If you need Work and Open (unpaid invoices still in play) you need to join the two tables holding documents and the two tables holding application records into two views and use the pair of views.
BTW...all of this is explained in our book Information Flow and Posting. Check it out on our web site. www.AccoladePubliatioins.com
Hi Ben,
If you havent already worked it out, to establish all invoices/ debits that are applied to WORK payments i would run:
If Computer Cheques
select vendorid,aptodcnm,aptvchnm,vchrnmbr as Payment from pm10200 where vchrnmbr in (
select pmntnmbr from pm10300 ) order by 1,4
If Manual Payments
select vendorid,aptodcnm,aptvchnm,vchrnmbr as Payment from pm10200 where vchrnmbr in (
select pmntnmbr from pm10400 ) order by 1,4
Hope that helps.
Mark
Hello,
You are right, Ben. Document 5 and 6 refers to saved Credit and Payment type of documents. The PM10200 table holds saved and posted payable documents that are not yet applied to an invoice(but not limited to).
There is another table that holds applied documents in GP. You may want to check the PM30300, I think. I may have to re-check my install first to confirm that as I am away from my GP install.
Should you need more info on this let me know and I will be happy to help. Another option for you is to call support +1 (888) 477-7877 in the United States or Canada.
Cheers,
Monette Vega-Laylo ( monette_vega@hotmail.com )
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (