Skip to main content
Supply Chain Management forum
Suggested answer

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

editSubscribe (0) ShareShare
ReportReport
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,512 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,512 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,633 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.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,068 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,591 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans