TR500 - 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

jerrybrennan

New Member

Posts: 0

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

Posts: 3366

New Poster

Engaged Reader

Avid Reader

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.

jerrybrennan

New Member

Posts: 0

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

Posts: 3366

New Poster

Engaged Reader

Avid Reader

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.