Unable to edit the zero record.

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

Low

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

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.

update "Customer Database"
set TaxIDExpDate = NULL
where TaxIDExpDate is not null

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