formatted search Item No. on number series

[MD1]

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

[former_member312729 · Accepted solution]

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]

[MD1 · Accepted solution]

Thanks Sir