cancel
Showing results for 
Search instead for 
Did you mean: 

Show available stocks for a specific warehouse in sales order

Former Member
0 Kudos

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?

View Entire Topic
kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

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

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

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
Active Contributor
0 Kudos

Hi,

Please refer this thread for solution

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

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
Active Contributor
0 Kudos

Thanks for feedback.