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.
Page 1 / 1
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?
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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.