FMS

[former_member209725]

Hi Experts,

Have a look on this FMS :

SELECT T0.[U_Drg_No] from oitm t0 inner join por1 t1 on t0.itemcode = t1.itemcode

where t0.itemcode =$[por1.itemcode]

This is working properly only for child items, If Production Items comes( BOM Code) then this FMS is not returning any data.

For Example . If Item Code is not a BOM Code then its working if Item Code Also a BOM Code with Drg. No. then FMS is not returning data.

I am sorry if My details creating some confusion.

Plz help with needful changes.

Regards,

Ravi

[Former Member · Accepted solution]

Hello Ravi,

You dont need to joining here because you are pick master data.

Just make FMS like

-

---

SELECT T0.U_Drg_No from oitm t0 where t0.itemcode =$[por1.itemcode]

-

---

Thanks

Manvendra

[former_member209725 · Accepted solution]

Hi Manav..

Thanks for reply.

Solved.

Regards,

Ravi

[Former Member]

Hi Ravi,

You can have an universal FMS for this:

SELECT T0.U_Drg_No from oitm t0 where t0.itemcode =$[$38.1.0\]

Thanks,

Gordon

[former_member209725]

Hi Gordon..

Thanks for such helpful reply.

You are always very helpful.

query solved.

Regards,

Ravi

[Former Member]

HI

The table for parent item code(BOM) was "OITT" and for the child table was "ITT1"....

so u try with these table names