Skip to Content

Need a FMS Query for Item Master Property Name on Bill of material table

Hi All,

Need a FMS Query for Item Master Property Name on Bill of material table.

Screen Shot attached for you information.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jun 21, 2017 at 10:06 AM

    Hi,

    Please add remaining properties to below FMS. I had set quantity field to refresh automatically.

    select OITG.ItmsGrpNam from OITM CROSS JOIN OITG

    where

    (

    (OITM.QryGroup1 = 'Y' and OITG.ItmsTypCod = 1)

    OR (OITM.QryGroup2 = 'Y' and OITG.ItmsTypCod = 2)

    OR (OITM.QryGroup3 = 'Y' and OITG.ItmsTypCod = 3)

    OR (OITM.QryGroup4 = 'Y' and OITG.ItmsTypCod = 4)

    OR (OITM.QryGroup5 = 'Y' and OITG.ItmsTypCod = 5)

    )

    and Oitm.ItemCode = $[$3.1.0]

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 21, 2017 at 09:33 AM

    Hi Mohd Danish,

    Fms is for header or row level BOM

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 21, 2017 at 09:43 AM

    Sir FMS is req row Level Item Code

    Regards

    Danish

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 21, 2017 at 11:28 AM

    one more help is req. for production order row level

    Add comment
    10|10000 characters needed characters exceeded