How to delete Budget Registry Entries with Status "COMPLETED"

Finance and Operations/AX User Forum
1

Hi All,

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 ?

Thanks,

Samanth

2

Hi,

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.

Pranav…

3

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 ?

Thanks,

Samanth

4

It depends on how you are moving the data from dev to PROD.

https://technet.microsoft.com/en-us/library/aa548629.aspx

5

Hi Kranthi,

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.

6

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.