To understand how the list structure in the Report Designer Add-In is formulated, you need to understand the general ledger chart of accounts hierarchy.
Below is a typical example of an account hierarchy.
The lists are retrieved from the General Ledger.
Adding Lists
There are various lists that can be used to view some of the key information; for example, account numbers and budget codes.
1. Drag and drop lists that you require from the Task Pane onto your Microsoft® Excel® worksheet. (Accounts, Account Groups, Account Segments)
2. You can reference items in these lists from within your formulas, to return data based on the selected list.
Company Codes
Lists are always returned from the company code which is selected in the Task Pane.
To change the company code:
1. Click on the company code.
2. Select a new GL Company Code from the drop down options.
Note that the company code is obtained from your General Ledger.
