Versions Compared

Key

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

The Filter Accounts screen is used to configure accounts filter for the following rows.

  • Filter Accounts row
  • Current Year Earnings row
  • Retained Earnings
  • Cash Flow Activity row

The following steps will guide you on how to setup filter accounts.

  1. Click on the dropdown button in the Filter Accounts field of the Filter Accounts row.  
    Image Added
  2. The Filter Accounts screen will be opened. 
  3. In the Quick Filter grid configure the account filter by checking the box before it. Then click Apply button.
    Image Added

    There are different ways to configure filter accounts depending on your need. See below how the grid changes and how accounts can be configured depending on Type selected from Quick Filter grid > Type field.
    1. If ID is selected, Account IDs will be shown in the grid below it. Select the Account ID/s and click Apply button.
    2. If Description is selected, Account Descriptions will be shown in the grid below it. Select the Account Description/s and click Apply button.
    3. If Type is selected, Account Types will be shown in the grid below it. Select the Account Type/s and click Apply button.
    4. If Group is selected, Account Groups will be shown in the grid below it. Select the Account Group/s and click Apply button.
    5. If Primary Account is selected, Primary Accounts will be shown in the grid below it. Select the Primary Account/s and click Apply button.
    6. If Location is selected, Locations will be shown in the grid below it. Select the Location/s and click Apply button.

  4. The configured Account Filter will then be show in the Filters grid.
    Image Added

    or directly configure the account filter from Filters grid

    Image Added

  5. Click Save.
  6. Click Preview to open the Preview screen where Accounts that matched the filter configured will be shown.
    Image Added
  7. Click Close. Filter Accounts screen is closed. You will be back in the Row Designer screen, this time Filter Accounts field will show the account filter configured.
    Image Added


Expand
title18.3

The Filter Accounts screen is used to configure accounts filter for the following rows.

  • Filter Accounts row
  • Cash Flow Activity row

The following steps will guide you on how to setup filter accounts.

  1. Click on the dropdown button in the Filter Accounts field of the

...

  1. Filter Accounts row.  

...

  1. Image Added
  2. The Filter Accounts screen will be opened. 
  3. In the Quick Filter grid configure the account filter by checking the box before it. Then click Apply button.

...

  1. Image Added

    There are different ways to configure filter accounts depending on your need. See below how the grid changes and how accounts can be configured depending on Type selected from Quick Filter grid > Type field.
    1. If ID is selected, Account IDs will be shown in the grid below it. Select the Account ID/s and click Apply button.
    2. If Description is selected, Account Descriptions will be shown in the grid below it. Select the Account Description/s and click Apply button.
    3. If Type is selected, Account Types will be shown in the grid below it. Select the Account Type/s and click Apply button.
    4. If Group is selected, Account Groups will be shown in the grid below it. Select the Account Group/s and click Apply button.
    5. If Primary Account is selected, Primary Accounts will be shown in the grid below it. Select the Primary Account/s and click Apply button.
    6. If Location is selected, Locations will be shown in the grid below it. Select the Location/s and click Apply button.

  2. The configured Account Filter will then be show in the Filters grid.

...

  1. Image Added

    or directly configure the account filter from Filters grid

...

  1. Image Added

  2. Click Save.
  3. Click Preview to open the Preview screen where Accounts that matched the filter configured will be shown.

...

  1. Image Added
  2. Click Close. Filter Accounts screen is closed. You will be back in the Row Designer screen, this time Filter Accounts field will show the account filter configured.
    Image Added



Expand
title18.1

The Filter Accounts screen is used to configure accounts filter for the following rows.

  • Filter Accounts row
  • Cash Flow Activity row

