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:
WHEN ENABLEMULTIBIN = 1
END AS [MultiBinning Status]
The GP inventory setup window contains the checkbox that controls this setting.