InventSumLogTTS – disable all planning processes in CU11 and AX7

There have been lots of posts of the years on the InventSumLogTTS table and it growing in size and how to manage that. You will see posts like these

http://community.dynamics.com/ax/f/33/t/51075

where the table has been identified as a large table slowing down performance in AX. InventSumLogTTS from the help text stores this “The InventSumLogTTS table contains a log of on-hand changes that have been made, which is used for net change master planning.”

Prior to AX2012 R3 CU11 the workaround (https://support.microsoft.com/en-us/kb/904855) was either to delete (truncate) the data or run master planning which should clean up that table. If you didn’t use master planning then the table was maintained but not needed because it’s master planning that looks at it so it’s safe to truncate it.

In CU11 and AX7 there is a new master planning parameter that you might want to have a look at called disable all planning processes. You can find this in the master planning parameters form.

Keep in mind that it’s helpful to turn this on if you are not using master planning, if you need to use master planning then you won’t be able to enable this parameter.

Here is a quick look at where you will find it.

AX2012 R3 Cu11 and AX7

Cheers

Lachlan

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s