Forums
Lawson Business Intelligence/Reporting/Crystal
Remove MNR PO Lines from Report
Author
Messages
brupp
Veteran Member
Posts: 165
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
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
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
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.)