Non-Compliant account code -1 should not be deleted

Expand / Collapse
 

Non-Compliant account code -1 should not be deleted


Article ID: 51894 - Last Review: April 4, 2013

PROBLEM

You must not delete the -1 Non-Compliant account code form YourSite Explorer.  This code is used as a default code, and the system will not work properly without it. 



WORKAROUND

If the account code is deleted from YSE it is not as simple as re-adding it through the YSE interface, as the minus sign "-" is an invalid character in reporting numbers.  In order to re-add the account code, please do the following:  

1. Open YourSite Explorer, and click on Account Codes
2. Click the Add button at the top.
3. Create a new Account Code with the name Non-Compliant and a reporting number of 99999
NOTE:
If reporting number 99999 is already in use you can substitute any unique reporting number.
4. Download the attached NonCompliantFix.sql file to the server (you must have SQL Management Studio installed)
5. Double click the NonCompliantFix.sql file.  This will launch the SQL script in SQL Management Studio.
NOTE: If you substituted a different reporting number in step 3, you must edit it in the SQL script.
6. Click the Execute button at the top of SQL Management Studio.  Once you receive confirmation at the bottom of the script which will say: (1 row(s) affected) you can close SQL Management Studio.



APPLIES TO

CCM all versions

Keywords: Non-compliant non compliant account code -1 delete deleted removed missing add



Rate this Article:
     

Attachments


NonCompliantFix.sql NonCompliantFix.sql (89 GB, 735 views)

Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:Thursday, April 11, 2013
Last Modified By: amontpetit
Type: FIX
Article not rated yet.
Article has been viewed 10,395 times.
Options