For starters, as of now we don’t use the Capture COS/WIP yet; we’re working with a portion of our ERP system.
We have two warehouses that purchase inventoried parts and stock them for machine breakdowns. (We have a little over a hundred machines ranging from weld cells, lathes, stamping press that we use to manufacture automotive components and ship to our suppliers)
We moved the inventory from a different system into Epicor in March, with a plan on using Average costing, as it was a manual process and the part cost were not being updated in the other system.
Whenever a part is taken out of the warehouse to repair a machine, the clerks use a Issue Misc Material screen, and enter the reason code (the department the item is being used in). At the end of the month, a report is run for all of the material issues that joins to the part cost table to calculate the amounts that each department used. We set up cycle counting in the warehouses as well to help with inventory accuracy; and we’ve run into a UOM issue where the previous system stored the cost of the part based on a different UOM. (So, the old system priced each foot of hose at say 24cents;) The quantity put into epicor was the number of feet of hose.)
After cycle counting; the count was posted and the adjustment made brought the on hand qty to 0. (i assume is was a part that was never marked as inactive in the old system, and moved over into Epicor.) Our clerk noticed they had zero on hand, and it being needed, ordered a box of tube and received it in. What seemed to happen, is that the usage report is showing the cycle count discrepancies (344 pieces) multipled by the current cost of a box ($100+)
So; going to replace the usage reports here; and would like to report the cost of the part at the time it was issued which I would think is in the Parttran table. That’s not the case for STK-UKN transactions from what I can tell.
What is the best / correct way to issue material to a department or machine?