Finance | Project Operations, Human Resources, ...

Help with finding invoices in D365

(5) Share

Report

Posted on by Community member

Hello,

I work as a consultant in finance and my current client uses D365. It's the first time I use this tool so I'm not very familiar with it.

Anyway, I asked my client for a list of all invoices from the last 2 years with basic data such as: invoice date, due date, invoiced amount, invoice number, client number/name and payment date in case the invoice has been paid (otherwise empty)

To my surprise I was told my a lot of people that this is not possible. During my last assignement I asked the same thing from someone using SAP and it could be retrieved in 2 minutes so i'm quite skeptical. Since no one could help me with this i starting looking into D365 myself as I'm pretty sure this must be doable. Using the aging reports and playing with the parameters i was able to come close to finding a solution but it's still not quite working, so I was wondering if someone could help me out with this issue.

Thanks in advance

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (2)

Report

You can get it from the below navigation.

Vendor- transactions- select filter as "ALL"

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (1)

Report

For partial paid, you can check with open transactions.

Was this reply helpful? Yes No
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
You can also find a list of customer transactions on the Accounts receivable > All Customers > Transaction page. In addition, if the information displayed on the page is insufficient, you can click insert column as shown in the screenshot to add columns to the table.

Best Regards,
Hana

Was this reply helpful? Yes No
Community member 14 on at

Like (1)

Report

Hi Hana,

Thanks for your answer.

I had already been on this page, however there are a few things i've noticed:

To check the transactions like you did i need to select 1 customer at a time, but I want all invoices for all clients, not just for a particular customer, isn't it possible to select for all?

Payments appear as a separate line, so how am i supposed to know to which invoice is payment linked to? In your screenshot it's straightforward because the amounts match 1 to 1 but what if a client pays 10 invoices in 1 payment? I managed to find and insert a field called "Payment reference" which apparently allows me to link payments to invoices with some extra work but I still need to make sure that is correct.

@Paul thanks for the help but I should have been clearer and say i meant customer invoices, not vendor invoices

Was this reply helpful? Yes No
SD-19091027-0 12 on at

Like (1)

Report

Hi, I had the same issue today and found 2 variants:

Sales invoices: Accounts receivable\Inquires\Journals\Invoice Journal.

Project Invoices: Project management and accounting > Project invoices > Project invoices

I would have expected to also find project invoices, in receivalbes invoice journal, but this was not the case.
As I am working in a customized 365, I am not sure if this is standard or adapted.

Was this reply helpful? Yes No
EG-02101759-0 2 on at

Like (0)

Report

So - if you paste this into your browser with a tab open to d365 it will list ALL customer invoices for the entity: In the example it is entity flv. We are multi company. Not sure if your client is, but the entity is in the upper right hand corner of every screen.

https://pursuit-prod.operations.dynamics.com/?cmp=flv&mi=CustTrans

Was this reply helpful? Yes No