Sage CRM

Cross posted on: https://community.sagecrm.com/partner_community/f/73/p/7160/19341.aspx#19341 I am attempting to add a new table to #CRM called ""Equipment."" The caption is ""Equipment"", the ID Field Name is ""eqp_equipmentid"", the column prefix is ""eqp"" and I am using CRM 7.1d. Whenever I try to save the table, I get an error: ""ErrorInSequences SQLError."" Any ideas? Thanks in advance! #UnhelpfulErrorMessages #sagecrm

How are you trying to add the table? Does it happen in multiple environments? Is this a trial environment? A production environment? As an aside / related note, here are two tips for anyone adding tables or fields into Sage CRM: 1. For adding tables, prefix them with a unique two character code for your company or the client. Ex. I'm adding a table to store Equipment, so I would call it AZEquipment. 2. For adding fields to existing tables, prefix them with the same unique two character code for your company or the client. Ex. I'm adding birthdate to the Person table, so I would call the field pers_azbirthdate. This will help make your customizations more resilient when it comes time to upgrade as it minimizes the chance of conflict with Sage modifications. There is a well-known partner who created an Order and Quote table in the early days of Sage CRM. When Sage expanded the Accpac integration to create similar tables ... oops! Lots of upset clients.

It's a test environment. I'm just doing some research for a client. Great advice on the customizations. Sent via DroidX2 on Verizon Wireless