Menu Path: General Ledger Inquiries Account Detail Inquiry
View detailed account activity for posted and unposted entries.
Use Account Detail Inquiry to review all General Ledger and subledger activity.
To view account detail information:
If your company uses consolidation ledgers, verify the ledger ID for which you want to view account detail information is entered in the Ledger ID field.
Enter a general ledger account number in the G/L Account field.
Enter a range of periods for which you want to view account information in the From Period and To Period fields.
Enter a range of years for which you want to view account information in the From Year and To Year fields.
If you want to view subledger information, select the Show Sub-Ledger Level check box, and select whether you want to be able to drill down to journal entries or transactions. If you want to view journal entry information, clear the check box, and select whether you want to view posted or unposted entries.
If you only want to view tax only adjustments, select the View Tax Only Adjustment check box.
Click the Show Data button in the ribbon. The information appears in the grid at the bottom of the window. You can drill down for more detailed information, or click the Line Items or Budget buttons in the ribbon to view line item information or compare amounts to a budget.
Button |
Description |
Exit |
Click this button to close the Account Detail Inquiry window. |
Show Data |
Click this button to display account information, based on the criteria selected. |
Line Items |
Click this button to display Journal Entry Trailers, which allows you to view journal entry line items for the selected journal entry. This button is only enabled if a journal entry is selected. |
Budget |
Click this button to Budget Comparison, which allows you to compare budget amounts to actual amounts for a selected general ledger account. |
Source Transaction Detail |
Click this button to display journal entry account or transaction detail information for the source journal entry related to a selected journal entry in a consolidation ledger. When you click this button, one of the following windows appears: This button is only available if a consolidation ledger is entered in the Ledger ID field, and is only enabled if a journal entry is selected. |
Field or Button |
Description |
Enter a general ledger account number for which you want to display information, or click the Lookup button to select an account number. |
|
Enter a ledger ID for which you want to display information, or click the Lookup button to select a ledger ID. Note This field is only available if at least one consolidation ledger is set up. |
|
This field displays the opening amount of the selected account. Depending on the account default, this amount is reflected as either a credit or debit. |
|
This field displays the description of the selected account. |
|
This field displays the total amount posted for all types of transactions for the selected account. Depending on the account default, this amount is reflected as either a credit or debit. |
|
This field displays the two-letter abbreviation for the account type. |
|
This field displays the closing amount for the selected account, which is equal to the difference between the opening amount and the total posted. Depending on the account default, this amount is reflected as either a credit or debit. |
|
Click the Lookup button to select the first period in a range of periods for which to display account information. |
|
Click the Lookup button to select the last period in a range of periods for which to display account information. |
|
This field displays the total unposted amount of manual journal entries for the selected account. Depending on the account default, this amount is reflected as either a credit or debit. |
|
Click the Lookup button to select the first year in a range of years for which to display account information. |
|
Click the Lookup button to select the last year in a range of years for which to display account information. |
|
This field displays the currency for the selected ledger ID. |
|
This field displays the currency for the selected account. This field is only available if the account currency is different from the currency for the selected ledger ID. |
|
Select this check box to display subledger information for the selected account. |
|
Select whether to display journal entries or transactions when drilling down to the subledger level. This radio set is only enabled if the Show Sub-Ledger Level check box is selected. This radio set is disabled if a ledger ID is entered in the Ledger ID field that is not the functional ledger for your system ID. |
|
Click this button to display subledger information if journal entry or transaction information is currently displayed. This button is only enabled if the Show Sub-Ledger Level check box is selected, and you drill down to view a specific journal entry. |
|
Click this button to drill down to journal entry or transaction detail information. If a journal entry or transaction is selected, when you click this button, the A/P Vouchers for Journal Entry, A/R Items for Journal Entry, A/R Transaction Detail for Journal Entry, I/C G/L Transactions for Journal Entry, or Journal Detail for Entry window appears. |
|
Select whether to display posted or unposted manual journal entries. These radio buttons are only enabled if you clear the Show Sub-Ledger Level check box. |
|
Select this check box if you want to only view transactions marked as tax only. |
|
Select how to drill down into displayed transactions. For the Inv subledger, select one of the following:
For the PUR subledger, select one of the following:
For the WO subledger, select one of the following:
For the A/R subledger, select one of the following:
For the A/P subledger, select one of the following:
These radio buttons are only available if the Transactions radio button is selected and you are viewing transactions for the Inv, PUR, WO, A/R, or A/P subledger. |
|
Select one of the following options for displaying monetary amounts:
These radio buttons are only available if the account currency is different from the currency for the selected ledger ID. |
|
This grid displays journal entry, transaction, or subledger information for the selected account, based on the selected criteria. Double-click a journal entry to display journal entry account or transaction detail information in A/P Payments for Journal Entry, A/P Vouchers for Journal Entry, A/R Items for Journal Entry, A/R Transaction Detail for Journal Entry, Foreign Currency Transactions for Journal Entry, I/C G/L Transactions for Journal Entry, Inventory Rounding Inquiry, Journal Detail for Entry, PO Receipts for Journal Entry, or PO Releases for Journal Entry. Double-click a subledger to display journal entry or transaction information in the grid. For transactions, the Drill Down radio set controls the drill down functionality. If you select the Show Sub-Ledger Level check box, you can use the up and down arrow buttons to switch between the subledger and journal entry or transaction information. If journal entry or transaction information is displayed in the grid, you can click the down arrow button to display the account or transaction detail information. |