ethiotech: Financial Statement Generator Report setup in Oracle General Ledger

From oracleappstechguide

Oracle General Ledger’s Financial Statement Generator (FSG) is a powerful and flexible financial report building tool you can use to build your own custom financial reports without programming.

There are two required components in defining a report: Row set and Column set.

Step 1 : To define Row set column:

Navigation : GL -> Reports-> Define-> Row Set

Add each line header in line item field. Indent field used to space from left side. you also can set Line to skip before and after to bifurcate each line heading. we can use Underline character as '-' or '=' or '*' to design layout. All property like line to skip , Underline character and page break used before and after we can set for our current line item.

To show balance for current line item you need to assign account code combination for this particular account. e.g. Income Line item comes under account code 710102 which is 6th segment as per my current setup for code combination in GL Accounting Flexfield.

You can set n number of line header for one FSG report

We can perform Addition and deletion operation on summary of group of line item. For this we need to click on Calculation Button instead of Account assignment button.

Here we use '+' sum operator to sum group of line item to show total sale in FSG report.we can add n number of line item

Step 2 : Define Column Set

Navigation : GL -> Report-> Define -> Column Set

Enter Name and description and then click on Define Columns button.

Position column is important in column set. it will decide position of current column name and its value in report. you need to imagine report layout and accordingly specify position field value.

e.g. if you started with position 50 for first column then you need to mention 70 in position field of very next column so it will appear after 20 space in report layout.

Amount Type column also important in column set this have value like YTD-Actual, PTD- Actual, QTD-Actual, YTD- Budget etc. This field will decide amount shown in this column against each line item will show YTD balance or QTD balance.

You define 20 column in FSG report. it will permit you to define more than 20 column in column set of FSG but report will not show header of column name in report output.

Step 3 Build Column Set: Once done with column set click on Build column set Button. below screenshot showing note ' This column set has more than 20 column. you can view first 20 column in column set builder.

Below screenshot showing how to build column set. in this you can edit name or width and left margin field as per your report requirement. This is last step of FSG setup. Once you done with it now you can run report