Dynamics Community Forum Thread Details

"THREAD" Unit of Measure Requirements

Hi:

We know that Business Central can forecast finished good sales in EACH, yet, conduct supply planning for their raw materials in Purchase Orders or Work Orders in FEET.

We also know that -- for some finished goods -- sales quotes and sales orders are created in EACH, yet, Business Central can consume their raw material in INCH.

Some of those finished goods are in INCH but, also, are measured in THREADS where you thread one end (TOE), thread both ends (TBE), or Plain end (PE = no threading).

The demand for these different THREADS and lengths have to be summed in INCH, which is converted into FEET of replenishment requirements for any ¾-inch finished goods.

Can Business Central, out of the box, handle these THREAD requirements? If so, how?

Thanks!

John

Categories:

Dynamics 365 Business Central

Yes It can be acheived through out of box functionality but not natively UOM as threads are not predefine UOM , before please try to follow this 6 steps and check

Step 1: Define Units of Measure (UOM)
Path: Item Card → Related → Item → Units of Measure

On the Item Card for your raw material (e.g., Pipe ¾-IN), set the Base Unit of Measure to INCH.
Add additional UOMs:
- EACH = e.g., 36 INCH (if one finished good uses 36 inches).
- FEET = 12 INCH.
- Any other needed conversion.

Step 2: Configure Item Variants for THREAD Types
Path: Item Card → Navigate → Item → Variants

Create variants for the same item:
- Variant Code = TOE (Thread One End).
- Variant Code = TBE (Thread Both Ends).
- Variant Code = PE (Plain End).

Step 3: Use Item Attributes (Optional, for reporting)
Path: Item Card → Navigate → Attributes

Create an Attribute called Thread Type.
Assign values: TOE, TBE, PE.
Link the attribute to the variants.

Step 4: Link to Production BOM or Routing (if manufacturing thread ops)
Path: Manufacturing → Production BOM → Lines
Manufacturing → Routings

If threading is a consumption/material difference, make separate BOMs for TOE/TBE/PE variants.
If threading is a process step, add a routing operation (e.g., Threading Machine = 1 min per end).
Assign routing to the variant.

Step 5: Forecast & Demand Planning
Path: Planning → Demand Forecast or Sales Orders / Quotes

Enter demand in EACH (finished goods).
System converts EACH → INCH.
Planning Worksheet converts INCH → FEET (raw material).
THREAD variant ensures that demand is separated (TOE vs. TBE vs. PE), but total length is rolled up for replenishment.

Step 6: Planning Worksheet
Path: Planning → Planning Worksheet

Run Calculate Plan.
BC aggregates demand across sales/forecast.
Replenishment requirements will show in FEET, while still respecting variant (TOE/TBE/PE).