gltransrel upload - LawsonGuru.com - LawsonGuru.com Forums -

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

linda phillips

Advanced Member

Posts: 40

9/19/2006 12:25 PM

Has anyone uploaded files into gltransrel and have the system add a leading number to the file? We are 8.03 msp8,ser.pk 4 and we are trying to load a file into the system. It has taken a for an example a credit for 10.00 and made it 210.00. The system added a leading 2 to every number if it was a credit or a debit. If anyone could help shed some light on this, It woulds be appreciated

Sam Simpson

Veteran Member

Posts: 239

9/19/2006 7:12 PM

We use mercator map to reformat incoming file and create gltransrel upload file. This are all done by using scanfileclient/BCI procedure combination plus a ksh script that will impexp the
reformatted file and email's the users to run their GL165.

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

9/19/2006 10:57 PM

Linda, how are you uploading the file? Are you using Excel upload wizard? importdb? BCI?

linda phillips

Advanced Member

Posts: 40

9/20/2006 6:30 AM

I don't have microsoft add ins so it is a import db.

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

9/20/2006 4:25 PM

In that case, you should take another look at the CSV file you used . . .

linda phillips

Advanced Member

Posts: 40

9/21/2006 9:23 AM

Thanks, for the help. It was the CSV file that was causing the problem. File has gone in ok this morning.