mO SharemO Share

#Sub Ledger Summary#

Report Name

#Sub Ledger Summary#

Report Location

Finance\Register\

Report Type

Register

Report Description

This report will show summary of the Sub-ledgers during a given period and selected parameters.

Report Objective

This Report is designed to have Subledger wise Ledger balance along with debit / credit amount for a particular date range. This report grouped at Ledger/Account level for each Sub ledger. There is hyperlink available on each Sub Ledger Name to redirect to have month wise ledger break up of the same summary report.

Target Audience

Accounts Executives, Accounts Manager, Finance Manager, Finance Executive, Senior Management

Selections

Name

Selection type

Objective

From Date

Single

Report to be shown based on transaction happened for the period starts from this date

To Date

Single

Report to be shown based on transaction happened for the period ends on this date

Agent

Single

Report will display for the Sub ledgers who has Agents defined in their master. User can select a particular agent or can consider 'ALL' to have record irrespective of Agent available in master.

Include Unposted Entries

Single

If it is ‘True’ then report will consider all those transactions which is not released/posted yet also.

Include Zero Balance Records

Single

If it is 'True' then report will show all the Ledger (or group which do not have non-zero balance)

Class Name

Single

User can select particular class of Sub Ledger by this option. if there is no such need then it should be kept as 'ALL'

Sub Ledger

Multiple

User Can select a particular Sub Ledger through this filter. This Filter is dependent on previous filter selection. If previous Filter is removed then all Sub Ledger will be visible to choose.

Ledger

Multiple

Since Same Sub Ledger can be tagged with Multiple Ledger here user can select a particular Ledger. Once such selection is there then the Report will consider to show for such Sub Ledger and Ledger combinations.

Dependencies

NA

Alternative reports to validate

#Sub Ledger Detail#, #Sub Ledger Monthly#

Sample Output

 

Data Source Category Used

01-Master\Ledger [LV_LEDGER]
02-Finance\04-Report Specific\Sub Ledger Summary [TV_SUBLEDGER_SUMMARY]
01-Master\Sub-Ledger [LV_SUBLEDGER]