Dear All
I want to make a Balance Sheet through FSG, please help me regarding Row Set about balance sheet. Mean how to build row set for balance sheet.
FSG Report Build
<u><b>Row Set</b></u>
Row Set defines the rows of your report. Typically, accounts are assigned to row set definitions. For each row, you control the format and content, including line descriptions, indentations, spacing, page breaks, calculations, units of measure, and precision.
<u><b>Defining Row Sets</b></u>
?A single row set can be used for many different reports. For example, Row Set A above is used for an Income Statement with current information. It can also be used to produce an Income Statement for any other entity (company, division, group, or cost center), or for the same entity with a yearly comparison column.
?A Row Set defines the format and content of the rows in an FSG report. In FSG, the commonly assumed attribute for a row definition is an account assignment, whereas the attribute for a column definition is a time period or amount type. When you define a row set, you can:
<b>Assign accounts:</b>
?To indicate which general ledger account balances you want to include in the row. You can assign an individual account, parent account, or range of accounts to each row.
<b>Define calculations:</b>
?To perform a variety of complex computations in your report. The calculations can refer to any previous rows in a report, including rows you choose not to display.
<b>Specify formatting:</b>
?To control page breaks, indentation, line spacing, and underline characters. You can define a new row set, or use FSG's AutoCopy feature to copy an existing row set, which you can then modify as needed.
<b><b>Row Set:</b></b>
?When creating a balance sheet, you must include your entire income statement account range for the Current Period Retained Earnings amount. Oracle General Ledger never posts the monthly net income amount to an actual current period retained earnings account. This only happens when the first period of a new fiscal year is opened. Thus, to achieve the figure for current period retained earnings, it is a reporting solution where you enter your Profit and Loss account range in the account assignment.
?When creating reports, it is a good idea to include check figures at the end of the report to verify that all accounts were properly assigned in the reports. This is particularly useful if you have had to enter account ranges with gaps because of the structure of your chart of accounts.
For example, when creating a Balance Sheet, add check figures at the end of the report defined as follows:
- Total Assets 1000-1999
- Total Liabilities 2000-2999
- Total Stockholder's Equity 3000-9999.
<b><b>Assigning Line Numbers to Rows:</b></b>
?You should enter line numbers in increments of 10 to allow for space to add additional rows for future modifications.
<b>Account Assignment Display Option:</b>
?Oracle General Ledger stores debit balances as positive numbers and credit balances as negative numbers. If you want your credit balance accounts, such as liabilities, and revenues to display as positive numbers, select the Change Sign check box. Doing so will have no effect on your calculations.
Regards,
Row Set defines the rows of your report. Typically, accounts are assigned to row set definitions. For each row, you control the format and content, including line descriptions, indentations, spacing, page breaks, calculations, units of measure, and precision.
<u><b>Defining Row Sets</b></u>
?A single row set can be used for many different reports. For example, Row Set A above is used for an Income Statement with current information. It can also be used to produce an Income Statement for any other entity (company, division, group, or cost center), or for the same entity with a yearly comparison column.
?A Row Set defines the format and content of the rows in an FSG report. In FSG, the commonly assumed attribute for a row definition is an account assignment, whereas the attribute for a column definition is a time period or amount type. When you define a row set, you can:
<b>Assign accounts:</b>
?To indicate which general ledger account balances you want to include in the row. You can assign an individual account, parent account, or range of accounts to each row.
<b>Define calculations:</b>
?To perform a variety of complex computations in your report. The calculations can refer to any previous rows in a report, including rows you choose not to display.
<b>Specify formatting:</b>
?To control page breaks, indentation, line spacing, and underline characters. You can define a new row set, or use FSG's AutoCopy feature to copy an existing row set, which you can then modify as needed.
<b><b>Row Set:</b></b>
?When creating a balance sheet, you must include your entire income statement account range for the Current Period Retained Earnings amount. Oracle General Ledger never posts the monthly net income amount to an actual current period retained earnings account. This only happens when the first period of a new fiscal year is opened. Thus, to achieve the figure for current period retained earnings, it is a reporting solution where you enter your Profit and Loss account range in the account assignment.
?When creating reports, it is a good idea to include check figures at the end of the report to verify that all accounts were properly assigned in the reports. This is particularly useful if you have had to enter account ranges with gaps because of the structure of your chart of accounts.
For example, when creating a Balance Sheet, add check figures at the end of the report defined as follows:
- Total Assets 1000-1999
- Total Liabilities 2000-2999
- Total Stockholder's Equity 3000-9999.
<b><b>Assigning Line Numbers to Rows:</b></b>
?You should enter line numbers in increments of 10 to allow for space to add additional rows for future modifications.
<b>Account Assignment Display Option:</b>
?Oracle General Ledger stores debit balances as positive numbers and credit balances as negative numbers. If you want your credit balance accounts, such as liabilities, and revenues to display as positive numbers, select the Change Sign check box. Doing so will have no effect on your calculations.
Regards,
Who is online
Users browsing this forum: Majestic-12 [Bot] and 0 guests