Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP2010 Sort Order 50 c...
Microsoft Dynamics GP (Archived)

GP2010 Sort Order 50 change to Sort Order 52

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

In version 10 and older there used to be scripts out there to pull the data out of GP database into a text file and then there were scripts to push that text files data into the new blank company database in the SQL instance that had sort order 52.  We have found that those scripts don’t work for v2010 or higher and we are running into issues with duplicates.  Are there scripts that can be run to find duplicates so they can be corrected?  Are there some tools or scripts out there that can help with pulling the data out and be able to push into the new sort order 52? 

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP2010 Sort Order 50 change to Sort Order 52

    Do you know which tables had the duplicates? I would guess the customer and vendor master tables. I would run something like these in SQL:

    SELECT COUNT(*),CUSTNMBR

    FROM TWO..RM00101

    GROUP BY CUSTNMBR

    HAVING COUNT(*) > 1

    SELECT COUNT(*),VENDORID

    FROM TWO..PM00200

    GROUP BY VENDORID

    HAVING COUNT(*) > 1

    I suppose the same thing would apply to employees and inventory items. You should not run into this issue with document numbers. I suppose if you really want to get carried you could write a script to go through every table to look for duplicates but there should not be that many. If you have been running the bulk copy scripts you should know which ones need help.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP2010 Sort Order 50 change to Sort Order 52

    How can these duplicates be identified throughout GP for the clean up your suggesting?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GP2010 Sort Order 50 change to Sort Order 52

    Those are called the bulk-copy scripts. They are not dependent on the version of GP. What you are running into is a case sensitive database being converted into a case insensitive database. So if your vendor IDs in the sort order 50(binary) database you could have two vendors, one with an ID of AcmeCons and another with ACMECONS. However, with sort order 52 these would both be treated the same, hence the duplicates. You will need to correct these duplicates before you do the bulk-copy. I would use the PSTL for GP 2010 and clean them up, assuming there are not that many. Once the IDs no longer contain duplicates they will be able to be pushed into the new sort order. If you do have many to adjust them custom scripts will be required.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans