• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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.