When attempting to edit Job Planning Lines in Excel, get error as below:
"The filter for entity "Job_Planning_Lines_Excel" was invalid and has been cleared Details: The filter contained the following invalid fields: Contract_Line"
Editing all other entities in Excel works fine.
Does anyone know how to resolve this issue?
Excel clears the filter passed through from BC and so shows all planning lines from all jobs and job tasks. While it is possible to again apply a filter in excel for a single job and task no, it is not possible to apply a filter that shows the planning lines for all of the tasks making up a task subtotal or total since the basic filters in excel doesn't cater for ranges.