Hi all, We're seeing negative stock balances in our OFBiz 18.12.19 instance (MySQL backend) and traced the root cause to manual data-entry errors in inventory transfers made by warehouse staff. Specifically we found three distinct failure patterns:
1. Transfers that physically happened but were never entered into the system 2. Transfers entered with incorrect quantities 3. "Extra" transfer entries on the server with no corresponding physical movement We suspect the extra entries and missing transfers are the main drivers of the negative balances, since they represent outflow being recorded without matching inflow (or vice versa). A few questions for anyone who's dealt with this: 1. Is there a recommended way to correct negative stock caused by this kind of entry error, beyond manually reversing/adjusting each InventoryItemDetail record - e.g., a built-in adjustment/variance service designed for this? 2. Has anyone found effective controls at the transfer-entry screen (validation, scanning, approval) that reduced "phantom" or missing transfer entries specifically? 3. Any recommended approach to safely correct historical negative balances without disrupting valuation or downstream reports that already reference that data? Appreciate any experience or pointers. Thanks, Ilma Masroor
