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 / Small and medium business | Business Central, N... / Publish orders header ...
Small and medium business | Business Central, N...
Answered

Publish orders header and detail from excel

(0) ShareShare
ReportReport
Posted on by Gabriel Prinz Landeo 35

It is possible to load sales orders from an Excel with central business header and detail

What is required to do is load sales orders from an Excel, it only lets me load the header but does not let me load the detail lines

By giving to publish the lines does not let me

Sincerely Gabriel Prinz

I have the same question (0)
  • Nitin Verma Profile Picture
    Nitin Verma 21,708 Moderator on at

    Hi,

    you can try Configuration packages, to Export Sales Header Table(36) and Sales Line Table(37), export them as a Excel and later after putting the data into excel, import those back.

    Follow the below link

    docs.microsoft.com/.../across-import-data-configuration-packages

    Thanks.

  • Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,111 Moderator on at

    If it is something you will do one time the the config pack is ok.

    If you are doing this import on a regular basis i would get a customization that are reading the Excel file directly with out going through the config package.

    If you write AL code you can use the Excel buffer codeunit.

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 95,739 Super User 2025 Season 2 on at

    Hi, here are some examples.

    Import data:

    https://yzhums.com/4223/

    Export data:

    https://yzhums.com/4180/

    Import multiple excel files in zip:

    https://yzhums.com/21483/

    Hope this helps as well.

    Thanks.

    ZHU

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,135

#2
YUN ZHU Profile Picture

YUN ZHU 733 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 612

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans