Skip to Content

formatted search Item No. on number series

Hi Experts,

Basically we have Multiple Series on item master but We have one Creator.

Is it possible to pick the Item numbering series remarks on Item Master UDF ,when select the series on item master.item-scrn.jpg

Thanks

Danish

item-scrn.jpg (253.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 23, 2017 at 06:54 AM

    Hi Mohd,

    This will fetch the Remarks field of Document numbering series of item as per the Series selected on Item Master

    try this

    SELECT T0.[Remark] FROM NNM1 T0 WHERE T0.[ObjectCode]='4' and T0.[Series] =$[OITM.SERIES]
    Add comment
    10|10000 characters needed characters exceeded