AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        


Sample Total Workorder Billable Grouped By... Expand / Collapse
Author
Message
Posted 12/11/2006 11:39:27 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 7:20:51 AM
Posts: 1,703, Visits: 4,009
If you previously downloaded the original Sample Total Billable or Sample Client Total Billable or Sample Total Billable for Workorders Grouped By Client provided in June, please remove and import this new sample in preparation of compliance with the new printing design and engine compoent that will be released with the next maintenance update:
  • Open Administration navigation pane -> Report Templates -> find Total Billable for Workrders Grouped By Client and open -> Delete
  • Find Total Billable, and Sample Client Total Billable and also delete
  • Download this new release and extract
  • Import the Sample Total Billable for Workorders Grouped by Client
  • Exit out of AyaNova and log back in
  • Template will now display as selectable in the Service Workorders navigation grid.

Sample Total Billable for Workorders Grouped By Client - this sample report template has visible only the sub-totals from each workorder item's Parts Labor, etc and than totals the billable for each client. A new page is forced after the client's Grand Totals.

This report template identifies the workorder number, its service data, and than the billable items for applicable parts, labor, travel, misc.expenses and loan items.

Possible uses - filter the Service Workorder grid based on your desired need (project, service date, client, etc) to obtain a summaried total for all listed workorders for each listed client.

As with all report templates, you can further customize to your specific needs.




AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2424
Posted 12/11/2006 12:55:19 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 7:20:51 AM
Posts: 1,703, Visits: 4,009
Here is another version of that above - but the Total has been changed to display for all clients displaying in the report. This report template may be useful if you wish to identify the total billable for clients of a head office for example where you would have filtered to show a number of clients, but you want a grand total at the very end. The change was that the totals that were in the GroupFooter for the report first posted above have now been moved to the ReportFooter instead.

Sample Total Billable

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2425
Posted 12/11/2006 1:41:03 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 7:20:51 AM
Posts: 1,703, Visits: 4,009
Here's another - further customization of the first sample report template where the totals are gouped by client - but with this one I have made the Detail bands True so that they are visible and set group headers to identify each actual part, labor, loan etc within the report.

Sample Billable Identified Grouped By Client with Total



AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2426
Posted 12/13/2006 1:58:11 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 7:20:51 AM
Posts: 1,703, Visits: 4,009
Here's another rendition on the report template - this one shows the subamounts (labor, parts, misc expen, etc) per workorder and than provides a total for each workorder showing on the grid

Sample Summary Billable Per Service Workorder

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2434
Posted 3/3/2007 5:19:50 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Today @ 7:20:51 AM
Posts: 1,703, Visits: 4,009
Here is another rendition of this report template with the following differences:
  • grouped by Project instead of by Client
  • includes displaying Net Service Hours Quantity, and Net No Charge Hours Quantity via the groupfooter for the WorkorderItemLabor band (these include OnSummaryCalculated scripts to get a running total for the bottom of the report)
  • includes displaying Total Service Hours Quantity and Total No Charge Hours Quantity in the groupfooter for all the workorders for that project (these are obtained via the OnBeforePrint scripts for these fields to display the running totals obtained from above)
  • Detail band for labor shows
  • Detail band for parts shows

Sample Total Billing Grouped By Project Includes No Charge Hours

I invite you to download these samples, and further customize as needed - for example, if you want to group by client, than you would edit the GroupFields Collection property for GroupHeader1 (presently is grouped by Project); or if you want details for Misc Expenses to show, you would set the Visible property for Detail6 (of the DetailReportItemMiscExpense band) from False to True, etc.

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2870
« Prev Topic | Next Topic »

Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: AyaNova Sales & Support

Permissions Expand / Collapse

All times are GMT -8:00, Time now is 9:20pm

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.031. 10 queries. Compression Disabled.