PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 09/05/2017 8:18 AM by  Kat V
Remove MNR PO Lines from Report
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
brupp
Sr. Data Analyst
UC Health
Veteran Member
(303 points)
Veteran Member
Posts:127


Send Message:

--
08/18/2017 12: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
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    08/23/2017 1:33 PM
    POLINE.MATCHED_NO_REC is a quantity. From your description - I think they want you to have POLINE.MATCH_QTY = 0
    brupp
    Sr. Data Analyst
    UC Health
    Veteran Member
    (303 points)
    Veteran Member
    Posts:127


    Send Message:

    --
    08/28/2017 11:37 AM
    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
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    09/05/2017 8:18 AM
    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.