BPM - how to access table not in expression builder

Kinetic ERP
1

We send a notification when an sales order is manually closed. I have a pre-processing directive on SalesOrder.CloseOrder that sends the email.

I have been asked to add contents of the Memo. I figured I would use either a BPM data field or a variable to hold the contents before popping them into the email message.

However, Memo is not one of the tables available in the Expression Builder to populate the BPM data field or the variable.

Is there a way to access a table (BO?) that is not already included?

I can do a separate BPM to send a separate email after it has been updated, but the users really don’t want double emails.

Thanks.

2

You should only need add Ice.Contracts.BO.Memo to your references & usings to provide availablity to the data needed {EDIT:} and the appropriate LINQ query to pull the memo data associated with the SO.

1 Like