Best approach for a cut-to-length part (cost following raw material) in Engineering Workbench?

Kinetic ERP
21

Not only that end up with the not so well designed upon Slider

22

Thanks so much, I am working on this new after approval, so to confirm clearly, BOM would be to dmt into the partMtl table and BOO would to dmt into PartOpr table right?

23

Its been a while… and of course my current DMT is out of sync (version) with the cloud server (because Epicor can’t grant us an auto-update :face_with_symbols_on_mouth:)… so, i can’t verify.

But I think there is a Bill of Materials and a Bill of Operations DMT template.

I think you’re correct that the imported records will land/live on those tables… but the DMT templates (I think) are called Bill of Materials and Bill of Operations.

24

Ok thank you very much. I will give you and update on how it worked.
Thanks very much

25

Hi David,
Thanks very much, I am progressing on this, but I met another road block, in as much as I DMT the parts into the tables, when I try to create a job for the Parts, I get the Error, " “Must be a valid Manufactured Part”. So I did some research and found out that I had to go into the Site tab of the Parts to change the source Type to Manufactured. Before the job creation could work.
So my question now is, do I have to do this manually for all parts, or is there a way I handle this in bulk like the other DMTs i have done.

Thanks very much

26

I believe both the PartPlant and Part DMTs have TypeCode fields.

27

Thanks very much, so I will also have to DMT into Part Plant as well.
Thanks so much for the help

28

You will only have to do a separate PartPlant DMT IF you have multiple Sites (Plants). When you are CREATING a part number, setting the Part.TypeCode value will flow down to the PartPlant table for the Site you are creating it in.

29

Thanks very much Ernie, I have 3 other Plants.
Thanks so much

30

I had been planning for these cut parts to be make-to-stock (MRP suggests jobs, orders ship from inventory). The team would now like jobs created from and linked to the sales order, and that raises a yield question.

Example:

  • Part A (manufactured) is cut from Part B (raw material).
  • Part B is currently stocked in EA, one stick, which yields 2 pieces of Part A (qty-per 0.5 EA).
  • The order is for 3 Part A, so we cut 2 sticks and end up with 4 Part A.

What I’m thinking:

  • Round the job production qty up to a multiple of the yield (3 → 4) so the material requirement is whole sticks.
  • Use two demand links on the job: 3 to the order release and 1 to stock.
  • Receive 3 Job → Order and 1 Job → Stock, and let the extra piece net against the next order.
  • Possibly add a BPM to handle the round-up and stock link, since the Order Job Wizard will only create the job for 3.

Questions:

  1. Is splitting demand links (order + stock) the usual way to handle this, or is there a cleaner approach?
  2. Has anyone automated the round-up-to-yield step with a BPM? Where did you hook it in?
  3. Do Part/Site planning settings (min lot size, lot multiple) help here, or do they only affect MRP-generated jobs?
  4. Does this change the case for moving Part B to FT as we discussed earlier? My thinking is that with FT we’d issue only what’s cut and the remnant would stay in raw stock, which avoids the overrun altogether when the shop cuts only what’s needed.

Thanks again for all the input so far.

31

Hi Team,
I am already checking this approach and wanted to know if anyone has any other approach for this.
Thanks in advance, If I need to take this to another topic, I can do that

32

Hi Team, I am still checking if anyone has tried this