Vendor and customer names in general ledger reports

(1) Share

Report

Posted on by KM-23101951-0

I am new to D365 Finance and Operations and we currently don't have the vendor and customer names coming through in general ledger reporting. Is there an easy fix for this? For example, if I run a ledger transactions list or a dimension statement for all GL accounts or a specific GL account, any APINVxxxx voucher transactions or Vendor Pay voucher transactions don't have the associated vendor name in the report. This is the same issue for cus pay and cinv voucher transactions in accounts receivable accounts.

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Jonas "Jones&q... 5,010 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Welcome to Dynamics (-:

Yes, using financial reporting. And you also get a better reporting experience

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/analytics/financial-reporting-intro?context=%2Fdynamics365%2Fcontext%2Ffinance

In this quick example, I have added customer name to the "Ledger Transaction List" report using the report designer.

Edit: And you can export to Excel if you want all transactions across dimensions in one file, like the reports you run today

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 20,636 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I would advise you use the customer and vendor code as dimensions.

This is the easıer way to track thıs ınformatıon on GL.

Was this reply helpful? Yes No
JK-14110037-0 6 on at

Like (0)

Report
Copy link

Link copied!

Hi Jonas,

Can you please provide a screen shot of the Row definition?

Was this reply helpful? Yes No
JK-14110037-0 6 on at

Like (0)

Report
Copy link

Link copied!

Here's what I am seeing, can you please confirm its setup correctly? I added the Customer Name in the column definition. However, report is not showing all the details, see the screen shot of the report. Please advise.

Was this reply helpful? Yes No
JK-14110037-0 6 on at

Like (0)

Report
Copy link

Link copied!

It seems that none of the attributes are displaying. Am I missing a GL attribute setup?

Was this reply helpful? Yes No