Formatted Search in SAP B1 Hana

[former_member614487]

Dear Expert,

                      I had applied the following formatted search in the UDO form.Its working fine if I give the constant date parameter.The Moment I applied the Date parameter to be selected from the UDF(U_Date the result is coming Out zero.

SELECT sum (T0."InQty")- sum(T0."OutQty") FROM OINM T0 WHERE T0."ItemCode" = $[@STATIONROW.U_Product] and T0."Warehouse" = $[@STATIONROW.U_STATION]

and TO_DATE(T0."DocDate") < (select TO_DATE($[@STATIONROW.U_DATE]) from dummy)

Please suggest the solution.

regards,

PankajK

[Former Member · Accepted solution]

Hi Sir,

try below query

SELECT sum (T0."InQty")- sum(T0."OutQty") FROM OINM T0 WHERE T0."ItemCode" = $[@STATIONROW.U_Product] and T0."Warehouse" = $[@STATIONROW.U_STATION]

and TO_DATE(T0."DocDate") < (select TO_DATE($[@STATIONROW.U_DATE.DATE]) from dummy)

regards,

Raviraj

[former_member614487 · Accepted solution]

Thank you very Much Ravi..Its working fine now

regards,

PankajK