Return sum of values from a BAQ

[LBARKER (Lawson Barker)]

Hello,
What I’m trying to do is:
Get the sum of values of all Sales Order related to a Project and display the Total value in a field in the Project Entry screen.
Some of our Projects have more than one Sales Order
In our Sales Orders we have a UD field with the Project number in it
I can get the values of each Sales Order to show in a BAQ that is related to a Project
What I’m having trouble with is how to get the sum of the values to the Project Entry Screen

[ckrusen (Calvin Krusen)]

Make a second BAQ that returns:

• Sum(OrderHed.OrderTotal)
• ProjectNum (grouped by)

[jorel (Jakob Orel)]

Once you get the value you would like in a BAQ you can display it to a field on the Project Entry screen by using a BAQDataView.

BAQ Dataview Example Video

Here’s an example video of how to do a BAQ dataview. BAQ Dataviews are a great way to view related data onto a screen in Epicor. If you can link the data on the screen to the data you want to display in a BAQ you can display it. They are faster and more flexible than FKVs or embedded dashboards. [Epicor BAQ DataView] and the code. public void CreateOrderLineOnHandBAQDV() { orderLineOnHandBAQDV = new BAQDataView("OrderLineOnHand"); oTrans.Add("OrderLineOnHandBAQDV",orderL…

[LBARKER (Lawson Barker)]

Thanks, with a combination of what @ckrusen and @jorel said, I’ve got my field displaying correctly,
The next thing I need to do is pass that value to the " Total Contract Value" field
Has anyone got pointers on that??