Show available stocks for a specific warehouse in sales order

[Former Member]

Hi All,

running v9.0 pl11.

In the sales documents, on the lines, the users have a column showing the total stock availability per item, across all warehouses. For product A1, stock for warehouse WA shows an available quantity of 10 and stock for warehouse WB shows an available quantity of 7. If I go to the sales order document, the available quantity shows 17.

How can I get a column that shows the stocks for each warehouse alongside the total stock availability on my sales order?

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please try with below settings under Document settings-->General tab.

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Thanks Nagarajan, it brings the item availability check which is a "interesting workaround" and I voted your answer as helpful.

But imagine having a list of 300 items to input into a sale order or delivery. If there was a column with the specific stock as I mentioned the users would visually instantly know what quantity to key in.

So my question remains, how can I have a column showing the quantities available for a specific warehouse, and not the overall total across all warehouses?

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please refer this thread for solution

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Thank you sir, you have put me on the right path to tailor the exact solution I was after!

I even got to learn the FMS along as a bonus!

Here is my query that I linked to the newly created UDF available on rows of marketing documents:

    SELECT T0.[OnHand] + T0.[OnOrder] - T0.[IsCommited] FROM OITW T0 WHERE T0.[ItemCode] = $[$38.1.0] AND T0.[WhsCode] = '01'

'01' being the warehouse I want to show the available quantities for!

[kothandaraman_nagarajan · Accepted solution]

Thanks for feedback.