Administration, Core Financials, and Project Accounting

[MSAruze]

I having issues importing a journal entry created from ADP.  Can anyone tell me the correct format including headers needed to import ADP entry?  Thank you

[reneeb]

Hi MSAruze

Did you get this one fixed?

If you are using the GL batch Import utility you can find the record layouts in MAS 500 Help for that.  Search for:

Batch Header Record Layout

Journal Header Record Layout

General Ledger Transaction Record Layout

Journal Footer Record Layout

Batch Footer Record Layout

You can have multiple journals in a batch, but only one batch in a file.

The layouts are for ASCI (fixed length) records, so they get a little long if you use the fixed length.

We use an API which worked for version 7.05 and is still working for 7.30.4.  We can also use the GL Import Utility with these files with delimited selected as the file type (.del is the file extension) and the below delimited format.  The fields are in the same order as the layouts for the ASCI file, there are double quotes around every field (even numeric) followed by a comma, skipped fields require a set of double quote followed by a comma as well.

"@HDR","BATCH","20110630","FY 2011 AP 10 Journal Import"

"@HDR","JOURNAL","JE","1"," "

"000000000000000000","","2011","10","20110630","1","","","PL","comment","","","","USD","-15.99","","","","SOA"

"423010410100010010","","2011","10","20110630","1","","","PL","comment","","","","USD","15.99","","","","SOA"

"@END","JOURNAL"

"@END","BATCH"

Good Luck!

[asiegel]

We also use ADP and take advantage of their gl interface product.  We export a csv file from ADP, then copy and paste the fields into MAS500 dataporter to perform the import.