On Hand Quantity

[anu_uma]

Hi All,

Is there any report to check the ON-Hand-Quantities of all the Items available ???


TIA

[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

[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

[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

[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

[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