Page 1 of 1
On Hand Quantity
Posted: Tue Jun 05, 2007 6:02 am
by anu_uma
Hi All,
Is there any report to check the ON-Hand-Quantities of all the Items available ???
TIA
Posted: Tue Jun 05, 2007 8:26 am
by ahmadbilal
You can check on-hand quantity by using navigation
Inventory - > on hand , Availability (Interface)
Or By Using Report
Item quantities summary
Locator quantities report
Subinventory quantities report
You can also use query as posted in Query
Posted: Tue Jun 05, 2007 8:33 am
by anu_uma
Hi Ahmad,
Thanks
But in the on hand qty we can check for individual item only na, is it possible to check for all the items???
Anyway thanks for the report details ........
Thnx
Posted: Tue Jun 05, 2007 8:38 am
by ahmadbilal
You can check all items by specifying from item and to item
Just pass Org Id in below query and get all item detail
http://erpstuff.com/topic.asp?TOPIC_ID=572&whichpage=3
Posted: Tue Jun 05, 2007 9:35 am
by admin
In addition check the following report,
Transaction historical summary
and enter current date in Rollback to this date.
Hope it will work for you for all items. thanks
Posted: Tue Jun 05, 2007 9:36 am
by anu_uma
Hi,
This is query is for functional purpose only and you have guided me to use from the backend also. Thanks for your guidance and help.........
Is there any difference in using the reports and queries? Reports also going to give the same values.....
Thnx