Get Average Balance
The Get Average Balance returns a General Ledger average daily balance individually or summed based on the segment values that you enter.
Important: Average balance functionality will only work should average daily balances be configured in your Oracle EBS environment.
The following options are available in the Function Wizard:
- Select a value from the drop down list. These lists are populated with the available values for each parameter or with the configuration data read directly from Oracle.
- Click the
button to link the parameter to an Excel cell.
- With an Excel range reference in a parameter, use the F4 key to toggle the absolute and relative addressing as you would in Excel.
- Use the
button to enter account combination criteria.
- Use the
button to enter descriptive flexfield criteria.
- Check the “Save as Default” checkbox to save the parameter values as defaults for future Get Balance function inserts. Defaults are saved per ledger (as selected in the toolbar).
| Parameter | Description |
|---|---|
| Accounting Date | The accounting date for the average daily balance. The date should be selected from the list of values provided or by entering it manually. If entering the date manually, the format should be the same as your PC regional settings. Alternatively, if a cell reference is being used, any valid Excel date will work. If an invalid date is specified the function will return Error (Date). You can only specify a single date for an average daily balance. Lists and ranges are not permitted. |
| Balance Type | EOD, PAGG, PATD, QAGG, QATD, YAGG and YATD all in upper case.
|
| Currency | The currency code as configured in Oracle all in upper case e.g. “USD”. |
| Translated Flag | Works the same as the Get Balance Translated Flag parameter, please see the Get Balance page. |
| Segment1 through Segment20 | Works the same as the Get Balance Segment parameters, please see the Get Balance page. |
| Ledger | Works the same as the Get Balance Ledger parameter, please see the Get Balance page. |
| Include the Ledger Id | Works the same as the Get Balance Include the Ledger Id parameter, please see the Get Balance page. |
See Also
Creating Get Balance functions using segment combination criteria.
Creating Get Balance functions using descriptive flexfield criteria.