Method Community

Hello, I've added a column in InvoiceLine details for "weight". In the invoice screen I've also added a field for "Weight Subtotal". I'd like this "Weight Subtotal" field to function similarly to the way "Subtotal" works for the column "Amount" (automatically adding up my newly created column for "weight"). Please advise on how to edit this field.

Thanks,

Andy

Hi Andy,

You'll want to add a couple of actions to the the 'Actions after add' and 'Actions after edit' (Steps 6 & 7 of the grid wizard). The actions you will want to use are:

Get sum (from the Weight column of the InvoiceLine grid)

Enter value into field on screen (to enter the sum into the weight subtotal field you added).

Hope that helps!