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.
Solved
Set stock items as inactive once inventory hits zero
Best answer by Robert Sternberg
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.
+7You 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.
Robert Sternberg, Crestwood Associates -- If a community member helped you, please *Like* their post/reply. If they provided an answer to your question, please mark it as *Best Answer*.
Hi,
I have the same requirement. I have the GI and BE set up to monitor the stock items, but I'm having trouble setting up an import scenario to update the status. Could you please help me understand how you achieved this?
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.