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

How to display particular customer with particular item code

21 Views

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.

Thanks.