WHERE TRXDATE BETWEEN AND GL105.ACTNUMBR_3 = ‘2000’ LEFT JOIN RV_GP.dbo.PM30200 PM ON GL20000.ORDOCNUM = PM.DOCNUMBR AND GL20000.ORMSTRID = PM.VENDORID When I query from PM30200, I’m getting blank records for invoices that are open/unpaid. Question: Is there a single table that has the Document Date for invoices regardless of whether it has been paid? PM20000 is for open documents and PM30200 is for paid documents.Īsking because I’m trying to measure the $ of invoices that hit our GL each month that are from the prior month. MC020103 – Multicurrency Payables Transactionsħ – Scheduled Payment (thanks to Dennis Sisnarine for this)ġ0 – transaction being entered for the first time before it has been saved by the userģ0 – transaction that is currently posting (realtime)ĥ0 – transaction that has encountered an error during postingĦ0 – transaction that has been saved previously and had a status of 20 and is now being edited by a userħ0 – transaction that has been posted previously in a recurring batch that still contains unposted transactions is now being edited by the userģ – Unposted PM80100 – Batch Headers (includes approval information) PM30600 – GL Distributions for Historical Transactions PM10100 – GL Distributions for Work and Open Transactions PM00204 – 1099 Period Detail (only in GP 10.0 and higher)
0 Comments
Leave a Reply. |