Small and medium business | Business Central, N...

Error when attempting to edit job planning lines in excel

(0) Share

Report

Posted on by Mat B

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.

All responses (6)

Answers (0)

Suggested answer

YUN ZHU 85,338 Super User 2025 Season 1 on at

Like (0)

Report

RE: Error when attempting to edit job planning lines in excel

Hi, just adding some info.

This problem was mentioned when BC21 was just released, and later Microsoft fixed part of it.

Hope this info helps.

Thanks.

ZHU
Suggested answer

Mat B 96 on at

Like (0)

Report

RE: Error when attempting to edit job planning lines in excel

I have received confirmation from Microsoft Support that they can reproduce the issue and they have created a work item to get it resolved.

In the meantime, they have shared with me a small .AL extension that adds the missing field to the Job Planning Lines page and thus makes it available in the API used by Edit in Excel as well.

I have tested it and it works well.

The AL code for the extension is below, if you would like to use it:

pageextension 50100 JobPlanningLinesExt extends "Job Planning Lines"
{
layout
{
addfirst(content)
{
field("Contract Line"; rec."Contract Line")
{
ApplicationArea = All;
Visible = false;
Editable = false;
}
}
}
}

I have the .app file that you can load as an extension, if you don't have access to a developer to assist.
raghu ponnala1 5 on at

Like (0)

Report

RE: Error when attempting to edit job planning lines in excel

Hi Mat. We are facing the same issue and I was wondering if you have had any reply or resolution to the issue from Microsoft. If you have already logged a support ticket, can you please give us the support ticket number that was raised so that we can reference the same and see if they can add us to the list of customers who have the same issue.
Mat B 96 on at

Like (0)

Report

RE: Error when attempting to edit job planning lines in excel

I agree, it was working before but has stopped after one of the recent updates, just not sure which one. I have not yet managed to log it officially with Microsoft as I am having a separate technical issue of not being able to log support requests with Microsoft, which Microsoft is currently looking into. As soon as I get that resolved, I will log it, unless I get a resolution to this issue prior.
Elinna 15 on at

Like (0)

Report

RE: Error when attempting to edit job planning lines in excel

I have the same issue and i think it started to appear when there was a new update.

Did you managed to raise it with Microsoft or get a solution?
Suggested answer

Marco Mels on at

Like (0)

Report

RE: Error when attempting to edit job planning lines in excel

Hello,

If you have a repro in standard, feel free to raise it to Microsoft via your partner or CSP.

Thank you.