SELECT DISTINCT DistributorCode FROM #ERPDatabaseName#.DistributorItemHistories DI INNER JOIN #ERPDatabaseName#.Manufacturers M ON M.ManufacturerID = DI.ManufacturerID INNER JOIN #ERPDatabaseName#.Distributors D ON D.DistributorID = DI.DistributorID INNER JOIN #ERPDatabaseName#.Items I ON I.ItemID = DI.ItemID INNER JOIN #ERPDatabaseName#.ManufacturerItemCategories C ON C.ManufacturerItemCategoryID = I.ManufacturerItemCategoryID INNER JOIN #ERPDatabaseName#.CodeDefs CD ON CD.CodeDefID = DI.ItemStatusCodeDefID WHERE CD.Description = 'Stocked' SELECT DISTINCT cdr_dstname, cdr_recordid FROM qmd_distributors WHERE NOT cdr_dstcode = '' ORDER BY cdr_dstname

Territory:	-- Select a Territory -- #repeatString( "  ", rank )##htmleditformat( territoryName )# inc. sub ters.
Distributor:	singlemutliple
Manufacturer:	-- All Manufacturers -- #htmleditformat( mfrName )#  singlemutliple
History Window:	Look back into order history this number of days
Min Order Quantity:
Page Breaks:	Yes    No