cancel
Showing results for 
Search instead for 
Did you mean: 

FMS for Subtraction of Two Fields Value

Former Member
0 Kudos

Hi Experts,

I had made 3 UDF (U_AS_PER_CHALLAN, U_Rec_Qty,U_APPROVE_QTY) by name of As per Challan, Received Quantity & Approved Qty in row level of GRPO

I want FMs should be

As per challan - Received Quantity = Approved Quantity

The final Value should be printed in the third UDF's i.e. Approved Quantity

pls guide me for this fms.

Thanks & Regards,

Pankaj Sharma

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Pankaj Sharma,

Try this:

SELECT $[PDN1.U_AS_PER_CHALLAN.number\] - $[PDN1.U_Rec_Qty.number\]

Thanks,

Gordon

Answers (1)

Answers (1)

Former Member
0 Kudos

Thank You very much Sir.. The FMS Works