JoshZastrow/PartsOnHand

Created March 21, 2017 15:23

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/JoshZastrow/d29d55427ca2e1e31e394b2384fa281a.js"></script>
Save JoshZastrow/d29d55427ca2e1e31e394b2384fa281a to your computer and use it in GitHub Desktop.

Download ZIP

EPICOR total parts on hand

Raw

PartsOnHand

	SELECT
	PartBin.PartNum,
	Sum(PartBin.OnhandQty) AS 'ON Hand'

	FROM ERP10PROD.Erp.PartBin PartBin

	WHERE (PartBin.WarehouseCode='FGI')

	GROUP BY PartBin.PartNum

Author

JoshZastrow commented Mar 21, 2017

total parts on hand across all bins and lot numbers for each part number

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment