We have a manual payment in GP 2013 that appears to be hung up. ,datediff(dd, coalesce(ph.DOCDATE, p.DOCDATE) Note that if you are using the POP module this will still return nulls for the dates from invoices posted in POP and not PM. I didn’t see this before replying to the previous message – try this, I changed your code around a bit and my SQL editor makes all the special words lower case. 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 kommentar(er)
