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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Sale Order upload thro...
Microsoft Dynamics AX (Archived)

Sale Order upload through Excel file.

(0) ShareShare
ReportReport
Posted on by Kamran J 75

Dear Experts,

Please advice me how to create excel template through which we can upload Sale Order.

Moreover what is the purpose of ''Generate from Template'' button in Sale & Marketing form.

Regards

Kamran J

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Kamran,

    Do you need that template for testing purposes or do you plan to use it for something else?

    For a live application the upload of mass data through the excel add in is not the best solution and you better go for the export import framework.

    Best regards

    Ludwig

  • Kamran J Profile Picture
    Kamran J 75 on at

    Hi Ludwig,

    Actually I want to design a solution for Live application. I want to design an excel file through which user fill all required data in excel sheet and upload in dynamics AX as a sale order, rather than to create sale order and add lines manually.

    we do the same in transfer order, like upload transfer order through excel file.

    so same solution for sale order I am looking for.

    Regards

    Kamran

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Kamran,

    Here is a brief description how this can be achieved

    community.dynamics.com/.../dynamics-ax-2012-sales-orders-import-using-excel-add-in

    It's already a bit older and things might be slightly different in a R2/R3 environment. However, I think that you can get the idea and concept how this can be realized.

    Please do some performance testing before using this in your live environment.

    Many thanks and best regards,

    Ludwig

  • Kamran J Profile Picture
    Kamran J 75 on at

    Dear Ludwig,

    Many thanks for your help. definitely i will test then deploy on live upon successful results.

    Yes! we are using R3 version. kindly suggest what is more appropriate than the solution on which i am going to work on.

    Regards

    Kamran

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Kamran,

    You need to test the performance of this Excel addin.

    Also check what happens if you share the Excel template with other users and whether they are able to execute the upload.

    If you find that this is not really gonna work for you, consider using the data import/export framework.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Kamran,

    did you get this excel template? Does it work properly?

    Thanks

    Yingwen

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans