Using Real-Time Summarization in the Customer Ledger Inquiry Program (P03B2002)

Access the Customer 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 Customer Ledger Inquiry form, click the Grid Aggregate icon on the Gross Amount, Open Amount, Foreign Gross Amount, or Foreign Open Amount fields in the QBE line to view the aggregated totals. When you click the Grid Aggregate icon, the system displays the Customer Ledger Summary form from the Customer Ledger Summary program (P03B11S).

When you view domestic amounts, the values in the Gross Amount and Open Amount fields are aggregated by customer number and company, and totaled by customer number and base currency. When you view foreign amounts, the values in the Foreign Gross Amount and Foreign Open Amount fields are aggregated by customer number, company, and transaction currency, and totaled by customer number and transaction currency.

If you enter a value in the As If Curr Code field on the Customer Ledger Inquiry form and click the Grid Aggregate icon for the Gross Amount or Open Amount fields, the system also provides values in the As If Gross Amount and As If Open Amount fields on the Customer Ledger Summary form. The As If values in these two fields are aggregated by customer number and company, and totaled by customer number and As If currency.

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 Customer Ledger Summary form, you click Cancel to return to the Work with Customer Ledger Inquiry form, or you can select a record to view the detailed transactions on the Work with Customer Ledger Inquiry form. If you select a record on the Customer Ledger Summary form, the system populates the header fields and QBE fields of the Work with Customer Ledger Inquiry 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.