Need FMS for Closing Stock in sales Order.

[former_member261836]

Hi EveryOne,

Thanks you  very much for all your help. in one of my client I have made FMS for closing stock in sales order document where formula is my RDR1.Quantity - RDR1.OnHand fields in sales order.

Please this FMS and calrify me where I am wrong.

"SELECT $[RDR1.onhand].number\] - $[RDR1.Quantity].number\]"

Thanks &Re grads

Vedanth

[Johan_H · Accepted solution]

Hi Vedanth,

Nagarajan's solution should work, but also:

SELECT $[RDR1.onhand.number] - $[RDR1.Quantity.number]

A possible error might be caused by timing. Meaning that the FMS may be triggered before the RDR1.OnHand and/or RDR1.Quantity field gets a value.

This you can try to solve with FMS refresh settings and/or with the ISNULL statement or a CASE statement.

Regards,

Johan

[former_member261836]

Hi Johan

Thank you very much "Mr. Nagarajan" solution is working.

regards

Vedanth

[kothandaraman_nagarajan]

Hi,

Please try this,

SELECT $[$38.33.number]-$[$38.11.number]

Thanks