Hello Jeff, All the best. Now I know who to ask when I start digging into SFA :)
Regards, Emad On Mon, Jul 15, 2024 at 7:39 PM Jeff Christensen <jchristen...@1wa.org> wrote: > Thanks for everyone's feedback. > > I have gone through most of the online documentation for both users and > devs. > > Emad, I think your overall sentiment that I need to dig into DB and code > is sound. > > Regarding using the CostComponentCalculations I am also stuck with our > current business model. I am trying to at least have a plan for how I would > implement our current business practices even if I take it slowly with some > simplifications. > > Our business model has us doing most sales (and thus production) annually > for our customers. This also drives our supplier costs in that we use our > renewal forecasts to set our production targets which sets our volume > discounts from our suppliers. > > I am in the process of setting this up in Ofbiz. > > In SFA create Sales Forecasts for each renewal target customer. With a > break down of product volume that they will purchase. > > In Products set up the supplier component prices. Set up Price Rules based > mostly on volumes. > > Set up the Costing Rules based on taking the Forecasts and calculating how > much it would cost to manufacture an amount to meet the Sales Forecasts. > > > -----Original Message----- > From: Emad Radwan <eradwan1...@gmail.com> > Sent: Sunday, July 14, 2024 1:51 AM > To: user@ofbiz.apache.org > Subject: Re: Cost calculations for product manufacturing > > Hi, > > I agree that the concept of Custom Methods is a great way to customize > specific calculations but I also think it's an advanced concept that you > only tackle if needed. Make sure first that your requirements can't be > covered in CostComponentCalculations. Ofbiz provides many structures to > configure costs on the level of BOM - Material -, Routing Task, and Product > in general. The code first considers these configurations before checking > if a custom method is defined. > > From the demo data, costs are configured for product 'PROD_MANUF' that has > a Routing, one Routing Task, and a Bill of Materials. You can check that in > the relevant costs screens under Products, Fixed Assets and Manufacturing. > > Or, if you like me understand better from the data itself, you can check > the following tables - from web tools -: > > ProductAssoc -> BOM > CostComponent > CostComponentCalculation > WorkEffortCostCalc -> links a routing task to a calculation > ProductCostComponentCalc -> same but for product level > > This is not the whole picture and maybe not 100% correct as I'm not an > Ofbiz expert but it will tell generally how costs are configured. > > The real challenge for me currently if someone can help is how to decide > on the numbers in a cost calculation; I mean, based on what you put the > fixed and variable parts in a cost calculation. > > Regards, > Emad > > On Sat, Jul 13, 2024 at 11:43 PM Omar Abdullwahhab < > omar.abdullwah...@gmail.com> wrote: > > > Also here is a link for the beginners tutorial > > > > https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Tutorial+-+A+B > > eginners+Development+Guide > > > > On Sat, Jul 13, 2024 at 11:28 PM Omar Abdullwahhab < > > omar.abdullwah...@gmail.com> wrote: > > > > > Hi Jeff, > > > Here are some notes that may help. > > > 1. regarding the first question, what you have seen is in xml > > > containing calcop element , > > > for ofbiz its called Minilang which you can call it an > > > intermediate programming language that you can use it to make small > > > programming tasks (business logic), > > > and later this XML element will be interpreted by Java code, > > > and for your information this MINIALNG will be deprecated as per the > > > ofbiz community and will be replaced by groovy scripts. > > > ( 2. & 3 ) . regarding to the second and third question I know that > > > you seem to be very new to the OFBIZ like me , so take the time to > > > read the getting started for both developers and business users, > > > Here is a link > > > https://cwiki.apache.org/confluence/display/OFBIZ/Home > > > > > > > > > On Sat, Jul 13, 2024 at 9:18 PM Jeff Christensen > > > <jchristen...@1wa.org> > > > wrote: > > > > > >> Hi Emad, > > >> > > >> I really appreciate the answer especially when I wasn't clear with > > >> my screen shot. You answered my question. > > >> > > >> I have some follow up questions: > > >> > > >> 1) The productCostPercentageFormula definition does the calculation > > >> via the "calcop" element. Where can I find information regarding > > >> how this mechanism works? i.e. What operations are allowed and syntax? > > >> > > >> 2) I am trying to undestand the Ofbiz theory of cost calculations. > > >> I > > can > > >> see the screens for "Costs" in the Product listing. There is a lot > > >> of functionality there. Is there any good documentation on how to > > >> use that functionality? > > >> > > >> 3) Another qustion about custom extensions. When I look at the > > >> example Routing Tasks call TASK_COST there is an Estimate Calc Method > called " > > >> Example task formula (qty * estimatedMilliSeconds * 10)". I have > > >> only > > found > > >> the string localization for this in CustomMethod.description.6000. > > >> But I don't know where the actual custom method is? > > >> > > >> Thanks. > > >> > > >> -----Original Message----- > > >> From: Emad Radwan <eradwan1...@gmail.com> > > >> Sent: Saturday, July 13, 2024 2:21 AM > > >> To: user@ofbiz.apache.org > > >> Subject: Re: Cost calculations for product manufacturing > > >> > > >> Hello Jeff, > > >> > > >> The screenshot you included isn't visible to me so I'll assume that > > >> you're talking about cost component calculation 'GEN_COST_CALC' > > >> with the description 'Overhead cost (5 percent of total cost) for > general costs'. > > >> > > >> This cost calculation references custom method 'Formula that > > >> creates a cost component equal to a percentage of total product > > >> cost' that needs > > to > > >> be defined first in the CustomMethods entity. I'm not sure if > > >> there's a screen to maintain that but you can see this from web tools. > > >> > > >> > > >> > > https://demo-stable.ofbiz.apache.org/webtools/control/FindGeneric?enti > > tyName=CustomMethod > > >> > > >> One of the fields in the custom method is CustomMethodName which in > > >> this case 'productCostPercentageFormula' for custom method > > 'PROD_PERC_FORMULA'. > > >> > > >> If you search in the code you'll find it as follows: > > >> > > >> <service name="productCostPercentageFormula" engine="simple" > > >> > > >> location="component://product/minilang/product/cost/CostServices.xml" > > >> invoke="productCostPercentageFormula" auth="true"> > > >> <description>Formula that creates a cost component equal to a > > >> percentage of total product cost</description> > > >> <implements service="productCostCalcInterface"/> > > >> </service> > > >> > > >> > > >> <simple-method method-name="productCostPercentageFormula" > > >> short-description="Formula that creates a cost component equal to a > > >> percentage of total product cost"> > > >> <set field="productCostComponentCalc" > > >> from-field="parameters.productCostComponentCalc"/> > > >> <set field="costComponentCalc" > > >> from-field="parameters.costComponentCalc"/> > > >> <set field="inputMap.productId" > > >> from-field="productCostComponentCalc.productId"/> > > >> <set field="inputMap.currencyUomId" > > >> from-field="parameters.currencyUomId"/> > > >> <set field="inputMap.costComponentTypePrefix" > > >> from-field="parameters.costComponentTypePrefix"/> > > >> <call-service service-name="getProductCost" > in-map-name="inputMap"> > > >> <result-to-field result-name="productCost"/> > > >> </call-service> > > >> <!--set field="productCostAdjustment" > > >> value="${parameters.baseCost > > >> * costComponentCalc.fixedCost}" type="BigDecimal"/--> > > >> <calculate field="productCostAdjustment" type="BigDecimal" > > >> decimal-scale="6"> > > >> <calcop operator="multiply" > field="costComponentCalc.fixedCost"> > > >> <calcop operator="get" field="parameters.baseCost"/> > > >> </calcop> > > >> </calculate> > > >> <field-to-result field="productCostAdjustment"/> > > >> </simple-method> > > >> > > >> > > >> So I believe this is the workflow for adding and using > > >> > > >> mew custom methods. > > >> > > >> > > >> Regards, > > >> > > >> Emad > > >> > > >> > > >> On Sat, Jul 13, 2024 at 12:14 AM Jeff Christensen > > >> <jchristen...@1wa.org > > > > > >> wrote: > > >> > > >> > I am trying to understand how Ofbiz can use custom cost > calculations. > > >> > This is probably a big picture question where I don’t understand > > >> > how custom functions are created and installed. > > >> > > > >> > > > >> > > > >> > If I look at the demo data I see that there is an option for > > >> > “Cost Custom Method ID” > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > Where is that function defined? > > >> > > > >> > > > >> > > > >> > How could I make my own? > > >> > > > >> > > > >> > > > >> > Thanks > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > > > > > > > -- > > > > > > *عـمــر عـبد الــوهــــاب* > > > > > > *جــوال : 0550677295* > > > > > > > > > -- > > > > *عـمــر عـبد الــوهــــاب* > > > > *جــوال : 0550677295* > > >