User defined Query for Warehouse availability Stock Query

[millicentdark]

Dear Experts,

I want a user defined query for SAP Business One version for HANA that will show the warehouse stock availability in the Sales Quotation document and can be copied to Sales order document without giving error: "invalid number value"

I want this so that I can show before adding sales order the available stock in the default warehouse of the item.

Six is a UDF i created to handle the substraction seen below in Sales Quotation;

SELECT T0."OnHand" - T0."IsCommited" FROM OITW T0 WHERE T0."WhsCode" = $[$38.24.11] and T0."ItemCode" = $[$38.1.11];

I used the above query but I get an error when I copy to sales order and I want to add.

Sales Order UDF

Error when adding

Validation Query to avoid adding when Qty is more than Available which is my UDF "Six"

Please treat this as urgent. Please test in SAP Business One version for HANA environment.

Regards

Justice

[kothandaraman_nagarajan]

No, i have removed ; from your query. Please try again

[millicentdark]

Still getting same message in SO when I am adding.

[millicentdark]

Hello Nagarajan,

I used the same query in my question and I explained further the error I was getting.

Please attend to it again.

Regards

Justice

[kothandaraman_nagarajan]

Hi,

Try this FMS,

SELECT T0."OnHand" - T0."IsCommited" FROM OITW T0 WHERE T0."WhsCode" = $[$38.24.11] and T0."ItemCode" = $[$38.1.11]

Regards,

Nagarajan