Skip to Content
0
Former Member
Dec 06, 2011 at 10:58 AM

Need a FMS Query on Sales Order!!!!

42 Views

Dear Experts,

I need a FMS query on SO with Following Conditions...

**Current Stock(UDF @Raw Level)

1.If InStock(as selected warehouse Quantity)>=Ordered Quantity Then Current stock Field should be taken Ordered Quantity.

2.If InStock< Ordered quantity Then Current stock should be taken InStock Quantity

Please provide me same...

Thanks in advance...