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 Send Private Message
Posts: 24
Basic Member
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 Send Private Message
Posts: 76
Veteran Member
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 Send Private Message
Posts: 76
Veteran Member
Field values:

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

Brad
willz06jw
Basic Member Send Private Message
Posts: 24
Basic Member
Great that's perfect.  Thanks for your help!

Will
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member

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).

Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health