on 06-08-2009 6:33 PM
The "In Stock" column displayed on the Sales Order row seems to show the total stock for that item across all warehouses.
Is there any way to restrict this to one or more specific warehouses (e.g. to exclude a 'Scrap' warehouse). I assumed that "In Stock" only counted stock in Nettable warehouses, but this does not seem to be the case.
Any help appreciated.
Chris Burr
Hi,
Regardless of the warehouse selected for the sales order in the
'In Stock' field the system will show the 'In Stock' quantity for
all warehouses.
In case your customer's business needs require a different method (for example they use a warehouse only for defected items) you may need to create a customized query in order to be able to see the 'In Stock' quantity per each warehouse.
For this customization please see the note 570827.
Kind Regards,
Jitin Chawla
SAP Business One Forum Team
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Jitin.
It looks like creating a user-defined value on the On-Hand column based on the following query will give me what I need
SELECT SUM(T0.OnHand - T0.IsCommited) FROM OITW T0 JOIN OWHS T1 ON T0.WhsCode = T1.WhsCode WHERE T0.ItemCode = $[$38.1.0] AND T1.Nettable = 'Y'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hai!
U can also able to see 'In Stock' of individual warehouse before adding your Doc.
After entering 'Item Code' Press Ctrl+Tab on Warehouse, this will dispaly a window which give u the information about 'In Stock','Orderd','Commited'.
Regards,
Thanga Raj.K
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
11 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.