Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.
select DISTINCT '60 Days' as [Date Range], IV30300.ITEMNMBR As [Item Number], IV00101.ITEMDESC As [Item Description], IV30300.DOCNUMBR AS [Doc], SUM(IV30300.TRXQTY) OVER (PARTITION BY IV30300.ITEMNMBR, IV30300.TRXLOCTN) As [SUMQTY], IV30300.TRXLOCTN As [Location Code], CASE WHEN IV30300.DOCTYPE = '1' THEN 'Adjustment' WHEN IV30300.DOCTYPE = '2' THEN 'Variance' WHEN IV30300.DOCTYPE = '3' THEN 'Transfer' WHEN IV30300.DOCTYPE = '4' THEN 'Purchasing Receipt' WHEN IV30300.DOCTYPE = '5' THEN 'Sales Return' WHEN IV30300.DOCTYPE = '6' THEN 'Sales' WHEN IV30300.DOCTYPE = '7' THEN 'Assembly' END AS [Document Type], IV30300.DOCDATE As [Document Date], IV30300.TRXQTY As [Qty], IV30300.UOFM As [U Of M], IV30300.UNITCOST As [Unit Cost], IV30300.EXTDCOST As [Extended Cost], IV00101.USCATVLS_1 as [Use] from DTZ..IV30300 INNER JOIN DTZ..IV00101 on DTZ..IV30300.ITEMNMBR = DTZ..IV00101.ITEMNMBR INNER JOIN DTZ..IV00102 on DTZ..IV30300.ITEMNMBR = DTZ..IV00102.ITEMNMBR and DTZ..IV30300.TRXLOCTN = DTZ..IV00102.LOCNCODE WHERE IV30300.DOCTYPE IN (1, 6) and IV00102.QTYONHND > 0 and IV00102.QTYONHND - IV00102.ATYALLOC > 0 AND IV00102.RCRDTYPE <> 1 AND IV00101.USCATVLS_1 IN ('FG', 'RAW') and IV30300.TRXQTY < 0 and IV30300.DOCDATE < cast(getdate()-60 as datetime)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.