MRP Calculation and ReqTrans table cleanup

(0) Share

Report

Posted on by Darshanak

255

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

All responses (1)

Answers (0)

Suggested answer

Gabriel Sotiriu on at

Like (0)

Report

RE: MRP Calculation and ReqTrans table cleanup

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