Updateable BAQ with UNION

[danielc0877 (Daniel Cardoso)]

Hi,

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,

Daniel

[dhewi (Daryl Hewison)]

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:

Update multiple tables with advanced BPM update

Here’s a butchered bit of an Advanced BPM Update in case it helps (I’ve taken out a load of stuff that isn’t relevant except to our particular requirements). As you can see, except for having two SvcContracts in one it isn’t very different from the AutoGenerated code. You just need to sift the ttResults data for the bits you need for each update, assemble each UpdateExt tableset, and do both updates. try { Erp.Contracts.PriceLstSvcContract hPriceLst = Ice.Assemblies.ServiceRenderer.GetService<…

[danielc0877 (Daniel Cardoso)]

Yes, I came to the same conclusion. Thank you for your sample code, even “butchered”, it is useful.

Thank you,

Daniel