Who's On?

	Membership:
	Latest: Hitman
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5208

	People Online:
	Visitors: 372
	Members: 0
	Total: 372

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

Using Lawson Queries to pull the transmission type from PO20 data (EDI or FAX?)

4 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

willz06jw

Basic Member

Posts: 24

9/9/2009 6:20 PM

Thanks for your help,

[I am using Lawson 9.0]

I am trying to use Lawson Queries in Excel

to pull the transmission type from the data for PO20.

For example: I need to know if the POs for last year were sent via fax, edi, or paper.

Thanks again for your help,
Will

Brad Schauer

Veteran Member

Posts: 76

9/10/2009 11:20 AM

Will,

I believe the field you are looking for is the PO Issue Method, it can be found on the PO20.2 (PO Header Options) screen, on the "Issue" tab.

The field is stored on the PURCHORDER table, field name ISSUE-METH.

Brad

Brad Schauer

Veteran Member

Posts: 76

9/10/2009 11:25 AM

Field values:

F = Fax
E= EDI
D = Do Not Print
P = Paper
I = E-Mail

Brad

willz06jw

Basic Member

Posts: 24

9/14/2009 8:29 PM

Great that's perfect. Thanks for your help!

Will

JonA

Veteran Member

Posts: 1163

12/17/2009 7:04 PM

Sorry I didn't see this sooner. But if you pull the PO issue method from PURCHORDER you will only return what the PO is set for at that time (the last revision). For example, if you have your PO10.2 record set to issue via EDI but your revisions are set to Paper or Do Not Print, your query may not return the kind of data you want. If you want to know how the PO initialy was issued (Revision 0) then query the POREVISION table and set your criteria to PO-REVISION=0. You can relate out to PURCHORDER to pull whatever other relevant data you need (but not POLINE- at least not with Addins, Crystal maybe).