Hello, I’m new to ERPNext and I have a question.
When I try to generate a report in the general accounting section, it only shows sales invoices and payment entries. What I actually need is a more detailed report — one that lists every product sold along with every payment entry related to it. In short, I want to combine the product-wise sales records with the payment entry records and display them as a single report. Is it possible to do this?
The combination of criteria seems odd to me. Can you further expat your use case?
Are you interested in the payment entry or the price/amount the item sold for?
You can build nearly any report you can think of using query report or script report.
you need to write custom report for that
I need this customization so that I can reconcile my accounts with the customers I’ve sold products to. I don’t want to send my customers the general ledger report and the sales invoices separately. For customers who don’t understand reporting systems, it becomes difficult to read these documents.
I need a report screen that shows the details and prices of the sold products, and also includes the payment entries. You can refer to the sample image I attached as an example.
Earlier versions used to have Paid Amount column in Sales Invoice but am not very sure if that is still relevant in newer versions 
.
Another possible work around is using the Accounts > Process Statement of Accounts functionality to generate and send Statement of Account to your customer(s)
You have a very specific need and desired report format. You’ll definitely need to create a custom report. It will most likely need to be a Script Report. To get your desired output from a Query report would be tough.
As a side note, allowing your customers to create extra work for you is going to make your life unnecessarily difficult. Your customers should already have your invoices (emailed, snail mailed, hand delivered, etc). If you need to satisfy them by combining invoice detail, payment history, for mutliple invoices, you are spoiling them 
Thanks for sharing your view. I get where you are coming from, but I see it a bit differently. Most of the well known accounting software in the market already give this option with a simple tick or untick while viewing the ledger. They even show the invoice item table right there, and it becomes very handy in day to day work. It saves time and makes the whole flow easier instead of jumping between reports. So it’s not really about spoiling customers. It’s more about offering a feature that many users already find practical and are used to.
Thank you for your response. Your answers helped me confirm that ERPNext does not support this and that I need to develop a custom report. Unfortunately, instead of reviewing separate reports, having everything in a single report will provide practicality not only for my customers but also for me. In this regard, I agree with what dipakthapa said. 
