93 Update A/R from the Address Book

This chapter contains the topic:

93.1 Updating A/R from the Address Book

Navigation

From Accounts Receivable (G03), enter 27

From A/R Advanced and Technical Operations (G0331), choose Update A/R from Address Book

If you change selected address book information for a customer, such as the number of the parent company, you must update the A/R ledger. To do so, run Update A/R from Address Book.

Each transaction in the A/R ledger includes:

  • Customer alpha name

  • Customer alternate payer address number

  • Parent company address number

  • Address book category codes (1-10)

You run this program before you print statements or run Credit Analysis Refresh. If you change the parent number and do not run Update A/R from Address Book, your A/R statements might not be correct due to duplicate credit/cash records for each of the different parent numbers.

Depending on the size of your A/R Ledger table (F0311), run Update A/R from Address Book after work hours. Run Update A/R from Address Book frequently to ensure that the A/R Ledger contains up-to-date information.

93.1.1 Example: Updating A/R from the Address Book

The following example illustrates the problems you might encounter if you change parent numbers and do not run Update A/R from Address Book.

On June 1, your company, Model Company, sends invoice 4455 to A&B Electric Motor Service (A&B) for 150.00. A&B, customer number 4006, is an individually owned company not associated with any parent or child company.

Figure 93-1 Invoice to A&B Electric Motor Service

Description of Figure 93-1 follows
Description of ''Figure 93-1 Invoice to A&B Electric Motor Service''

  • On June 10, you assign A&B Electric Motor Service the parent address of 5709, Erickson Electric.

  • On June 15, Model Company sends invoice 5683 to A&B Electric Motor Service.

Figure 93-2 Invoice to A&B Motor Service Not Updated in Address Book

Description of Figure 93-2 follows
Description of ''Figure 93-2 Invoice to A&B Motor Service Not Updated in Address Book''

If you do not run Update A/R from Address Book before you process statements, and you process them by parent company, two invoices for A&B will appear on two separate statements.

93.1.2 Updating A/R Category Codes

You can use Update A/R from Address Book to globally update the A/R category codes in the A/R ledger (F0311). This program will update the A/R ledger with the Address Book category codes (AC01 - AC10) with values from the Address Book file (F0101). If you do not want to have one or more of these category codes updated when this program is run, you must protect the fields from update in the processing options.

93.1.3 Processing Options

See Section 117.1, "Update A/R from Address Book (P03802)" for more information.