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
View original
+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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.