Client is on GP 2013. Needs to print the e-mail address from the Customer Maintenance Options window To field under Send E-mail Statements on the SOP Blank Invoice Form. Can someone please tell me how to achieve this. Thanks
*This post is locked for comments
You are most welcome Nasha
Please never hesitate to share any further inquiries,
Mahmoud, thank you so much for your quick response, confirmation and thorough answer. Nasha
Hello Nasha
In GP 2013, the e-mail address is stored in company database.SY01200 table, which will not be retrieved by the usual RW_GetInternetInfo function. Therefore, support article 874101 can no longer be useful. Here is the reply from Microsoft Support Article as illustrated on a previous thread:
Quoted below
"The email address in the internet information window in the To field is now found in the EmailToAddress feild in the Internet Addresses table (SY01200) on GP 2010. And since the RW_GetInternetInfo function will only pull from INET fields, we can no longer use the instructions in KB 874101 to add the customer email address on the SOP Blank Invoice from.
We cannot also add the email address found in the Customer Maintenance Options window (Cards >> Sales >> Customer >> Options button) which is stored in RM Statements E-mail Addresses (RM00106) and connect link to the report. And the only alternative we have left that I can think of is to use one of the User Defined fields to store the customer’s email address in the RM Customer MSTR (RM00101) and link it to the report.
There currently is no flag or table that indicates that the SOP invoice was emailed versus printed. However I believe that functionality was added in GP2013 because there is a icon indicated that it was emailed. "
>> Reference: How to add the "Email To Address" to the SOP Blank Invoice Form
In this essence, you could arrange with your clients to keep entering the e-mail address on the customer maintenance, while you could create a trigger on the back end to copy such details to the RM00101 (customer master) for some user defined field. The user defined field could easily be linked to the SOP Blank invoice later on.
Your feedback is highly appreciated,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (