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 is attached to a PO that already has an activated GRNhave 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)) <> ''
Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.Related articles
| Filter by label (Content by label) |
|---|
| showLabels | false |
|---|
| max | 5 |
|---|
| spaces | J7UG |
|---|
| showSpace | false |
|---|
| sort | modified |
|---|
| reverse | true |
|---|
| type | page |
|---|
| cql | label in ("po","grn","line_not_found","purchase","goods_received_note","purchase_order","order") and type = "page" and space = "J7UG" |
|---|
| labels | Purchase_Order Purchase Order PO Line_Not_Found GRN Goods_Received_Note |
|---|
|
...