The Inventory Available field remains false (zero) after you add Inventory to a Purchasing system or Purchasing to an Inventory system

This article provides a resolution for the issue that the Inventory Available field remains false (zero) after you add Inventory to a Purchasing system or Purchasing to an Inventory system in Microsoft Dynamics SL.

Applies to:   Microsoft Dynamics SL 2011 Service Pack 1, Microsoft Dynamics SL 2011 Service Pack 2, Microsoft Dynamics SL 2015
Original KB number:   3049901

Symptoms

You notice that when you add the Inventory module to a system that uses Purchasing, the inavail field in the purchase order setup record (posetup.inavail) remains 0 (zero) to indicate that inventory is not available in Microsoft Dynamics SL.

Resolution

Run the following SQL update statement in SQL Server Management Studio.

update posetup set inavail = '1'