Skip to main content



No record found.

Project Operations forum

Customizing The Project Invoice Report to Show Sales Order Lines with Retention Lines

Posted on by 847

Greetings dears !

I'm trying to customize the project invoice report "PSAProjInvoice".

This report shows the whole sales order as a one line.

While I want to show the lines of the sales order and the retention lines of the sales order from the retention terms that is defined in the project contract.

I'm confused from which way to implement this.

is it by going to the sales order selected in the project invoice then do a loop on the lines and then do the retention calculation based on the percentage specified in the project contract then insert a retention line?

or there is another screen that I can read these transactions from?

I can see there is a voucher screen in the project invoice that have the retention lines along with the sales order lines.

But I'm not sure if it's the correct approach to do that.

Please any advice is appreciated !

Thanks in advance !

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,773 Super User

Martin Dráb Profile Picture

Martin Dráb 225,513 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans