120
What tables hold open payables transactions? We had an issue with e-mail remittance failing, and the customer carried through with posting. Then to recreate the remittance they recreated the batch but did not post to GL. So now there is a large amount, 150, of open transactions that they want removed. They don't want to have to void them one by one. So essentially I'm looking for a way to safely remove the open transactions via a query. Thanks!
-Anthony
*This post is locked for comments
You need to look at the PM Key master table as well(PM00400) not to mention the PM distribution table(PM10100) and there are other PM10xxx tables. Voiding would have been a better choice. Back-end corrections so often lead to more serious problems.
Mr. Arwinter
I was doing a delete with an open payment, but it still appears in inquiry even after check link
with following statement
delete from pm20000
where TRXSORCE = 'PMPAY00000002'
and DOCTYPE = '6'
and VENDORID = '1270'
delete from pm10100
where TRXSORCE = 'PMPAY00000002'
and VENDORID = '1270'
are you delete it from other financial tables?
Thanks
I find the list Victoria (victoriayudin.com/gp-tables) has on her blog very helpful to find required tables.
All Payables tables will have header table and a line details tables, so you'll need to correct both tables. I normally run check links afterwards as well to ensure I did not miss anything.
You can also find a list of GP tables in the application under Tools>Resource Descriptions>Tables. Here you can view them buy series.
Share
Report
All responses (
Answers (
