Skip to main content

Notifications

Announcements

No record found.

Supply Chain Management forum

Error Executing Code : the field with ID '0' does not exist in table 'purchline'

Posted on by 40

we can getting error in  D365 f&o on premise in pu26

Error Executing Code : the field with ID '0' does not exist in table 'purchline'

This is coming when we modify unit price and then try to modify quantity.

There is no customization in environment it is standard environment.

Error is not coming in vhd with demo data but when we restore sandbox database we are getting this error.

We updated to pu27 also but still same error.

Please help if someone is having solution for this issue

  • Mirror7 Profile Picture
    Mirror7 5 on at
    RE: Error Executing Code : the field with ID '0' does not exist in table 'purchline'

    Hi, cfernandez,

    I also get this error message as you.

    Did you solve this problem or not?

  • cfernandez Profile Picture
    cfernandez 40 on at
    RE: Error Executing Code : the field with ID '0' does not exist in table 'purchline'

    No..this we are doing now and will let you know the result

  • Suggested answer
    Khushhal Garg Profile Picture
    Khushhal Garg 1,514 on at
    RE: Error Executing Code : the field with ID '0' does not exist in table 'purchline'

    Can you also rebuild all packages again after restoring database. Was it done?

  • cfernandez Profile Picture
    cfernandez 40 on at
    RE: Error Executing Code : the field with ID '0' does not exist in table 'purchline'

    Yes we tried all these options but unfortunately not working for us

  • cfernandez Profile Picture
    cfernandez 40 on at
    RE: Error Executing Code : the field with ID '0' does not exist in table 'purchline'

    Yes i had gone through above blog and we did synchronization also.

    Now we are debugging standard code..let's see

  • Suggested answer
    Khushhal Garg Profile Picture
    Khushhal Garg 1,514 on at
    RE: Error Executing Code : the field with ID '0' does not exist in table 'purchline'

    After restoring sandbox database, I hope application is synchronized. Can you confirm? Also, try these options

    1. clearing caches

    2. check License configuration in sandbox database if everything required is enabled

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,645 on at
    RE: Error Executing Code : the field with ID '0' does not exist in table 'purchline'

    Hi..Have you done Synchronization after DB restore. Also take a look at link below:

    community.dynamics.com/.../getting-the-field-with-id-0-does-not-exist-in-table-message

    If sync doesn't do it, suggest to get the environment restored on Dev box and have developer troubleshoot the error message after DB sync.

    Thanks,

    Satish Panwar

    Please take time to click Yes against the answer if it help guide you in right direction.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans