web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... SOP Invoice -- show cr...

Finance | Project Operations, Human Resources, ...

Suggested Answer

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

(1) Share

Report

Report

Posted on by kwj3

11

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:

Microsoft Dynamics GP

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Lisa at AonC.com 923 Super User 2025 Season 2 on at

Like (0)

Report

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.]

Was this reply helpful? Yes No
Suggested answer

Devon Southall 160 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

Martin Dráb 664 Most Valuable Professional

#2

André Arnaud de Cal... 522 Super User 2025 Season 2

#3

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans