Who's On?

	Membership:
	Latest: HireIQ
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5264

	People Online:
	Visitors: 241
	Members: 0
	Total: 241

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

PO64 query

3 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

pglibra

Veteran Member Send Private Message

Posts: 76

1/3/2019 12:31 PM

Good morning all,

I am trying to write a query in Access pulling data from PO64...specifically, the transaction types listed at the bottom of PO64 of either REC, INV and RET. What Lawson table can I find these item types listed?

Thanks

Ragu Raghavan

Veteran Member Send Private Message

Posts: 477

1/3/2019 8:24 PM

Looks like it is build in the logic. Look at PO64PD to see how it is coded:
MOVE "REC" TO LIH-DOC-TYPE.
MOVE "SUB" TO LIH-DOC-TYPE
MOVE PJL-DOC-TYPE TO LIH-DOC-TYPE
MOVE "RJ" TO LIH-DOC-TYPE
MOVE "AC" TO LIH-DOC-TYPE
MOVE "CB" TO LIH-DOC-TYPE
MOVE "INV" TO LIH-DOC-TYPE.
MOVE "CB" TO LIH-DOC-TYPE
MOVE "INV" TO LIH-DOC-TYPE.
MOVE "CB" TO LIH-DOC-TYPE
MOVE "INV" TO LIH-DOC-TYPE
MOVE "CB" TO LIH-DOC-TYPE
MOVE "INV" TO LIH-DOC-TYPE.
MOVE "CB" TO LIH-DOC-TYPE
MOVE "INV" TO LIH-DOC-TYPE.
MOVE "RET" TO LIH-DOC-TYPE.
153954 MOVE PTH-VEN-CLAIM-TYPE TO LIH-DOC-TYPE

pglibra

Veteran Member Send Private Message

Posts: 76

1/4/2019 11:57 AM

Good morning,
Not sure I know what you mean when you say it is built in the logic.
I have access to Lawson tables, such as PORECLINE, etc.
I am looking for the Field name that contains the text transaction type of REC/RET/INV, etc.
Is there such a table/field?

Thanks

JonA

Veteran Member Send Private Message

Posts: 1163

1/10/2019 1:30 PM

It depends on how much detail you need. You can find the line quantities in the POLINE table. REC is the receipt quantity; RET is the return quantity; INV is the matched quantity. But these are totals. If you need transaction detail like document numbers, dates and each transaction quantity (if there are multiple receipts or invoices for instance) you need to link POLINE to PORECLINE, PORETURNLN, and MAINVDTL.