Details about this thread
  • State Suggested Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 112 subscribers
  • Views 2148 views
  • Users 0 members are here
Related content from around SugarClub

Adding Business Type Column in Report Editor

Jessica Bolts

Hello! I am building a custom tabular report in the analytics section of Sugar Market. I am trying to include a column for the "Business Type" field in the account level of our records in Sugar Sell.

I have searched through every column option, tested out a handful (such as accounts.account_type, accounts.AccountTypeID, contacts.account_type_c, and more) and nothing seems to pull in what I'm looking for. Any insight on how I might accomplish adding a Business Type column?

Thanks in advance!

Parents Reply Children
  • 0 Sugar Employee Badge in reply to Jessica Bolts

    Hey Jessica,

    Glad you found it! I was going to suggest to locate the field in Sugar Sell Studio where you can view all fields on the Account table and look for the system name (or the backend name) as sometimes those are very different than the user friendly 'label' that's displayed in the Account/Contact Layout. But sounds like you were able to find it.

    Regards,

    Michael North

    Sr. Manager, Technical Support