web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Howto clean up PROJTRA...
Microsoft Dynamics AX (Archived)

Howto clean up PROJTRANSPOSTING table

(0) ShareShare
ReportReport
Posted on by Community Member

We've have an enormous sized PROJTRANSPOSTING table. Actually it's the largest table we have in the database.

Does anyone know if there's a standard/front-end way of cleaning up this table? Like with a clean up job of some kind...

We use AX2012R2 CU7.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,896 Super User 2025 Season 2 on at

    Hi neveskiet,

    There is no option to clean up this table. The number of transactions is not important. This table is used for analysis purposes between ledger transactions and the project transactions.

    Would there be any business requirement to clean up the table? Technically, there should be no issues having large number of transactions if you have proper indexes and database maintenance.

  • Verified answer
    b_radlyjames Profile Picture
    b_radlyjames 3,155 on at

    Andre is right.  

    1. You shouldn't 'clean up' this table. All the records here are necessary and shoulddn't be removed.

    2. I can't think of any reason why you would want to do this.

    We have about 16 million records in our PROJTRANSPOSTING table but they are ALL necessary.  

    We use that table to reconcile our General Ledger to Project Subledger.

  • Community Member Profile Picture
    Community Member on at

    Thank you guys for your helpful response. We will have to do some index maintenance then to reduce the overall size.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans