Multiple Ledgers

It is possible to include multiple Ledgers in a single Get Balance function by entering a list of Ledger Ids in the the Ledger parameter. For example:

=OCL_GLW_Get_Balance(“Jan-14″,”PTD”,”USD”,”Total”,”A”,,”01″,”000″,”7000″,”0000″,”000″,,,,,,,,,,,,,,,,”1,650″)

This function will consolidate the balances for the selected accounts from Ledger 1 as well as Ledger 650 into one balance. Please note the following important points:

• The Ledgers must have the same chart of accounts and calendar.
• You cannot enter a list of Ledger Ids in the Get Balance wizard at this time. To enter a list of Ledger Ids, first create the Get Balance function using the wizard, linked to a single Ledger. Then, once the function has been entered into the Excel cell, edit it as you would normally edit any other Excel function and modify the Ledger parameter to include the list of Ledger Ids.
• The list of Ledger Ids must be entered as text values surrounded by quotes otherwise Excel will interpret the value as a number.
• The Ledgers do not need to have the same currency. If you choose to report on Ledgers that do not have the same currency GL Wand will include the functional balance for those Ledgers that have the same functional currency as the currency requested in the Get Balance function. The translated balances will be selected for the Ledgers that do not have the same functional currency as the currency requested in the Get Balance function.

• You can use the wild card character in the Ledger parameter to include all the Ledgers that you are currently logged on to.

Ledger Sets

You also have the ability to create a Ledger Set which is a grouping of Ledgers. By using the Ledger Set function in conjunction with the multiple Ledger capability of the Get Balance function, you can report on Ledger Sets. Use the function to return the list of Ledgers that are included in a specific Ledger Set and then link the output of that function to the Ledger parameter of the Get Balance function.