Microsoft's David Musgrave takes on OLE attachments and record notes based on a support case he tackled recently. David reviews the process use by Dynamics GP to retrieve the next note index value and how the system associates the note to a record. He explores the OLE container and how the file names are encoded along with the path.
Furthermore, he provides some Dexterity and SQL code to demonstrate how you would retrieve the hexadecimal value used to compose the notes file name. Be sure to read David's article to get the complete scoop.
All About the Dexterity OLE Container - click here
Understanding Notes and the Note Index Field @ Developing for Dynamics GP, click here
Until next post!
Mariano Gomez, MVP
Maximum Global Business, LLC