Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Creating Collections Management Note Programmatically

(0) ShareShare
ReportReport
Posted on by 536

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:
  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Creating Collections Management Note Programmatically

    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.

  • Riaan Taljaard Profile Picture
    Riaan Taljaard 536 on at
    RE: Creating Collections Management Note Programmatically

    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
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Creating Collections Management Note Programmatically

    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
    Riaan Taljaard 536 on at
    RE: Creating Collections Management Note Programmatically

    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

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Creating Collections Management Note Programmatically

    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 ?

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans