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 / Finance | Project Operations, Human Resources, ... / For Project Invoices, ...
Finance | Project Operations, Human Resources, ...
Answered

For Project Invoices, Are All Types of Project Invoices Use The Same Tables for a Project Invoice Report?

(0) ShareShare
ReportReport
Posted on by Momochi 1,036

Hello dears!

I want to know the tables used for project invoices (after posting). The thing is I lack in experience and knowledge regarding the project management and accounting module and how it works.

But the least I know is that there are 2 types of external projects that can be invoiced which are "Time-and-material" and "Fixed-Price" projects.

So are all project invoices types are using the same tables after posting?

Also, is "ProjInvoiceEmpl" table used to store all lines for the different types of project invoices?

If possible to provide me with an ER diagram for ProjInvoiceJour table, it would be appreciated.

Sorry for my lack of knowledge and thanks in advance!

I have the same question (0)
  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

    Hi Mamochi,

    Project invoices can be found on table "ProjInvoiceJour". 

    Based on project transaction type, project transactions that have been invoiced (i.e. Billable) will be delegated on the following tables:

    Item > ProjInvoiceItem - For Project categories with "Item" as Transaction type

    Cost > ProjInvoiceCost - For Project categories with "Expense" as Transaction type

    OnAccount > ProjInvoiceOnAcc -  For OnAccount project invoices

    Revenue > ProjInvoiceRevenue - For Project categories with "Fee" as Transaction type

    Hour > ProjInvoiceEmpl - For Project categories with "Hour" as Transaction type.

    More information about project invoicing on Microsoft Docs: docs.microsoft.com/.../project-invoicing

    Regards,
    Alireza Eshaghzadeh| Business Consultant | My blog

    Please mark this thread as verified if the answer is helpful.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

    Hi Momochi,

    A small addition to the reply from Alireza. The tables mentioned, are used regardless of the project type.

  • Momochi Profile Picture
    Momochi 1,036 on at

    Thanks for the detailed clarification guys!

    But dear @Alireza, I see that you didn't mention OnAccount as transaction type.

    Is there a field on the "ProjInvoiceHeader" that identifies that this invoie is an "OnAccount" invoice?

  • Momochi Profile Picture
    Momochi 1,036 on at

    Actually, never mind my previous comment, I miss read your reply correctly.

    But I still confused regarding why the "ProjId" field is only available in the lines tables and not in the header table?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

    Hi Momochi,

    A field om the invoice level is not available as project transactions from multiple projects can be invoiced on a single project invoice.

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 592 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans