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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

SmartList Builder Notes Gone

(0) ShareShare
ReportReport
Posted on by

Hello:

SmartList Builder, like many GP windows, has a note field near the SmartList ID field.

Yesterday, I noticed that all such notes are gone.

Hopefully, they are simply "hidden" within a SQL table and can be retrieved.  That table is not the "regular" SY03900 table.  That's a "company" table and not a system table.

Which table contains SmartList Builder notes?  Also, other than restoring a backup from whenever the notes got "carried off", is there a way to retrieve these?

Almost as important, why would something like this happen?

We're on GP 2013 R2 (12.00.1920).

Thanks!

John

*This post is locked for comments

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

    Hello:

    I have an update.  The notes are back!  Somehow, the notes have "magically" reappeared.  I discovered this, earlier this morning.

    Although I'm glad about this, I'd like to know why the notes temporarily disappeared, in the first place.  Does anybody have any ideas?

    Can someone at least tell me the name of the SQL table that holds SmartList Builder's notes?

    Thank you!

    John

  • Verified answer
    Community Member Profile Picture
    on at

    I have another update.

    Smartlist Builder's notes are kept in the company database table, SY03900, and are displayed only when you are logged into particular company in GP.  Then, you can see notes that have been created and saved while logged into particular company.

    John

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans