You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by "Kevin M. Myer" <km...@gmail.com> on 2007/01/24 21:45:46 UTC

Inventory reports

Can anyone provide me with an overview of what inventory summary
reporting facilities exist in OfBiz?  I'm working with the demo data
and have added a few products to that.  So I want to query my
facilities (individually and in aggregate) and find out, as of a point
in time, what my inventory will be.  For the products I've added of my
own, I'm struggling a little bit to find them most of the time.  I'm
creating them through production runs and at first, I thought maybe
all production runs disappeared somewhere :)  However, upon further
investigation, I've found that they are indeed in the warehouse, but I
can't find them using normal searches.  For instance, if I go to the
Facility module and choose the Facility, I can search for Finished
Goods under Inventory.  The only results that show up are the demo
data items, but none of the products that I added show up.  However,
if I goto the Catalog module, and work my way down through the
categories to the products, and choose Inventory through that means, I
come up with a list of Inventory Items for the product.  Likewise, if
I work through an order screen that has the particular product on it,
I can click on the Inventory link for that item and get to the same
place.

I can also obtain some information under the
EditFacilityInventoryItems screen, but this lists all the inventory in
a historical format, more like each inventory-related transaction.

So is there an easy way to get a summary inventory report, by product,
per facility and across all facilities?

Thanks,
Kevin

Re: Inventory reports

Posted by Jacopo Cappellato <ti...@sastau.it>.
Hi Kevin,

you just have to add a ProductFacility entry for your products and they 
will appear in the Inventory list.
You can do that from the Catalog->Product->Facilities screen

Jacopo

Kevin M. Myer wrote:
> Can anyone provide me with an overview of what inventory summary
> reporting facilities exist in OfBiz?  I'm working with the demo data
> and have added a few products to that.  So I want to query my
> facilities (individually and in aggregate) and find out, as of a point
> in time, what my inventory will be.  For the products I've added of my
> own, I'm struggling a little bit to find them most of the time.  I'm
> creating them through production runs and at first, I thought maybe
> all production runs disappeared somewhere :)  However, upon further
> investigation, I've found that they are indeed in the warehouse, but I
> can't find them using normal searches.  For instance, if I go to the
> Facility module and choose the Facility, I can search for Finished
> Goods under Inventory.  The only results that show up are the demo
> data items, but none of the products that I added show up.  However,
> if I goto the Catalog module, and work my way down through the
> categories to the products, and choose Inventory through that means, I
> come up with a list of Inventory Items for the product.  Likewise, if
> I work through an order screen that has the particular product on it,
> I can click on the Inventory link for that item and get to the same
> place.
> 
> I can also obtain some information under the
> EditFacilityInventoryItems screen, but this lists all the inventory in
> a historical format, more like each inventory-related transaction.
> 
> So is there an easy way to get a summary inventory report, by product,
> per facility and across all facilities?
> 
> Thanks,
> Kevin