Error on Deals: Column 'ColumnName' is editable

Description

There is a following error coming from the server:

Column 'Price' in table 'Leads' is editable. Procedure 'eWaySP_CalculateLeadsPrices' was terminated.

Name of the column in error can differ.

Version

All versions of eWay-CRM

Difficulty

Low

Resolution

Situation can be checked here: Administration Application > Column Permissions > System user > Deals where all columns can be editable - the permission for the column is set to Users Hold Full Control Over This Column. For more information, go to Set Column Permissions.

If the field on deals is set to Users Hold Full Control Over This Column, please follow these steps:

  1. Go to eWay-CRM tab and click on Administration Settings.
  2. In left menu, select Global Settings.
  3. Choose Deals and double-click Calculate Revenue on Deals From Bookkeeping Records.
  4. Set the value to 0, then confirm it. Let it synchronize.
  5. Double-click the setting again, set the value to 1, then confirm it. Let it synchronize.
  6. Check state of columns in Column Permissions. Permissions must be changed to value Users See This Column But They Can't Edit Values and error does not appear anymore.