When processing an order in Alternate Unit of Measure, we find inventory records with decimal data ( < 1.0). In example, a customer orders (and we process) Widget A for 10 meters. Our stocking UOM is Feet. Conversion is .3048. So we need to process 30.48 feet for this order. We process in whole number inventory. So to satisfy the order and stay within tolerance, we issue and ship 30.48 feet and bill the customer for 10 meters. This leaves us with XX.52 feet in inventory. Currently, we sift thru our inventory, looking for those that have decimal amounts. Then, cycle-count them to the nearest whole number. For those < 1 we cycle-count to 0.
I would like to know if there is a better way to reconcile these balances. If any of you have this issue and have a process to reconcile the inventory balances, please share your process. Thank you.