Report Group F/M (GLF310)

Use the Report Group F/M program to establish and maintain the report groups that determine what groups of GL account numbers appear on the GL financial reports.

A report group is a user-defined, four-character code that references multiple companies, branches and departments. You have the option to:

• Specify two descriptions to print on the header of the financials.
  
• Skip up to nine lines after each description.
  
• Consolidate account balances for companies, branches and/or departments. (Note: Companies on consolidated financial reports must use the same fiscal year.)
  
• Specify up to 10 ranges of companies, branches and/or departments to print.
  

Report groups come into play when you print financial reports. An example account number might be 410-00-00 where the 410 is the base account number, -00- is the branch and -00 is the department. If the company has 2 branches (01 and 02) and 2 departments (01 and 02) then the following account numbers could exist:

 410-01-01

 410-01-02

 410-02-01

 410-02-02

When you set up a financial report, 410-00-00 is entered (not indicating any specific department or branch). The report groups are where you specify which companies, departments and branches to print on the financial reports. When printing the financials, the system looks at the report group to determine which account numbers (including branch and department) to print.

Using the example above, if the report group specifies branch 01, departments 01 and 02, the financial report would print the following account numbers:

 410-01-1

 410-01-2

Branch 02’s account numbers are not printed because branch 02 was not specified in the report group.

When setting up report group, you can specify for account type lines (as set in the Report Setup F/M) whether to consolidate for selected companies, branches and/or departments.

Using the previous example of the 410-00-00 account number using branches 01 and 02 and departments 1 and 2 the following account numbers exist:

 410-01-01 (Branch 01, Department 01)

 410-01-02 (Branch 01, Department 02)

 410-02-01 (Branch 02, Department 01)

 410-02-02 (Branch 02, Department 02)

If printing all branches and all departments and if the departments are to consolidate, the financial report would print the following:

• A total of both departments for branch 01
  
• A total of both departments for branch 02
  

The department figures are consolidated into one figure.

To access this program, click General Ledger> Financial Reports Setup>Report Group F/M.

Click field descriptions for information on each field.