cancel
Showing results for 
Search instead for 
Did you mean: 

FMS Query?

Former Member
0 Kudos

Hi Experts,

i have createrd a UDF on the Item master data and i have also ceated 2UDF's on the delivery note.

I have created a FMS with a query that updates the UDF(Opening Readings) with the value from Item Master data.

Now for me to achieve the second UDF on Delivery i want a query that will subtract the Opening readings UDF from Quantity entered.

I want the subtraction to happen immediately the quantity is changed.

Attached is the images for your assistance

Urgent help will be appreciated

Regards

Justice

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try this:

SELECT $[DLN1.U_Openingreading.number] - $[$38.11.number]

Thanks & Regards,

Nagarajan

Answers (0)