web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... All customer invoices ...

Finance | Project Operations, Human Resources, ...

Unanswered

All customer invoices (Project and Sales order) with at least Customer, Invoice number and amount.

(0) Share

Report

Report

Posted on by Community member

4

Hi Experts,

Is there any possibility to extract the report which includes all the customer invoices (Project and sales order) with at least following 3 columns:

1. Customer

2. Invoice number

3. Amount

If not, is there any other option to perform so that I can get all the customer invoices.

Thanks & Regards,

Mukesh

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

André Arnaud de Cal... 297,200 Super User 2025 Season 2 on at

Like (0)

Report

All customer invoices (Project and Sales order) with at least Customer, Invoice number and amount.

Hi Mukesh,

When you only need these three columns, you can use the records from the CustTrans table and set a range on the field Invoice. In case the Invoice field is not filled, it is either a payment or another journal transaction.

Was this reply helpful? Yes No
Kevin Xia Microsoft Employee on at

Like (0)

Report

All customer invoices (Project and Sales order) with at least Customer, Invoice number and amount.

Hi,

You can check whether the standard report has a report that meets your needs, and if not, you can choose the report design, which can be referred to this official document: Report Designer interface - Finance & Operations | Dynamics 365 | Microsoft Learn. This article explains how to navigate through Report designer and how to use the various options to meet your specific requirements. Or you can use Power BI to implement your needs, this is the official website: Combine Power BI and Dynamics 365 | Microsoft Power BI.

Best regards,

Kevin

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Responsible AI policies for the Community

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Sohaib Cheema 665 User Group Leader

#2

Martin Dráb 595 Most Valuable Professional

#3

Yng Lih 558

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans