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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Import Purchase Requis...
Microsoft Dynamics NAV (Archived)

Import Purchase Requisitions

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

Need help importing excel spreadsheet containing purchase items from supply vendor (Daycon) such as item numbers, description, cost etc. Upon completion this would automatically create requisition. Once requisition has been generated the quote would need to be imported into NAV.

Thanks,

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

    Hi,

    You have posted the question in the wrong forum (AX). I have moved it to the NAV forum for you.

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 on at

    What exactly help do you estimate? Are you already making some development and face issues or do you want to get the general understanding how to solve the task?

    It can be resolved differently:

    Importing excel spreadsheets with items you can do using RapidStart service:

    msdn.microsoft.com/.../hh997614(v=nav.90).aspx

    msdn.microsoft.com/.../dn874068.aspx

    It would not require development, however will not provide you with automatically created requisition. You would need either to create it manually or generate it in Excel and again import using e.g. same RapidStart.

    Another option is to develop an xml-port for importing the data from your file, that would generate requisition automatically in the end of the import, as well as the quote. This would require developer's license and few days of work.

  • Community Member Profile Picture
    Community Member on at

    Thanks. I have set up the template for RapidStart, however the import from excel failed. Are you familiar with the ongoing issues regarding Field 480 having to be included when utilizing Table 246?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Are you facing any error? Can you attach the screen shot here?

    If it is related to Dimension Set ID, you can exclude 480 field as this would be generated automatically by system.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans