Straight into the service manual page
WrenchQuarry
More

Track 2 units for parts bought in boxes, sold in kilos

WrenchQuarry Editorial Team · Published · 13 min read · How these guides are written

Track two units for each part: the unit you buy it in, the unit you sell it in, and the conversion between them. Many parts arrive in one unit and leave in another. A supplier ships a box. Your team sells, issues or bills the same goods by the kilo. Nothing about this is unusual, but it causes a steady trickle of errors: stock counts that do not match, prices that look wrong on an invoice, and jobs that use more or less material than the paperwork says.

Key takeaways

  • Record each purchase in the unit the supplier counts and bills.
  • Pick one sale unit for each part and use it on every record.
  • Write the conversion factor on the part record, with its source and date.
  • Post each delivery in boxes first, then convert it to kilos as a separate step.
  • Reconcile counts in the sale unit on a schedule before adjusting the record.

This post covers the two units you need to track for each part like this, and the link between them. The fix is not complicated. It comes down to deciding which unit each record uses, writing the conversion down once, and checking it from time to time.

Unit one: the unit you buy in

The first unit is the purchase unit. For a part bought in boxes, that is the box. It appears on the purchase order, the supplier's price list, the delivery note and the goods-received record. When a delivery arrives, count what came in using this unit, because that is what the supplier counted and billed.

Record the purchase unit exactly as the supplier names it. If the supplier says "box," write box, not "carton" in one place and "case" in another. Two names for the same thing can split one part into two records, and then your totals never agree.

Keep the purchase record intact. Do not overwrite a received quantity in boxes with kilos after the stock has moved. The delivery record is your evidence of what you paid for. If you later need to check a supplier invoice or dispute a short delivery, you will want the original count in the unit they billed.

Unit two: the unit you sell or issue in

The second unit is the one that leaves the shelf. For a part sold by weight, it is usually the kilo. It appears on the sales order, the dispatch note, the job requisition and the customer invoice. The people who pick, issue and bill work in this unit every day, so it should be the unit they see on screen.

Pick one sale unit for each part and stick to it. If one dispatcher writes kilos, another writes grams, and a third writes "piece" for the same goods, the system holds three records that look like three different products. Choose the unit your customers and your jobs use, and set it as the default for the part.

Be clear about what the sale unit measures. A kilo is a weight. If a customer orders by weight, the invoice line should show the weight issued, not the number of boxes opened. The boxes are a convenience for storage and buying. They are not what the customer pays for.

Why the two units drift apart

The two units drift apart because they measure different things. The U.S. Energy Information Administration makes the same point about energy. In its guide to energy units, it says that "We use different physical units to measure different types of energy or fuels." Its examples show the problem. One household "used 67,000 cubic feet of natural gas for heating last winter," while a neighbor's furnace "burns heating oil, which used 500 gallons last winter." Both homes are heated, yet the two figures cannot be compared as they stand.

The same is true for your parts. A count of boxes and a weight in kilos can describe the same stock, but you cannot add them or compare them directly. The EIA's answer is the one to use: "To compare fuels with each other, we need to convert their measurements to the same unit." In your system, that means converting boxes to kilos, or kilos to boxes, before you compare anything.

Drift happens when someone compares the two without converting. A stock report that adds a count of boxes to a weight in kilos is wrong. A purchase price by the box set beside a sale price by the kilo gives a margin that looks fine or terrible for no real reason. These slips are small, and they are easy to make when the two units live in separate lists.

Write the conversion down once

Everything depends on one number: how many kilos are in a box. Call it the conversion factor for the part. It belongs on the part record, next to both units, so anyone who opens the part can see the link without asking someone else.

Where does the number come from? The best source is the net weight the supplier states on the product sheet or the label, if they give one. If the supplier gives no weight, or the label gives only a range, weigh a sample of boxes on the scale you use for dispatch. Record how many boxes you weighed and the average result, and note the date. A conversion factor with no source is a guess, and a guess repeated across every stock movement becomes a large error.

