Adding Gross & Net Totals in Cost Report Templates

This article covers the process of adding Gross and Net totals to Cost Report Templates in Eclipse as requested by some users.

In the Eclipse interface, under Control Table, select Report Layout Manager.
Select the report that needs to be edited under GL Financial Reports.
Select Copy Layout and rename it as close to the original name but with the addition of Gross at the end to differentiate it from the original.
Select the newly named layout and click on Change.
From the popup menu, select Layout Designer located at the bottom right.
In the Layout Designer interface, double click on Other.SequenceSubTotal found on the table image.
Click on the drop-down menu and select an empty line (line 4 by default).
From the popup menu, select Group Footer, click on the drop-down menu and select line 3 and click OK.
Change the name of line 3 to Sequence Total by click on it on drop-down menu and overwriting it.
Do the same for line 4 and rename it to Gross Total instead.
Under Gross Total, double click the line OTHER.SequenceSubTotal and rename it to OTHER.SubTotalDesc in the text box below.
Do the same for the lines below OTHER.SubTotalDesc, changing it from Fstr$(@Seqxxx to Fstr$(@Subxxx for all of them.
Go back to OTHER.SubTotalDesc and change the font size by clicking on the “+” icon next to font and change the font size from 7 to 9.
Click on Options and ensure all fields are unticked and click OK.
Under Change Cond., enter OTHER.Subtotal in the textbox.
Under Appearance Cond., enter OTHER.Subtotal = 'Y' in the textbox.
Doubleclick on REPORT TOTAL in the table and rename it to NET TOTAL.
Following step 13, change the font size for NET TOTAL to size 9.
Click save and exit the window.
Go back to General Ledger > Financial Reports.
Select the new report layout that was just created from the drop-down menu.
Select Summary Report and click save.
Finally, click ok to run the report.