sms_-_error_unable_to_edit_zero_record [Support]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

======  ======



===== Error Message =====



Unable to edit the zero record.



{{::sms_unable_to_edit_the_zero_record.png?nolink&|}}



===== Explanation of Error =====



When attempting to edit a customer record in SMS you receive an error advising: "Unable to edit the zero record".



===== Severity =====

**Low**



===== Possible Root Cause(s) =====



The TaxIDExpDate field for that customer contains an improperly formatted date which is causing an error when SMS attempts to edit the customer record.



===== Resolution =====



Although not an ideal solution, in an instance where you can not resolve the problem through other means you can execute the following SQL query to remove the TaxIDExpDate entries. You can do this for a single company through Database Browser or for all companies using the same query.



<code>
update "Customer Database"
set TaxIDExpDate = NULL
where TaxIDExpDate is not null
</code>



===== Version Information =====
  * Reported : 7/6/2010, Ticket # 138831
  * Version(s): SMS 8.x