Add code :
qbsSum.addGroupByField(fieldNum(InventSum,InventDimId));
in the “modifyQuery” method on the “InventDimCtrl_Frm_OnHand” class
Example code
query.clearGroupBy(); qbsSum.addGroupByField(fieldNum(InventSum,ItemId)); qbsSum.addGroupByField(fieldNum(InventSum,InventDimId));
Result:
