SELECT
YEAR(votrdt) AS 'Year',
MONTH(votrdt) AS 'Month',
COUNT(vo_id) AS '# Vouchers',
SUM(voamt) AS 'Voucher Amt'
FROM apvo
WHERE
YEAR(votrdt) >= '2005'
GROUP BY YEAR(votrdt),MONTH(votrdt)
ORDER BY YEAR(votrdt),MONTH(votrdt)
Tuesday, October 27, 2009
Volumes - Vouchers
The following is a simple query to assess the volume of vouchers being processed each month. This includes all voucher types.
Labels:
accounts payable,
enterprise,
fms,
sql,
voucher
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment