Use the Query wizardto create and set up query parameters to calculate values for cell operations for the Function querydata type.

1. Click General ledger> Setup> Financial reports generator> Financial reports generator> Setupto open the Field setupform.

2. In the lower pane, in the Line typefield, select Function query.

3. Click Edit the queryto open the Query wizard.

4. Select the Show system names of tables, fields, and methodscheck box to view the names for tables and fields in the query wizard.

5. Click Next. In the All tablesfield, select the main table on which the calculation is performed and click >to move it to the Selected tablesfield.

6. In the Tables that are related to the Selected tablesfield, select additional tables and move them to the Selected tablesfield. You can assign filters in the query if necessary.

   Note
   Only tables that are linked to the selected main table are available.

7. Click Next. In the Available fieldsfield group, select the field to be calculated and click >to move it to the Field namefield.

   Note
   Numerical fields of the selected main table can be selected.

8. In the Operationfield, select the operation to be used for the calculation.

9. Click Next. In the Available fieldsfield group, select the field that has the base date for generating a report, and then click >to move it to the Field namefield.

10. In the Periodfield, enter a value if it is different from the default value determined for the cell or report.

11. Click Next. In the Available fieldsfield group, select the fields to be used for filter setup, and then click >to move them to the Selected fieldsfield group.

12. Click Next> Finishto create and save the query with the specified parameters.

13. Click Edit the queryto open the Inquiryform to edit the query if necessary. You can add more tables and set up filters in the generated query.