1. Real Estate Management Implementation Guide
  2. Updating Invoices from the Address Book

Updating Invoices from the Address Book

When you generate invoices, either manually or automatically from another system, the system writes certain address book information, such as the customer's alpha name, 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 the 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 the R03B802 program during off-peak hours. Run this periodically, especially before running aging reports or printing statements, to ensure that the F03B11 table contains current information. You do not have to run it nightly, because the accuracy of programs such as Credit Analysis Refresh (R03B525) is not dependent upon the address book. However, if you use the Customer Ledger Inquiry program to search by parent number, and parent numbers are changed frequently in JD Edwards EnterpriseOne Address Book, you might want to run the R03B802 program nightly.

The system updates these fields in the Customer Ledger table (F03B11):

  • 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 Customer Master by Line of Business 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 Customer Master by Line of Business table.

  • Collection Report Y/N (COLL), from the Customer Master by Line of Business table.

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

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

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