I am fairly new to BPMs and I am in the process of trying to create one to auto populate the comment section of our POs with information pulled from the ShipVia and OrderHed tables. I read some of the topics in here and tried implementing what I read but so far nothing is working.
My Condition is for the Drop Ship check box in the Releases/Detail section to be checked:
I don’t know for sure… but I don’t believe you can update the release and the header in the same call. So I believe it’s going to end up being more complicated than just filling in the field.
You’ll need to see what rows you have to work with. Once you get the messages firing, add in the row or fields into the message box to see what rows you have. I suspect you are only going to have the release rows.
Also, this will replace the comment. So if the user entered something, it will be overwritten by this directive. You’d have to append to the existing comment and add some logic to ensure it’s not added multiple times.
In the message, in the body you can right click and do field, or row queries. Add that into the message and see what rows are populated in the BPM. I suspect there isn’t a header row.
Do you really need to update the PO comment or do you just need to reference something the lives on another table when you print the PO form PDF? Altering a Report Data Definition, and then flowing that down the SSRS template is usually less of a headache than monkeying with something like this.
It’s a relational database, use it to alias data rather than duplicating it.
