I created this FMS query to pull the Blanket Purchase Order Free Text (Line) to the PO Line Free Text field.
It seems to fail on lines where the Blanket Order Planned QTY and Open QTY is equal - meaning that that line was not yet copied to a PO. Here my thinking of using POR1 might be flawed...
SELECT T1."FreeTxt" FROM POR1 T0 LEFT OUTER JOIN OAT1 T1 ON T0."ItemCode" = T1."ItemCode" AND T0."AgrNo" = T1."AgrNo" WHERE T0."ItemCode" = $[POR1."ItemCode"]<br>
Your assitance will be greatly appreciated,