JoshZastrow/Bar_yield

Created March 21, 2017 12:51

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/7c398efb5824149daf13d482a7696312.js"></script>
Save JoshZastrow/7c398efb5824149daf13d482a7696312 to your computer and use it in GitHub Desktop.

Download ZIP

Bar Quantity Yields per Part Number

Raw

	SELECT PartMtl.PartNum, PartMtl.MtlPartNum, PartMtl.QtyPer, ROUND(12/PartMtl.QtyPer,0) AS 'Bar Yield'
	FROM ERP10PROD.Erp.PartMtl PartMtl
	WHERE (PartMtl.UOMCode='FT')

Author

JoshZastrow commented Mar 21, 2017

Divides a 12 ft bar by the part materials qty/per. This gives the qty of parts that a bar can produce. Only looks for material that is required by the foot for parts (vs pieces of material, which would just be 1 for 1)

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