Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

NoteIndx/RM20101 Table

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Does anyone understand how the noteindex in rm20101 is assigned. I believe its created at the time an invoice is created but is there a table that keeps track of the noteindex. I realize that all transactions do not have notes and therefore the noteindex number/note will not be in the sy03900 table.

*This post is locked for comments

  • veeyeskay Profile Picture
    veeyeskay on at
    Re: NoteIndx/RM20101 Table

    Hi Michael

    My 2 cents to it - This procedure typically uses the value for the NOTEINDX field in the SY01500 table in the DYNAMICS database and immediately increments the note index value by 1.

    Also take a look at the article Fixing missing Note Index values by David Musgrave, which talks of updating missing note indexes, which should be of help. :)

    blogs.msdn.com/.../fixing-missing-note-index-values.aspx

    Let us know if you need further assistance.

  • MichaelJ2 Profile Picture
    MichaelJ2 265 on at
    Re: NoteIndx/RM20101 Table

    Here's some more information on how to use that.

    mbsguru.blogspot.com/.../get-next-noteindx.html

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: NoteIndx/RM20101 Table

    Use the smGetNextNoteIndex procedure in the Dynamics DB which updates the table  SY01500 with the noteindx

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans