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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Creating Collections Management Note Programmatically

(0) ShareShare
ReportReport
Posted on by 538

Hi everyone

I know there is software you can get that explain how to create collections management notes programmatically in GP. I was testing this a few weeks ago and misplaced the software and when I restored my live DB into my TEST environment I lost the stored proc also. I only remember the sp was called AddUpdateDeleteCollectionManagementNote.

Anyone have any info for me?

Categories:
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,075 Moderator on at

    Hi Riian,

    See if you can find anything related here:

    community.dynamics.com/.../collectionsmanagementtipstricks

    Other than that, I'd suggest to contact ProfAd.. I'm not aware of any other tool that integrates with CM.

    How did you create the SP in the first place ? didn't you kept the script somewhere ?

  • Riaan Taljaard Profile Picture
    538 on at

    Hi Beat

    I eventually found the stored proc on a TEST company I forgot about. Now I only have the sp and not the instructions that go with it but at least I can do my testing again.

    I have attached the proc if you wanted to see it.

    I have also contacted ProfAdv.

    Thank you

    /cfs-file/__key/communityserver-discussions-components-files/32/AddUpdateDeleteCollectionManagementNote.sql

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,075 Moderator on at

    Thank you Riaan for sharing the code.

    Unfortunately that link seems to be blocked by the Dynamics Community servers and is not allowing the download.

    Maybe you could share it thru some other means ? (drop box, 1Drive, etc.)

  • Riaan Taljaard Profile Picture
    538 on at

    Hi again

    I have one better. I got feedback from ProfAdv and then remembered how I got the code initially. Here is the response from ProfAdv.

    "The SDK can be installed during the installation of Collections Management.  The SDK folder is placed in the Documentation folder within the GP code folder to in which Collections Management is installed.  The SDK includes additional stored procedures that can be used to import collections notes.  There is also a Dexterity API that can be installed and called within the Dexterity code.  We do not currently have an external application for use with importing data into Collections Management.  You would have to reach out to Microsoft for help with record/window notes, OLE notes, or document attachment within GP."

    Have a good day.

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,075 Moderator on at

    Thank you very much Riaan,

    I'll make a note on that one from ProfAd.. though it never occured to me that there was an SDK deployed when installing CM, but now that I checked the documentation, it's listed as part of the selection during the setup. :-)

    I found all the SDK documentation under the CM-SDK folder once it's deployed in a folder. There are some very interesting lectures there.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 544 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 347 Super User 2026 Season 2

#3
CU-1234529-002 Profile Picture

CU-1234529-002 197

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans