Updateable BAQ with UNION


I have a BAQ which is pretty much a UNION of the Sales Order and the Transfer Order tables. I would like to be able to update the Required Date for either the SO or the Xfer from the same BAQ. How do I go about it? If I setup the BAQ to be updateable it seems that I can only update the OrderHed table.

Thank you,


You need to use Advanced BPM and code it for yourself.

Fortunately that isn’t quite as big a task as it sounds, because you can cheat by using the code Epicor creates for you. If you create a standard BAQ for each table singly, you can copy the code from those into a new blank Custom Code widget in your Union BAQ with Advanced BPM Update.

Here’s another thread where similar is discussed: