Converting volume to weight in UOM

Yahoo Archive
1

Thanks, everyone, for your help with this!  We are in the process of creating the separate UOMs for these items (QTINK, GAINK, etc.).  We are using them all under the WEIGHT part class.  We store the raw material  in volume (quart, gallon, liter, etc) but use it on the job in weight (gram, ounce, pound, etc) and that is the issue.  Some of the containers have both weight and volume on them but most don’t.  Right now we have decided to use an average calculation because we know that it would take a lot of time to figure out the accurate calculation for each raw material and the cost of doing so would outweigh the benefit unless we have a raw material that is very expensive.  I was just wondering if anyone on the list had already developed a similar system for this type of raw material that they could share with us.

 

Bethany Rye
PTI Epicor Business Analyst

2
We need to convert volume such as a quart or a gallon to grams for inks,
hardeners and thinner. These items are purchased in quarts and gallons yet
used on the job in grams. We are on 9.05.702. Has anyone on here done this
successfully? If so, would you please share how you did it? Thanks in
advance!!



Bethany Rye
Epicor Business Analyst

<http://www.teampti.com/>



[Non-text portions of this message have been removed]
3
You can do this, but I think the UOM Class you use still has to have a Class Type of Other in order to convert between weight and volume.  Rumor has it this is changing in the near future.  I'd also assume that each of your parts would have a part specific UOM Conversion rate since the densities most likely vary from part to part.

Do you stock the parts by weight or by volume?  Whichever one you consider to be your inventory unit of measure would be the Base UOM that you add to your newly created UOM Class.  For example, if you stock the part by weight, add your grams first.  Then add the gallons and mark it as part specific.

In Part Entry, you'll need to choose the UOM Class you created and then define what the part specific UOM conversion is.  Once that's completed, you should be able to use any defined UOM conversion.  You can purchase in gallons and stock/consume in grams.
4

I guess I needed to clarify what I need.  I am looking for the scientific calculation of inks, hardeners and thinner purchased in quarts then used in grams. 

 

If it were water, the ratio would be 1 gram = 0.00105668820497 quarts but this is ink so the calculation would be different.

 

1 cubic meter is equal to 1056.68820497 quarts, or 1000000 gram [water].

 

Bethany Rye
Epicor Business Analyst


5
Because it's part specific I would think your vendors have this information. Did you check with them?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Bethany Rye
Sent: Friday, September 20, 2013 10:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Converting volume to weight in UOM


I guess I needed to clarify what I need. I am looking for the scientific calculation of inks, hardeners and thinner purchased in quarts then used in grams.

If it were water, the ratio would be 1 gram = 0.00105668820497 quarts but this is ink so the calculation would be different.

1 cubic meter is equal to 1056.68820497 quarts, or 1000000 gram [water].

Bethany Rye
Epicor Business Analyst






[Non-text portions of this message have been removed]
6
If you need different conversions for different products, I think that you are going to need separate UOMs for each of the weights and volumes.

For instance:
GRH2O
QTH2O

GRINK
QTINK

Then have separate conversions between each of the products where the conversion rate is different.




On Fri, Sep 20, 2013 at 8:39 AM, Bethany Rye <brye@...> wrote:
 
<div>
  
  
  <p></p><div><p class="ygrps-yiv-1644414374MsoNormal">I guess I needed to clarify what I need.  I am looking for the scientific calculation of inks, hardeners and thinner purchased in quarts then used in grams.  <u></u><u></u></p><p class="ygrps-yiv-1644414374MsoNormal">

Â

If it were water, the ratio would be 1 gram = 0.00105668820497 quarts but this is ink so the calculation would be different.

Â

1 cubic meter is equal to 1056.68820497 quarts, or 1000000 gram [water].

Â

Bethany Rye
Epicor Business Analyst


</div>
 


<div style="color:#fff;min-height:0;"></div>



--
Tanya Denison | IT Manager | NRS, Inc.
2009 S. Main Street, Moscow, IDÂ 83843
c: 208.301.0599 | p: 208.883.7834 Ext 277 | f: 208.882.1744
7

 We also purchase inks in gallons and quarts and use/inventory in grams. We ended up creating a couple dozen UOMs in our weight UOM class that relate to the volume and weight. For example, we have a UOM called G9 that represents a 9 pound gallon. The conversion on the class is 1 G9 = 4081 grams. 


Scott



--- In vantage@yahoogroups.com, <tdenison@...> wrote:

If you need different conversions for different products, I think that you are going to need separate UOMs for each of the weights and volumes.

For instance:
GRH2O
QTH2O

GRINK
QTINK

Then have separate conversions between each of the products where the conversion rate is different.




On Fri, Sep 20, 2013 at 8:39 AM, Bethany Rye <brye@...> wrote:
  
<div>
  
  
  <div><p class="ygrps-yiv-1394787630ygrps-yiv-989988087MsoNormal">I guess I needed to clarify what I need.&nbsp; I am looking for the scientific calculation of inks, hardeners and thinner purchased in quarts then used in grams.&nbsp; <u></u><u></u></p><p class="ygrps-yiv-1394787630ygrps-yiv-989988087MsoNormal">

 

If it were water, the ratio would be 1 gram = 0.00105668820497 quarts but this is ink so the calculation would be different.

 

1 cubic meter is equal to 1056.68820497 quarts, or 1000000 gram [water].

 

Bethany Rye
Epicor Business Analyst


</div>
 


<div style="color:#fff;min-height:0;"></div>



--
Tanya Denison | IT Manager | NRS, Inc.
2009 S. Main Street, Moscow, ID  83843
c: 208.301.0599 | p: 208.883.7834 Ext 277 | f: 208.882.1744
8

You can't convert from volume to weight... it would be part specific. Use a party specific conversion

On Sep 20, 2013 6:01 PM, "Bethany Rye" <brye@...> wrote:
 
<div>
  
  
  <p>We need to convert volume such as a quart or a gallon to grams for inks,<br>

hardeners and thinner. These items are purchased in quarts and gallons yet

used on the job in grams. We are on 9.05.702. Has anyone on here done this

successfully? If so, would you please share how you did it? Thanks in

advance!!



Bethany Rye

Epicor Business Analyst



<http://www.teampti.com/>



[Non-text portions of this message have been removed]


</div>
 


<div style="color:#fff;min-height:0;"></div>
9

Create a UOM Class of IHT type other. You can then include the QT, GQ and GR UOMs in that class. Use the GR as the base UOM in the class and create the conversions from GR to QT and GR to GA.

That should work for you.

 

Charlie Smith

2W Technologies Inc., Sr. Business Consultant

Phone: (312) 533-4033 Office

                (860) 919-1708 Cell

      Fax: (847) 374-3620

www.2WTech.com 2W Tech on Facebook

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Bethany Rye
Sent: Friday, September 20, 2013 8:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Converting volume to weight in UOM

 

 

We need to convert volume such as a quart or a gallon to grams for inks,
hardeners and thinner. These items are purchased in quarts and gallons yet
used on the job in grams. We are on 9.05.702. Has anyone on here done this
successfully? If so, would you please share how you did it? Thanks in
advance!!

Bethany Rye
Epicor Business Analyst

<http://www.teampti.com/>

[Non-text portions of this message have been removed]

1 Like