Updating Effective Dates on Address Book Records

Run the Effective Address Update (R01840) program to verify effective dates of addresses and to update corresponding supplier and customer records accordingly. The system stores the GeoCode in the Tax Rate/Area field of either the F03012 or the F0401 tables.

The Effective Address Update program does not update the supplier master and customer master records if any of these are true:

  • The Tax Explanation Code field is missing the correct code of S, U, or E.

  • The Tax Rate/Area field contains a value that is not a GeoCode or is blank.

  • A GeoCode cannot be assigned because of incomplete information or an address (city, state, and zip code) crossing multiple tax jurisdictions.

The system generates a report that displays both unmatched records and records that you might want to match. The system sends messages to the Work Center that identify unmatched records. Messages in the Work Center are sent to the user who is processing the batch report, based on the User ID. You will need to manually update these records.