PO Transmitted Information - LawsonGuru.com

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

Kate Liamero

Veteran Member

Posts: 70

8/17/2006 12:02 PM

I am trying to do a crystal reprot where to get the actual transmitted date and time for EDI PO's. I have looked in both the poaudit and porevision files. The porevision file has the fields for Xmit date, Xmit time, Xmit tries but the fields are blank. Date shows for all records as 01/01/1700. Any ideas?? Also does anyone know how to convert lawson time to real time in crystal?? Time shows as 10220, or 110140 etc.

Thanks
Kate Liamero
New York Presbyterian Hospital
kad9025@nyp.org

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

8/17/2006 2:28 PM

Here's a function you can use to format the time:

StringVar strTime := ToText({ACTRANS.RUN_TIME},"######");
NumberVar intHH := ToNumber(Left(strTime,2));
NumberVar intMM := ToNumber(Mid(strTime,3,2));
NumberVar intSS := ToNumber(Mid(strTime,5,2));
Time(intHH,intMM,intSS)

Kate Liamero

Veteran Member

Posts: 70

8/17/2006 2:54 PM

Hi John,

When I place this into a formula in crystal 10 using oracle 9 ODBC the formula workshop opens and I get the following message:

The string is non-numeric

Message is for line 2 of the formula

ToNumber(Left(strTime,2));

thanks for all of your help

I use you data dictionary all the time when developing reports. Is there also similar documention available for the LOGAN product line??

Regards,
Kate

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

8/17/2006 4:27 PM

Hi Kate,

- Regarding the blank xmit fields in POREVISION, are you running PO122?

- What table/field are you trying to format with the time field? I just did that against a SQL server database w/o any problem, but don't have access to an Oracle database at the moment. Try commenting out the lines 2-5 and see what prints from the first line.

- I did do a data dictionary and ERD for Logan but never published it. One of these days I might.

John

P.S. You're killing me.