View General Ledger

This script loads a View form, which gives access to the general ledger account. You can enter criteria and view the limited list of general ledger accounts or to view all accounts that you have access to.

The Transactions tab gives access to a specific general ledger account's transactions. You select the general ledger account to view the transactions for in the Balances table. You can enter transaction search criteria on the Transactions tab before performing the search or view all transactions for the selected general ledger account.

You can drill down on the transaction line to access the transaction performed. The Transactions tab also displays the total number of transactions displayed in the table and the total amount for these transactions.

Drill down from Excel

This script enables drill down from within Excel back to Greentree Desktop, where you can view the balances and transactions that make up a figure for general ledger accounts. The criteria fields default using the selected cell in Excel. The search is performed as part of the drill down and focus is set to Greentree, so that the results are auto displayed.

Options Reference

Each option and field on the form is described below. Mandatory options and fields are highlighted in red.

Account

Within Greentree: Select the account to view the detail for a specific general ledger account from the search field.
From Excel: The general ledger account defaults to the account that forms part of the formula used in the Excel cell on which drill down was performed.

Transaction Type

Within Greentree: Select the type of transactions to see the general ledger account detail for.
From Excel: Transaction Type defaults to the transaction type that forms part of the formula used in the Excel cell on which drill down was performed.

Period From Year

Within Greentree: Enter the first year for which to display transactions.
From Excel: This field is filled using the formula used in the Excel cell on which drill down was performed.

From Period

Within Greentree: Enter the first period for which to display transactions. This field is disabled if YTD is selected.
From Excel: This field is filled using the formula used in the Excel cell on which drill down was performed.

Period To Year

Within Greentree: Enter the last year for which to display transactions.
From Excel: This field is filled using the formula used in the Excel cell on which drill down was performed.

Period To

Within Greentree: Enter the last period for which to display transactions. This field is disabled if YTD is selected.
From Excel: This field is filled using the formula used in the Excel cell on which drill down was performed.

Search Filter

This field is filled when the drill down from Excel is performed. This field contains the filters used in the Excel cell on which drill down is performed.

Invert Sign

Within Greentree: Select this option to invert the signs in the search.
From Excel: This field is selected or deselected using the formula used in the Excel cell on which drill down was performed.

Credit

Within Greentree: Select this option to retrieve credit accounts in the search.
From Excel: This field is selected or deselected using the formula used in the Excel cell on which drill down was performed.

Display Zero Balances

Within Greentree: Select to retrieve zero balance accounts. If you select this option, the zero balance accounts are included in the display on the Balances tab.
From Excel: This field is filled using the formula used in the Excel cell on which drill down is performed.

Formula

This field is filled when the drill down from Excel is performed. This field contains the formula used in the Excel cell on which drill down is performed.

Tree

Within Greentree: Select the general ledger account tree to search on. Once selected, all the tree branches display. select the branches you want to search on.
From Excel: This field uses the formula used in the Excel cell on which drill down was performed.

Tree Branches

Within Greentree: This field displays all the branches for the selected tree. Select the branches to search on. You can click the:

Select All button to select all of the tree branches.
Unselect All button to deselect all the tree branches so that none of them is selected for the search.

From Excel: This field defaults using the formula used in the Excel cell on which drill down was performed.

Balances

Within Greentree: This table displays the general ledger accounts using the criteria you entered on the form. The balance of each account displays.
From Excel: This tab displays by default and automatically filled with the general ledger accounts for the formula used in the Excel cell you drilled down to.

Note: Use this tab to select a general ledger account line and then view the transactions for this account on the Transactions tab.

Transactions Table

This table displays the transactions for the general ledger account selected in the Balances table, using the Summarise by and Transaction by selections you have made.