6,775
Is there a way to mass update the email statements checkbox in the customer card options window? The field is not available in Integration Manager so I'm guessing an update statement would be needed. Or maybe a VB Script in Integration Manager?
*This post is locked for comments
If you would like to script integration using e Connect then here is one example you can use...
www.sanjaykumar.us/.../econnect-customer-address-internet-info
Cheers
TSQL -
UPDATE [dbo].[RM00101]
SET [Send_Email_Statements] = 'VALUE'
WHERE [CUSTNMBR] = 'CUSTOMERID'
--
--0=Do not sent statements;
--1=Send statements
PS - Use with caution - Back up the company database before you update
Cheers!
Sanjay
use the e Connect destination of integration manager.
Cheers!
Sanjay
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (