How do I correct the situation where an purchase order was created and the a receipt was posted against that Purchase Order and then the Item number was changed. The Purchase order is still open and gives an error when posting saying " Item No. must be equal to "OldItemNumber" in Purch. Rcpt. Line: Document No-107002, Line No. =20000. Current value is 'newItemNumber'.
I cannot delete the item receipt nor cancel the purchase order.
Is there a way to manually edit the Purchase Order Lines on the SQL Table and correct the item number?