1. Home
  2. /
  3. User Guides
  4. /
  5. Analyser
  6. /
  7. Financial analysis
  8. /
  9. General Ledger enquiry in...

General Ledger enquiry in DC1 Analyser

Related topics

The following describes how you access General Ledger transaction information.

Note: Any enquiry templates defined on the iSeries will be displayed in the Advanced selection drill down allowing you to run from DC1 Analyser. If you hover the mouse in the upper part of the drop down list, you will be prompted with the selection/sorting details of the enquiry templates.

Tip: If you create a table view with the same name as any of the enquiry templates, DC1 Analyser will use this table view when running the actual Advanced selection.

Note: Before you use the G/L transaction enquiry routine, make sure that you familiarise yourself with the standard routine for object enquiry described in Working with objects in DC1 Analyser, where you will find full details of the Multimedia functionality. See the related topics for configuration information as well as creating shortcuts to favourite functions.

Viewing G/L transaction information

To view a G/L transaction, do as follows:

  1. Select the G/L Transactions menu item in the Financial Analysis sub-menu, the Object categories list, or the All functions list.
  2. You access the G/L Transaction browser window. To run a G/L transaction search, you can enter some or all of the following information in the three selection pages in order to determine the search terms. Note: When available, you can click the Find icon to the right of a field to retrieve and select from a list.

    3. Selection 1 page:

    Account parts
    Enter the account part in the four available fields.

    Selection 2 page:

    Journal number
    Enter the journal number.
    Document number
    Enter the document number.
    Voucher number
    Enter the voucher number.
    Voucher type
    Enter the voucher type.
    Voucher date
    Enter the voucher date.
    Document date
    Enter the document date.
    Document type
    Enter the document type.
    Currency
    Enter the currency.

    Selection 3 page:

    Year
    Enter the year or select a year from the drop menu.
    Period
    Enter the period or select a period from the drop menu.
    Amount
    Enter the amount.
    Reconciled group box
    Select Yes, No or All.

    Tip: You can run a search according to the user-defined sequences determined in DC1 Financials. Click Select sequence to view the Sequence selection view window in which you can choose to Select or Deselect a sequence.

    Click Find to run the search.

  3. You view the results of the search in the table list in the G/L Transaction browser window. To access more G/L transaction information, do as follows:
    • Either, select the G/L Transaction and choose Select or Select menu item G/L Transaction.
    • Or, click G/L Transaction with the right mouse button to get the G/L Transaction pop up menu and choose G/L Transaction/Show details.
  4. You access the G/L Transaction details view window.

    5. Where you see a grey push-button in an information field of the G/L Transaction details view window, click the push-button to view further information.

    For example, the account parts are displayed in grey push buttons. When you click an account part, you view an Account enquiry window with basic information. In this window, choose Account part/Select balance enquiry option from the menu bar. Select a balance enquiry option and click Select. In the Account enquiry window, click Show balance to view the Balance details view window. See About analysing balances and budgets in DC1 Analyser for more information.

    If details exist, you can click the Details button in the lower left hand corner to drill down to view the transaction details. From the Transaction details window, you can select a line and drill down to view the actual A/P or AR transactions, by clicking the View A/P transactions or View A/R transactions button.

Viewing G/L log entries

If you want to view the log file containing all G/L transactions, per accounting year that you hold in the system, do as follows:

  1. Select the G/L Log menu item on the Financial Analysis sub-menu or All functions list.
  2. You access the G/L log selection view window. Select the applicable Year from the drop down list and if you want to narrow down the selection, enter the applicable journal number. Click OK.
  3. You access the G/L Log entry browser. You see all G/L log entries for your selections made on the previous window. To view details for an entry, right click on the applicable entry and select G/L log entry/Show details.
  4. You view the G/L Transaction details view window outlining details for the log entry.

Related topics