Dashboard: Ledger Sets

18.4.2.3 Dashboard: Ledger Sets

The Ledger Set Report allows user to see Management Ledger Period Balances using a ledger set which is mapped to more than one ledger. This section provides information about the Ledger Sets dashboard used in Balance Computation Results.

Effective Date: Click the calendar icon and select the effective date.
Ledgerset Name: Select the name of the Ledgerset.

After updating the options, click Apply. To refresh the data in the fields click Reset.

A few reports also have filters at each reporting level which are detailed in the Report Descriptions section. Select the appropriate report filters so that data is displayed accordingly. Each report within a dashboard contains the following features:

Print: To print the values displayed in the report.
Edit: To edit the values displayed in the report.
Refresh: To update the values displayed in the report.
Export: To export data into multiple formats such as PDF, Excel, PowerPoint, and so on.

Table 18-14 Ledger Sets Report Information

Report Name	Ledger Sets
Report Description	This report displays the following parameters of the selected entity: Effective Date Ledgerset Name Ledger Name As of Date Functional Currency Entered Currency Quarter to Date Accounting Balance in Entered Currency Quarter to Date Accounting Balance in Functional Currency Credit Movement Quarter to Date Accounting Balance in Entered Currency Credit Movement Quarter to Date Accounting Balance in Functional Currency Debit Movement Quarter to Date Accounting Balance in Entered Currency Debit Movement Quarter to Date Accounting Balance in Functional Currency Average Month to Date Accounting Balance in Entered Currency Average Month to Date Accounting Balance in Functional Currency Month to Date Accounting Balance in Entered Currency Month to Date Accounting Balance in Functional Currency Credit Movement Month to Date in Entered Currency Credit Movement Month to Date in Functional Currency Debit Movement Month to Date in Entered Currency Debit Movement Month to Date in Functional Currency Average Quarter to Date Accounting Balance in Entered Currency Average Quarter to Date Accounting Balance in Functional Currency Debit Movement Year to Date in Entered Currency Debit Movement Year to Date in Functional Currency Average Year to Date Accounting Balance in Entered Currency Average Year to Date Accounting Balance in Functional Currency Year to Date Accounting Balance in Entered Currency Year to Date Accounting Balance in Functional Currency Credit Movement Year to Date in Entered Currency Credit Movement Year to Date in Functional Currency Month To Date Net Movement In Entered Currency Month To Date Net Movement In Functional Currency Quarter To Date Net Movement In Entered Currency Quarter To Date Net Movement In Functional Currency Year To Date Net Movement In Entered Currency Year To Date Net Movement In Functional Currency

Report Name

Ledger Sets

Report Description

This report displays the following parameters of the selected entity:

Effective Date
Ledgerset Name
Ledger Name
As of Date
Functional Currency
Entered Currency
Quarter to Date Accounting Balance in Entered Currency
Quarter to Date Accounting Balance in Functional Currency
Credit Movement Quarter to Date Accounting Balance in Entered Currency
Credit Movement Quarter to Date Accounting Balance in Functional Currency
Debit Movement Quarter to Date Accounting Balance in Entered Currency
Debit Movement Quarter to Date Accounting Balance in Functional Currency
Average Month to Date Accounting Balance in Entered Currency
Average Month to Date Accounting Balance in Functional Currency
Month to Date Accounting Balance in Entered Currency
Month to Date Accounting Balance in Functional Currency
Credit Movement Month to Date in Entered Currency
Credit Movement Month to Date in Functional Currency
Debit Movement Month to Date in Entered Currency
Debit Movement Month to Date in Functional Currency
Average Quarter to Date Accounting Balance in Entered Currency
Average Quarter to Date Accounting Balance in Functional Currency
Debit Movement Year to Date in Entered Currency
Debit Movement Year to Date in Functional Currency
Average Year to Date Accounting Balance in Entered Currency
Average Year to Date Accounting Balance in Functional Currency
Year to Date Accounting Balance in Entered Currency
Year to Date Accounting Balance in Functional Currency
Credit Movement Year to Date in Entered Currency
Credit Movement Year to Date in Functional Currency
Month To Date Net Movement In Entered Currency
Month To Date Net Movement In Functional Currency
Quarter To Date Net Movement In Entered Currency
Quarter To Date Net Movement In Functional Currency
Year To Date Net Movement In Entered Currency
Year To Date Net Movement In Functional Currency