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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / The Purchase Line does...
Small and medium business | Business Central, N...
Suggested answer

The Purchase Line does not exist

(0) ShareShare
ReportReport
Posted on by Alejandro Bohorquez 101

Hello Everyone

I'm having the following error when I try to post a purchase order:

The Purchase Line does not exist. Identification fields and values: Document Type='Order',Document No.='870428',Line No.='50000',

But there is no line 5000 the purchase order only has until 4000, the last time I had this error I wrote something in the line error and deleted it but in this case, doesn't work. I appreciate it If anyone can help me with this error.

pastedimage1665592316497v1.png

I have the same question (0)
  • Omar K Profile Picture
    Omar K 201 on at
    RE: The Purchase Line does not exist

    Hi,

    Is it possible to delete the PO and recreate it? Deleting the PO will delete any related line.

    The way I can see it, is in the backend the line no. "50000" does exist but there is a problem with it, I would say corrupted record.

    In your question above you mentioned "Last Time" happened? Can you please describe what is happening ?? disconnection?? Interruption maybe?

    I also recommend trying "businesscentral.dynamics.com/?table=39" (Add ?table=39) at the end, can you see the record - filters can be applied" ?

  • Alejandro Bohorquez Profile Picture
    Alejandro Bohorquez 101 on at
    RE: The Purchase Line does not exist

    Thanks for your answer,

    I had this same error in the past so I fill the line with the error and then deleted it so that fixed the problem that time but now didn't work

  • Omar K Profile Picture
    Omar K 201 on at
    RE: The Purchase Line does not exist

    Yes, I do understand the issue, but I am thinking why it is happening ? what there is a corrupted line?

    Can you see the line when you open the table?

  • Alejandro Bohorquez Profile Picture
    Alejandro Bohorquez 101 on at
    RE: The Purchase Line does not exist

    I checked table 39 but I still see only four lines. Deleting the PO is the last option that we want to do, so we are searching for another possible solution.

  • Omar K Profile Picture
    Omar K 201 on at
    RE: The Purchase Line does not exist

    The way I see it is the following:

    - There is a "bad" record related to that PO.

    - Why is this happening as it is the second time, This leads me to a question, how that PO was created?

    - You can also search for "Purchase Lines" and then try "Edit in excel" can you see the records?

    - Another way to check the record, create a configuration package for table 39 and export it to excel, can you see the record?

    pastedimage1665596782438v1.png

  • Alejandro Bohorquez Profile Picture
    Alejandro Bohorquez 101 on at
    RE: The Purchase Line does not exist

    I checked the purchase line with edit excel and checked with the configuration package but I don't see the record only four lines are related to the document.

    Do you recommend deleting the PO and creating a new one?

  • Omar K Profile Picture
    Omar K 201 on at
    RE: The Purchase Line does not exist

    Deleting the PO will delete the related lines.

    But I am thinking why is this happening? How the PO was originally created as you said this is the second time?

  • Alejandro Bohorquez Profile Picture
    Alejandro Bohorquez 101 on at
    RE: The Purchase Line does not exist

    Yes, we create the PO using the configuration package to do it by "batch"  and sometimes do manually.

  • Omar K Profile Picture
    Omar K 201 on at
    RE: The Purchase Line does not exist

    I see,

    There is something with the configuration package, First confirm that the last line in the configuration package is not the last line in that PO, if it is then be sure to select that line and delete the line, not just clear the cells.

    If not, then check that the configuration package fields are validated so if something is wrong the configuration package will error.

    pastedimage1665601577047v1.png

    I am trying to discover the source of the problem so it doesn't happen again, for now, try to delete the PO and re-create it.

  • Alejandro Bohorquez Profile Picture
    Alejandro Bohorquez 101 on at
    RE: The Purchase Line does not exist

    I'll check it, however, we also check if the customization that we have maybe is causing this error.

    Thanks for your help.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,255

#2
Sumit Singh Profile Picture

Sumit Singh 2,665

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,401

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans