Skip to Content

User defined Query for Warehouse availability Stock Query

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

sq.png (17.9 kB)
so.png (18.3 kB)
s0-1.png (10.8 kB)
so-v.png (14.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 23 at 02:09 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 23 at 02:25 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 23 at 02:28 PM

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

    Add comment
    10|10000 characters needed characters exceeded