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

Notifications

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) / GP Table for SOP Notes
Microsoft Dynamics GP (Archived)

GP Table for SOP Notes

(0) ShareShare
ReportReport
Posted on by kuroneko1313 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
    Richard Whaley 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
    kuroneko1313 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

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

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans