I am building a BPM that will send out an email to our purchasing agent whenever a requisition is made. I am trying to link the PurAgent table and the PartClass table so that I can pull in the email for our purchasing agent. the error I’m running into says that the partclass table does not have a BuyerID.
OH! Okay, so I think I get what you mean. In this case I want to run the ReqDetail Class against the Part class and get the buyerID that way. Then run the BuyerID against the the PurAgent Table BuyerID to get the buyer Email. With that logic in mind, how do I specify the curent ReqNum and ReqLine from the ReqDetail table?
Right now we only want the BPM to trigger if the Req is dispatched. And yes that is the field I am now using for some of the logic. Thanks for the help thus far!
Notify Dispatcher and Requester of updates: Data Directive on ReqLog Table. Create Variables to Store To & From values and get the values via C# Expression based on thier User ID.
When a Req goes to purchasing it immediately creates a PO Suggestion Record in the SugPoDtl table (New PO Suggestions) and it already determines the BuyerID in that process. So you can create a Data Directive on SugPoDtl with a condition where there is a new record and ReqNum > 0 then use a C# Expression based on the BuyerID to get their email address from the PurAgent table.
I’ve been trying that and have been met with two results. Firstly, if I use pre-processing it will lock me out of entering new lines on the Req entry screen. Secondly, if I use post-processing it won’t do anything. The condition I’m using is Req Head Status Type and set it to be equal to “P” for pending. Would you mind sharing what condition you’re using?
@Rick_Bird,
I’m going to have a crack at that in the morning. Thanks for the help!