Do not round the factor for convenience. A small rounding error on one box is harmless. Multiplied across a full season of deliveries and issues, it becomes a stock discrepancy that someone has to explain. Keep the factor as precise as your scale allows, and let the system do the arithmetic every time.

Review the factor when the supplier changes the pack. A new box size, a new label or a new supplier can all change the weight without anyone mentioning it. If the first delivery after a change looks off against the count, check the factor before you blame the warehouse. For a step-by-step version, see Price parts by unit and set stock counts: 3 steps.

Count the boxes at the goods-in door

The goods-in step is where a box count and a weight first meet. Count the boxes that arrive against the delivery note, not against the order. A short delivery is a supplier problem. A count that differs from the note is a receiving problem. You need to know which one you have before you post the stock, because the fix for each is different.

Look at the boxes themselves as well. Note any that are damaged, wet, open or visibly lighter than the rest. You do not need to weigh every box on arrival, but a spot check on a few boxes from each delivery tells you whether the conversion factor still holds. If the spot check drifts away from the factor, record the result on the delivery record so the discrepancy can be traced later.

Enter the delivery in boxes first, then post the conversion to kilos as a separate step. That order matters. If the box count and the kilo figure are typed in together, nobody can tell later whether a problem came from the count, the factor or the typing. Two separate steps give you two places to check, and each one is easy to review on its own.

Illustrative example of one box delivery

A delivery note lists 20 boxes, and the part record holds a factor of 4 kilos for each box. Post the 20 boxes first, as the note counts them. Then post the kilo figure as a separate step, using the factor. Later, a job orders 50 kilos. The dispatcher issues it in kilos, so the job line shows kilos and no box count is needed.

Set prices in the unit the customer orders by

Pricing is where the two-unit problem is easiest to see on an invoice. Frappe's ERPNext documentation uses this exact case in its price list guide. The passage on it begins "Price Not UOM Dependent:" and continues: "Consider an item, Tomatoes, which you buy in Boxes and sell in Kilos." The example shows that one item can be bought in one unit and sold in another. For more on this, see 2 prices every stocked part needs: buying and selling.

In practice, check which unit your price list uses. If the price is set by the box but the sale line is in kilos, someone has to convert the price at the point of sale, and the answer will vary with each person doing it. If the price is set by the kilo, a sale line in kilos is direct. Either way, the invoice should show the quantity, the unit and the unit price side by side, so a customer or an auditor can follow the sum without guessing.

Check the cost side too. Your cost for each box is real, but your margin is measured for each kilo sold. Divide the box cost by the kilos in the box, using the conversion factor, to get the cost of each kilo. Then compare that figure with the sale price of each kilo. Do this first for the parts that carry the most value or the most volume, and do it again whenever the supplier changes the box price.

Be careful with discounts and surcharges that are set by the unit. A discount written by the box applies to a different weight than a discount written by the kilo. If the two are mixed on one price list, the invoice may look right while the margin is wrong. Put every rule on the same basis as the sale unit.

Keep purchases and issues as separate records

Buying stock and using stock are two different events, and they should have two different records. OpenStax's managerial accounting text describes a company that buys materials "in order to have enough inventory on hand for all of its jobs." The purchase builds the balance. The job draws on it. Mixing the two into one line makes it hard to see what came in, what went out and what is still on the shelf.

The same text ties materials to jobs through a materials requisition form, using the form for Job MAC001 as its example. A requisition is the document that says which job took the material and how much. For a parts store, the equivalent is the issue note: it names the job or order, the part, and the quantity issued. Use the sale unit on that note, so the cost of each job can be traced back to the stock it used. For the dispatch side, read Field Service Work Order Checklist for Dispatch Handoffs.

