About Optional Fields in Financial Reports

Sage 300 ERP

Home > Financial Reporter > Designing Financial Statements > About Optional Fields in Financial Statements

About Optional Fields in Financial Reports

You can print account optional fields and transaction optional fields detail using Financial Reporter.

  • You can retrieve account optional fields using FRACCT or FRPOST.

    Note: A field name for an account optional field is the original optional field name with the prefix A. You must include the period following the letter A.

  • You retrieve transaction optional fields using FRPOST.

    Note: A field name for a transaction optional field is the original optional field name with the prefix T. You must include the period following the letter T.

If an FR command retrieves data from more than one transaction, you can consolidate optional field data for Amount, Integer, and Number optional field types in the following ways:

  • You can print the optional field value of the first retrieved record that has optional field values.

    If the field specified in the first parameter of the FRACCT or FRPOST command is an amount, integer, or number field, and is appended with U, only the first optional field value is reported.

  • You can print a consolidated total that sums up all values from the retrieved optional fields.

    If the specified field name is not appended by anything or is appended by C, a consolidated total is printed.

Related Topics