The following steps will guide you on how to setup filter accounts.

  1. Click on the dropdown button in the Filter Accounts field of the Filter Accounts row.  
    Image Added
  2. The Filter Accounts screen will be opened. 
  3. In the Quick Filter grid configure the account filter by checking the box before it. Then click Apply button.
    Image Added

    There are different ways to configure filter accounts depending on your need. See below how the grid changes and how accounts can be configured depending on Type selected from Quick Filter grid > Type field.
    1. If ID is selected, Account IDs will be shown in the grid below it. Select the Account ID/s and click Apply button.
    2. If Description is selected, Account Descriptions will be shown in the grid below it. Select the Account Description/s and click Apply button.
    3. If Type is selected, Account Types will be shown in the grid below it. Select the Account Type/s and click Apply button.
    4. If Group is selected, Account Groups will be shown in the grid below it. Select the Account Group/s and click Apply button.
    5. If Primary Account is selected, Primary Accounts will be shown in the grid below it. Select the Primary Account/s and click Apply button.
    6. If Location is selected, Locations will be shown in the grid below it. Select the Location/s and click Apply button.

  4. The configured Account Filter will then be show in the Filters grid.
    Image Added

    or directly configure the account filter from Filters grid

    Image Added

  5. Click Save.
  6. Click Preview to open the Preview screen where Accounts that matched the filter configured will be shown.
    Image Added
  7. Click Close. Filter Accounts screen is closed. You will be back in the Row Designer screen, this time Filter Accounts field will show the account filter configured.
    Image Added
Expand
title17.1

The Filter Accounts screen is used to configure accounts filter for the following rows.

  • Filter Accounts row
  • Cash Flow Activity row

The following steps will guide you on how to setup filter accounts.

  1. Click on the dropdown button in the Filter Accounts field of the Filter Accounts row.  
    Image Added
  2. The Filter Accounts screen will be opened. 
  3. In the Quick Filter grid configure the account filter by checking the box before it. Then click Apply button.
    Image Added

    There are different ways to configure filter accounts depending on your need. See below how the grid changes and how accounts can be configured depending on Type selected from Quick Filter grid > Type field.
    1. If ID is selected, Account IDs will be shown in the grid below it. Select the Account ID/s and click Apply button.
    2. If Description is selected, Account Descriptions will be shown in the grid below it. Select the Account Description/s and click Apply button.
    3. If Type is selected, Account Types will be shown in the grid below it. Select the Account Type/s and click Apply button.
    4. If Group is selected, Account Groups will be shown in the grid below it. Select the Account Group/s and click Apply button.
    5. If Primary Account is selected, Primary Accounts will be shown in the grid below it. Select the Primary Account/s and click Apply button.
    6. If Location is selected, Locations will be shown in the grid below it. Select the Location/s and click Apply button.

  4. The configured Account Filter will then be show in the Filters grid.
    Image Added

    or directly configure the account filter from Filters grid

    Image Added

  5. Click Save.
  6. Click Preview to open the Preview screen where Accounts that matched the filter configured will be shown.
    Image Added
  7. Click Close. Filter Accounts screen is closed. You will be back in the Row Designer screen, this time Filter Accounts field will show the account filter configured.
    Image Modified
Expand
title15.3 and below

The Filter Accounts screen is used to configure accounts filter for Calculation or Hidden rows. The following steps will guide you on how to filter accounts.

  1. Select a type in the Type field.

    1. If ID is selected, Account IDs will be shown in the grid below it.
    2. If Description is selected, Account Descriptions will be shown in the grid below it.
    3. If Type is selected, Account Types will be shown in the grid below it.
    4. If Group is selected, Account Groups will be shown in the grid below it.
    5. If Primary Account is selected, Primary Accounts will be shown in the grid below it.
    6. If Location is selected, Locations will be shown in the grid below it.
      Example: Type is selected.
  2. Use the checkbox to define your account filter.
    Example:  You want the row to filter all accounts under Expense Type.
  3. Click Apply button. The Filters section will then be filled with Accounts configuration. 
  4. Repeat Steps 1 to 3 if you like to filter it even more. 
    Example: Add Cost of Goods Sold Group to the Filter. 
  5. Use the Filters section, to modify the Conditions. In this example, you will want to filter accounts under Expense Type and Account Group is not Cost of Goods Sold.
  6. Click Save toolbar button. Preview Accounts section will show all accounts that matched the accounts filter configured. 
  7. Click Close toolbar button. Filter Accounts screen is closed. You will be back in the Row Designer screen, this time Filter Accounts field will show the account filter configured.

...