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

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... 304,508 Super User 2026 Season 1 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,157 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans