Hi,
Just wanted to share a report which may help with Service Desk Billing.
The attached SQL and Report will show all Service Desk tickets that enter the closed stage within the last day.
All you should need to do to get this report running is create the view in SQL Management Studio and replace the UnbilledRevenueByCustomer_portrait.rdl and UnbilledRevenueByCustomer_landscape.rdl files in \Kaseya\xml\Reporting\RDL\2008\ServiceBilling\ with the new ones attached.
You can then access the report in the Info Center, Reports, Service Billing, Unbilled Revenue By Customer
I have only done limited testing on this report so I can't guarantee it will work for everyone (or anyone else) but maybe it will.
Below is a sample of the output report
Brad
I will attach the files again tomorrow, Integrated security was not working in the report and I forgot to remove the SA password.
New report and SQL attached, enjoy.