Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Error when attempting to edit job planning lines in excel

Posted on by 88

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.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 68,757 Super User 2024 Season 2 on at
    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.

       

    pastedimage1678329921056v1.png

    Hope this info helps.

    Thanks.

    ZHU

  • Suggested answer
    Mat B Profile Picture
    Mat B 88 on at
    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 Profile Picture
    raghu ponnala1 5 on at
    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 Profile Picture
    Mat B 88 on at
    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 Profile Picture
    Elinna 15 on at
    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 Profile Picture
    Marco Mels on at
    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.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,349 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,212 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans