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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

SOP Invoice -- show credit card number field for Amount Received

(1) ShareShare
ReportReport
Posted on by 17
customer receives credit card payment on some SOP Invoices.
i've been able to modify the SOP Invoice to add 'Amount Received' and calculate the new Document Amount.
customer would like to show the credit card number used to pay the amount received from customer
they don't need the entire card number --- just the xxxxxxxxxx5031 number stored in GP is adequate
 
how would i modify the SOP Invoice to add card number?
Categories:
  • Suggested answer
    Lisa at AonC.com Profile Picture
    1,178 Super User 2026 Season 1 on at
    Here is a link on how to mask a SSN.  I would think the Credit Card masking would be similar.

    Use Report Writer to create calculated field to mask the social security number - Dynamics GP | Microsoft Learn

    [You may need to do a conditional field if you first need to validate if it is a Credit Card versus a Check/cash payment.]
  • Suggested answer
    Devon Southall Profile Picture
    160 on at
    well -- normally you can add tables to the reports - but I can tell you that the SOP Invoice can't add the payment table to get this detail without major changes because the report already has a "many" table added.  (SOP Invoices can have multiple payments! and this document already has lines and serial/lot numbers)
     
    I don't believe that MS has programed a function to pull this data (like they have done for Tracking number for example)
     
    So your option is to use a custom function in Dexterity custom or Power Tools. #GPPT Speeding up Custom Report Writer Functions | Winthrop Development Consultants Blog
     
    hope this helps.  Feel free to ask clarifying questions... 
    Devon

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 284 Super User 2026 Season 2

#2
Aayush Tiwari Profile Picture

Aayush Tiwari 217

#3
Subra Profile Picture

Subra 200 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans