SP_TransactionNotification to send an email

[macdonald_ngowi]

Hi guys,

I'm looking for a way to send an email directly from transaction notification when an invoice is added. I think this is the best effective way of handling this process as TNs work at user actions, Add, Update, Close, Cancel.

So a way to send an email notification to given users when an invoice is added through SP_TransactionNotification stored procedure, is this even possible? If not, what is the alternative?

Thanks in advance

[agustin_marcoscividanes · Accepted solution]

Hi

you can use the sp_send_dbmail stored procedure.

Check this documentation.

Kind regards

Agustín

[agustin_marcoscividanes · Accepted solution]

Hi

check this tutorial.

Kind regards

Agustín

[kothandaraman_nagarajan]

Hi,

Try with standard function from B1 under Print Preference -Per Document-->AR Invoice-->When adding document--> Email Document.

Regards,

Nagarajan