convert Unit of measure pcs to Displays

[Atinder]

Hello,

I need help with Converting my inventory from pcs to Sales unit of measure  Which can be displays, PCS, mastercase.

How Can i link these 2 table or add new cloumn which can convert all my items from pcs to sales unit of measure.  So, I can see how many displays or master I have to sell.

[mussaenda · Accepted solution]

Hi @Atinder 

You can merge using the the columns NO=Item NO and Sales Unit of Measure = CODE

Hope this helps

[Atinder]

Hi @mussaenda 

I tried but it is not working. I need like conversation pcs to Displays . 

[mussaenda]

Hi @Atinder ,

if you will provide a sample data with your expected output,

the community can help you better.

Thank you!

[Atinder]

I figured it out thank you

[v-kkf-msft]

Hi @Atinder ，

Could you please share your solution and mark it as solution? That will help other people with the same problem to find the solution quickly.

Best Regards,
Winniz

[ALLUREAN]

Hi, @Atinder 

Please look at the example below. I need more information about first table, is No column  unique (no duplicates)?

[Atinder]

Hello @ALLUREAN,

in 1st Table is No. column is unique there is no duplicate in that but in second table Item no is repearting becasue of Unit of measure. Our base unit is pcs but we sell some SKU'S by Displays (which can be 12, 15,18,20 pcs) or mastercase qty. I want convert my inventory from Pcs to sales unit of measure whih is last column in 1st table and Qty per Sales unit is in 2nd table.