TSQL determine inventory MultiBinning is enabled in Dynamics GP

Inventory Control Setup Table IV40100, field “ENABLEMULTIBIN” shows if the company has multiple binning enabled or not.

Use the following SQL to check the status:

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

Pingbacks and trackbacks (1)+

Add comment

Loading