cancel
Showing results for 
Search instead for 
Did you mean: 

Warehouse Stock levels

Former Member
0 Kudos

Forum,

When we process a sales order, the current stock level for an item is displayed. This is currently the total of all warehouses.

Is it possible to display the stock quantity of a single warehouse on the sales order entry screen?

Regards,

Juan

Accepted Solutions (1)

Accepted Solutions (1)

former_member204969
Active Contributor
0 Kudos

To show the quantity in the actual warehouse

1. Create a row level UDF field with type units and total and structure Quantity, the description e.g. u2018On warehouseu2019

2. Save this query:

Select T1.OnHand  From OITW T1
 Where $[RDR1.WhsCode] = T1.WhsCode and $[RDR1.ItemCode] = T1.Itemcode

3. Set the query as an FMS to the UDF field autorefreshing when the column Whse changes.

Answers (4)

Answers (4)

Former Member
0 Kudos

Dear Juan,

At the time of creation of sales order in warehouse column press Ctrl+TAB system show you actual stock position of your warehouse.

Dear All,

Please first suggest system function if its not fulfill the user requirement than definitely try to MAP system through UDF & FMS.

Regards

MANGESH PAGHDHARE

Former Member
0 Kudos

Hi everyone

How do you view stock levels from a sales order?

Former Member
0 Kudos

Hi Juan,

You need a UDF with FMS like:

SELECT T0.OnHand FROM OITW T0

WHERE T0.ItemCode = $[$38.1.0\] AND T0.WhsCode=$[$38.24.0\]

Thanks,

Gordon

Former Member
0 Kudos

Hi Juan.....

This can be achieved by UDF and FMS in that on line level.......

Regards,

Rahul