Issue/Symptom/Question

Crystal report to review open Accounts Receivable (AR) for our customers.

Applies To

Penta for Windows

Crystal Report - Accounts Receivable - Open Account Listing

Billing & Accounts Receivable

Resolution/Fix/Answer

This report lists information about each accounts receivable invoice that has an open balance as of the report date. Open balances are aged based on the invoice date. The report includes all transactions that affect the accounts receivable balance, including billings, cash receipts, credit memos, and retention.

Report Code: ac_ar_OpenAccounts_p124_cr11.rpt

Available Parameters:

Example Report Results:

Fields

Customer ID - The ID of the customer to which the invoice was issued.

Customer Name - The customer’s name.

Invoice Location - The customer’s invoice location code and associated description.

Contact - Includes the phone number, name and email address for the primary contact at the customer’s invoice location.

Work Site Location - The location at which the work was performed. This displays the following information if different from the invoice location, work location code/work location description/first line of the location address/location city. This is only applicable for balances related to a work order or maintenance contract.

Job Description - This depends on the entity you are billing:

• Job = Job name

• Work Order = Work order description

• Maintenance Contract = Maintenance contract description

• On Account Entries = Transaction description

• Sales Order = Users first initial/Users last name/Parts Sales

Customer PO # - The customer PO # entered for a work order, maintenance contract, or sales order. This is blank for job transactions.

Project Manager - Id of the project manager for job and work order transactions. This is blank for maintenance contract transactions.

Salesperson - Id of the salesperson for job, work order, and maintenance contract transactions.

Invoice # - The invoice number.

Check # - Check # for cash receipt entries applied against the invoice.

Days Outstanding - The number of days the invoice has been outstanding. Calculated as: Report date – Invoice date

Date - The invoice date for invoices and credit memos. This is the posting date for cash receipts.

Trans Type - This identifies the source of the transaction, which includes the following:

• BILL – Original Invoice Amount

• SCHG – Service Charge Amount

• ADJ – Credit Memo Amount

• CASH – Cash Receipts Amount

• ACCT – Payments Applied on Account

Total Amount - The amount for the transaction type.

0 – 30 Days - The invoice amount where the invoice is between 0 and 30 days old.

31 – 60 Days - The invoice amount where the invoice is between 31 and 60 days old.

Over 60 Days - The invoice amount where the invoice is over 60 days old.

Retention - The retention amount.