GL Reporting
Spreadsheet Server retrieves financial data from the General Ledger to Excel using the following formulas:
| Formula | Description |
|---|---|
|
Returns an account balance (see GXL Formula for Account Values for more information and links below to access ledger-specific information). |
|
Returns an account segment or account string description (see links below to access ledger-specific information). |
|
Expands summary data line into detail data lines (see Expand to Account Balances and Expand to Journals for more information). |
|
Customized formula. Contact insightsoftware for configuration of new formulas. |
|
For JD Edwards ledgers only, returns sales totals based on sales criteria (see JD Edwards GXSALES for more information). |
Note:
Formulas available for processing are based on the user's licensed features (see Query for query-related formulas.
Use the following links to access ledger-specific GXL information:
- Analyst
- BPCS 4.05
- BPCS 6.02
- BPCS 6.04
- Data Warehouse
- Designer GL
- Infinium
- Jack Henry 20/20
- Jack Henry Silverlake
- JD Edwards
- Lawson
- Movex
- Oracle
- PeopleSoft
- SAP
Use the following links to access ledger-specific GXD information: