Built an assembly with multiple manufactured components. Each one has it’s own method and material. When I quote the assembly, it doesn’t seem to bring in any of the labor associated with each component method. I haven’t put the raw material costs in yet - I think that is done in the supplier price list, correct?
Just trying to figure out how to get my costs in some kind of usable format for quoting purposes
The labor comes from the method, it is the estimated amount of time to manufacture (quantity x prod standard). Material costs will come from the cost that is on the material. If you are standard costing and have not set the standard yet, it will be 0.
I did a cost adjustment, however the material cost is still showing as $0.00
There is nowhere on the part itself to enter a cost, which to me is completely stupid. Why can’t it be as easy as putting a material cost in a box on the part itself lol. Epicor makes you do 87 exercises half of which don’t do anything useful. It’s taken me an entire weekend to build a simple assembly, and I still can’t get accurate costs.
I could have had this done 300 times over using a spreadsheet, but I am trying to do it right, and I am lost. Losing time, quote is late, I am dead in the water. Thanks Epicor. You’re sure helping my company.
Also - the BOM cost report is garbage. It’s jumbled up, can’t read it. Is this some bs SQL crap that I can’t edit? If so, do i have to sub contract and pay someone $300 an hour to make a report that a human can read? I really hate Epicor.
The BOM cost report actually captures everything where the quote worksheet does not. Why?
Still can’t find where to enter in actual part cost in, anywhere
It is Cost Adjustment, but if you are Standard costing, I believe you need to do a roll. Do you know what your costing is?
I know what the purchase price is, yes. Everything should be Avg but the problem is that these are all new entries and have no purchase history, so they don’t have an average cost yet.
A cost adjustment will add the cost in for you.
Ok thanks. I tried that and the fields are still zero dollars.
Will keep at it, just super frustrating to do something that should take seconds
If you provide screen shots of where you are running into problems, we could probably help you better.
Did you put the cost in the correct field in cost adjustment?
Here’s a BOM Cost Report, the items FWP3000.120.011 and .012 each have assembly items on them that utilize P.1.48.96.A36 in their methods. They’re sub-assembly weldments all in the FWP3000.120.60.3K.F.001 assembly. When I built the method it did not allow for “sub assemblies” just operations and materials.
First pic below of the BOM cost report in excel, circled are the areas where material cost should be tallied.
Below that is the Cost Adjustment screen for P.1.48.96.A36
Below that is “View costs” in Engineering Workbench for FWP3000.120.60.3K.F.001 and material cost is zero.
Bottom pic is the method for FWP3000.120.60.3K.F.001
Did you recalculate the quote worksheet after doing the cost adjustment? It’s under actions/refresh worksheet
Yes, I tried that. Quote aside, it’s not updating material boxes in the BOM Cost Report itself, or when selecting “view costs” in the Engineering Workbench.
Your materials may be average, but is the finished good standard?
@anon99908839 Best is to delete all and the re-add get details. That is usually the only way the quote worksheet will update for our configuration
I have been unable to get raw material costs to show up in a quote worksheet. I even tried a cost roll up although I may not have done it correctly.
I did a Cost Adjustment to all the raw material parts. I am still getting zero dollars for cost on the assembly items associated.
For perspective - this quote would normally take me a few hours. I spent 4 days beating my head in trying to make Epicor work, and failed. I was late delivering the quote and risked a $200,000 job trying to do this correctly… and could not. At this point Epicor his hurting us more than helping.
I am not sure what to do at this point. We are lost, and cannot correctly use this software.
I want to sincerely thank Epicor and our implementation partner (you know who you are) who sold us something that is hurting us. Really appreciate that guys. Unless we pay someone $200/hr and spend another $50k, we’re sunk. Cudos. 20 years in the business and it’s come to this. I am at a loss for words.
Is this a configured item and/or something with manufacturing details? Have you done a cost roll? The Quote will not load updated information unless you refresh the line items… Delete All in the tree view then Get Details again or readd them…
