1. Accounts Receivable Implementation Guide
  2. Understanding Address Book Information for Customers

Understanding Address Book Information for Customers

When you generate invoices, either manually or automatically from another system, certain address book information, such as the customer's alpha name, is written to each record. The JD Edwards EnterpriseOne Accounts Receivable system uses the address book information for many processes, such as printing statements and reports, and for inquiry programs. When address book information changes, you can update invoice records by running the Update A/R from Address Book program (R03B802).

Depending on the size of the Customer Ledger table (F03B11), you might want to run Update A/R from Address Book during off-peak hours. Run this periodically, especially before running aging reports or printing statements, to ensure that the Customer Ledger table contains current information. (Release 9.2 update) You should run the Update A/R from Address Book when changes are made to the Customer Master for parent numbers, credit manager, or collection manager. However, if you use the Customer Ledger Inquiry program to search by parent number, and parent numbers are changed frequently in the Address Book, you might want to run Update A/R from Address Book nightly.

The system updates these fields in the F03B11 table:

  • Payor (PYR), based on the processing option on the Updates tab.

    The system retrieves the value for the Payor from the Alternate Payor field (ARPY) in the Customer Master by Line of Business table (F03012). If the Alternate Payor field is blank, the system retrieves the value from the Address Book Number field (AN8).

  • Alpha Name (ALPH) from the Address Book Master table (F0101).

  • Parent Address Number (PA8) from the Address Organization Structure Master table (F0150).

  • Alternate Payee (AN8J), based on the value of the Send Statements To (STTO) field in the F03012 table.

    The address book number that the system assigns to the Alternate Payee field depends on the value of the Send Statements To field. For example, if you send the statement to the customer (value of C), the system updates the Alternate Payee field with the customer's address book number (AN8). If you send the statement to the parent (value of P), the system updates the Alternate Payee field with the address book number of the parent (PA8) from the Address Organization Structure Master table.

  • Category Codes 1-10 (AC01-AC10), from the F03012 table.

  • Collection Report Y/N (COLL), from the F03012 table.

  • Credit Manager (CMGR) from F03012 table (Release 9.2 update).

  • Collection Manager (CLMG) from F03012 table (Release 9.2 update).

The system updates these fields in the Receipts Header table (F03B13):

  • Alpha Name (ALPH), based on the setting of the processing option, from the F0101 table.

  • Parent Address Number (PA8) from the Address Organization Structure Master table.