trying to move extensive code in a UI Customization to an Epicor Function Library
The UI code takes the dataset from the BomSearch BO and multiplies the MtlPartNum and the Parent QtyPer fields (parent qty = 4 per and MtlPartNum QtyPer = 16 so that means we really need 64 of the component) - Then it groups the MtlPartNums together and sums the QtyPer and writes the data to a UD table for further reporting
my problem is the Grouping and Summing - these are not options in the widget fill by query or update by query
Anyone have some nice custom code to take the items in the BomSearch.PartMtl, extend the QtyPer, then Group and Sum and send to UD tableset for updating the UD table?