Skip to Content
0

formatted search Item No. on number series

Aug 23, 2017 at 06:25 AM

28

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Balaji Selvaraj Aug 23, 2017 at 06:54 AM
0

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]
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Sir

0