PO64 - Open to Match Field

Hi Ardra. You will need to pull the detail from POLINE and complete formula's to provide the open to match and open to receive totals. You also will likely need the PURCHORDER table to provide you with additional detail. Hope this helps!

Hi Andra
This is a derived field. Formula is PO Received Qty - Matched Qty. All fields are in POLINE if I am not mistaken. (Sorry I dont have field names memorized)

Thank you for the info Stephanie and Mike.

Fair Warning - Open to Match can also be found on the receipt line. It's possible to Order 1, Rec 1, Match 1 on PO line and still have a Matched Not Received Qty 1 if the invoice only saw the PO and not the receipt.

If you do go to the receipt line, you need to make sure you are using some sort of SUM() function to account for PO lines with multiple receipts.

Kat,

I have run into this exact situation and have opened a Lawson incident but haven't been able to help me....

So If you end up with Order 1 Rec 1, Match 1 and still have a Matched Not Received Qty of 1 because the invoice saw the PO and not the receipt; what do you do to remedy this outstanding amount?

Thanks in advance for any pointers you can offer.

Kodi Larson

We've got a data corruption issue with some of our older POs, so I'm not the best source for this. We've archived the Receipt line, then added another new receipt which *should* clear the MNR.

This happened to us just this week when AP tried to match an 8 line PO. Lines 1-7 were received in full and half of line 8. The attempted match created a cost message on line 8 and seven "No receipts to match" messages for the other lines. I'd never seen this type of message. The buyer created a receiver for the remainder of line 8 and that was matched in full. The messages were answered for the other lines and AP released the invoice. When you drilled on the PO line and looked at the quantity detail those lines showed fully matched but also showed the same quantity in MNR. But if you looked at PO64 no MNR was on any of the lines. Drilling on the invoice showed only line 8 was matched. I created a receiving adjustment for lines 1-7 which was a pain because they were all stock and 4 of the lines didn't have sufficient SOH, then re-received the lines. The MNR went away, all receivers archived and all the lines closed. Still a bit messed up because the lines don't look matched on the AP side but the payment went out so we'll see if it causes any problems down the road.