Users may occasionally report the below error when adding customers in SedonaOffice:
This is usually the result of the Geographic tables having a duplicate zip code. However, if you have checked the zip code, see if they have an AR_Dealer table. If they’ve used the Manitou integration in the past, they could receive this error if there are duplicates on the AR_Dealer table.
Select * from AR_Dealer order by Dealer_Code
There can be duplicates in the Dealer_Code field if they are pushed over from Manitou rather than saved in SedonaOffice itself. However, once there, the stored procedure will brick any additional ones added. The query should reveal them and allow you to update them as needed.
