Hi One other hack that might work well for this would be to create an excel xml spreadsheet with the products and a calculation for the price.
When the price changes, you could just re-import the affected products, and excel would do whatever calculations you wanted. Or you could create a few dozen xml files for different gold prices, and just import the appropriate one when the price changes. I wouldn't normally suggest such a hack normally, but it seems like it might be appropriate in this situation. Daniel On Sat, 2006-06-24 at 03:34 -0700, BJ Freeman wrote: > I would use the manufacturing module and create BOM, so you have all the > components of the item. > from there the price can be determined. currently the pricing used lifo, > fifo, averaging. so there many need to be a change in the code for > following gold prices. > > > Rohit Sureka sent the following on 6/23/06 10:51 PM: > > hi, > > > > i was curious if one could automatically calculate product price based on > > material and labor cost. > > > > To give a better perspective of what i mean, i will brief about our > > products. We basically sell silverware and gold jewelry items. The price of > > the product is based on cost Silver and Gold, plus the labor charges to > > manufacture it which is a percentage of the metal price. Typical pricing > > method would be Gold price + 30%(just for illustration), this if metal > > costs are $100, the minimum sale price has to be $130 . Now bullion prices > > have been very volatile over the past few weeks. From $71 an ounce to $57 > > approx. This completely changes the pricing and cost structure and a store > > which has thousands of products, it would be a tiring task to manually > > update the prices of all products. > > > > Therefore is it possible to define a material like gold, which price per > > ounce can be updated as frequently as needed. The product will have a > > feature denoting the metal weight, such that it calculates the cost of gold > > based on the metal weigth in the product and adds to it the labor price to > > fianlly arrive at the minimum sales price. > > > > For e.g. > > > > Standard metal rate is $50 per ounce. > > Product X has 1/2 ounce of gold. > > Thus the minimum product price is $50/2 * 1.30 = $32.5. > > > > I think it is possible to do this in the standard ofbiz download, i.e. > > without modifying the code, but have not been able to figure out how to do > > it. > > > > Any suggestions or comments will be appreciated. > > > > Thank you. > > > > rohit > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam protection around > > http://mail.yahoo.com -- 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.SatelliteRadioZone.com http://www.Cards-Visa.com http://www.ColorGlasses.com *-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-
