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 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)
  • Jennifer Spitler Profile Picture
    Jennifer Spitler on at

    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

  • Verified answer
    Bruce Schwantz Profile Picture
    Bruce Schwantz 72 on at

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

  • Ying Fong Profile Picture
    Ying Fong on at

    Thanks Bruce.

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

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 SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans