Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Follow the steps below to guide you on how to configure Total Calculation row and show row balances on Other columns, except Credit and Debit columns.

  1. Open row designer record.
  2. In that record, there should be Total Calculation row. Click Total Calculations toolbar button.
    Image RemovedImage Added
  3. Total Calculations screen will open. In that screen, check Show Others checkbox.
  4. In your column designer record, there should be Calculation, Column Calculation or other columns that are intended to show row balances. All of those columns, except Debit and Credit columns, will go with this setup. Here is the column designer record we will use for this illustration.
  5. Generate the report. You can generate report either way:
    1. Click Print toolbar button from Financial Reports screen. See How to Print Report .
    2. Click Generate toolbar button from Report Builder screen. See How to Print Generate Report .
  6. If Show Report Settings checkbox is checked in the Report builder for a specific report, then Report Settings will be shown. In that screen, click Print toolbar button.

This is how the report will look like with the above setup. Total is shown on rows that are intended to show balances, except for Debit and Credit Columncolumns, along with underscore and double-underscore preceding or following it.

Image RemovedImage Added

See How to Configure Total Calculation row to show on Credit and Debit columns for help on how Show Credit and Show Debit work.