Purchase Order Line Not Found when opening GRN

Problem

The user has opened a GRN and the following error occurs "Purchase Order Line Not Found".

This may occur when the open GRN is attached to a PO that already has an activated GRN.

Solution

Run the following SQL script to fix the link between the GRN and the PO.

UPDATE RE_Lines
SET OrderLineID = ''
WHERE RE_Lines.OrderLineID NOT IN (SELECT OrderLineID FROM PO_Lines)
AND RE_Lines.OrderLineID IS NOT NULL
AND LTRIM(RTRIM(RE_Lines.OrderLineID)) <> ''

Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.Related articles

• Page:
  Purchase Order Workflows and Statuses
• Page:
  Unactivated GRN Reversals appear incorrectly in the Transaction History tab of inventory
• Page:
  REINF010 - Receival Slips Uninvoiced report is including reversals - 7.00.175 and earlier
• Page:
  MNT40001 Purchase Order report
• Page:
  Supplier part no. not appearing on purchase order lines