Microsoft Dynamics NAV (Archived)

Issue whilst posting a PO "The Purch. Rcpt. Line already exists. Identification fields and values: Document No.='-1',Line No.='10000'"

(0) Share

Report

Posted on by Hartej Virdi

steps followed

1. Opened PO

2. Clicked "Post" and then Receive and Invoice

3. It comes up with an error message "The Purch. Rcpt. Line already exists. Identification fields and values: Document No.='-1',Line No.='10000'"

Any help will be appreciated. :)

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

AJAnsari 5,754 on at

Like (2)

Report

I remember seeing an issue like this with a customer on NAV 2013 some years ago. We couldn't find a fix at the time (although it may have been addressed by a subsequent hotfix/cumulative update), and at the time our recourse was to find and delete the record(s) in the Purchase Rcpt. Header and Purchase Rcpt. Line tables where the Document No. was -1.

It wasn't happening with every PO, but we'd see it once every couple weeks. Unfortunately, we couldn't establish a pattern, so there wasn't a way to find a long term fix.

I hope this helps. If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Hartej ,

It seems that the Purchase Receipt lines have already been created for the PO.

You just need to Invoice .

For further clarification you may check the Posted Purchase Receipt for the Vendor.

Was this reply helpful? Yes No
Hartej Virdi 15 on at

Like (0)

Report

Unfortunately, that didn't work. I understand the analysis you went with here but accessing tables and deleting it from the table can cause other issues. is there another way you are aware of?

-Hartej V

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Check whether receipt no already exist in Posted receipt

If yes then check the no series attached for generating receipt no

Was this reply helpful? Yes No
Suggested answer

Mubashir 4 on at

Like (1)

Report

Hello, you need to open posted purchase receipts table and copy and paste the receipt number. It will show which PO it belongs to. Go on the PO (in my case the PO was partially invoiced and it had £0.02 left. I created zero value invoice and that solved the problem.

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,202 Super User 2025 Season 2 on at

Like (0)

Report

check the item ledger entry if there is an increase of the item qty associated with the PO. Also check value entries as well. If it's not possible to solve this from front end, you'll be able to access the impact on inventory and gl if a manual intervention is required from back end

Was this reply helpful? Yes No