I was checking today to make sure all completed Banked Service workorders had their service banked.  I figured the easiest way check this was to open up the Service Workorders>Labor Grid and filter the Banked Service column to non-blanks.

I made two discoveries.  1. There isn't a filtering option for this column.  2. The column will not sort even if I make it the first column - I was hoping to make the blanks appear before the checkmarks.

I don't know if this by design but not being able to filter or sort makes this column, challenging to use in a grid view.  For now I am going to create a report template and do my sorting in there.

Do these filter/sort options not exist because this is a checkmark field?

Thanks,

Bob

The Banked column in the Labor grid in the Service navigation field is for display only and use within report templates. The Banked column in this grid is not filterable at this time.

We wanted to include the ability to report whether labor had been applied to Banked Service or not as per a number of AyaNova users requests (an sample report template can be found at http://forum.ayanova.com/Topic1798-103-1.aspx) 

We do have it on our list for a future version to make Banked in the Labor grid filterable - but it is not available at this time.

I've attached a Labor summary report template that is grouped by the Banked - with those that are False (not yet banked) listing first as an example of using a report template to sort.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

	Post Attachments
	LaborBankedorNotBanked.zip (1 view, 13.32 KB)

I will use that template.  Thank you!

Take Care,

Bob