When Primary Segment checkbox is checked and you generate rows, what it does is, it generate rows per primary account.
Follow the steps below on how to generate rows by Primary Account.
- Check Primary Segment checkbox.
![](/download/attachments/18415676/image2016-1-22%2014%3A49%3A52.png?version=1&modificationDate=1453445568987&api=v2&effects=border-simple,shadow-kn)
In the grid area, configure rows to generate. In this example, let's use Type. Use the Condition, Criteria and Criteria Between fields to configure account type/s. The primary accounts under the account type/s configured will be generated.
![](/download/attachments/18415676/image2018-3-22%2016%3A19%3A48.png?version=1&modificationDate=1521706786007&api=v2&effects=border-simple,shadow-kn)
- 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.
- Click Ok toolbar button.
![](/download/attachments/18415676/image2018-3-22%2016%3A20%3A44.png?version=1&modificationDate=1521706841620&api=v2&effects=border-simple,shadow-kn)
- This message is shown. Click OK button to bring you back to the Row Designer screen.
Image Removed
- In the Row Designer screen, each row created will have have the following information.
Row Type to show Filter Accounts.
Row Name to show the Primary Account ID and Description.
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.
- Filter Accounts to show by Primary Account.
Source to show Column.
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 |
---|
title | ID is selected in Type field |
---|
|
Image Added
Here's how it will look like when generated. Primary Account matching the selected Account ID will be generated. Image Added |
Expand |
---|
title | Group is selected in Type field |
---|
|
Image Added
Here's how it will look like when generated. All primary account under the selected Group/s will be generated. Image Added |
Expand |
---|
title | Primary Account is selected in Type field |
---|
|
Image Added
Here's how it will look like when generated. Primary Account that matched the Primary account/s selected will be generated. Image Added
|
Expand |
---|
title | Location is selected in Type field |
---|
|
Image Added
Here's how it will look like when generated. All Primary Accounts created for the selected location will be generated. Image Added |
Expand |
---|
title | Description is selected in Type field |
---|
|
Image Added
Here's how it will look like when generated. Primary Account that matched the selected account description will be generated. Image Added |
Expand |
---|
|
When Primary Segment checkbox is checked and you generate rows, what it does is, it generate rows per primary account. Follow the steps below on how to generate rows by Primary Account. - Check Primary Segment checkbox.
Image Added In the grid area, configure rows to generate. In this example, let's use Type. Use the Condition, Criteria and Criteria Between fields to configure account type/s. The primary accounts under the account type/s configured will be generated.
Image Added - 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.
- Click Ok toolbar button.
Image Added - This message is shown. Click OK button to bring you back to the Row Designer screen.
- In the Row Designer screen, each row created will have have the following information.
Row Type to show Filter Accounts. Row Name to show the Primary Account ID and Description. 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. - Filter Accounts to show by Primary Account.
Source to show Column. Account Type to show BS if account is a Balance Sheet account or IS if account is Income Statement account. Image Modified
Here are illustrations when different Account options are selected to configure rows to generate. Expand |
---|
title | ID is selected in Type field |
---|
| Image Modified
Here's how it will look like when generated. Primary Account matching the selected Account ID will be generated. Image Modified |
Expand |
---|
title | Group is selected in Type field |
---|
| Image Modified
Here's how it will look like when generated. All primary account under the selected Group/s will be generated. Image Modified |
Expand |
---|
title | Primary Account is selected in Type field |
---|
| Image Modified
Here's how it will look like when generated. Primary Account that matched the Primary account/s selected will be generated. Image Modified
|
Expand |
---|
title | Location is selected in Type field |
---|
| Image Modified
Here's how it will look like when generated. All Primary Accounts created for the selected location will be generated. Image Modified |
Expand |
---|
title | Description is selected in Type field |
---|
| Image Modified
Here's how it will look like when generated. Primary Account that matched the selected account description will be generated. Image Modified |
|
Expand |
---|
|
When Primary Segment checkbox is checked and you generate rows, what it does is, it generate rows per primary account. Follow the steps below on how to generate rows by Primary Account. - Check Primary Segment checkbox.
![](/download/attachments/18415676/image2016-1-22%2014%3A49%3A52.png?version=1&modificationDate=1453445568987&api=v2&effects=border-simple,shadow-kn) In the grid area, configure rows to generate. In this example, let's use Type. Use the Condition, Criteria and Criteria Between fields to configure account type/s. The primary accounts under the account type/s configured will be generated.
![image2016-1-22 13:59:47.png](/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=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.
- Click Ok toolbar button.
![](/download/attachments/18415676/image2016-1-22%2014%3A52%3A0.png?version=1&modificationDate=1453445696327&api=v2&effects=border-simple,shadow-kn) - This message is shown. Click OK button to bring you back to the Row Designer screen.
![image2016-1-22 14:6:54.png](/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2) - In the Row Designer screen, each row created will have have the following information.
Row Type to show Filter Accounts. Row Name to show the Primary Account ID and Description. 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. - Filter Accounts to show by Primary Account.
Source to show Column. Account Type to show BS if account is a Balance Sheet account or IS if account is Income Statement account.
![](/download/attachments/18415676/image2016-1-22%2015%3A26%3A43.png?version=1&modificationDate=1453447779960&api=v2&effects=border-simple,shadow-kn)
Here are illustrations when different Account options are selected to configure rows to generate. Expand |
---|
title | ID is selected in Type field |
---|
| ![](/download/attachments/18415676/image2016-1-22%2014%3A56%3A56.png?version=1&modificationDate=1453445992573&api=v2&effects=border-simple,shadow-kn)
Here's how it will look like when generated. Primary Account matching the selected Account ID will be generated. |
Expand |
---|
title | Group is selected in Type field |
---|
| ![](/download/attachments/18415676/image2016-1-22%2015%3A4%3A37.png?version=1&modificationDate=1453446453693&api=v2&effects=border-simple,shadow-kn)
Here's how it will look like when generated. All primary account under the selected Group/s will be generated. |
Expand |
---|
title | Primary Account is selected in Type field |
---|
| ![](/download/attachments/18415676/image2016-1-22%2015%3A7%3A23.png?version=1&modificationDate=1453446619427&api=v2&effects=border-simple,shadow-kn)
Here's how it will look like when generated. Primary Account that matched the Primary account/s selected will be generated. ![](/download/attachments/18415676/image2016-1-22%2015%3A8%3A25.png?version=1&modificationDate=1453446682140&api=v2&effects=border-simple,shadow-kn)
|
Expand |
---|
title | Location is selected in Type field |
---|
| ![](/download/attachments/18415676/image2016-1-22%2015%3A10%3A13.png?version=1&modificationDate=1453446791137&api=v2&effects=border-simple,shadow-kn)
Here's how it will look like when generated. All Primary Accounts created for the selected location will be generated. |
Expand |
---|
title | Description is selected in Type field |
---|
| ![](/download/attachments/18415676/image2016-1-22%2015%3A15%3A1.png?version=1&modificationDate=1453447077507&api=v2&effects=border-simple,shadow-kn)
Here's how it will look like when generated. Primary Account that matched the selected account description will be generated. |
|
...