SAP B1 UoM groups for Poles in different lenghts

[former_member698435]

Dear Experts,

Scenario:

• My client buys poles in different lengths: 4 feet, 8 feet, 16 feet, 25 feet.
• They use these poles in production. They can cut up the longer poles into shorter lengths required in manufacturing. They cannot put together shorter sections of poles when longer sections are needed.

So far it tested well, costing is working per 1 feet.

My question:

• Will this work in the Inventory reports? I have not yet seen a standard Inventory report that will split up the UoM to show this as separate lines.
• Will MRP know to cut a longer piece and not issue a PO.

Thanks,

Marli

[Johan_Hakkesteegt · Accepted solution]

Hi Marli,

The MRP is not terribly sofisticated. That means that it will try to fulfill Required Stock levels, and needed stock for open sales orders.

If your open sales order contains 4 pcs of 4-foot (with stock 0), the MRP will create a PO for 4 pcs of 4-foot.

You might be able to make the MRP create a PO for 1 pcs of 16-foot, using a "deconstruction" BOM for the 4-foot item. I.e. 4 pcs of 4-foot end product, will have 1 pcs of 16-foot as the component.

You can also test how this would work when staggered. I.e.:

1. a BOM for 2 pcs of 8-foot end product with 1 pcs of 16-foot as the component
2. a BOM for 2 pcs of 4-foot end product with 1 pcs of 8-foot as the component

With such a setup, you could test what the MRP will do when there is an open sales order for 4 pcs of 4-foot. Conceivably the MRP will try to create a PO for 1 pcs of 16-foot.

Regards,

Johan

[former_member698435 · Accepted solution]

Johan,

Thank you! This is worth giving it a shot.

Do you know if there are any standard inventory reports that will show the qty of the UoM groups separately/split up? I could not find one, and this will be a deal breaker.

Thank you,

Marli Schutte

[Johan_Hakkesteegt · Accepted solution]

Hi Marli,

Sorry, I have no experience with the UoM groups functionality, and I do not know if there is a report for it.

However, my suggestion would entail having separate items for each length. Production would be the method to convert one to another. I suppose it would also mean that your UoM would be pieces instead of feet.

Regards,

Johan