Skip to Content
Former Member
Jul 27, 2009 at 03:16 AM

Delete Zero value records from FMIT table



I have created fund center without assigning superior fund center and created few PR. While creating PO there is an error message " Budget exceeded". Reason being fund center hierarchy not setup properly, Can not change the fund center hierarchy because transaction posted already.

Decided to delete the transaction which means PR deleted but still I can not change the fund center hierarchy thus decided to delete the fund center and create the fund center with same code. But system not allowing me to delete the fund center " Function not allowed: Funds center IMCB R03008 defined as budget object"

I checked the table FMIT and found there is some transaction for the respective fund center but zero value.

My quesitons:

is there any program to delete the zero value transaction from FMIT table.