web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / SL Transaction Import ...
Microsoft Dynamics SL (Archived)

SL Transaction Import multiple line item problem

(0) ShareShare
ReportReport
Posted on by Ying Fong

I am trying to import orders using transaction import to 4010000.

My orders have 1 order header and multiple line items. However when I ran the transaction import, a separate order is created for every line item. How can I create 1 order with multiple line items.

*This post is locked for comments

I have the same question (0)
  • Ying Fong Profile Picture
    Ying Fong on at
    Re: SL Transaction Import multiple line item problem

    Thanks Bruce.

    Can also refer to mbs2.microsoft.com/.../KbDisplay.aspx

  • Verified answer
    Bruce Schwantz Profile Picture
    Bruce Schwantz 72 on at
    Re: SL Transaction Import multiple line item problem

    Make sure the screen is not minimized.  It seems to be an issue when the screen is set to minimized.

  • Jennifer Spitler Profile Picture
    Jennifer Spitler on at
    Re: SL Transaction Import multiple line item problem

    Ying,

    The data file will depend on how many defaults you have setup - for example, if Ship Via ID is setup on the Customer Shipping Address, then it doesn't need to be included in the data file, but, if it is not setup on the Shipping Address, it is a required field and will need to be in the data file.  As for the structure of the data file, you should be able to import a multiple line sales order with something like the following:

    Level0,,,SO, C300

    Level1,HON-672L-L,LA,1

    Level1,HON-673L-L,LA,1

    Level1,HON-674L-L,LA,1

    This is a very simple example, but, this should import a sales order using the SO order type for customer C300 with 3 lines as represented by each Level1 line.  

    Let me know how this compares to what you are using that is not working.

    Kind regards,

    Jennifer Spitler

    Partner Online Technical Community

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans