We are looking for a way to reconcile weight issues through conversion.
We need BC to simultaneously:
-
Receive 23,976.80 kg into inventory against a PO
-
Ship 23,976.80 kg out of inventory against a SO
-
Invoice the customer 52,890.00 lbs against the same SO
-
Reconcile the 30.75 lb difference somewhere in the financials without it becoming an error or an open balance
We are a brokerage company so we purchase from many different suppliers and sell to many different customs without actually taking possession of the cargo. We buy in multiple UOM and sell in multiple UOM.
What is BC’s native solution to non-exact UOM conversions?
Looking for suggestions please.
Hi @Chris_Pratt
BC doesn’t have a magic answer for this. The 30.75 lb difference is normal when you convert between kg and lbs. You can’t avoid it.
Here’s what to do:
-
Set up your UOM conversion in BC with consistent rounding.
-
Accept the small difference. It happens.
-
Create a “Rounding Variance” account in your general ledger. Post the difference there instead of ignoring it.
-
Keep track of which orders have conversions so you know where the gap came from.
For a brokerage, this is normal. It won’t be perfectly balanced, but documenting it keeps your books clean.
If you need it exactly, you’d need custom coding to track everything in greater depth. But honestly, the variance account approach works fine for most companies.