Don't try to track a suppliers inventory. Since it is not your assets, it
will mess up accounting. But here is what you can do:
Setup an external process that reads the suppliers XML/CSV file to
determine current inventory levels of the supplier. If their inventory
falls below a minimum level (determined by you), you can "age out" the
product by updating the following ofbiz tables:
Product: product_id -> sales_discontinuation_date
ProductCategoryMember: product_id -> date_thru (all records)
For low inventory, set the above fields to a date in the past (i.e.
01-01-1980), which turns off the ability to add to cart. It should also
prevent the product from showing up in searches as well. For adequate
inventory, set the above dates to blank or a date in the future
(01-01-2038).
If you want to track (just for info only) the last-known suppliers
inventory, you can add/update the following:
ProductFacility: product_id + facility_id -> last_inventory_count
You can then read the suppliers last inventory count from the back-end. As
far as I can see, it doesn't mess with accounting.
The are probably better ways of doing this. Maybe someone else can chime
in.
On Wed, Mar 6, 2013 at 3:47 AM, Sanjeev Gupta <
[hidden email]>wrote:
> If a suppliers drop-ships to fulfill customer orders, is there a way by
> which
> we can track / manage suppliers inventor in ofbiz so we don't accept orders
> more that what the supplier has ?
>
>
>
>
> -----
> Rgds
> Sanjeev
> www.sanjeevg.com
> @sanjeevgcom
> --
> View this message in context:
>
http://ofbiz.135035.n4.nabble.com/Drop-shop-supplier-intentory-tp4639716.html> Sent from the OFBiz - User mailing list archive at Nabble.com.
>