Duplicate Address Book Entries

Good Morning List,

We have a situation where multiple address book numbers exists for the same
vendor and customer. An example is a vendor ABC corp. AB# 155677, ABC Inc. AB#
155987 and so on. We also have AP history with the two address book numbers,
which means there are records in the AP and GL tables. We want to keep one
address book number in the Address Book and update the AP and GL tables
(history) with the correct address book number. Oracle’s financial package
calls this an Address Book Merge program. I know that JD Edwards has no
program that does this operation. I have seen this situation at other clients
in the past but I have not resolved it programmatically. We have numerous
duplicates so there is no other solution. I am curious if anyone has solved
the duplicate Address Numbers programmatically and how this was accomplished?
Was it solved with a batch process and an interactive process for day-to-day
use? If anyone has created a interaction application did you use a fix-inspect
or a headerless-detail?

--
Senior Technical Consultant
17611 E. Tennessee Pl.
Aurora, CO 80017
Work 303-337-1906
Cell 303-885-1405
Fax 303-306-1800

We are manually setting one AB record to say do not use and from then on using only the other AB#. But you can set a parent on the A/B records and use queries to tie all of the numbers together.