mO SharemO Share

#Sub Ledger Detail (Printable)#

Report Name

#Sub Ledger Detail (Printable)#

Report Location

Finance\Register

Report Type

Register

Report Description

This report will display transactions as per the selected Sub-ledger and other parameters. This report can be used for printing in A4 Size page format.

Report Objective

The objective of this report is to share the sub ledger details in a printable (A4 Size) format so that it can be understood properly by the users. There are various options in Report so that user can hide some of information which is not relevant for specific purpose.

Target Audience

Finance Manager, Finance Executive, 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

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 Sub Ledger which do not have non-zero balance

Show Narration :

Single

If it is ‘True’ then Narration of each Transaction will be visible in Report else it will not be visible in Report.

Show Adjustments :

Single

If it is ‘True’ then Adjustments of each Transaction will be visible in Report else it will not be visible in Report.

Show Particulars :

Single

If it is ‘True’ then Particulars of each Transaction will be visible in Report else it will not be visible in Report. Particulars are nothing but the related financial posted in other Ledgers.

Show Status :

Single

If it is ‘True’ then Status of each Transaction (i.e. Poster / Unposted) will be visible in Report else it will not be visible in Report.

Show Owner Site :

Single

If it is ‘True’ then Document Owner Site of each Transaction will be visible in Report else it will not be visible in Report.

Show BRS Date :

Single

If it is ‘True’ then Bank Reconciliation Date (BRS Date) of Transaction will be visible in Report else it will not be visible in Report.

Class

Multiple

User can select particular Class of Sub Ledger for which user want to see report. If no specific Class need to be selected then can remove this filter when Sub Ledger Selection is needed else it can be kept as Blank for report on all Sub Ledger.

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

Not Applicable

Alternative reports to validate

Sub ledger Detail Report.

Sample Output

 

Special Feature of this Report : User can see the Transaction Document by clicking on hyperlink available on the Entry No.

Data Source Category Used

01-Master\Ledger [LV_LEDGER]
01-Master\Owner Site [LV_SITE]
01-Master\Sub-Ledger [LV_SUBLEDGER]
02-Finance\04-Report Specific\Sub Ledger Detail [TV_SUBLEDGERDETAIL_NEW]