Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
When Full Account ID checkbox is checked and you generate rows, what it does is, it generate rows per account id.
Follow the steps below on how to generate rows by Full Account ID.
  1. Check Full Account ID checkbox.
    Image Added
  2. In the grid area, configure rows to generate. In this example, let's use Type. Use the ConditionCriteria and Criteria Between fields to configure account type/s. The accounts under the account type/s configured will be generated.
    Image Added

  3. Use the Description field if you would like to overwrite the Account Description with another value . If you opted to do that, any value entered on this field will be shown on all rows generated. Else, leave it blank.

  4. Click Ok toolbar button.
    Image Added
  5. This message is shown. Click OK button to bring you back to the Row Designer screen.
    Image Added
  6. In the Row Designer screen, each row created will have have the following information.
    1. Row Type to show Filter Accounts.

    2. Row Name to show the Account ID and Description.

    3. Balance Side to show the account's normal balance side. Debit if account is an Asset or Expense type and Credit if account is a Liability, Equity or Revenue type.

    4. Filter Accounts to show by ID
    5. Source to show Column.

    6. Account Type to show BS if account is a Balance Sheet account or IS if account is Income Statement account.
    Image Added

Here are illustrations when different Account options are selected to configure rows to generate.

Expand
titleID is selected in Account field

 Image Added

Here's how it will look like when generated. Account matching the selected Account ID will be generated.

Image Added
Expand
titleDescription is selected in Type field

Image Added

Here's how it will look like when generated. Accounts that matched the account description will be generated.

Image Added
Expand
titleGroup is selected in Account field

Image Added

Here's how it will look like when generated. All accounts under the selected Group/s will be generated.

Image Added
Expand
titlePrimary Account is selected in Account field

Image Added

Here's how it will look like when generated. All accounts that matched the Primary account/s selected will be generated.

Image Added

Expand
titleLocation is selected in Account field

Image Added

Here's how it will look like when generated. All accounts created for the selected location will be generated.

Image Added
Expand
titleLOB is selected in Account field

Image Added

Here's how it will look like when generated. All accounts created for the selected location will be generated.

Image Added



Expand
title18.3

When Full Account ID checkbox is checked and you generate rows, what it does is, it generate rows per account id.
Follow the steps below on how to generate rows by Full Account ID.

  1. Check Full Account ID checkbox.
    Image Added
  2. In the grid area, configure rows to generate. In this example, let's use Type. Use the ConditionCriteria and Criteria Between fields to configure account type/s. The accounts under the account type/s configured will be generated.
    Image Added

  3. Use the Description field if you would like to overwrite the Account Description with another value . If you opted to do that, any value entered on this field will be shown on all rows generated. Else, leave it blank.

  4. Click Ok toolbar button.
    Image Added
  5. This message is shown. Click OK button to bring you back to the Row Designer screen.
    Image Added
  6. In the Row Designer screen, each row created will have have the following information.
    1. Row Type to show Filter Accounts.

    2. Row Name to show the Account ID and Description.

    3. Balance Side to show the account's normal balance side. Debit if account is an Asset or Expense type and Credit if account is a Liability, Equity or Revenue type.

    4. Filter Accounts to show by ID
    5. Source to show Column.

    6. Account Type to show BS if account is a Balance Sheet account or IS if account is Income Statement account.
    Image Added

Here are illustrations when different Account options are selected to configure rows to generate.

Expand
titleID is selected in Account field

 Image Added

Here's how it will look like when generated. Account matching the selected Account ID will be generated.

Expand
titleDescription is selected in Type field

Image Added

Here's how it will look like when generated. Accounts that matched the account description will be generated.

Expand
titleGroup is selected in Account field

Image Added

Here's how it will look like when generated. All accounts under the selected Group/s will be generated.

Expand
titlePrimary Account is selected in Account field

Image Added

Here's how it will look like when generated. All accounts that matched the Primary account/s selected will be generated.

Image Added

Expand
titleLocation is selected in Account field

Image Added

Here's how it will look like when generated. All accounts created for the selected location will be generated.

Expand
titleLOB is selected in Account field

Image Added

Here's how it will look like when generated. All accounts created for the selected location will be generated.



Expand
title18.1
When Full Account ID checkbox is

...

checked and you generate rows, what it does is, it generate rows per account id.
Follow the steps below on how to generate rows by Full Account

...

ID.

...

  1. Check Full Account

...

  1. ID checkbox.

...

  1. Image Added
  2. In the grid area, configure rows to generate

