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