Hello - Does anyone have any tips on how I can report, via SQL, on the notes field on the user table? Basically, I'd like to build a query to return the notes, by user. I'd like to store info on a user in the notes field, hence the request. I am aware that the Notes Master table is SY03900 table, and that the user master table is SY01400. I appreciate any input you can offer. Thanks.
User Notes table is in Dynamics Database. Table Name : Sy02600.
Take a look at our product Enhanced Notes. Please see following link where you can try a demo also www.gpelementz.com/enhanced-notes.html
SY03900 this is Record Notes Master table. It will save all the note information rather than users notes information. User notes will save in separate table called User Notes Master (SY02600) in system database. You can directly get notes values from this table without linking to user master table SY01400.
Hope this helps!!!
Soma, I apologize if I've already asked, but are you planning on going to any of the conferences this fall? I'd like to meet you.
Wanted to create a smartlist for capturing the notes next to Document number in the Sales Transaction Entry screen under Document id "Invoice". What is the table from the sales module that should be linked with Record Notes Master.