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



Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos


Try this:

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

Thanks & Regards,


Answers (0)