Who's On?

	Membership:
	Latest: Lauren Beeker
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5222

	People Online:
	Visitors: 55
	Members: 0
	Total: 55

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

Remove MNR PO Lines from Report

3 Replies

0 Subscribed to this topic

23 Subscribed to this forum

Sort:

Author

Messages

brupp

Veteran Member

Posts: 165

New Poster

8/18/2017 4:57 PM

Hello - I have a Crystal Report of open PO lines where PO qty < Received qty & have been asked to only include those lines without an invoice matched to the line. I found POLINE.MATCHED_NO_REC but do not understand the numeric values & they're not listed in the guru data dictionary. Does anyone know the values & their meaning, & will setting this field achieve the desired result in my Crystal Report? Thanks.

Kat V

Veteran Member

Posts: 1020

New Poster

Engaged Reader

Avid Reader

8/23/2017 5:33 PM

POLINE.MATCHED_NO_REC is a quantity. From your description - I think they want you to have POLINE.MATCH_QTY = 0

brupp

Veteran Member

Posts: 165

New Poster

8/28/2017 3:37 PM

Hi Kat - Yes that's what I was thinking but Infor actually kind of advised against it due to unreleased invoices. My next thought was to have them bump up the crystal report against MA236 & do a vlookup to eliminate the lines they do not want to see.

Kat V

Veteran Member

Posts: 1020

New Poster

Engaged Reader

Avid Reader

9/5/2017 12:18 PM

I think I disagree with Infor. If it is unmatched, it isn't on POLINE?

I thought I had a query showing me invoices on purchorder not on poline but I either didn't save it or it was another table. (We had an issue with an 810 batch ages ago and I had to hunt them all down.)