Inventory quantities are skewed or not updated

Step-by-step guide

Separate quick-fixes for incorrect or confusing Inventory counts

1. If your Inventory listing counts differ from the counts inside the Inventory items' editing window:
   • Load the Components Services app (it's easy to find by clicking the Windows desktop's "Start" button and typing "component").
   • Restart the "Spire API Server" service (this will refresh any internal materialized views and other cached data).  Note logged-in staff should be warned they may be kicked-off Spire, so they shouldn't have unsaved forms open before the API is restarted.
   • Within the Spire desktop app, reload/refresh any stale data.
2. Open the Inventory menu and select "Inventory Adjustments".

1. • All items (batch adjustments and batch transfers) listed here are not yet processed/posted.  These pending batches just Commit inventory.
   • It's suggested to run the report "Item Allocations" from the primary Inventory listing.
   • If you find that a pending Adjustment batch is the problem, you can either delete a batch or open-and-post it to remove it's pending commitments.
     Note the Inventory menu has an "Inventory Counts" feature.
2. All items (batch counts) listed here with an enabled "Post" button (after opening the batch) are not yet posted.  These do not affect inventory counts (they change the On-Hand quantity after posting) so most likely your problem's source isn't here.
   
   
3. Run the Inventory menu's "Inventory Reallocate" tool.
   • Logged-in staff should be warned to avoid modifying anything to do with inventory until the process has completed.
   • Click "Begin" to run it.
   • After it completes, refresh/reload any stale inventory data.
   • This tool recalculates correct inventory quantities by re-synchronizing the Committed and On-Order quantities based on existing Sales Orders, Production Orders, Purchase Orders and Inventory Adjustments.