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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / In which table sales o...
Microsoft Dynamics GP (Archived)

In which table sales order line level note will be saved in Dynamics GP 2013

(0) ShareShare
ReportReport
Posted on by Community Member

In which table sales order line level note will be saved in Dynamics GP 2013?7484.Notes.png

In above figure as i showed that note where it should be stored in GP Database table?

Advance Thanks for you all

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    SY03900 - Record Notes Master. It stored all notes with reference to NoteIndx field that is stored at SOP line record.

  • Verified answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at

    The notes of the Line Items correspond to the notes of the Item itself and not to the Sales Transaction Line.

    Record notes are stored in the table SY03900 (Record Notes Master), but the NOTEINDX you need is found in table IV00101 (Item Master) and not in table SOP10200 (Sales Transaction Amounts Work).

    The following script will help you to find the note you are looking for:

    SELECT IV00101.ITEMNMBR, IV00101.ITEMDESC, SY03900.NOTEINDX, SY03900.DATE1, SY03900.TIME1, SY03900.TXTFIELD

    FROM IV00101 INNER JOIN SY03900 ON IV00101.NOTEINDX = SY03900.NOTEINDX

    WHERE (IV00101.ITEMNMBR = 'REDMINOTE1')

  • Galina Profile Picture
    Galina 1,077 on at

    Actually, what you are pointing at is an Item Master note. Don't use it to put comment in the sales line.

    The table you need is SOP10202

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#3
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans