Method Community

I'm trying to do some basic multiplication of columns in InvoiceLine. I created columns for "pieces", "package net", and "ext net". I'm trying to achieve "pieces" x "package net" = "ext net" where I fill in "pieces" and "package net" manually to automatically calculate "ext net."

Here are the steps I've taken so far:

From Grid Wizard step 5, added a basic math calculation. (Value from screen: invoicelineitems: pieces) X (Value from screen: invoicelineitems: Pkg Net). Action result named resultExtNet

Then I add another action Enter Value Into Field On Screen. This might be where I'm going wrong.
Update Field or Object: Ext Net Subtotal
With the value: Action Result, resultExtNet.

What am I missing/doing incorrectly? I'd like to be able to go down my item list and fill in pieces and package net for each item, and then hit "update" for the calculations to be made automatically for all my items.

Thanks,
Andy

Hi Andy,

With grids things can get a bit tricky sometimes. You will have to update the Ext Net field on the InvoiceLine table for each record in the grid and not actually enter the values onto the grid. Essentially you would loop through each value in the grid and update the Ext Net field in the InvoiceLine table.

-Michael