If multiple matches are for the name search criteria you type on the Find Names screen, you can select the customer from list of names found on the Primary Address browse screen. Once you select the customer, you can then click the Select option on the Additional Customer Options dialog box to select that customer for the invoice search. Addr No. This optional field is used to pull data for invoices that are using additional addresses. Contract This is the contract number associated with the invoice. For/Loc This box contains general comments that print at the top of the invoice. This can be a difficult search option to use, unless your site has a policy to always put in standard wording or numbers in this field in the same location on every invoice. Once you have entered your search criteria, Accept. The program creates the active set of records based on your search criteria. Use the navigation bar at the bottom of the screen to move to the next record in the active set or click Browse to view all invoices in the list. Use the Output group ribbon buttons to output the browse screen or Invoice Inquiry records to a report. In addition, on the browse screen and the Invoice Inquiry screen, you can click Excel to export the set of invoices directly into Microsoft® Excel. On the Invoice Inquiry screen, you can also click Word to export the set of invoices into Microsoft Word. Click any of the following buttons to view additional invoice information, if required: Click Detail to access the table of detail lines on the screen. You can double-click a detail line to view more detailed information about it on the Invoice Detail screen. Click Audit to display the Invoice Master Audit screen and the audit record for the current invoice. Click History to display a browse screen of the payment history records for the invoice. You can double-click a record to view receipt details on the Payment History Receipt Display screen. User Defined to view the user-defined fields established on the Invoice Header User-Defined Fields screen, if applicable. Reports - Open Accounts Receivable by Revenue Account The Open Accounts Receivable by Revenue Account program creates a report of open accounts receivable by general ledger account for General Billing invoices. Use the following steps to create the report:
as of the date you type in the Date box. Bill Year Range These boxes indicate the range of bill years for the bills to include in the report. Type the beginning and ending years in the boxes or leave the default values of 1111 to 9999 to include bills for all bill years in the report. Customer Range boxes indicate the range of customer ID numbers for the bills to include in the report. Type the beginning and ending ID numbers in the boxes or leave the default values of zero to all nines to include bills for all customers in the report. AR Code Range These boxes indicate the range of AR codes for the bills to include in the report. Type the beginning and ending codes in the boxes or leave the default values of a blank value to all Z’s to include bills for all AR codes in the report. AR Category This list indicates the AR category for the bills to include in the report. Bill Type This list indicates the type of bills to include in the report: A—Annual C—Certificate of Change D—Discovery H—Half-year I—Initial K—Rollback N—Certificate of Occupancy O – Omitted P – Apportionment Q – 1/4 Year R – Regular/Original S – Supplemental T – 3/4 Year U – Utility X – Suspense
Select the Exclude check box to exclude this bill type from the report. Special Condition This list indicates the special condition code for bills to include in the report. Select the Exclude bills with this special condition code. Minimum Bill Balance This box indicates the minimum balance for bills to include in the report. Include Activity Occurring After Aging Date If you select this check box, the program includes activity that occurs after the aging date. Calculate Interest If you select this check box, the program calculates interest as of the aging date. Aging Based On The option selected under Aging Based On indicates whether to include overdue bills in the report based on their due date or bill date. Days Past Due If any of the boxes under Days Past Due are selected, it directs the program to include bills that are that many days past due: 1 – 30 31 – 60 61 – 90 91 – 120 Over 120 Print Credit Balances—If you select this check box, it directs the program to include customers that have credit balance bills in the report. Zero Balances—If you select this check box, it directs the program to include customers that have zero balance bills. Report Type This indicates the type of report to create: Detail Summary AR Code Summary