We recently found a variance between the LOT numbers that our material transactions were set to consume vs the LOT number our issue transaction were consuming. The quantity of each product deducted was the same, but the LOT it was using was different between the two transactions.
We escalated this issue to Acumatica and they came back and told us that we needed to switch our base UOM to the smallest unit of measure that we use. Currently our base unit is in LBS and we have a UOM conversion into grams and into kilograms.
Moving all of our inventory from being stocked in LBS to being stocked in grams is going to be a major change to our processes and take a lot of time to fix a problem that was working fine for us for over 6 months. Does anyone have any ideas in how to fix this issue with changing the UOM’s?