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 some or all of the lines on the open GRN have been deleted from the linked PO.

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)) <> ''}

Problem

Solution

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