infor crm tip

Infor CRM Tip: How to Find Specific Attachments

I recently helped a client who was looking for a solution that would enable him to find specific attachments quickly based on their intended use. For example, an Account might have several attachments associated with it, but the user may want to know which of those various attachments is being used for which specific purposes. A "specific purpose" might be something like a contract for the account, or a support agreement.

In the code example below, it is assumed that a contract document needs to be tracked for every Account. So there is a custom field called ContractAttachmentId that stores the identifier of the Attachment containing the agreement for the Account being currently viewed. The code populates a drop down list with all the attachments associated with that Account. A user can then choose one of those attachments and save the record so he doesn’t have to scan through the entire list to find the contract.

This code should be set up on the Load event so as to populate the dropdown as soon as the screen loads. The same concept can be extended if other entities such as Opportunities, Contacts etc. have to be linked to specific attachments.

Related Articles

June 29, 2017

We humans are used to managing things. We manage our time, our money, our deadlines, our family obligations – it’s exhausting! So, when we get the opportunity to simplify some of those management responsibilities, it’s worth a second look. TAI partners with tools that make the management of CRM data a little less daunting. The products I’ve listed below integrate with either Infor CRM, SugarCRM, or Salesforce. So, without further ado, here are five CRM tools that will make your management tasks effortless.

October 31, 2016

You may not think of CRM as a marketing tool, but the information it provides can be extremely useful to a marketer. You could be utilizing some great features of CRM not only to enhance your marketing, but also make your life a little simpler – and goodness knows we all could use a little more simplicity! Here are 3 ways to use CRM to enhance your marketing:

Allen D'Souza
Senior CRM Consultant

Allen is a senior CRM consultant at Technology Advisors Inc. He spends most of his time designing solutions using InforCRM, StarfishETL, and SQLServer. He also specializes in data migrations from-and-to Microsoft Dynamics CRM and Allen has been involved in large implementations for prominent players in the real estate, telecom, manufacturing, and publishing industries. Prior to working at Technology Advisors, Allen worked as a Microsoft application developer in the Accounting space. Outside of work, he likes to meditate, play his guitar, and eat chocolate.