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.
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:
| 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:
|
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.
Related Topics