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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Cross-linked or incorr...
Finance | Project Operations, Human Resources, ...
Answered

Cross-linked or incorrect notes indexes in Microsoft Dynamics GP

(0) ShareShare
ReportReport
Posted on by joeyinlfs 37

I am having this note issue where notes are getting cross-linked into different modules like sales, inventory and purchasing. We have seen some sales order notes with also appear in the customer card notes and vice versa. This is happening to the new company I created in December 2019. I created a new company and restored the database from another company. Since then I have noticed on the new company that it is assigning NOTES ID which has already been used hence the cross-linked. 

I know there had been several relevant threads posted before with this same issue. The problem is I have GP 2016 R2 and the fix that Microsoft have for this issue does not apply to my version. I was wondering if anyone has an updated SQL statement fix for GP 2016 R2 or if anyone knows where I can get a copy of the free tool from Microsoft, NOTE FIX UTILITY. I read that this is a dexterity tool with complete user interface.

Can anyone please help or maybe direct me to the proper people or department?

Looking for your response.

Thank you.

Joe Soriano

joe.soriano@siegers.com

I have the same question (0)
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 967 Super User 2025 Season 2 on at

    After restoring the database, did you set the NOTEINDX in DYNAMICS..SY01500 to a number greater than the one in the original company?  

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    Do you still have the original DYNAMICS database? If so, simply retrieve the note index value from each of your companies and set the values in the new DYNAMICS database to those values. That is essentially what the NOTEINDX utility did although it would go through your company databases and retrieve the highest note index value. Hopefully you haven't entered too many new transactions. The last NOTEFIX I have is for GP2013. Any new tables since GP 2013 would not be in there to search.

  • joeyinlfs Profile Picture
    joeyinlfs 37 on at

    No I did not.

  • joeyinlfs Profile Picture
    joeyinlfs 37 on at

    Since I just added a new company, I believe all of the other companies NOTEINDX are still there. How do I retrieve the highest value of NOTEINDX? Should I just get the NOTEINDX number from the company I copied from and set that number to the new company? I created the new company Dec. 19 and this is the busiest time of the year for us. Once I get the highest value of the NOTEINDX, do I just use an "UPDATE" SQL statement? Thank you for your help. Much appreciated.

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    Using the NOTEINDX from the original company you can run this in SSMS

    UPDATE DYNAMICS..SY01500 SET NOTEINDX='Value from original company' WHERE INTERID='NEWCOMPANY INTERID'

    When you created this company the NOTEINDX value was set to one and then it started going up. It would also help to look at what the current value of NOTEINDX for your copied copy in SY01500 and add this value to the value from the original company. When you are done try testing entering new notes to insure you have set the value high enough.

    Finding the highest note index is a very involved task as there are hundreds of tables that have multiple noteindex values in them.

  • joeyinlfs Profile Picture
    joeyinlfs 37 on at

    Thank you Richard. I am not too familiar with SQL statement. Should I include the zeroes in the NOTEINDX number? Like should my entry be NOTEINDX='2498577.00000'

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    The zeroes are not necessary.

  • joeyinlfs Profile Picture
    joeyinlfs 37 on at

    Good morning Richard. The solution you suggested worked. So far we haven't seen any cross-linked notes. Thank you.

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 Giving Solutions is Here!

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 679 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 429 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 264 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans