+4In IFS Cloud
Most customers have a valid email in Communication Method. Some don’t.
When printing Reminder, a report rule is set up to send the reminder by email to this customer. But for the other customer, how can i set up a report rule to print the reminder only for customer without email?
+2Hi Chota,
you can achieve this with a second report rule.
In both you can fetch the value of the communication methode with a select into the condition.
If the Condition = E-MAIL then you can proceed with the mail dispatch, if FALSE then you can use the print funtion of the report rule to override the selected printer.
For example this would be condition from us to get the value of the mail adress in the report rule:
[&SELECT cm.value FROM IFSAPP.comm_method cm JOIN IFSAPP.identity_pay_info ipi ON cm.Comm_ID = ipi.Comm_ID WHERE ipi.Party_TYPE_DB = 'CUSTOMER' AND ipi.CUSTOmer_ID = [@REMINDER_ITEMS_REM_REP/CUSTOMERS/CUSTOMER/IDENTITY] AND ipi.comm_ID IS NOT NULL AND ipi.COMPANY = [@REMINDER_ITEMS_REM_REP/COMPANY] AND cm.Customer_ID = [@REMINDER_ITEMS_REM_REP/CUSTOMERS/CUSTOMER/IDENTITY]]
Kind regards,
Thomas
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
