Transaction Type SQL UPDATE

(1) Share

Report

Posted on by Napolo

750

I have approx 54 transactions that were imported into the bank as CHK type. Is there an easy way to update the transaction type from CHK to Withdrawal?

I tried this update, but it doesn't appear to change in the bank reconciliation window. I am assuming I am missing a few tables?

UPDATE dbo.CM20200

SET CMTrxType = 4

WHERE CHEKBKID = '53 BANK_TPA' and DEX_ROW_ID = 14133

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

L Vail 65,271 on at

Like (1)

Report

RE: Transaction Type SQL UPDATE

Hi Nicole,

If you change it in the CM20100, it will show up on your bank rec as a withdrawal.

Kind regards,

Leslie
Napolo 750 on at

Like (0)

Report

RE: Transaction Type SQL UPDATE

Thank you! I had searched, but I think I was using the wrong verbiage.

This is what i found.

SELECT

TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH

FROM INFORMATION_SCHEMA.COLUMNS

WHERE COLUMN_NAME like '%CMTRXType%'

ORDER BY COLUMN_NAME, TABLE_NAME

Thanks again.
Suggested answer

Bron 4,887 on at

Like (0)

Report

RE: Transaction Type SQL UPDATE

Nicole - There's a SQL script available (just google) that will search Table columns and return all the tables that have the column you want to update (CMTrxType). Couple of caveats - on rare occasions, GP does store data elements as two different columns and of course - always do your SQL work in a TEST environment first. After running your update script best practice would be to run check links as well.....

Good Luck let us know how this turns out.......