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 :
Microsoft Dynamics NAV (Archived)

Error importing from excel

(0) ShareShare
ReportReport
Posted on by

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

  • Suggested answer
    Suresh Kulla Profile Picture
    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.

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    on at
    RE: Error importing from excel

    Are you importing Purchase Header or Purchase Line ?

  • Suggested answer
    Bamidele Joseph Profile Picture
    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,
  • Bamidele Joseph Profile Picture
    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
    RockwithNav Profile Picture
    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!

  • Suggested answer
    Olister Rumao Profile Picture
    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.

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

    Thank you Olister,

    It worked perfectly.

    Thanks

    Bamidele Joseph

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

    Glad it helped.

    Kindly verify the answer if my answer resolved your queries.

  • IMDS Profile Picture
    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

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

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…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans