Microsoft Dynamics NAV (Archived)

Error importing from excel

(0) Share

Report

Posted on by Bamidele Joseph

How can I resolve this error text emanating from Config.Package Errors:

The Purchase Header does not exist. Identification fields and values: Document Type='Invoice',No.='12608/01/2018'

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

As the error mentions if you have multiple records with the same no. then you will get that error. Check for duplicate records in your file and avoid all the special characters in the No. Field. Check the format of the file.

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (0)

Report

Are you importing Purchase Header or Purchase Line ?

Was this reply helpful? Yes No
Suggested answer

Bamidele Joseph 12 on at

Like (0)

Report

@ Teddy H

Yes,

I am trying to import purchase header and purchase lines.

The header seem to be correct but the lines is what's giving the problem.

I have tried to analyse it and discovered that the document number is where the issue lies.

The question then is "How do I produce Document number?"

I will appreciate any assistance you can provide.

Thank you,

Was this reply helpful? Yes No
Bamidele Joseph 12 on at

Like (0)

Report

@ Teddy Herryanto

Yes,

I am trying to import purchase header and purchase lines.

The header seem to be correct but the lines is what's giving the problem.

I have tried to analyse it and discovered that the document number is where the issue lies.

The question then is "How do I produce Document number?"

I will appreciate any assistance you can provide.

Thank you,

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,637 Super User 2025 Season 2 on at

Like (0)

Report

If you are executing this from Rapid-start and ended with this error then you need to cross check somewhere either that duplicate values exists OR while importing system is trying to make that duplicates!

Was this reply helpful? Yes No
Suggested answer

Olister Rumao 3,967 on at

Like (0)

Report

Hi Bamidele Joseph,

Let me explain you the structure of Purchase Header and Lines.

There are total 2 fields whose combination is needed to be unique.

For Purchase Header

1. No.

2. Document Type.

Where as for Purchase lines there are total 3 fields whose combination is needed to be unique.

1. Document Type

2. Document No. ( This is Purchase Header No. )

3. Line No.

If this combination is correct then NAV will not give you error.

Let me know if you need any help.

Was this reply helpful? Yes No
Bamidele Joseph 12 on at

Like (0)

Report

Thank you Olister,

It worked perfectly.

Thanks

Bamidele Joseph

Was this reply helpful? Yes No
Olister Rumao 3,967 on at

Like (0)

Report

Glad it helped.

Kindly verify the answer if my answer resolved your queries.

Was this reply helpful? Yes No
IMDS on at

Like (0)

Report

Hi,

I am also facing the same problem. Could you please check the attached excel file used to upload the information.

The attached excel has three sheets. Sheet name "Purchase header" is the header and "Purchase line" is the purchase line. Sheet name "Error" is the error received while uploading transaction.

Default27_5F00_05_5F00_2021_5F00_21_5F00_42_5F00_31.xlsx

Was this reply helpful? Yes No