Notifications
Announcements
No record found.
Hello,
I am looking for the name of the table contaning the Project Transaction Types, i.g 2 = hour, 4 = item etc. but can't seem to find it (https://docs.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/gg883466(v=ax.60) )
I would be happy if someone could help me locate the table name, because it is needed in a Power BI model.
Thanks!
Hi NewBeginner,
You can try with following tables:
Posted Transactions:
ProjPostedTransTable
Project Transactions per type:
ProjInvoiceCostTrans,
ProjInvoiceEmplTrans,
ProjInvoiceItemTrans,
ProjInvoiceOnAccTrans,
ProjInvoiceRevenueTrans
Posted invoices:
ProjInvoiceCost,
ProjInvoiceEmpl,
ProjInvoiceItem,
ProjInvoiceOnAcc,
ProjInvoiceRevenue
Hi NewBeginner
Please mark this thread as verified if the answer is helpful.
Ended up using the ProjCateory table, but thanks for the help!
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 663 Most Valuable Professional
André Arnaud de Cal... 540 Super User 2025 Season 2
Sohaib Cheema 348 User Group Leader
