Skip to Content
0
Sep 16 at 01:26 PM

FMS pulling Free Text from Blanket Order to PO

67 Views Last edit Sep 28 at 05:14 AM 2 rev

Experts,

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>

2022-09-16-8-22-33.png

Your assitance will be greatly appreciated,

Marli Schutte

Attachments