Steve,
Works fine. We just finished, over the past 6 months, uploading close to
200,000 customers using the F0101Z1 file process from G01313. The process
works exceptionally well except that for Customers not all of the defaults
in the Data Dictionary loaded for some of the fields in the Billing
Instruction portion of the F0301 records, i.e. A5BACK, A5APTS, A5PLST to
name a few. This is probably due in part to the fact that when the Billing
Instruction fields were incorporated into the F0301 record not all of the
fields were added to the batch file servers.
The primary load work that has to be done is to determine the address book
codes (ABAC01- ABAC30) prior to the upload, especially if any of the codes
require a value (UDC table does not have a blank entry). The batch load
edit (in proof mode) will show you the errors of your efforts prior to
loading the records. However, when the proof report is clean it doesn't
show any total records to process or anything. Also, if the entries are
Customers then be sure that VOATR is a "Y" so that a Customer Record, F0301,
is added. And likewise if the entries are Vendors then have VOATP set to a
"Y" so that a Supplier Record, F0401, is added. (Forgot during one load and
had to remove a lot of "other" records in order to reprocess the load.)
The best guide available is Appendix C from the JD Edwards Address Book
Guide, either hard copy or CD Documentation, that describes the Batch Input
Setup. This chapter describes the required, conditional, optional, and
ignored fields in the batch load process. We then used MS Access, as we
could import the Excel file and clean up null fields and pre-process/edit
many of the fields in the Access file. Then we would create a link table to
the AS/400 file and use an Insert Query to load the file. May have been a
few extra steps but it allowed us to "work" on the upload file and if
necessary dictate the field attributes of the load file and strip or enhance
the data provided by the user. Also note that any of the ignored fields in
the F0101Z1 file can be loaded and after the update the file will contain
the assigned Address Book number. Then the information could be loaded via
SQL update or a simple update program.
Hope this helps.
George Smith
World A7.3, Cum10 - V5R1
Walco International, Inc.
Grapevine, TX
