web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply Chain Management forum / Error Executing Code :...
Supply Chain Management forum

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

(0) ShareShare
ReportReport
Posted on by cfernandez 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

Categories:
Supply Chain Management
Development / Customization / SDK
On-prem Implementation
I have the same question (0)
  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,671 Moderator on at

    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.

  • Suggested answer
    Khushhal Garg Profile Picture
    Khushhal Garg 1,514 on at

    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

  • cfernandez Profile Picture
    cfernandez 40 on at

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

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

  • cfernandez Profile Picture
    cfernandez 40 on at

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

  • Suggested answer
    Khushhal Garg Profile Picture
    Khushhal Garg 1,514 on at

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

  • cfernandez Profile Picture
    cfernandez 40 on at

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

  • Mirror7 Profile Picture
    Mirror7 5 on at

    Hi, cfernandez,

    I also get this error message as you.

    Did you solve this problem or not?

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 > Supply Chain Management

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans