Skip to Content
0

User defined Query for Warehouse availability Stock Query

Apr 23 at 01:26 PM

26

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Nagarajan K Apr 23 at 02:09 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Justice Lawer Doku Apr 23 at 02:25 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Apr 23 at 02:28 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Still getting same message in SO when I am adding.

so-p.png (4.8 kB)
0