Account Group Data Entry in Excalibur

Search the IFS Reporting Wiki

The instructions below describe how to create Account Groups and map them to Major and Minor Accounts in the IFS Excalibur application.

Log into Excalibur.
Open the Account Group GL120 Master File by navigating to Accounting > General Ledger > Master Files > Account Group.
Type in an Account Group ID.
- If you do not specify an Account Group ID the system will assign it a number.
- If you are setting up Account Groups to use the IFS Reporting Custom Financial Report, see the Training Guide for recommendations on assigning Account Group IDs.
- In this example, the assigned ID is "-LOS-S-N".
Type in a Description.
- In this example, the assigned description is "LOS NGL Sales".

Select a Detail Type.
- The Detail Type determines which accounts you will be able to select in the Detail window.
- Click F3 for a list of Account Group Types.
Select Systems.
- Click F3 for a list of Systems.
- The System Field is associated with the system codes for Unposted Transaction Master items.
- You can pick a specific system or select ALL systems.
Select Companies.
- To view available companies, click the Detail button or F5 to open the Account Detail GL210B window.
Select Accounts.
- To view available accounts, click F3 in Co. Account field box.
- Type in the accounts you want to add to this Account Group.
- You can select Major and Minor accounts.
- Exclude is a required field.
  - Type Y to exclude the account.
  - Type N to include it.
- Click the Save button.
Review Account Groups.
1. To view a list of your Account Groups and their accounts, run the Account Group Master GL720 report.
2. Navigate to the report at Accounting > General Ledger > Master Reports > Account Group.
3. Type in the Group Type. This is the Detail Type selected in the Systems window GL120 in step 6 above.
4. Click the F8 Process button to run the report.