gltransrel upload

Sort:
You are not authorized to post a reply.
Author
Messages
linda phillips
Advanced Member
Posts: 40
Advanced Member
    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
    Veteran Member
      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
      Senior Member
      Posts: 3348
      Senior Member
        Linda, how are you uploading the file? Are you using Excel upload wizard? importdb? BCI?
        Thanks for using the LawsonGuru.com forums!
        John
        linda phillips
        Advanced Member
        Posts: 40
        Advanced Member
          I don't have microsoft add ins so it is a import db.
          John Henley
          Senior Member
          Posts: 3348
          Senior Member
            In that case, you should take another look at the CSV file you used . . .
            Thanks for using the LawsonGuru.com forums!
            John
            linda phillips
            Advanced Member
            Posts: 40
            Advanced Member
              Thanks, for the help. It was the CSV file that was causing the problem. File has gone in ok this morning.
              You are not authorized to post a reply.