Extending "End Date" for new accounts & existing accounts for clients on 3.x legal module
Configuration for 3.x legal Budgeting
-
Login as an admin account
-
Go to Setup
-
Go to Object Definitions → Account
-
Go to Templates
-
Create a new Template
-
Set General Tab as in the picture
-
Go to the record tab of the template, create a new field for applEndOn and set it to 12/31/3999
-
Save the template
-
Go to rules tab and create a new rule
-
Match the General Tab with the following image and save
-
Go to the Qualifier tab and create the following 2 qualifiers and make sure it is set to OR Logic.
-
Go the the action tab and set the template to the one created earlier.
-
Save the rule
-
Check-out and save the old jar legal-legalutilities-library-3.x.jar and the 2 class files in it. TCLBudgetHandlerSYS.class and TCLBudgetHandlerSYS$1.class somewhere.
-
Replace with the attached class files in the jar "legal-legalutilities-library-3.x.jar" TCLBudgetHandlerSYS$1.class TCLBudgetHandlerSYS.class
-
Check-in the new jar with the replacement class files back into the instance and restart the TeamConnect instance.
For Existing Accounts on 3.x
Run the following SQL:
SELECT * FROM T_ACCOUNT WHERE NAME IN ('Allocated - All Matters','Allocated - All Vendors','Actuals - All Matters','Actuals - All Vendors');
SELECT * FROM T_ACCOUNT WHERE PARENT_ACCOUNT_ID IN (SELECT PRIMARY_KEY FROM T_ACCOUNT WHERE NAME IN ('Allocated - All Matters','Allocated - All Vendors','Actuals - All Matters','Actuals - All Vendors'));
SELECT * FROM T_ACCOUNT WHERE PARENT_ACCOUNT_ID IN (SELECT PRIMARY_KEY FROM T_ACCOUNT WHERE PARENT_ACCOUNT_ID IN (SELECT PRIMARY_KEY FROM T_ACCOUNT WHERE NAME IN ('Allocated - All Matters','Allocated - All Vendors','Actuals - All Matters','Actuals - All Vendors')));
UPDATE T_ACCOUNT SET APPL_END_ON = '3999-12-31 12:00:00' WHERE NAME IN ('Allocated - All Matters','Allocated - All Vendors','Actuals - All Matters','Actuals - All Vendors');
UPDATE T_ACCOUNT SET APPL_END_ON = '3999-12-31 12:00:00' WHERE PARENT_ACCOUNT_ID IN (SELECT PRIMARY_KEY FROM T_ACCOUNT WHERE NAME IN ('Allocated - All Matters','Allocated - All Vendors','Actuals - All Matters','Actuals - All Vendors'));
UPDATE T_ACCOUNT SET APPL_END_ON = '3999-12-31 12:00:00' WHERE PARENT_ACCOUNT_ID IN (SELECT PRIMARY_KEY FROM T_ACCOUNT WHERE PARENT_ACCOUNT_ID IN (SELECT PRIMARY_KEY FROM T_ACCOUNT WHERE NAME IN ('Allocated - All Matters','Allocated - All Vendors','Actuals - All Matters','Actuals - All Vendors')));