The C3 - Account Detail folder in Customer Consolidated Inquiries (ibis_su45) displays all open accounts receivable (AR) items, including open invoices that are paid in full for the customer entered in the Header Section. These open items remain on this folder until Paid Invoice Purge (ibis_ar87) program runs. Once AR87 runs, the invoices are no longer open and are only visible on the C4 - Payment History folder in SU45.

The following list defines the fields and buttons on the Account Detail folder:

• For more information on an invoice/credit note from the list box, highlight the invoice line and click on the Invoice button (hover over the word invoice). Invoice History Consolidated Query (ibis_in45) automatically opens for the invoice/credit note currently highlighted in the list box.

  TIP: Double-clicking on a line in the list box automatically opens IN45.

• To view payments made against an invoice in the list box, highlight the invoice line and click on the Payments button (hover over the word Payments). The Payments window opens displaying the reference number (check or credit note number), the date and the payment amount.
  • If no payment has been made, the following message displays: "There is no Payment against this Reference. OK". Click OK to close the message window.

• If the invoice has installment terms applied, highlight the invoice line and click on the Installments button (hover over the word Installments). The Installments window opens displaying the installments, the due date and the payment amount. The details of the installments are set up in the A/R Terms Codes (AR03) (ibis_art) table.

• You can create a Collection Letter using the Create Collection Letter icon. When you click on the icon, the automated 'Collection Letter' within Microsoft Word automatically opens. To customize the Collection Letter, edit the Microsoft Word Document Template located in:
  c:\winsol\forms\su45collection.dot

  You may wish to keep a backup copy of the letter to ensure that it can be restored in the event that you move from one system to another or are required to re-install your client software.

  To share the customized template, forward a copy of the template to each user requiring the changes and replace the existing c:\winsol\forms\SU45Collection.dot.

• You can sort the items in the list box using the Sort by drop down list. Valid options include:
  • Invoice Number
  • Invoice Date (YYYYMMDD)
  • Invoice Date Descending

• The field to the right of the 'Sort by' field allows you to determine the starting value for the items in the list box. This field is dependent on the 'Sort by' field, for example:
  • If you select the invoice Number as the 'Sort by', then an invoice number is entered in this field and the list box will begin with that invoice Number.
  • If you select invoice Date as the 'Sort by', then you enter a date in this field and the list box will displays all invoices starting with that date.

• The list box displays all outstanding open AR items. There are 9 columns in the list box:
  • Reference - invoice or credit note number
  • Terms
  • Date - the invoice Date
  • Debit
  • Credit
  • Balance
  • Overdue
  • Customer
  • Name

  Double-click on a line in the list box to open IN45.

  The 'Overdue' column includes the number of days the payment is overdue (from the current system date). The letter in this field represents the AR Terms code assigned to the sales order or direct bill, as maintained in A/R Terms Codes (ibis_art):

  • R - Regular
  • I - Installment
  • S - Special
  • IS - Installment Special
  • QI - Quick Payment Installments

• The section below the list box is the AR aging summary section. It ages the open AR items according to the 'Aging Control Method' (Date or Oldest) selected in Company Control Initialization (CC00/Accounts Receivable). This section also displays the total value. Note: the aging represents OVERDUE balances based on the terms of each item.