Skip to Content
Former Member
Jan 22, 2016 at 02:09 PM

How to display particular customer with particular item code


Hi Experts,

One scenario, For particular customer they need particular item should be listed in the sales order.

So what i did it i have created user defined field in the item master table (OITM).In that field i gave customer code .

In sales order form, i added a FMS in the item code field.

FMS: SELECT T0.itemcode from oitm T0 where t0.u_custname = $[ordr.cardcode]

If i gave that particular customer code, it displays item code. But also add other item code and if i press tab button . It displays all item code.

It should not display any other item code and also restrict to non item codes.

Kindly give some guidance to me.