Share
ReportI'm fairly new to the world of GP and I'm wondering is there a way to view all the notes attached to jounral entries and accounts for a given year.
*This post is locked for comments
You’re offline. This is a read only version of the page.
65
I'm fairly new to the world of GP and I'm wondering is there a way to view all the notes attached to jounral entries and accounts for a given year.
*This post is locked for comments
To be more flexible and stay our of SQL (unless you are technical) you can create a SmartList using SmartList Builder to perform this function. This can be added to the current list of Smartlists for any authorized user and you can then apply filters as desired.
We have a book that explains the Smartlist Builder and other tools called Customizing MS Dynamics GP with The Builders that explains how to do this. You need the SmartList builder tool (it is an option)
Dynamics GP notes for either master or transaction tables are stored in the "Record Notes Master" | [ SY03900 ]. Any text that you enter will be included in the
[ SY03900 ] under TEXTFIELD.
In order to check for simple test on an account.
To check the note entered above,
SELECT * FROM SY03900 WHERE NOTEINDX = (SELECT NOTEINDX FROM GL00100 WHERE ACTINDX = #ACCOUNTINDEX )
The test above applies as well on transaction (Journal Entries), you need to check for the note index in GL20000, and look for it in the record notes master.
#1
Almas Mahfooz
3
User Group Leader
All responses (
Answers (
