UOM/Specific Gravity

Leigh M

Function: There is no native field to automatically convert Litres to Kilograms using a specific gravity variable during receipt of stock.  For instance, our supplier supplies a product in Litres or Kilograms and we measure internally for our BOM's as a different UOM.

 

Workaround:  Using Cin7 Core Additional Units of Measure or Disassembly function to apply a conversion that is product specific which then creates 2 different products to capture / manage different UOM/Specific Gravity.

Related to

0

Comments

1 comment

Date Votes
  • Comment author
    omar

    Hi,

    Cin7 Core keeps each product in one stock unit and has no specific gravity field, so it can't convert litres to kilograms by itself when stock is received. How you handle it depends on whether the specific gravity (SG) is fixed for each material or changes from batch to batch.

    1. SG is fixed per material (a single value on the spec sheet)

    • Set the product's base unit to the unit your BOMs use, e.g. kg.
    • Add an Additional Unit of Measure for the supplier's unit, with the ratio set to the SG. For example, with SG 0.92, 1 L = 0.92 kg.
    • Raise POs in litres. Cin7 converts the stock to kg, and your BOMs consume it in kg.
    • This creates a second linked SKU for the litre unit. That's how Cin7 handles alternate units, and it's a one-time setup per material.

    2. SG changes by batch (it comes from each batch's CoA) A fixed ratio will be wrong on every batch that differs. For example, glycerine at 1,000 L × $2.00/L = $2,000:

    • Batch A, SG 1.26: 1,260 kg, at $2,000 ÷ 1,260 = $1.5873/kg
    • Batch B, SG 1.25: 1,250 kg, at $2,000 ÷ 1,250 = $1.6000/kg

    If you used a fixed 1.26 ratio, batch B would be received as 1,260 kg, but only 1,250 kg is physically there. That's 10 kg of stock that doesn't exist, and the cost per kg would be understated.

    So keep the product in kg only and do the conversion on the purchase:

    1. When you order: raise the PO in kg using the nominal SG from the spec sheet, e.g. 1,260 kg × $1.5873. This is an estimate.
    2. When the delivery arrives: before authorising, use the CoA SG to update:
      • Stock Received: the actual kg (1,250 kg) against the batch number.
      • Invoice: 1,250 kg × $1.60 = $2,000, which matches the supplier's bill to the cent.
    3. Record the batch SG in the receiving notes so the conversion can be traced.

    The stock cost comes from the invoice and receipt, not the order, so the order price is only a plan. We recommend testing this once on a sample purchase to confirm how it works with your costing method.

    What your supplier sees: Your supplier never needs to see kilograms. There are two ways to set this up:

    • Option A (recommended when SG varies): keep the PO in kg internally, but show the supplier's terms on their copy.
      • Write "1,000 L @ $2.00/L, $2,000.00" in the line comment, or set the supplier product name on the product's Suppliers tab to show the litre pack.
      • If you do this a lot, edit the PO print template so the supplier copy shows litres.
      • The supplier sees 1,000 L at $2.00 and the $2,000 total matches, while Cin7 keeps everything in kg.
    • Option B (when the variation is small and purchasing prefers litres): order the litre SKU, so the supplier gets a normal PO of 1,000 L × $2.00.
      • Cin7 receives it at the nominal ratio, e.g. 1,260 kg.
      • After receiving, post a small stock adjustment on that batch using the CoA, e.g. minus 10 kg for SG 1.25.
      • This means one extra step per delivery, and it slightly shifts the cost per kg.

    If you'd like help setting this up, such as configuring the units of measure, building a conversion sheet for your materials, adjusting your PO template, or walking your receiving team through the process, feel free to reach out to me directly at omar@scitex.ltd. I'm happy to help.

    Best regards, Omar SciTex – Cin7 Core Partner

     


     

    1

Please sign in to leave a comment.