I want to delete budget registry entries with status as “COMPLETED”. Can any one help me out.
I want to delete all budget transactions whether it is in draft/completed. I have run systransdelete class and it deleted all finance transactions except budget transactions. So i am asking is there a way to clear all budget related transactions at once ?
Once the budget is posted, the status is updated to completed. Posted data cannot be deleted.
Since budget data is not impacting GL, you can create a new budget model and use it for reporting. If deletion is not allowed from frone end, deleting it from backend will not be a good idea.
What you said is correct, i can create new budget models. But i want to move my development data to production server, after clearing all transaction except for setup’s and master data.
I want to upload budget entries as fresh. I dont want to keep old data. I there any direct way to clear budget transactions ?
I tried to delete it from backend, but at table level also its throwing error when am trying to delete. Please suggest me what action i should take ?
It depends on how you are moving the data from dev to PROD.
I want to move through SQL-Database backup and restore process. In my development server i used SYSTRANSDELETE class to remove all transaction. But its not deleting budget registry entries. Once these transactions gets deleted i will move database to production server.
SysDatabaseTransDelete may not guarantee a clean environment, especially in case of global tables. Not all the global tables were handled here.
It is better you move only the master data from DEV to PROD.