Upload to JDE

LisaE

Member
Has anyone done an upload to the JDE database using Client Access? We are looking to load beginning balance information into the Fixed Assets system, but don't want to have to key in several thousand items. I was thinking we could create a flat file from our existing FA system and then upload it to the F1201, but I'm not sure how to go about doing so.

Thanks

Lisa Eichelberger
 
Checkout using journalized budgeting for your beginning balance upload. It's
the same process as uploading a budget, just change the ledger type from BA
to AA....

--------------------------------------------
James G. Donahue
Manager, Applications & Development
Paramount Parks Inc.
(704) 561-8111
 
Whoops, sorry. Wrong system. I was thinking about the General Ledger....

JGD
 
Lisa, there are a number of ways of doing this, for example -

using DFU or similar, create one record in the F1201 with a couple of fields
containing data. Download this file to the PC and create a File Description
File in the process (.FDF extension). (As the record length of the F1201 is
too long to use a .PRN flat text file without wrapping, use .CSV (comma
separated variable) type in the transfer). Save your new F1201 data (from
Excel or whatever) as a .CSV file and you can then transfer the data to the
AS/400 using the .FDF you created in the dummy download process.

The other, probably easier, route is FTP. Save the file to upload as a flat
file (if doing this from Excel, note that you have to set the column widths
to match the fields exactly and ensure that data is correctly justified (ie,
Business unit, 12 chars, right justified) and that leading zeros in alpha
fields have not been dropped because Excel thinks they are numeric) and FTP
with a put command from a DOS session on your PC.

It is a simple process but full of traps for the uninitiated and the error
messages out of Client Access are not always helpful. If you need any
further info or assistance, just ask.

Regards
Ron Tuohy
RJT Information Systems Limited.
 
If you have MS Access you might consider transferring the existing data to
an Access data base and then use an update query to load the data into JDE.
Don't forget to multiply out the decimal places.

Mike
 
Lisa:
We converted some 30,000 fixed asset records and 170,000 Plant Maintenance
equipment records in 1999. We used a series of visual basic apps to mimic
keystrokes on the FA Master, Category Codes, Supplemental Data, and Beginning
Balance screens. It worked great. The VB apps read conversion files created from
our old systems, and virtually keyed the data into the JDE screens. This allowed
us to use JDE functionality to ensure the accuracy of mass data entry.

Hope this helps.

Peter Davis
Business Analyst
Newfoundland and Labrador Hydro




LisaE <[email protected]> on 19-04-2001 04:53:57 PM

Please respond to [email protected]

To: [email protected]
cc: (bcc: Peter Davis/NLHydro)
Subject: Upload to JDE



Has anyone done an upload to the JDE database using Client Access? We are
looking to load beginning balance information into the Fixed Assets system, but
don't want to have to key in several thousand items. I was thinking we could
create a flat file from our existing FA system and then upload it to the F1201,
but I'm not sure how to go about doing so.

Thanks

Lisa Eichelberger


--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=W&Number=9450
 
Back
Top