Manual Ledger Adjustment Report

Owned by Former user (Deleted)
Oct 27, 2016
2 min read

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. From the Accounting Center window, click Reporting in the left navigation.
  2. Double click Investment Accounting, Ledger Reports, and Manual Ledger Adjustment.
    You see the Manual Ledger Adjustment panel.
  3. Complete the fields on the Manual Ledger Adjustment panel.
  4. Click Submit and then click Advanced Report or Classic Grid Report for the report view you want.

Manual Ledger Adjustment Panel Options

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

Search Criteria

  • Entity ID. Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by the entity ID of the entity.
  • Entity Name. Specifies a portfolio, sector portfolio, composite portfolio, or Master Fund by name of the entity.
  • Accounting Basis. Specifies the entity accounting basis. For example, USTAX, GAAP, or IFRS.
  • Report Type. Specifies 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 Date. Specifies 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 Date. Specifies 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 Filters. Allows you to show/hide additional security and ledger account filters. The default is No.
  • Advanced Report Options. Allows 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 Filters. Allows 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 Account. Specifies the starting ledger account number for your report results.
  • To Ledger Account. Specifies 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 Selection. Allows you to select Manual Ledger Adjustment as an additional view for your report results. Default is Yes.