Pick Confirm writes back to Sales Order with Primary UOM in LB
We have items which are shipped from US to Asia so we are sharing one item master. The items are created with a Primary UOM as LB (as this is the smallest UOM) and with the recent implementation of WMS, we realised that these items with a primary UOM as LB is posing an issue as we needed it written back into the Sales order in KG but instead after pick confirmed, it writes back to the Sales Order in LB (this seems as designed based on Primary UOM) .
I have 2 options so far:
1) to use Dual UOM (with Warehouse Pick in Dual UOM flag on) with KG as the Secondary UOM. This seems a good option except that I can only setup either the KG or LB with a special handling code of W but not both. It did not seem feasible as US ad Asia are all sharing the same database.