Items In Stock

[Former Member]

Is there a way that in the sales order screen or sales quote screen under the form settings tab for in stock is there a way to define only one warehouse and not a global warehouse

[Former Member · Accepted solution]

Please explain how a udf would work? I need to know how much is in stock for each different item without having to drill down on each item to see if it's in stock in our main warehouse

[Former Member · Accepted solution]

Hi

Create a UDF in marketing document at the Row Level.

write the querry in the querry generator

SELECT T0.OnHand From OITW T0 WHERE $[$38.1.0] = T0.ItemCode and $[$38.24.0] = T0.WhsCode

then press altshiftF3 and put this querry in this field.

you will get what you want

Ashish Gupte

[Former Member]

You said you need only one warehouse. Then the FMS query would be:

SELECT T0.OnHand From dbo.OITW T0 WHERE $[$38.1.0\] = T0.ItemCode AND $[$38.24.0\] = T0.WhsCode

[Former Member]

You may need an UDF to reach your goal easily.

Thanks,

Gordon

[Former Member]

Under the tab settings screen there is a column called ( in stock ) once that is selected it will show the how much is in stock but the total in stock across all warehouses. Is there a way that I can define only one warehouse to show up on the in stock column

[Former Member]

Hi Ryandigitex,

In Warehouse field press CTRL + TAB it shows all the warehouses Instock details.

Regards

Jambulingam.P

[Former Member]

Hai!

Before selecting a whs in document rows, press Ctrl+Tab in whs field instead Tab. It will Pop a window where which you can get individual whs stock details.

Regards,

Thanga Raj.K

[Former Member]

Dear Ryan,

It will be great if you can elaborate more regarding your question.

From what I know, under the Form Settings > Document Tab > Table Tab, the Warehouse field is used to update all the rows in your document. To update individual rows in your document, just directly change the Warehouse code from the row level.

Hope it helps.

Warmest Regards,

Chinho