Remove MNR PO Lines from Report

Sort:
You are not authorized to post a reply.
Author
Messages
brupp
Veteran Member
Posts: 165
Veteran Member
    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
      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
        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
          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.)
          You are not authorized to post a reply.