Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

SL Transaction Import multiple line item problem

Posted on by

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

  • 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 70 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.

  • 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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans