UOM meters and pieces

(0) Share

Report

Posted on by FinOps

D365 FinOps, how to handle this scenario :

i have 1 pcs of cable of 1000m in my stock, i sold 600m. it remains 400m in my stock.

then i bought again 1000m and sold from it also 600m.

my stock balance now shows 800m but i am not able to tell that it is 2 pcs of 400m.

What if client asks for 500meters in one piece.
how to solve this?

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Hanna17 172 on at

Like (0)

Report

RE: UOM meters and pieces

Hi FinOps!

In your situation you need to use a Catch Weight Unit functionality.

When you create a Released product you need to check the parameter "Catch weight", and after creating the product, to go to a Product details / tab "Manage inventory" and fill out values in fields: CW unit, Nominal quantity, Minimum quantity, Maximum quantity.

And keep in mind that you will need to have tracking dimension group with active batch number to be able to see on-hand inventory in meters per each batch. In your example it will be 2 batch numbers, in the on-hand you will be able to see 2 lines: first line with first Batch number, quantity = 1, unit = ea, CW quantity = 400, CW unit = meter. And second line with second Batch number, quantity = 1, unit = ea, CW quantity = 400, CW unit = meter.

Was this reply helpful? Yes No
Suggested answer

FinOps 20 on at

Like (0)

Report

RE: UOM meters and pieces

Thank you, that is good solution for cables. So i need to create a batch for every roll of cables? correct?

NOW the more interesting question

What will be the solution for tubes (or iron rods). we buy 1000 iron rods, each Rod have a length of 6 meters.

while using it the factory we cut these rods, how can i track the remaining cuts.

shall i create batch for every length (6m, 5m, 4m, 3m, 2m, 1m) ? if yes, how to manage and transfer quantities from batch to another. ie if a rod length 5m i cutt from it 1 meter, the remaining is 4meters it should be moved to the batch of the 4m!!

or there is another solution?

Was this reply helpful? Yes No
Hanna17 172 on at

Like (0)

Report

RE: UOM meters and pieces

Yes. If you want to see on-hand for each roll, there should be a batch attached for each roll.

Was this reply helpful? Yes No