Hi Daniel This subject has come up before, and there have been some interesting ideas...
One idea that intrigues me, as it is the way I think about making an order, is if a business would setup a requirements/automatic purchasing system that would run periodically on a supplier by supplier basis instead of after every sale on an item by item basis. For example, setup a purchasing scan that runs through all the suppliers, and looks for items that need to be reordered. It might eliminate the need for all of the requirements data tables in the database, and instead could create orders automatically, or on-demand for any particular supplier. Additionally, for those companies that like to operate this way, the orders could easily be adjusted to meet minimum quantity or dollar values for price breaks or reduce the number of orders you're likely to need to place with a particular supplier by including items in the order that you are running lowish on. Rather than just ordering items that have a strict requirement, you would include items that are relatively low on. This might save you from needing to place another order as soon, and would probably cut down on shipping costs, but stocking would be a little more complicated since the orders would have few numbers of a larger variety of products. In other words, if you're already placing an order, why not include some of the other items that you're running low on. I believe a system like this might allow a business to reduce backorders, since most items would usually be reordered before the inventory actually reaches the minimum. A previous discussion on the topic. http://www.mail-archive.com/[email protected]/msg00675.html Another thread about combining Requirements, etc. http://osdir.com/ml/java.ofbiz.user/2005-11/msg00020.html Thanks -- Daniel *-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*- Have a GREAT Day! Daniel Kunkel [EMAIL PROTECTED] BioWaves, LLC http://www.BioWaves.com 14150 NE 20th St. Suite F1 Bellevue, WA 98007 800-734-3588 425-895-0050 http://www.Apartment-Pets.com http://www.Illusion-Optical.com http://www.Card-Offer.com http://www.RackWine.com http://www.JokesBlonde.com http://www.Brain-Fun.com *-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-
