About Verifying Account Data

Sage 300 ERP

Home > Financial Reporter > Printing Financial Statements > About Verifying Account Data

About Verifying Account Data

You can use two methods in Financial Reporter to test account information to decide whether it should appear in a report.

  • Use a formula in column C to test the contents of a line. You can specify conditions for excluding generated lines from a report based on the contents of the line.

    For more information, see About Columns in Report Specifications.

  • Use FR functions with spreadsheet functions. Financial Reporter functions can replace parameters of spreadsheet functions, so you can test the contents of fields before printing the report, or manipulate them as you wish.

    Example:

    To specify that a balance is printed only if it exceeds 6000, use =IF(FRAMT("BALP","1000")>6000,FRAMT("BALP","1000"),0).

    To print the average value of two accounts, use =AVERAGE(FRAMT("BALP","1000"),FRAMT("BALP","2000")).

Related Topics