...

  1. . In this example, let's use Type. Use the ConditionCriteria and Criteria Between fields to configure account type/s. The accounts under the account type/s configured will be generated.
    Image Added

  2. Use the Description field if you would like to overwrite the Account Description with another value . If you opted to do that, any value entered on this field will be shown on all rows generated. Else, leave it blank.

  3. Click Ok toolbar button.
    Image Added
  4. This message is shown. Click OK button to bring you back to the Row Designer screen.
    Image Added
  5. In the Row Designer screen, each row created will have have the following information.
    1. Row Type to show Filter Accounts.

    2. Row Name to show the Account ID and Description.

    3. Balance Side to show the account's normal balance side. Debit if account is an Asset or Expense type and Credit if account is a Liability, Equity or Revenue type.

    4. Filter Accounts to show by ID
    5. Source to show Column.

    6. Account Type to show BS if account is a Balance Sheet account or IS if account is Income Statement account.
    Image Added

Here are illustrations when different Account options are selected to configure rows to generate.

Expand
titleID is selected in Account field

 Image Added

Here's how it will look like when generated. Account matching the selected Account ID will be generated.

Image Added
Expand
titleDescription is selected in Type field

Image Added

Here's how it will look like when generated. Accounts that matched the account description will be generated.

Image Added
Expand
titleGroup is selected in Account field

Image Added

Here's how it will look like when generated. All accounts under the selected Group/s will be generated.

Image Added
Expand
titlePrimary Account is selected in Account field

Image Added

Here's how it will look like when generated. All accounts that matched the Primary account/s selected will be generated.

Image Added

Expand
titleLocation is selected in Account field

Image Added

Here's how it will look like when generated. All accounts created for the selected location will be generated.

Image Added
Expand
titleLOB is selected in Account field

Image Added

Here's how it will look like when generated. All accounts created for the selected location will be generated.

Image Added
Expand
title16.1
When Full Account ID checkbox is checked and you generate rows, what it does is, it generate rows per account id.
Follow the steps below on how to generate rows by Full Account ID.
  1. Check Full Account ID checkbox.
    Image Added
  2. In the grid area, configure rows to generate. In this example, let's use Type. Use the ConditionCriteria and Criteria Between fields to configure account type/s. The accounts under the account type/s configured will be generated.
    Image Added

  3. Use the Description field if you would like to overwrite the Account Description with another value . If you opted to do that, any value entered on this field will be shown on all rows generated. Else, leave it blank.

  4. Click Ok toolbar button.
    Image Added
  5. This message is shown. Click OK button to bring you back to the Row Designer screen.
    Image Added
  6. In the Row Designer screen, each row created will have have the following information.
    1. Row Type to show Filter Accounts.

    2. Row Name to show the Account ID and Description.

    3. Balance Side to show the account's normal balance side. Debit if account is an Asset or Expense type and Credit if account is a Liability, Equity or Revenue type.

    4. Filter Accounts to show by ID
    5. Source to show Column.

    6. Account Type to show BS if account is a Balance Sheet account or IS if account is Income Statement account.
    Image Added

Here are illustrations when different Account options are selected to configure rows to generate.

Expand
titleID is selected in Account field

 Image Added

Here's how it will look like when generated. Account matching the selected Account ID will be generated.

Image Added
Expand
titleDescription is selected in Type field

Image Added

Here's how it will look like when generated. Accounts that matched the account description will be generated.

Image Added
Expand
titleGroup is selected in Account field

Image Added

Here's how it will look like when generated. All accounts under the selected Group/s will be generated.

Image Added
Expand
titlePrimary Account is selected in Account field

Image Added

Here's how it will look like when generated. All accounts that matched the Primary account/s selected will be generated.

Image Added

Expand
titleLocation is selected in Account field

Image Added

Here's how it will look like when generated. All accounts created for the selected location will be generated.

Image Added
  1. How to Generate row using Account Type
Expand
title15.3 and below
When Full Account Id checkbox is checked and you generate rows, what it does is, it generate rows per account id.
Follow the steps below on how to generate rows by Full Account Id.
  1. Check Full Account Id checkbox.
    Image Added
  2. In the grid area, configure rows to generate. 

  1. Click Ok toolbar button.
    Image Modified
  2. This message is shown. Click OK button to bring you back to the Row Designer screen.
    Image Modified
  3. In the Row Designer screen, each row created will have an account filter by Account Id. Also, the Description field will show the Account ID and its Description.
    Image Modified

Here are illustrations when different Account options are selected to configure rows to generate.

Expand
titleID is selected in Account field

Image Added

Here's how it will look like when generated. Account matching the selected Account ID will be generated.

Image Added

Expand
titleDescription is selected in Account field

Image Added

Here's how it will look like when generated. Account matching the selected descriptions will be generated.

Image Added
Expand
titleGroup is selected in Account field

Image Added

Here's how it will look like when generated. All accounts under the selected Group/s will be generated.

Image Added
Expand
titlePrimary Account is selected in Account field

Image Added

Here's how it will look like when generated. All accounts with matched Primary account/s will be generated.

Image Added

Expand
titleLocation is selected in Account field

Image Added

Here's how it will look like when generated. All accounts created for the selected location will be generated.

Image Added