Delete open payables transactions

(0) Share

Report

Posted on by arwinter

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

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
arwinter 120 on at

Like (0)

Report

Perfect thanks, I had checked a couple other sites that listed the tables, but the check links portion is what I was missing.

I ended up using the PM20000 and PM10100 to clear the transactions I wanted.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

I agree with Richard suggestion.

Deleting transaction from back-end is not a recommended solution. Better, you can void it from GP.

Was this reply helpful? Yes No