*This post is locked for comments
Sorry that was my first post. After emailing and posting a sales invoice. It appears that we do not have the ability to change the email address that it was sent to. This presents a problem when the invoice was sent to an incorrect email address. Is there an option that would allow me to edit email addresses on a historical invoice?
I came across this same issue. Seems like bad design to me. I can understand locking in the address against an invoice, but locking in an email address doesn't seem necessary.
Anyway, I have created a work around. It is a nightly SQL Server scheduled Job to update the inovice email addresses from the customer email addresses. Below is the script.
Regards
Konrad
-- Update SOP Invoice Email Addresses from Debtor Email Addresses
update i
set i.EmailToAddress = c.EmailToAddress, i.EmailCCAddress = c.EmailCCAddress
--select
-- i.Master_ID, i.ADRSCODE, i.EmailToAddress, i.EmailCCAddress, c.EmailToAddress, c.EmailCCAddress
from
SY04910 i
inner join
SY01200 c on i.Master_ID = c.Master_ID and i.ADRSCODE = c.ADRSCODE and i.Module1 = 11 and c.Master_Type = 'CUS'
where
(cast(i.EmailToAddress as varchar(100)) <> cast(c.EmailToAddress as varchar(100)))
or (cast(i.EmailCCAddress as varchar(100)) <> cast(c.EmailCCAddress as varchar(100)))
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
