TSQL determine inventory MultiBinning is enabled in Dynamics GP

Inventory Control Setup Table IV40100, field “ENABLEMULTIBIN” shows if the Dynamics GP company has multiple binning turned on or off (enabled or not).

Use the following SQL to check the multiple bin status of a GP company:

SELECT CASE 
       WHEN ENABLEMULTIBIN = 1
           THEN 'ENABLED'
       ELSE 'DISABLED'
       END AS [MultiBinning Status]
FROM IV40100

The GP inventory setup window contains the checkbox that controls this setting.