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
