If you work with VI contract costing chances are you need to run comaprisons of actual costs against initial and current estimates. This query will give you the initial costs and revenue for each contract grouped by expense code and expense group. If you look at the comment section you can change MIN to MAX [...]

Continue reading " Getting Contract Costing Estimates "

Following on from the last post it would be easy to say, the forecast report doesnt work, we know that so lets just bear that in mind. Or you could have what I have, a customer demanding a report which reflects accurate figures. So if you want to get a report with the right figures then you [...]

Continue reading " Fixed Assets Part 2 "

I mentioned in my last post about SQL Server reporting services (SSRS) and how you really must consider it not just as an enhancement to Sage reporting but a complete replacement. I have produced many reports that provide detailed cost centre, project costing and time booking reports the likes of which do not even exist [...]

Continue reading " Sage Reporting #2 "

Are you still using Sage to do all your reporting? Finding it tedious to get the information on the format that you and your users want? Then STOP! Whilst the reports deliver what they say on the tin the format is something akin to old character based UNIX and DOS systems and you have no [...]

Continue reading " Sage Reporting #1 "