Set Field BPM - "There are no records in the table"

,

@Banderson I ended up getting it done on a post BPM using Update Table by Query

Thanks for all of the help.

So you basically were just missing the header information that you needed to make the change, and so instead of pulling it directly from the TTHeader table, (since it wasn’t populated) you created a query to get the information you need and then changed the field. Is that right? And you were able to do that on GetNewPoDetail? Looks like I learned something new today!

Yes, since there was no header data, I used a query of the ttPOLine and joined it to the Db.POHeader and return the field I needed. I then just mapped the field I returned from the query to the field I needed it in on the Line.

First time that I have used that type of BPM setter. It worked really nice since I did not have to actually specify the right syntax, it was just do this query, return this field, and stick it here.