Calculated field for Sum(),Group by

Epicor ERP 10
1

Good day,

I want to add a calculated field for total received Qty against the job in multiple receipts. So i tried Sum() function in calculated field, but i got following error.

2017-08-17_0918.png690×578 21.4 KB

I am new to the SubQueries…I just want to know ,if there are 7 tables in my 1st subquery(main BAQ), do i need to add all those 7 tables ? also how i call add Sum() function to rcvdtl.passedqty and where it will be ? In subquery1 or newly added subquery2 ?

Any help will be greatly appreciated.
Thanks

2

That group by should not be there. It’s a checkbox in display fields.

3 Likes