Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

SL2011 Importing Multiple PO Lines

Posted on by 2,401

Good day - i'm having issues importing multiple PO lines into a purchase order. The error is a bulletproof error 10115 - "Out of bounds row value passed to kernel function _mdelete"

Has anybody seen this?

Or better - does anyone have a sample (functioning) import file i can use as a reference?

thanks

James

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL2011 Importing Multiple PO Lines

    Yes. Here is another example for the voucher.

    Currency, CAD

    CuryRate, SPOT, 03/03/2003, .74

    "Batch",,200501,"H",100.00,

    "Document",,"VO","VENDID",03/03/2003,,03/03/2003,01,100.00,0,"A",,,,,03/03/2003,,,,,,,,,,,,,,,,,,,,,,,,

    "Transaction","N",5200,,,0000,,,,,100.00,,,,,,,,,,,,,,,,,,,,,

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,401 on at
    RE: SL2011 Importing Multiple PO Lines

    Ok Elaine - i did some googling and found out that you need to declare it beforehand:

    Currency,USD

    CuryRate,SPOT,11/01/2013,96.432015429

    Level0,TVCL,016794,OR,API001,O,,748323,,03712,,P,,,,,,,,,,,,,,,,,,,,,,,,,,,07/10/2013,0,,,001,,

    support.microsoft.com/.../844270

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,401 on at
    RE: SL2011 Importing Multiple PO Lines

    Hi Elaine.. Sorry I realize now that i need to select the currency of the document by clicking the 'Currency' button on the top of the screen..

    Do you perhaps know how i can select this in the import file?

  • SU-22040800-0 Profile Picture
    SU-22040800-0 2,401 on at
    RE: SL2011 Importing Multiple PO Lines

    Hi Elaine

    Thanks for the help on this, but i have 1 last small question:

    I have a number of PO's that are being imported for Vendors that have various currencies. Do I import these at the vendor's currency amount? Or do i import them as a converted BASE/Company currency?

    I've just run a few tests in a SLDemoApp60, and it didnt seem to affect the figure whatsoever..

    thanks a mil

    James

  • Verified answer
    SU-22040800-0 Profile Picture
    SU-22040800-0 2,401 on at
    RE: SL2011 Importing Multiple PO Lines

    Awesome - that worked Elaine! Thanks a million!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL2011 Importing Multiple PO Lines

    Hi James,

    I find bug 23449 reported in ver 8 which says:

    When using Transaction Import in Minimized mode to import more than one detail line into the Purchase Orders (04.250.00) screen only the first detail line is saved in the newly created Purchase Orders..

    The workaround is to Run the Import with the Minimized option unchecked.

    I don't see any error though with this.

    Is the screen customized?

    Sample data file from the bug:

    Level0,,,,VT0121,O,,,,,,,,,,,,,,,,,,,,,,,,,,,,,05/24/2011,,05,,,,,

    Level1,GI,0RCHAINGUARD,LA,111,EA,1.1000,09.86,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

    Level1,GI,0RCHAINGUARD,LA,222,EA,0.7500,11.94,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

    Level0,,,,VT0121,O,,,,,,,,,,,,,,,,,,,,,,,,,,,,,05/24/2011,,05,,,,,

    Level1,GI,0RCHAINGUARD,LA,333,EA,0.7500,54.46,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

    Level1,GI,0RCHAINGUARD,LA,444,EA,0.7500,78.33,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

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