How to declare parts movements in shop order with alternative UoM

You’ll need to use a Formula and Formula Variables with your Input UoM Group. I have some notes I can compile into one document. It may be scattered somewhat, but the concept will be in there.

File attached.

Hello Matt,

thanks a lot for your very quick and documented answer 😀.

This is what i’m looking for, except the fact that density is entered as a fixed value in your example. What we need is to get the density from the master part; otherwise we’ll need to enter it manually for each component. Do you know if there is any way to do this?

Thanks a lot for your precious help 😀

@RECOFR I do not know if it is possible to fetch the value from the Part record into a formula when using the Input UoM at material issue or receipt. This would require a discussion with a technical resource.

How many different densities are involved, which would relate to the number of required formulas and number of required input UoM groups?

Well, i don’t know how many distinct density exists…

I see your idea: create as many UoM group as distinct Density right?

That was the direction I was thinking of.

I was trying to avoid it, but met me check how many distinct density we have first..

very interesting dicussion. I’m currently strugling to use it in Sales as described here : 

​@matt.watters , if you have some ideas. i have the feeling that the usage of the input qty field is not consistant. do you know if we can get the input qty field value, included in a formula ?

​@RALAFR would it be enough to have the Input Qty hard-coded as a variable in the formula as below, where EA would equate to the Input Qty? As the output of the calculation, if the Sales Qty and the Sales UoM are correct, is that good enough?