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

130

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.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

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

Thank you.

Was this reply helpful? Yes No
Elinna 15 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Mat B 130 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
raghu ponnala1 5 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Mat B 130 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No