Hello Experts !!!

[Former Member]

We have an healthcare company and our products are sold on assessable value and MRP, also we have an Batch number management for all finished product. Please help me for FMS query as follows:

I have create one UDF for MRP on Item Master data(OITM) and I want to drag that MRP UDF directly to OBTN based on specific item code and for specific from and To Batch Numbers.

Request to please help me as this is very urgent.

[Former Member · Accepted solution]

Please help me to get this FMS query.

It is very urgent.

Thanks in Advance and Happy Diwali to all.

Regards,

Harshal Makwana

[kothandaraman_nagarajan · Accepted solution]

Hi,

1.Created UDF at OITM header level

2. Create second UDF at batch details window.

3. Assign below for second UDF to get OITM UDF value

SELECT T0.[U_TEST1] FROM OITM T0 WHERE T0.[ItemCode] = $[$40.1.0]

Thanks & Regards,

Nagarajan

[Former Member]

Dear Sir,

Thank you so much for the answer.

Regards,

Harshal Makwana

[Former Member]

Dear Nagarajan Sir,

Thanks for the answer. Can I update this FMS on Sales order as well?

Thanks and Regards,

Harshal Makwana

[kothandaraman_nagarajan]

Hi,

Yes. But slight change in FMS query:

SELECT T0.[U_TEST1] FROM OITM T0 WHERE T0.[ItemCode] = $[$38.11.0]

Thanks & Regards,

Nagarajan