Understanding the Customer Ledger Inquiry Program (P03B2002)
The Customer Ledger Inquiry program (P03B2002) enables you to quickly locate, review, and update invoices and receipts in the JD Edwards EnterpriseOne Accounts Receivable system. Use the fields in the header of the Work with Customer Ledger Inquiry form to narrow the search results. For example, you can:
Inquire on a range of invoice numbers.
Search for Open, paid, or all invoices.
Search by invoice date, due date, statement date, or G/L date.
Review invoice amounts in both the domestic and foreign currency.
Use the As If Curr Code field to review invoice amounts in an alternate currency.
Use the As Of Date field to review invoice amounts as of a specific date.
The Customer Ledger Inquiry program enables you to audit a customer's transaction history and determine the outstanding balance of a customer's account. After the system retrieves the invoices, you can review totals for the gross, open, foreign gross, and foreign open amounts in the detail area of the form by scrolling to the bottom of the form. The system displays the totals in a highlighted color.
From the Work with Customer Ledger Inquiry form, you can use the Form or Row menus to access the following Accounts Receivable programs:
Customer Master program (P03013) to add and revise customer information including:
Bank account
Who's who
Parent/child relationships
Invoice Entry program (P03B11) to revise invoice amounts.
G/L Distribution to review account distributions.
Speed Status Change program (P03B114) to update discounts and due dates.
Revisions Audit to review invoice revisions.
Revise Recurring to change recurring invoice information.
Receipt/Draft Details to review receipts that were applied to an invoice.
Receipt Entry to locate, review, add, and revise receipts.
Batches to approve and post batches.
Deductions to add deductions.
Work with Deductions to resolve deductions.
Account Status Summary to review credit and collection information.
Activity Log and Promises/Promises to review and add activities.
Customer Service Inquiry to add and review sales orders.
You might use other JD Edwards EnterpriseOne systems that create associated entries into the JD Edwards EnterpriseOne Accounts Receivable system, such as Contract and Service Billing, Real Estate Management, and Sales Order Management. The Customer Ledger Inquiry program enables you to review the originating system from which a transaction was created. You can use the Originating System field (OMOD) in the detail area of the Work with Customer Ledger Inquiry form and the Source System selection from the Row menu to access the original transaction. You might find this helpful, for example, when reviewing the original contract information for an invoice pay item when applying a customer's payment.