1. General Accounting Implementation Guide
  2. Using Real-Time Summarization in the Account Inquiry by Object Account Program (P09201)

Using Real-Time Summarization in the Account Inquiry by Object Account Program (P09201)

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 by Object Account 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 processing option 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, currency code, and company, and totaled by currency code and company.

  • If the Currency Code processing option 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, company, and posted code or just posted code, and totaled by currency code and company.

  • If the Currency Code processing option is off, 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 company and posted code, and totaled by company.

  • If the Currency Code processing option is off, 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 company and posted code or just posted code, and totaled by company.

  • 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 company.

If you enter a value in the As If Curr Code field on the Work With Account Ledger by Object Account 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 by Object Account form, or you can select a record to view the detailed transactions on the Work With Account Ledger by Object Account 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 by Object Account 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.

If the ledger type is not CA or YA and you select a record on the Account Ledger Summary form, the system defaults the value from the Posted Code and Company fields from the selected record on to the Work With Account Ledger by Object Account form, but not the value from the Currency Code field. If the ledger type is CA or YA and you select a record on the Account Ledger Summary form, the system defaults the values from the Posted Code, Company, and Currency Code fields from the selected record on to the Work With Account Ledger by Object Account form.