We would like to take our price lists and do a mass update of the standard material cost.
I have created an updateable BAQ which updates the value of the standard cost, but does not perform the action of creating a cost adjustment within part tran, which I am told will screw up the general ledger.
What fields/row update options need to be added in order to accomplish this?
The Epicor way to mass update standard cost is the Costing Workbench. You create a costing group, update costs to your price list, and post. It will make your adjustments to inventory. It will also roll the costs up to higher level Parts in the BOM.
Do you have DMT? Before doing our standard cost roll up, we do a DMT to update purchased parts with their more recent costs. Then you do the cost roll up through the costing workbench to flush those costs up to the top level.
A lot depends on exactly what you mean when you say, “screw up the general ledger”. If you use the Costing Workbench the Cost Adjustment program, or any updateable BAQ that affects the PartCost table, you will modify the standard cost on the parts involved, meaning if any of them are currently in inventory their value will change, which will have a GL effect. If all you want to do is change your price list, then do not use any of those processes.
Exactly what costs are you trying to update, and what is your end goal?
you can use DMT in two ways to fix costs:
The goal was to update all raw material’s material standard cost. Apparently purchasing has been using Cost Adjustment and doing each one at a time which sounded terrible.
After some testing, it appears as though Mark’s suggestion of using the costing workbench accomplishes what we were trying to do without having to recreate the wheel. For 3000 or so parts, is there a faster way than exporting to excel, update values in excel from indexed list of parts, copy values, paste update?
We do not have DMT to my knowledge.
When testing the BAQ I created above, it updated the standard cost in the system but did not create any kind of transaction, so our costing team was nervous there would be a phantom change that was unreported if we ever wanted to look back at the changes or if there were any issues.
Thank you all.
you could create a BAQ that exports all the fields you want and grab that into Excel… then give the Excel file to Purchasing. When they are done updating it, then you can use DMT to import that excel file to update all the records.
