Favourites feature not working for Custom entity

By | April 4, 2019

Sage CRM’s Favourites feature allow users to mark all primary entities record as user’s favourite record and access them easily from user Favourites list. Users can also mark record from custom entities as Favourites. But have you ever have faced any error while accessing a Custom entity record from Favourites list?

New Stuff:  How to know Company/Person has been used for MailChimp/Swiftpage E-Marketing

There were various kinds of error faced while marking a Custom entity record as Favourite; like in some cases, the user can include a custom record in favourites list, but upon clicking on the link it fails to display the record and gives an error. Whereas, in certain cases when you click on Star icon to make custom record favourite and nothing happens – the icon colour remains unchanged suggesting the record is not marked as a favourite.

On troubleshooting the issue we found that the recordUrl attribute of the Favourite item in JSON Request is blank. Thus whenever user clicked on the link it failed.

You can follow below steps to solve the link issue for favourite records:

  • JSON request is based on sData, so you need to enable the SData for custom entities as well. You can enable the SData for Custom entity from:
    Administration -> Advanced Customization -> Tables and Databases -> Select Yes from Read-only sData field and save the details.

You can refer below screen shot for same.

  • Once you have enabled the sData for custom entity, you can check that the recordUrl Attribute have value in JSON Request by accessing the below URL in browser

localhost/sdata/InstanceNamej/userdata?SID=**************&Action=getFavourites

By accessing above URL you will get the list of all favourite items and value in recordUrl attribute.

You can refer below screen shot for reference.

  • When the recordUrl attribute of JSON request is blank for custom entity then in such scenario make sure that the Bord_EntityKind and Bord_ViewFileName fields are not blank in the Custom_Tables table in Database for custom entities.

Bord_EntityKind should be set as asp and Bord_ViewFileName should be summary page path.

For example, for Custom Entity named Agreement execute below Update Query:

UPDATE Custom_Tables SET  bord_EntityKind=’asp’, Bord_ViewFileName=’Agreement\AgreementSummary.asp’
WHERE bord_caption='<Custom Entity Table Name>’

  • Once you have done with above steps, do full metadata refresh. Your favourites will work.

In this way you can now easily solve linking issue for custom entity in Sage CRM.

About Us
Greytrix a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix has some unique integration solutions for Sage CRM with Sage ERPs (Sage Enterprise Management (Sage X3), Sage Intacct, Sage 100Sage 500 and Sage 300).We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users and Sage PSG worldwide. Greytrix helps in migrating of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature and Sage CRM CTI Framework.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage Enterprise Management – Sage CRM integration also listed on Sage Marketplace.

For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.