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 :
Microsoft Dynamics GP (Archived)

GP Table for SOP Notes

(0) ShareShare
ReportReport
Posted on by 2,119

 Hello GP Experts,

 I have a quick question. Our users have been putting in notes into the Sales Orders. And now I have to make a query to retrieve the content of those Sales Order notes. Unfortunately GP tables confuse me; I'm not sure which table these notes are stored into. Does anyone know which GP table brings this Sales Order notes information?

The notes are stored and can be retrieved by clicking on this button in Sales Order:


 When clicked it displays this note:

Thanks in advanced for your help!!

 

 -Elizabeth

*This post is locked for comments

I have the same question (0)
  • Richard Whaley Profile Picture
    25,195 on at

    These notes (called Record Notes) are stored in the SY03900 table in the company database.  The individual records (in SOP10100) contain a field named NOTEINDX.  Use this field to relate the sales order to the NOTEINDX field of the SY03900 table to pull the appropriate note.

  • kuroneko1313 Profile Picture
    2,119 on at

     Richard, thank you very much for your reply; this helps me a lot!

    Have a great day :)

     

    -Elizabeth

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