Small and medium business | Business Central, N...

How to create a report, which shows customer ledger entries?

(0) Share

Report

Posted on by Community Member

Hey guys,

I want to create a report, which shows all customer ledger entries (sales invoice / sales credit memo) and can be filtered by customer no. & let's say dimension code 1 + dimension code 2.

How do I have to begin?

I have the same question (1)

All responses (3)

Answers (0)

Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

You do not need a report for that - you can drill down to customer ledger entries from the customer card and then clear customer filter to show all customer ledger entries - which you can further filter and export to Excel

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ok, but I need it as a report and not in Excel...

Was this reply helpful? Yes No
Suggested answer

divyeshchitte 968 on at

Like (0)

Report

Create a New Report using Customer Ledger Entry and you will get all the details. or search for some default reports of NAV based on your requirement.

The option provided by Alexander would be appropriate as the user can play with the data in excel as well.

Was this reply helpful? Yes No