Trying to add a Cost Center entry in Pharos Administrator, which I have done before in the past. Cost Center is basically account number with notation as to whose account it belongs to. For some reason, I keep getting an error stating "Cannot insert explicit value for identity column in table 'cost_centers' when IDENTITY_INSERT is set to OFF." Seems like a programming issue, but not sure why it would say this when I did this in the past. No programming involved, just click "Insert Cost Center" and put in information, then say ok. I am sure it is something really simple, but wondered if anyone knew what the problem was before I contacted Pharos support. Any help is greatly appreciated.
This is a most puzzling error, since that particular table isn't supposed to have any identity column (and wasn't touched by any recent upgrades or service packs). I can only think that somebody might have manually make a weird change to your database. You'll probably want to contact Pharos support, and supply all the settings (within SQL Server) for cost_centers table and its columns so that they can be compared with their normal settings.