web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Credit Card Informatio...
Microsoft Dynamics GP (Archived)

Credit Card Information that is kept in the Sales Card File

(0) ShareShare
ReportReport
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)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    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.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans