I have inventory items : AAA BBB CCC and I Have customers : 111 222 333 how to generate easily the details of what items ar purchased per customer like: customers 111 purchased > AAA = 100 pcs BBB = 120 pcs Because if we generate from tab customers it only shows the list of invoices not li…

You can create a custom report for this. If I remember well, there was a post about this recently.

I difficult to use custom report, can you help me how to make it?

Well, the forum rules (see FAQ) clearly says you should post the result of your best try and mention why the outcome is not as you expected. Furthermore the help is available on the forum and there’s also a guide so I suggest you read that guide and you search the forum as there are several topics s…

@ejjaadiargo start with this custom report and modify it to your needs: [image] Custom report Customer and products Try this: [Custom Report] Make sure that on the Where line, “Inventory - sales” is typed correctly.

I tried based on tutorial you shared above. But why it show the blank page only?

As per the FAQ, if you want help with custom reports, you need to post the definition of your best attempt and a screen shot of the results. @Mark already called your attention to this guidance. You ask “why,” but how could anyone know without seeing your report definition?

this is how manager shows the result : [Screen Shot 2022-10-13 at 14.40.57] this is what manager showed [Screen Shot 2022-10-13 at 14.39.20]

I would temporarily add the General Ledger Account/Name to the Select clause and remove the Where clause to see that there are actually any transactions for the period and Inventory-Sales accout for the period It is better to start with many more transactions than you want and once you are sure tha…

Thankyou @Joe91 , but may I see your set up here?

I haven’t setup a custom report, I am only advising how to go about it systematically - this will be the quickest way to get to the result you want

How to sort the details of what items are purchased?

dcVest September 28, 2022, 12:48pm 5

@ejjaadiargo start with this custom report and modify it to your needs:

Topic		Replies	Views
Custom report Customer and products	19	1847	December 1, 2021
Custom report issues (Cusomer & Bought items)	16	325	January 28, 2025
Product Sold per customer	8	861	April 5, 2024
Customer Purchase History	5	532	August 30, 2022
Custom reports	2	323	February 9, 2023

How to sort the details of what items are purchased?

Related topics