Cannot Update Part Cost Method

We are trying to change the costing method attached to all of our purchased raw material parts within epicor. We copied live over to pilot and then ran a couple different DMT’s. First, we just tried to force the costmethod to change from FIFO to AVG. we ran the dmt without a problem and could see that the part master cost method was now AVG. when we ran the stock status report, we saw that they were still set to FIFO. we then checked cost adjustment which also said it was set to FIFO. our second DMT was to zero out the qty on hand and then re-run the FIFO to AVG dmt. this was done after another copy over of live to pilot. this also did not work and the part master cost method and the cost adjustment method are different.

Is there another location or is there more criteria we need to change so we can modify our costing method?

The Costing Method on the Part screen is the default to use for the Site, which is where it is actually used.

image

1 Like

our default for our site is already set. we need to change parts that have existed for years from FIFO to AVG. these materials have purchases attached to them also.

@Joe_Tahan I looked at my DMT run from changing cost methods and I did an adjust quantity out then used Part Combined template to change master and site cost methods then adjusted quantities back in.

If this doesn’t work then you need to use the UI to change a part’s cost manually and then DMT those steps for all parts.

1 Like

Hi Joe,

Please run the DMT for Part Plant also

Regards,
Anbuselvi Thirumavalavan

1 Like

so i was able to update both the part and partplant CostMethod fields using the PartCombined Import table in DMT. i verified this using both cost adjustment and the stock status reports which both showed the updated AVG fields.

2 Likes