Invoice Register with Total Quantity & Weight.

vikash

Hello everybody!

We have a Detailed Invoice register report where the total quantity and total weight for each item sold is given. The total weight is the last colum in the report and is calculated as follows:

Total weight = Quantity Sold * Unit Weight (In the item card)

We also have the total weight per invoice on the report.

Now we need to have the Grand Total Weight of all the invoices on the report. I believe this should be in the Sales Header Footer section of the report designer,but do not know how to proceed.

Please help.

Thanks in advance.

kriki

In case the total weight per invoice is the SAME field as the total weight per line, you can try to put it in the sales header footer of the report.

If this doesn't work, you need to create a new variable. And in the "OnAfterGetRecord" of the line, you add the total weight of the line to the new variable. This new variable you can put in the sales header footer of the report.