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 / 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

  • Nitin Verma Profile Picture
    Nitin Verma 21,812 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.

  • IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 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 103,797 Super User 2026 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the September Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 795 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 561 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 323 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans