AnsweredAssumed Answered

Deleting the Transaction Class

Question asked by MadhuriThakur on Sep 4, 2013
Latest reply on Sep 11, 2013 by Chris_Hackett
Hi All,

When I tried to delete the Transaction Class A, got the error "Selected items cannot be deleted because one or more of them are being used".

We wrote a query to find out the associations of that particular Transaction Class A. Below is the query for your reference.

SELECT I.ID ProjectID,
I.NAME PROJECT,
i.code code,
FP.NAME PLANNAME,
fp.is_plan_of_record PLR
FROM FIN_PLANS FP JOIN INV_INVESTMENTS I ON FP.OBJECT_ID=I.ID
WHERE FP.OBJECT_CODE='project' ;


And I found only two projects with the Cost Plans. When I go to detail, Cost Plan do not have that Transaction Class "A".

I went and deleted the Cost Plan for 1 project but still I am seeing the 2 projects in my query .

Please let me know what is the issue.

Any help would be appreciable.

Thanks
Madhuri Thakur

Outcomes