Prev
Next
Forums Lawson S3 HR/Payroll/Benefits

TR500

Sort:
You are not authorized to post a reply.
Author
Messages
jerrybrennan
New Member
Posts: 2
New Member
10/27/2006 4:07 PM
    When processing the above program I received two error messages
    1. Completion date / / is invalid
    2. Course NAME is not in effect

    In table PATRACKDTL effective date = 1/1/2000
    end date 1/1/1753

    In table PACOURCE effective date = 1/1/2000
    end date = 1/1/2020

    format in TRNLOAD date-completed - yyyymmdd



    Thanking you in advance for your help
    John Henley
    Senior Member
    Posts: 3348
    Senior Member
    10/27/2006 4:43 PM
      Based on the workdef for TR500, the date format for that file, TRNLOAD, should be mm/dd/ccyy not yyyymmdd.
      If you fix that, both errors should go away.
      Thanks for using the LawsonGuru.com forums!
      John
      jerrybrennan
      New Member
      Posts: 2
      New Member
      10/30/2006 4:08 PM
        John
        Stilll getting the same error messages. The workdef in our PROD & CONV is expressed as yyyymmdd and the TR500ws file is the same. Tried to change with no luck.
        Any suggestions?
        Thanks for your help.
        John Henley
        Senior Member
        Posts: 3348
        Senior Member
        10/31/2006 12:51 PM
          In the workdef for TR500 / TRNLOAD, press F6, then select "Define File Attributes". On that screen, you will see the date field format and separator. To make it easy as possible, you should match your incoming CSV file to match these.
          Thanks for using the LawsonGuru.com forums!
          John
          You are not authorized to post a reply.