Cost Workbench roll, wiped out standard costs, thoughts on how?

We are preparing for Go Live and practicing imports. We had a hiccup with Bill of Materials not having the UoM and some were off. As I fix them, we run a Cost workbench and roll up parts. This morning a user ran the costing workbench without selecting the costing method and ran it on all manufactured parts. We use Standard costing, and I had DMT’ed in the Standard costs through the Cost Adjust DMT. Some costs were set to zero as a result of the Costing Workbench being run without selecting the costing method.
We have test re-run the costing workbench with selecting the costing method and it seems fine, just wondering what went wrong that it reset the values.
Settings used that zeroed out the costs.


I checked the transaction log against one part and can see that indeed it was the costing workbench that zeroed out the standard cost.

Selected Tran Date Type Part Description Quantity UOM Trans Quantity Trans UOM Amount Bin Type Costing ID Costing Method Mtl Unit Cost Reference User ID
TRUE 11/5/2025 ADJ-CST 100-00001 Tape, applique, white, .010x24x340 ft 0 Roll 0 Roll 0 1 S 0 Manager
TRUE 11/5/2025 ADJ-CST 100-00001 Tape, applique, white, .010x24x340 ft 0 Roll 0 Roll 0 1 S 1,927.17 Manager
TRUE 11/10/2025 ADJ-CST 100-00001 Tape, applique, white, .010x24x340 ft 0 Roll 0 0 S 1,927.17 Standard Cost roll-up JGates
TRUE 11/10/2025 ADJ-CST 100-00001 Tape, applique, white, .010x24x340 ft 0 Roll 0 0 S 0 Standard Cost roll-up JGates

We think we are fine as long as we remember the run costing workbench with Standard cost entered, but want to make sure we avoid this in the future.

HELP?

3 Likes

You avoid it by running the costing workbench report (forget what it was) and it shows you the total change% and when you see that some of your parts are going down 100% you pause and don’t click post. You could probably make some BPMs or something too to stop you or warn you about $0 costs… idk just spit-balling here.

I always run the change % report and also grab a current inventory from partbin for the sites that use the costID that I’m rolling and check what the total change will be at that level too.

2 Likes

Subsequent runs of Costing workbench we have been careful to make sure and select Standard costing method (don’t judge me, LOL). All has been fine. We are also laboring to make sure our default costing methods get updated on the parts, I fell prey to setting the Costing Method on the Part table and not on Part Plant (Ugh!), but that is all fixed now.

1 Like

There you go Tory