Financial Reporter Functions in Sage 300 ERP

By | April 28, 2015

General Ledger in Sage 300 ERP includes Financial Reporter – a powerful tool that uses Microsoft Excel to read, manipulate, format and print general ledger data. The Financial Reporter helps retrieve data from General Ledger including transaction and the optional field information.  Financial statements use special functions to extract data from the company database.

The New Stuff: Expense Separately Functionality for Tax in Sage 300 ERP

Vendor

FR Function: This function can retrieve G/L Option, company, and fiscal calendar data; runtime parameter values; and statement print options.

FRACCT Function: This function retrieves data from G/L account records, including account optional fields. It cannot retrieve data from transaction optional fields.

FRAMT Function: This function retrieves actual, budget, and quantity balances and net amounts from General Ledger accounts for a specified period.

FRAMTA Function: This function is similar to FRAMT Function. It has the same arguments as FRAMT, and returns the same data. The difference is that the sign of the return value is dependent on the account type for FRAMT, but not for FRAMTA. FRAMTA returns all debit balances as positive numbers, and all credit balances as negative numbers, making it easy to sum a range of accounts without regard for the account type.

FRCREDIT Function: This function returns values for only those accounts that have credit amounts (balances or net changes) – regardless of whether the account is a debit or a credit account.

FRDEBIT Function: This function returns values for only those accounts that have debit amounts (balances or net changes) – regardless of whether the account is a debit or a credit account.

FRFISCAL Function: This function returns a date (as a string) from the fiscal calendar in Common Services.

FRPOST Function: This function retrieves account and transaction detail information from posted G/L transactions. It can also retrieve transaction optional fields and account optional field data for the account specified in the transaction record.

FRSDESC Function: This function returns the account segment name from the General Ledger segment codes table, given a segment number and code.

FRTRN Function: This function retrieves net amounts and net quantities from posted transactions for a specified period. It retrieves actual values and summary totals (by both account and transaction fields), and allows drill down to associated transactions.

FRTRNA Function: This function retrieves net amounts and net quantities from posted transactions for the period that you specify. It retrieves the actual values and summary totals (by both account and transaction fields), and allows drill down to associated transactions.

FRTRNCR Function: This function retrieves net totals (credit amounts only) from transactions. It retrieves actual values and summary totals (by both account and transaction fields), and allows drill down to associated transactions.

FRTRNDR Function: This function retrieves net totals (debit amounts only) from transactions. It retrieves actual values and summary totals (by both account and transaction fields), and allows drill down to associated transactions.

Also Read:
1. Financial Reporter Commands in Sage 300 ERP
2. Paste Command in Financial Reporter of Sage 300 ERP
3. Financial Reporter made reporting tranquil in Sage 300 ERP
4.Financial Reporter in General Ledger Module of Sage 300 ERP
5. Statement Designer Error in Financial Report of Sage 300 ERP