BI Accounts

BI Accounts are used for the BI solution and period end reporting. Accounts are grouped together and then used in reporting based on the filters applied to the BI report. For example, Feed Consumed would be comprised of all of the feed consumed accounts in the system and then depending on the data selected for the report, it will calculate the total feed consumed dollars for the data. BI Accounts are sourced from Chart of Accounts Master.

There is a base of system BI Accounts created for use in BI reports. These accounts may need to be modified if there are additional accounts added to the system at the discretion of the user.

The BI Accounts document contains the following sections:

• Creating a BI Account
• General
• Details
• Editing a BI Account
• General
• Details

Create BI Account

1. In Admin>Business>General>Chart of Accounts Definition, select BI Accounts.

2. Set the focus or click in the General section and select the button to create a new record.

General

The General section defines the master account that will be used in the BI Report. The master account will group all of the accounts together that are required to be reported on the BI Report.

1. Enter a Caption to identify the grouping. This should be a brief description of the account. This field can be used in BI Reports if the system caption is not adequate. Alphanumeric, maximum 50 characters.

2. Enter a Description to describe the grouping. Alphanumeric, maximum 255 characters.

3. Enter a Sequence to determine the order that the items will be displayed in the reporting structure.

Details

The Details define the specific accounts that will be used to report the data in the BI solution.

1. Set the focus or click in the Details section.

2. Select to add a new account.

3. Filter the accounts that are required.

4. Manually select the required account by checking the Select field or select Options>Select All to add all of the accounts based on the filter applied.

5. Click OK

6. Save Record.

Edit BI Account

The Editing process is used when the BI Account is previously defined and additional accounts are required to be added or deleted.

General

1. Select the required line that is required to be edited.

Details

1. Set the focus or click in the Details section.

2. To add a new account, select

3. Filter the accounts that are required.

4. Manually select the required accounts by checking the Select field or select Options>Select All to add all of the accounts based on the filter applied.

5. Click OK

6. To delete a line, click on the required lines and right-click to select  

7. Save Record.