Cost Rollup with a .5 Ea Qty Item

Epicor ERP 10
1

We recently did a cost roll-up through the Costing Workbench and we ran across an oddity. We use 2 different stacking brackets in a BOM. For every 2 items we manufacture we use 1 left hand bracket and 1 right hand bracket. We wanted to account for the cost of the brackets as they carry a significant cost. So… we thought that if we put .5 as a Qty per Parent in the BOM all would be well. We saw a demand for the brackets in time phase and all seemed to be well. When we dove into the results of the Cost roll-up, we discovered that the cost of these brackets were not reflected in the overall material cost of the Manufactured item. These are the methods we used to verify what the Material cost of this manufactured part should be
1). Added up Manually
2). Refered to Epicor Bill of Material Report, This was interesting, it showed Qty/Parent of .5 and a required Qty of 0
3). Refered to Epicor Report Bill of Material Cost Report-Indented Level…Same perception, .5 Req Ea , Correct Material Cost and Extended Cost as 0
4). Referes to Methods Master Listing, Single Level. This one shows .5 each for Qty/Parent and .5 for required Qty. This is the only report that returned results as expected.

This may lend a hint, I checked the Rollup Log and found this entry for both the .5 qty parts and fount this entry
Part 96116892 does not exist in the Cost Group
Part 96116893 does not exist in the Cost Group

I am not sure as to where I would ‘Add this part to a cost Group’ as there are a little over 500 entries in the log file with the same ‘error’ and the roll-up seems to be fairly accurate and a spot check of these entries, shows that they were in fact rolled up correctly.

Am I overlooking something else that has to be set up/entered for this to work correctly or am I using the .5 qty per in a way Epicor is not expecting ?

Thank you in advance for your help.

2

Under UOM maintenance do you have allow decimals checked for that UOM?

3

Thank you kyle. Unfortunatly I get this error when trying to allow decimals… ‘Decimals are not allowed because this UOM(Ea) is being used by a serial tracked part’. Our top level parts(Manufactured parts) are serialized, that is non negotiable.

4

We needed have 2 “Each” UOMs to allow decimals for some parts.

We decided on:
EAS - Each Serialized
EAD - Each Decimal

5

Same as @amurdock .

EA = Whole Numbers and serialized
PC = fractional and non-serialized.

1 Like
6

I did the same as @amurdock and @Mark_Wonsil

Each & Each-D

7

Thank you Andrew, Mark and Kyle, that makes sense. I will work on implementing that today, I speculate that a UOM Conversion would have to take place. We do have a test Environment I can try this out in.

8

If you made transactions to this part already you will not be able to convert the inventory UOM. You would be better off creating a new part num.

9

Thanks Kyle. I was just running into that

10

Many Thanks to all of you for your help. We did have to create new part numbers as there were transactions for the part number.

How do I denote this question as Solved ??