Microsoft Dynamics AX (Archived)

How to delete Budget Registry Entries with Status "COMPLETED"

(0) Share

Report

Posted on by Samanth

517

Hi All,

I want to delete budget registry entries with status as "COMPLETED". Can any one help me out.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Jesus R. ABASCAL 1,450 on at

Like (0)

Report

Hi Samanth,

You can check this info:

technet.microsoft.com/.../hh227354.aspx

I hope it helps you.

Was this reply helpful? Yes No
Samanth 517 on at

Like (0)

Report

It says we can delete a budget entry if its status is "draft". 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 ?

Was this reply helpful? Yes No
JesusMiranda1993 on at

Like (0)

Report

Hi,

Could you delete transactions?

I am in the same situation. I need to delete them manually or by code.

I appreciate the help

Greetings.

Was this reply helpful? Yes No
Verified answer

Samanth 517 on at

Like (0)

Report

I found a solution for this. But am not sure if it effects anywhere. I have no problems till now.

Go to AOT-->Tables-->BudgetTransactionHeader.

-->Methods-->Open ValidateDelete method.

-->In Line 10 LookUp Definition for "checkTransactionStatusForDelete"

-->comment the following code

if (_budgetTransactionStatus == BudgetTransactionStatus::Completed)

{

// Do not allow the header to be deleted if it has been processed.

isValid = AifFault::checkFailedLogFault(

strfmt("@SYS127808", _budgetTransactionId),

#UnableToDeleteCompletedBudgetTransaction);

}

Then go to -->BudgetTransactionLine table and delete the line you want to delete.

then go to --> BudgetTransactionHeader table and delete the Budget registry entry header level.

**First delete lines then header.

Hope this would help you.

Thanks

Was this reply helpful? Yes No
Suggested answer

Hichem.Chekebkeb 3,371 on at

Like (1)

Report

Deleting lines like this will complicate things even more. AVOID MANUAL DELETE IN ANY CASE

Was this reply helpful? Yes No
Suggested answer

JesusMiranda1993 on at

Like (0)

Report

Sure, is more complicate... I have been geeting experence in this... The solución i found was deleting all the transactions and delete the following tables....

BudgetTransactionHeader

BudgetTransactionLines

SourceDocumentHeader

SourceDocumentLines

BudgetSource

BudgetTracking

BudgetTrackingDetail

BudgetTrackingRelieveDetail

And the budget check results tables

Regards

Was this reply helpful? Yes No
Hichem.Chekebkeb 3,371 on at

Like (0)

Report

Is this removing budget controls, transfers on dimensions also?

Was this reply helpful? Yes No
JesusMiranda1993 on at

Like (0)

Report

Yes, First execute the delete transactions class... This delete all the transactions, that incluide the dimensions created. Then clear the tables that i listed, there you find the transfers details

Was this reply helpful? Yes No