Hold the stock balance in one place. Most teams find it simplest to keep the balance in the sale unit, since that is what leaves the building, and convert the purchase into kilos when goods arrive. Whichever unit you choose, the balance should not be kept in two places, updated by two different methods. Two balances will disagree sooner or later, and then nobody knows which one to trust.

Decide, too, who is responsible for the balance. One person or one role should be able to answer for the figure in the system, and should be the only one who adjusts it. When several people can change the balance with no shared record of why, the balance stops meaning anything, and every count becomes an argument about who touched it last.

Handle opened boxes and partial returns

Opened boxes create a third question. A box is partly used, but the stock may be recorded as whole boxes or as kilos. Decide the rule and apply it everywhere. The simplest rule is to record stock in kilos as soon as a box is opened, reducing the box count by one at the same time. Another option is to keep opened boxes as a separate line with their remaining kilos. Either works. Mixing the two methods in one store does not.

Some parts arrive in boxes of different sizes, or from different suppliers with different pack sizes. If the sizes differ, each size needs its own conversion factor, and the goods-in record should say which size it belongs to. Averaging two box sizes into one factor looks tidy, but it moves the error into every issue made from the blended figure, and it is hard to unwind later.

Partial returns need the same care. When a customer sends back part of an order, the kilos go back into stock, but the returned goods may not fill a box again. Record the return in kilos, and keep the opened-box record accurate. Do not guess at a box count. If you cannot weigh the returned goods, say so on the record and mark them for a count later.

Damaged or spoiled stock deserves its own line too. Write it off in the unit you hold the balance in, with the reason. A write-off that is recorded only as a missing box is hard to explain later, and it hides how much of the loss was real and how much was a conversion error.

Reconcile on a schedule

Even careful records drift. Count stock on a regular schedule, in the sale unit, and weigh any opened containers rather than estimating them. Compare the count with the system balance in kilos. Investigate any difference before you adjust the record, and record each adjustment with a reason, not just a new number.

Team leads can learn a lot from the direction of the differences. If the count is consistently below the system balance for one part, the conversion factor is the first thing to check. It usually means the box weight was overstated. A consistently higher count usually means it was understated. Checking the factor is quick, and it often explains a pattern that otherwise looks like theft or poor handling.

A routine for the team

The steps below work for most parts bought in one unit and sold in another. Adjust the details to your own system, but keep the order.

  1. Record each purchase in boxes, exactly as the supplier counts and bills them.
  2. Confirm the conversion factor on the part record, with its source and date. 3.
  3. Price and quote in the unit the customer orders by, and show the unit on every line.
  4. Issue stock to jobs and dispatch orders in kilos, with the job or order number on each line.
  5. Count on a schedule, weigh opened containers, and reconcile any difference before adjusting the record.

Start with one part

You do not need to fix every part at once. Pick the one that causes the most trouble, usually a part with a high value, a high volume or a long list of complaints. Write down its purchase unit, its sale unit and its conversion factor. Check the factor with a sample weighing. Then run one full cycle, from delivery to invoice to count, and see where the numbers stop agreeing.

Once that part is clean, repeat the process for the next one. Most teams find that a handful of parts cause most of the errors, and that the same few fixes apply to all of them. The aim is not perfect records on day one. It is a single agreed conversion for each part, written down, and a count that tells you when it has stopped being true.

Your next step today: open the record of your most troublesome part and check that it names both units and the conversion factor.

Related guides: Flat-rate pricebook price: 3 parts to build in · Floor price for a one-off job: 3 cost parts · Parts order discounts and returns: 3 amounts to record.

Frequently asked questions

Do I need both units for every part?

Yes, for any part bought in one unit and sold in another, the purchase unit and the sale unit should both be on the part record.

Where should the conversion factor come from?

The best source is the net weight the supplier states on the product sheet or label, or a sample weighing if they give none.

Should opened boxes be counted as boxes or kilos?

Pick one rule and use it everywhere: record the stock in kilos as soon as a box is opened, or keep each opened box as a separate line.

Sources

More field guides