Skip to Content
0
Dec 29, 2021 at 05:57 AM

FMS with column identification is not working

137 Views Last edit Dec 30, 2021 at 10:24 AM 2 rev

Sir while using SAP B1 Sales Order, on header level, I am trying to call CardName with FMS, so I used these codes

SELECT distinct T0."CardName" FROM OCRD T0 INNER JOIN ORDR T1 ON T0."CardCode" = T1."CardCode" WHERE T1."CardCode" =$[ocrd."CardCode"]<br>

The codes work fine no issue but when I use below codes then codes do not work

SELECT distinct T0."CardName" FROM OCRD T0 INNER JOIN ORDR T1 ON T0."CardCode" = T1."CardCode" WHERE T1."CardCode" =$[$139.4]<br>

I used correct column identification $[$139.4] like shown in image

untitled.png

Please help

Attachments

untitled.png (53.8 kB)