web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / System Message 8031: T...
Microsoft Dynamics SL (Archived)

System Message 8031: The object names in the simple control file are not sorted correctly.

(0) ShareShare
ReportReport
Posted on by Shelly Spaugh 130

When using the Transaction Import to upload our budgets, we keep getting the above error.  I have checked the control file against the csv I'm importing and they are the same.  We'd made sure that all the numbers are in text format and that we don't have any extras that the system might not recognize in the file.  Any suggestions?

*This post is locked for comments

I have the same question (0)
  • Adam Leonard Profile Picture
    Adam Leonard 2,151 on at

    Hi Shelly,

    We've seen some problems using a simple control macro in TI.  I want to say I've personally written up a bug in Budget Maintenance in regards to TI and simple control macros.  I would recommend first generating an intelligent control macro for the screen and use it.  See if the error message changes or goes away.

  • Greg Klemm Profile Picture
    Greg Klemm on at

    I am receiving the same message when trying to import a GL entry. Can you please clarify what you mean by "generating an intelligent control macro?" Thanks.

  • Suggested answer
    tknow Profile Picture
    tknow 817 on at

    The intelligent macro is definitely the ticket.  My simple macro kicked back the same error when changing Inventory Item descriptions and when I switched to the intelligent macro, I had no errors at all.

    Thanks for the help on this.

  • Community Member Profile Picture
    Community Member on at

    While working with the Simple Control file and the Sales Order entry screen in Order Management I received the same System Message 8031.  I had pared the control file down to just the few fields I wanted/needed to import.  As part of that paring I removed the cOrdNbr field which is a key field. Once i put that field back into the control file and adapted the import file to leave it blank (since it is serially assigned by the system), the error was resolved.

  • Community Member Profile Picture
    Community Member on at

    I'm having the same problem when importing for Journal Transactions.

    My CSV files have the following columns (cjvno, cacct, csub , ctrandate, cdramt, ccramt, ctrandesc) and the numbers are in text format. I have tried both Intelligence and Simple CTL and same message received "The object names in the simple control file are not sorted correctly"

    For the Intelligence CTL i did not change anything inside and use the same CSV. With the simple CTL I edited the file and have the same columns displayed with the CSV.

    Please help!

    Thanks,

    Luanne

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

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April 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