[Jackie Hodge]

??Recently we set up a new customer with the incorrect email address.  When we sent the invoice from GP, the email was kicked back due to the wrong email.  We fixed the email address in the customer card.  We attempted sending the Historical Invoice Document again via email through GP, however it sent to the “old/Incorrect” email address.

is it possible to change an address or email for a Historical Document in GP and resend it with the correct info through GP?  Or does changing the address and email info only work for invoices going forward (not yet posted) ?

Thanks for your help!

#Emailing Invoices  #Changing Address Info  #Email from GP directly 
????

——————————
Jackie Hodge
Motion Picture Association of America, Inc.
Sherman Oaks CA
——————————

[Jeff Pfershy]

Hi ,

We’re not using the emailing feature but you are correct – similar to other ‘address’ info on a sales document, the email address at the time is ‘stamped’ on the invoice record.

You can change the email address in SQL? – it’s stored in the SY04910 table and you’ll need to select the correct record based on the DOCTYPE, DOCNUMBR, Master_ID, and ADRSCODE. You also may need to include the field MODULE1 if a select query using the other fields doesn’t filter down to just the records you’re looking for.

This query is from our install of GP 2016 R2:

SELECT MODULE1
,DOCTYPE
,DOCNUMBR
,Master_ID
,ADRSCODE
,EmailMessageID
,EmailSubject
,EmailMessageFrom
,DEX_ROW_ID
,EmailToAddress
,EmailCcAddress
,EmailBccAddress
,EmailBody
,EmailReplyToAddress
FROM dbo.SY04910

Hope this helps,
Jeff

——————————
Jeff Pfershy
Sr Business Analyst
BluJay Solutions Inc
Holland MI
——————————
——————————————-

[Jackie Hodge]

thanks!  I just realized I submitted this post twice.?

I now know that it cannot be changed, in the system and emailed directly.  but going forward, if we have incorrect info, I can print a template and fix the template to show the correct address/email info.

thanks for your response!

——————————
Jackie Hodge
Motion Picture Association of America, Inc.
Sherman Oaks CA
——————————
——————————————-