Financial Reporter Functions
Financial Reporter Error Messages
About Generating Reports from Specifications
Accounts in General Ledger (G/L) contain two main types of data:
- Master information: Account name, account type, and other information regarding the account.
- Fiscal set values: Balances and net amounts for each general ledger account.
You can use the following functions in Financial Reporter to retrieve data from General Ledger, including transaction and optional field information.
Function | Data Retrieved |
---|---|
FR Function | G/L Option data, company data, and statement print options |
FRACCT Function | Account data, including account optional fields |
FRAMT Function , FRAMTA Function , FRCREDIT Function , FRDEBIT Function | Fiscal set data |
FRFISCAL Function | Fiscal calendar dates |
FRPOST Function | Accounts and transaction detail data, and account and transaction optional field data from posted transactions |
FRRATE Function | Exchange rates |
FRSDESC Function | Segment code descriptions |
FRTRN Function, FRTRNA Function, FRTRNCR Function, FRTRNDR Function | Transaction detail data including net totals, and account and transaction optional fields (but not provisional amounts) |
Tip: In Excel, use FR Paste (available from the Financial Statement Designer's FR menu) to insert a Financial Reporter function into a financial statement. From the FR Paste screen, you can select the function, its arguments, and additional report options. For more information, see About FR Paste.