Credit Card Information that is kept in the Sales Card File

(0) Share

Report

Posted on by Community Member

We are using Dynamics GP 2010. My question concerns credit card information that is stored in Cards/Sales/Customer (options screen Credit Card # field). We have many credit card #'s in this field and we no longer want to keep this info on file. Is there an easy way that we might be able to wipe out all of this information in all of our customer cards at one time.....for example maybe a script could be run to replace all the information with XXXX's or 99999's?

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

RE: Credit Card Information that is kept in the Sales Card File

Thank you so very much - exactly what I needed!!!

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,615 Super User 2025 Season 2 on at

Like (1)

Report

RE: Credit Card Information that is kept in the Sales Card File

Here's the SQL script necessary to clear the values in this field. Make sure you backup the database before executing.

Update RM00101 Set CRCRDNUM = 'XXXXX'

'XXXXX' = whatever value you want to fill with. Or just '' if you want the field to be blank.

Was this reply helpful? Yes No