1. General Accounting Implementation Guide
  2. Using Real-Time Summarization in the Account Ledger Inquiry Program (P09200)

Using Real-Time Summarization in the Account Ledger Inquiry Program (P09200)

Access the Account Ledger Summary form.

Account Ledger Summary form

In selected JD Edwards EnterpriseOne programs, you can use real-time summarization to quickly review aggregated totals, instead of scrolling to the end of the grid to review the totals.

On the Work With Account Ledger form, search for records to populate the grid and then click the Grid Aggregate icon on the LT 1 Amount or Units fields in the QBE line to view the aggregated totals. When you click the Grid Aggregate icon, the system displays the Account Ledger Summary form from the Account Ledger Summary program (P0911SW).

Review how the system displays values on the Account Ledger Summary form:

  • If the Currency Code constant is on, the ledger type is CA or YA, and you click the Grid Aggregate icon for the LT 1 Amount field, the values are aggregated by posted code and currency code, and totaled by currency code.

  • If the Currency Code constant is on, the ledger type is not CA or YA, and you click the Grid Aggregate icon for the LT 1 Amount field, the values are aggregated by currency code and posted code or just posted code, and totaled by currency code.

  • If the Currency Code constant is off and you click the Grid Aggregate icon for the LT 1 Amount field, the values are aggregated and totaled by posted code.

  • When you click the Grid Aggregate icon for the Units field, the values are aggregated by unit of measure and posted code, and totaled by the unit of measure.

If you enter a value in the As If Curr Code field on the Work With Account Ledger form, the system displays As If Currency totals when you click the Grid Aggregate icon for the LT 1 Amount field.

Note: As If totals in the summarized grid might not match with As If totals in the detail grid, due to rounding.

After you view the aggregated totals on the Account Ledger Summary form, you can click Cancel to return to the Work With Account Ledger form, or you can select a record to view the detailed transactions on the Work With Account Ledger form. If you select a record on the Account Ledger Summary form, the system populates the header fields and QBE fields of the Work With Account Ledger form to display the detail records associated with that aggregated total. You can delete or change the values in these fields if you want to search for additional records.