MRP Calculation and ReqTrans table cleanup

(0) Share

Report

Posted on by Darshanak

261

Dear Consultants,

We would like to have your advise on deleting ReqTrans tables and the implications of the delete. I have updated detail requirement in to attached PDF. Please advise

/cfs-file/__key/communityserver-discussions-components-files/33/MRP-Calculation.pdf

Rgds

Darshank

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Gabriel Sotiriu on at

Like (0)

Report

Hello,

An exact root cause for the reason why you are left with some orphan records on ReqTRans table might require additional investigations on the basis that problem may be replicated.

However, cleaning up MRP-related tables is something that is used on a regular basis, especially on AX2012 releases.

Related to this aspect, please review below link:

https://www.linkedin.com/pulse/top-10-actions-troubleshoot-performance-dynamics-ax-master-caillet

So, it is safe to truncate ReqTrans table (among other tables) as data is going to be repopulated after a new full MRP run.

I hope this will help.

Best regards,

Gabriel

Was this reply helpful? Yes No