The Drill down view enables the user to view the breakup of the Balance sheet / Income statement items, further to schedules, sub schedules (account codes) and transactions. Further, the respective transactions page can also be viewed. Drill down view is available for Indian Companies.
Select the “Print Report” link under the “Custom layout Definition” component under Book Keeping Business Process Component.
The “Print report” page appears.
Select the following fields:
Report Type |
Predefined - Financial Statement |
Report Description |
Select report description as,
|
Company Code |
Login company would be loaded and defaulted. |
Finance Book |
Select the finance book for which drill down view will be launched. |
Layout No. |
A unique number identifying layout of the balance sheet/income statement. The layout number must have already been defined in the “Financial Statement Layout” business component for the Balance sheet/Income Statement. |
|
Help facility Available. |
Currency |
Drill down view can be launched for base currency and parallel base currency. |
As on Date |
Provide “as on date” on which the Balance sheet drill down view has to be launched. (As on date will be visible only when the report option is Balance Sheet / Balance Sheet – Revised/Layout Based Balance Sheet). |
Comparison Date |
Provide “comparison date” for which the Balance Sheet drill down has to be launched. (Comparison date will be visible only when the report option is Balance Sheet/ Balance Sheet – Revised/Layout Based Balance Sheet). |
Financial Year |
Use the drop down list box to select the finance year for launching Income Statement drill down view. (Financial year will be visible only when the report option is Income statement/ Income statement – Revised/Layout Based Income Statement). |
Finance period range |
Use the drop down list box to select the financial periods for launching Income Statement drill down view. (Financial Period will be visible only when the report option is Income statement/ Income statement – Revised/Layout Based Income Statement). |
Comparison Year |
Use the drop down list box to select the comparison year for launching Income Statement drill down view. (Comparison year will be visible only when the report option is Income Statement/ Income Statement – Revised/ Layout Based Income Statement). |
Comparison Period Range |
Use the drop down list box to select the comparison periods for launching Income Statement drill down view. (Comparison period will be visible only when the report option is Income Statement/Income Statement – Revised / Layout Based Income Statement). |
Include memorandum vouchers |
Use this check box to select whether you want to include the memorandum vouchers in drill down view. |
Include Initial Balance entry |
Use this check box to select whether you want to include the Include Initial Balance entry in drill down view. |
Click on Launch Drilldown to view Drill down view:
Balance Sheet / Income statement will be launched.
On click of the values against each line item in Balance sheet/Income Statement, the same is drilled down to “Schedules to Balance Sheet/Income Statement".
On click of the values against each line item in schedules, the same is drilled down to “Sub Schedules to Balance Sheet/Income Statement“ at account code level.
On click of the values against each line item in Account codes, the same is drilled down to list of transactions posted for the account codes.
On click of data hyperlink in the transactions the view page of the respective transactions will be launched.
For Layout Based Balance Sheet/Layout Based Income Statement, on click of values the same is drilled down to account level and then to list of transactions and to view page of the respective transactions.