Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Hi @Atinder
You can merge using the the columns NO=Item NO and Sales Unit of Measure = CODE
Hope this helps
Hi @Atinder
You can merge using the the columns NO=Item NO and Sales Unit of Measure = CODE
Hope this helps
Hi @mussaenda
I tried but it is not working. I need like conversation pcs to Displays .
Hi @Atinder ,
if you will provide a sample data with your expected output,
the community can help you better.
Thank you!
I figured it out thank you
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
Hi, @Atinder
Please look at the example below. I need more information about first table, is No column unique (no duplicates)?
Proud to be a Super User!
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.
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |