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

(0) Share

Report

Posted on by Momochi

1,044

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)

All responses (5)

Answers (2)

Sort by

Verified answer

Alireza Eshaghzadeh 15,190 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 305,583 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Momochi,

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

Was this reply helpful? Yes No
Momochi 1,044 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Momochi 1,044 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
André Arnaud de Cal... 305,583 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No