Set stock items as inactive once inventory hits zero

  • 15 November 2023
  • 1 reply

We are looking for a way to “turn off” items that are discontinued or sold out when gone once inventory is depleted. We’re not necessarily looking for an event to be triggered in Acumatica (purchase or transfer), but a way to identify and track when inventory is low for specific SKUs would be helpful so they can be set as Inactive. 


Best answer by Robert Sternberg 15 November 2023, 15:55

View original

1 reply

Userlevel 7
Badge +8

You can monitor the stock item’s qty using a GI on the INSiteStatus table grouped by InventoryID.  When the QtyOnHand’s value is equal to zero trigger a business event that will run an import scenario to update the item status to Inactive. 


This could be resource intensive from a system perspective as every change to QtyOnHand will be evaluated.  You can reduce the resource consumption by limiting the stock item’s returned on the GI. 


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved