Skip to Content
0
Former Member
Mar 17, 2009 at 07:41 AM

FMS Query

218 Views

Hi All,

I have created 2 UDFs

1. Instock as Quantity (Data Type)

2. Closing Quantity as Quantity (Data Type)

I need a formatted search in quantity field which is the difference of Instock and Closing quantity in quantity field

I wrote the following query

Select $[133.U_instock] - $[133.U_Closingqty]

But this is giving internal error.

should I select datatype as numeric instead of quantity?

Regards

Shashi

Edited by: shashi mantripragada on Mar 17, 2009 9:24 AM