Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Error importing from excel

Posted on by 10

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

  • IMDS Profile Picture
    IMDS on at
    RE: Error importing from excel

    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

  • Olister Rumao Profile Picture
    Olister Rumao 3,957 on at
    RE: Error importing from excel

    Glad it helped.

    Kindly verify the answer if my answer resolved your queries.

  • Bamidele Joseph Profile Picture
    Bamidele Joseph 10 on at
    RE: Error importing from excel

    Thank you Olister,

    It worked perfectly.

    Thanks

    Bamidele Joseph

  • Suggested answer
    Olister Rumao Profile Picture
    Olister Rumao 3,957 on at
    RE: Error importing from excel

    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.

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: Error importing from excel

    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!

  • Bamidele Joseph Profile Picture
    Bamidele Joseph 10 on at
    RE: Error importing from excel

    @ 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,

  • Suggested answer
    Bamidele Joseph Profile Picture
    Bamidele Joseph 10 on at
    RE: Error importing from excel
    @ 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,
  • Suggested answer
    TeddyH Profile Picture
    TeddyH 12,868 Super User 2024 Season 1 on at
    RE: Error importing from excel

    Are you importing Purchase Header or Purchase Line ?

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Error importing from excel

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans