Using Formulas to Retrieve General Ledger Account Information

Sage 300 ERP

Home > Financial Reporter > Designing Financial Statements > Retrieving G/L Account Information > Using Formulas to Retrieve G/L Account Information

Using Formulas to Retrieve General Ledger Account Information

In the Financial Statement Designer, you use Excel formulas to insert account record information or fiscal set values anywhere in a financial statement.

Example:

FRACCT("ACCTDESC","1000-333") inserts the account description from account 1000-333 (for example, "Cost of goods sold").

FRAMT("ABALP.2019","1000-333") inserts the actual balance of account 1000-333 for the current fiscal period for the year 2019.

You can also insert company information in a financial statement. For example, FR("Coname") inserts the name of the currently open company.

The easiest way to insert Sage 300 ERP financial information is by using the FR Paste function, which you can use to create a formula quickly. For more information, see About FR Paste.

To specify balances and quantities, you use the following syntax:

Financial Information Syntax
Formula	Sage 300 ERP Financial Information	Notes
PBALP	Account balance	If BALP is specified without an A or P prefix for actual or provisional amounts, it will default to the report setting chosen at print time.
PBALP	Provisional balance
QABALP	Actual quantity
QPBALP	Provisional quantity	You can specify budget sets according to the edition of Sage 300 ERP you use: Sage 300 Standard ERP includes budget sets 1 and 2 Sage 300 Advanced ERPincludes budget sets 1, 2, and 3 Sage 300 Premium ERP) includes the numbers 1 to 5 for the budget sets (for example, 1BALP or 2BALP)

Tip: You can construct your financial statements by placing a Financial Reporter function at each point where you want to print financial information. However, identifying each item individually can be a time-consuming and unnecessarily rigid way to create a statement. Developing a statement specification with default formulas for each column, indicating the group of accounts to which the column formulas will apply, is a more flexible and efficient way to create your statement.