Thanks Jacopo, I'll check that out more carefully before I proceed. Skip
-----Original Message----- From: Jacopo Cappellato [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2008 10:39 PM To: user@ofbiz.apache.org Subject: Re: Multiple Supplier Prices You can also associate the SupplierProduct records to the Agreement entities (see the fields in the SupplierProduct entity; you may also define more than one agreement with your supplier; there are also screens to manage this information) This may help, Jacopo On Apr 3, 2008, at 6:17 AM, [EMAIL PROTECTED] wrote: > Yep, saw that, but how about when you get a special promotional > price or you > get a discount from list price for a quantity or you have an > agreement for a > price when the order exceeds a dollar value. > > I have written a service that gets the lowest price so I can have > promo > prices. > > I am writing an Economic Ordering Quantity (E.O.Q. in retail parlance) > routine that needs to know all the possible available costs for the > computation to be successful in ording the quantity that results in > the > highest profitability for the item. > > SupplierProduct suffices for 95% of my needs, but I have a few costs > that > are agreement based (I can manually convert the "discount from list" > ones by > supplying the quantity 1 price and let the operator do the math). > > I was hoping for something as comprehensive as the price calculation > routines that exist for the shopping cart and the sales price. > > With some luck, lots of folks will be using Ofbiz and that will > include some > of our suppliers who will offer us the price flexibility found in > the sale > prices for Ofbiz which of course become our costs. > > Thanks for the insite though, it is always appreciated. > > Skip > > -----Original Message----- > From: David E Jones [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 02, 2008 8:14 PM > To: user@ofbiz.apache.org > Subject: Re: Multiple Supplier Prices > > > > There is already a field on the SupplierProduct entity for quantity > breaks. > > -David > > > On Apr 2, 2008, at 6:49 PM, [EMAIL PROTECTED] wrote: >> Has anyone given any thought to or better yet, has any work been >> done on the >> issue of multiple supplier prices. For example, you might get price >> 1 for >> quantity 1, a lower price for 10x, and a still lower price for 100x. >> >> I have come up with my own scheme (SupplierProductCost) based on the >> ProductPrice table (but related to SupplierProduct instead of >> Product). I >> am about to embark on wholesale changes to the Requirements code to >> implement this. However, I thought I'd ask to see if others have >> done or >> thought about it. >> >> If there has been, I'll move this over to the dev mailing list. >> >> Skip >> >> >> No virus found in this outgoing message. >> Checked by AVG. >> Version: 7.5.519 / Virus Database: 269.22.1/1352 - Release Date: >> 3/31/2008 >> 10:13 AM >> > > > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.519 / Virus Database: 269.22.1/1352 - Release Date: > 3/31/2008 > 10:13 AM > > No virus found in this outgoing message. > Checked by AVG. > Version: 7.5.519 / Virus Database: 269.22.1/1352 - Release Date: > 3/31/2008 > 10:13 AM > No virus found in this incoming message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.1/1352 - Release Date: 3/31/2008 10:13 AM No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.1/1352 - Release Date: 3/31/2008 10:13 AM