Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

PO223 -crystal report retrieved received/full received POs

 2 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
GKLA
New Member
Posts: 2
New Member
9/16/2016 1:58 PM

    I am working on crystal report to pull only open POs from Purchorder and Poline (PO223) but i am getting received/full received POs too. Is there any field and value that determines POs are received/full received POs?

    JonA
    Veteran Member
    Posts: 1163
    Veteran Member
    9/16/2016 3:37 PM
      I use a formula to calculate the Open Quantity (OpenQ)

      {POLINE.QUANTITY} - {POLINE.CXL_QTY} - {POLINE.REC_QTY}

      Then use {@OpenQ} > 0 in my record selection.
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      GKLA
      New Member
      Posts: 2
      New Member
      9/16/2016 9:31 PM
        Thanks JonA!. I will update my report with above formula and will have it verified by end users.