Load Accounts

Use this form to load general ledger tree structures and their associated general ledger accounts from trees into Excel. The database must be open before you can access this option.

The starting point for the load is always the current cell. Before retrieving the tree structure, the process examines the Excel spreadsheet from the current cell to determine if it is safe to load the structure. If the process finds that the load will overwrite any cell with a formula in it, the load process is aborted and an error message displays.

Company

The company to draw the trees and accounts from.

Tree

The name of the general ledger account tree to draw the structure from.

Branch

The tree branch to draw the structure from. You can leave this empty to load the entire tree structure. The tree branch can be a full path.

Include Sub Trees

This option indicates if Greentree Desktop should follow the tree structure down.

If this option is:

• Selected, then the structure is followed down the number of levels indicated in the associated box. A maximum of eight levels is allowed, This is a limit imposed by Excel outlining.
• Not selected, then only the level immediately below the tree branch combination specified loads.

Load Accounts

This option determines whether or not tree branch accounts are loaded.

If this option is:

• Selected, then all accounts attached to each branch are loaded with the branch.
• Not Selected, then only the tree branch structure is loaded.

Use Outline

Determines whether or not to use Excel outlining to display the tree branch structure.

If this option is:

• Selected, Excel outlining is used.
• Not selected, outlining is not used and the tree branch structure displays by moving one column to the right for each level in the structure.

Load Across

Changes the orientation of the load function from down rows to across columns. All other parameters remain the same.