Follow

User Submitted Query: 1099 Help

Summary

Here's a quick and dirty query that will, hopefully, help me get my 1099's all done for 2014 and help ensure I get the BPs configured properly for 2015. 

 

Query

SELECT max(T0.[CardName]) AS 'Customer/Vendor Name',
T0.[CardCode],
T2.[GroupName],
T1.[FormCode],
T1.[Box1099],
T1.[LicTradNum],
sum(T0.[DocTotal]) AS 'Document Total'
FROM [dbo].[OVPM] T0
Inner Join [dbo].[OCRD] T1 ON T0.[CardCode]=T1.[CardCode]
Inner Join [dbo].[OCRG] T2 on T1.[GroupCode] = T2.[GroupCode]
WHERE T0.[DocDate] >= (CONVERT(DATETIME, '20140101', 112) ) AND
T0.[DocDate] < (CONVERT(DATETIME, '20150101', 112) ) and
T0.[Canceled]= 'N'
group by T0.[CardCode], T2.[GroupName], T1.[FormCode], T1.[Box1099], T1.[LicTradNum]

 

Version 4.5.1.0

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments