Issues with Catch Weight / Unit of Measure Conversions / Buying in one UOM and selling in Another

(1) Share

Report

Posted on by CP-26051834-0

We are a brokerage company where we purchase goods from various suppliers and ship from the supplier's facilities directly to our customer' facilities. This is int'l business so the purchase and sales are through many countries. We are experiencing issues when we purchase goods in one UOM (Example my supplier provides 13.61 kg cartons) and we sell to our client in another UOM (Our customer purchases 30 lb cartons). The goods never change packaging, this is just an industry accepted equivalence. In this example my PO is created in kg and our SO is created in lbs. Our issues seem to be at the conversion stage between kg and lbs and how to balance inventory in/out without having to make an accounting adjustment. What do others do in this scenerio? I am looking for an open discussion on this topic as it is causing us nothing but headaches - looking for help.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Teagen Boll 2,655 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

I have seen this scenario before and what I have done with clients is setup a Catch weight field as an extension of package tracking in Business Central. Clients would then receive 1 unit or 1 case but the system would take the Kg and Lbs and just convert those. For food you would usually be entering a lot number anyways so in this you can just enter the weight as well (either kilograms or pounds) and just have the system convert to the other weight as needed.

Here's an example where you can see Catch Weight in pounds and kilograms:

You would need to work with a developer and/or partner to develop an extension to accomplish that goal.

Hopefully that gives you a starting point.

Best,

Teagen Boll

Work: Catapult ERP

Social: LinkedIn

Was this reply helpful? Yes No