Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

The Manual Ledger Adjustment report displays the details about the entries stored in the ESTAR_LEDGER_POST table. You can select pure manual entries as well as other manual ledger entries that are not otherwise identified as manual.

To create the Manual Ledger Adjustment report:

  1. In Accounting Center, in the left navigation pane, click Reports > Ledger Reports > Ledger Balance > Manual Ledger Adjustment Report. 
    You see the Manual Ledger Adjustment Report panel.
  2. Complete the options on the Manual Ledger Adjustment Report panel.
  3. Under Result Options, click Grid or Advanced Report for the report view you want.
  4. Click Submit.

Manual Ledger Adjustment Report Panel Options

A definition of the options on the Manual Ledger Adjustment Report panel follows.

OptionDescription
Search Criteria
Entity IDSpecifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.
Entity NameSpecifies a portfolio, sector portfolio, composite portfolio, or Master Fund by name of the entity.
Accounting BasisSpecifies the entity accounting basis. For example, USTAX, GAAP, or IFRS.
Report TypeSpecifies the reported date type. Options include:
  • Accounting Date (Default)
  • Month End Date
  • Post Date
Report Period

Specifies the date or date range for your report. Options include:

  • Daily Activity (Default)
  • Date Range
Report Start DateSpecifies the start date for your report results. The default is first day of the current month. To use this option, you must select Date Range as your report period.
Report End DateSpecifies the ending date for your report results. The default is the last day of the current month.
Entries Type

Specifies the type of manual ledger in the report. Options include:

  • Pure Manual (Default). Selects entries with ACCT_CATEGORY = 'M' and MESSAGE_TYPE = 'SINGLE' values.
  • Other Manual. Selects entries with MESSAGE_TYPE = MISCINC, FEERECLASSBST, SINGLE, MISCEXP, or FEERECLASSICST.
  • All. Selects all entries.
Selection Criteria
Report FiltersAllows you to show/hide additional security and ledger account filters. The default is No.
Advanced Report OptionsAllows you to show/hide advanced report detail tab selection, group, sort, and format options. The default is No.
Filter Security By

Allows you to show/hide additional report filters. Options include:

  • Security Cross Reference (Default). If you select this option the panel unhides the Xref Type and Xref Security ID fields for data entry.
  • Issue Name. If you select this option, the panel unhides the Issue Name field for data entry.
  • Primary Asset ID. If you select this option, the panel unhides the Primary Asset ID field for data entry.
Other FiltersAllows you to filter report results. Options include:
  • Asset Currency
  • Security Type
  • Processing Security Type
Query Ledger Account Options
Ledger Accounts

Allows you to filter by ledger account number. Options include:

  • All Ledger Accounts
  • Ledger Account Range
  • Single Ledger Account
From Ledger AccountSpecifies the starting ledger account number for your report results.
To Ledger AccountSpecifies the ending ledger account number for your report results. To use this option, you must filter by Ledger Account Range.
Advanced Report Options
Detail Tab SelectionAllows you to select Manual Ledger Adjustment as an additional view for your report results. Default is Yes.
  • No labels