Add a Column on a Transaction Saved Search to show the difference between Amount Debit and Amount Credit columns of GL Accounts on the Search Total

1.      Navigate to Reports > Saved Searches > All Saved Searches > New.

2.      Select Transaction as the Search Type.

3.      On the Criteria tab, enter a filter for Account and select the appropriate account.

4.      Add filter for Date.

5.      On the Results tab, tick the Show Totals box.

6.   Add a column field for Amount (Debit).

7.      Add a column field for Amount (Credit).

8.      Add a column field for Formula (Currency) and enter the following formula = nvl({debitamount},0)-nvl({creditamount},0)

9.      Enter an appropriate search title.

10.      Click Save & Run.