Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Bill Fuller]

looking for some info on TMSTransaction table clean up options. , this is one of our larger tables,  struggling to find some info on how to 
clean it up , thanks,

——————————
Bill Fuller
Mgr. System Administration Team

Allegion Information Technology
11819 North Pennsylvania St
Carmel, IN 46032
——————————

[Michael Sigler]

Hi Bill,

Have you tried the ‘Transaction purge’ option under Transportation management – Periodic tasks?  That should allow you to specify how many days of information you would like to keep while removing the rest.  Naturally, i would recommend validating this in a Dev / Test environment.

——————————
Michael Sigler
Rangeline Solutions
——————————
——————————————-

[Bill Fuller]

Thanks Michael   , Found it . !   will give this a try and do some testing  ..

——————————
Bill Fuller
Mgr. System Administration Team

Allegion Information Technology
11819 North Pennsylvania St
Carmel, IN 46032
——————————
——————————————-

[Dave Phillips]

Hi Bill –

TMSTransaction table contains transportation transactions for historical purposes.

We do have an option to delete the records on this table. See, Transportation management > Periodic > Transaction purge. The periodic routine will delete all the records if you are running with parameter Days = 0. Days is the number of days of transaction data to keep.

As with any of these cleanups, best to test first and understand everything the process is doing. SQL Profiler filtering by Deletes is great way to evaluate.

I ran a quick test and only one statement was the result.

DELETE FROM TMSTRANSACTION WHERE (((PARTITION=@P1) AND (DATAAREAID=@P2)) AND (MODIFIEDDATETIME<@P3))

Thanks…..Dave

——————————
Dave Phillips
Sr Support Escalation Engineer
Microsoft
Fargo ND
——————————
——————————————-

[Bill Fuller]

Thank you , Dave     Appreciate the help, will give this a try and do some testing ..

——————————
Bill Fuller
Mgr. System Administration Team

Allegion Information Technology
11819 North Pennsylvania St
Carmel, IN 46032
——————————
——————————————-