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.
 
 

Pingbacks and trackbacks (1)+

Add comment

Loading