• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Remove MNR PO Lines from Report

 3 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
brupp
Veteran Member
Posts: 165
Veteran Member
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
Veteran Member
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
Veteran Member
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
Veteran Member
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.)