I want to see the list of products sold per customer, is there a way to know what are the products they bought from us?
You would need a custom report. There have been several discussions of this on the forum. But the suggestion has never made its way onto the ideas list. I am putting it there now. If implemented, information/options should include:
- Date range
- Customer selection
- Inventory item quantity sold by sales transaction
- Unit price by sales transaction
- Extended amount by sales transaction
- Summarization by inventory item
- Overall totals
In other words, this should be a detailed inventory sales report for a specific customer. I think implementation will not be trivial. It would be an expansion and combination of both the Inventory Quantity Summary and the Inventory Value Summary.
New implementation of custom reports that is coming soon will make this significantly easier.
Wow… I cant wait to hace this feature on manager software
Here you are
Go to custom report and create this one
in the line “Customer” you can change “Code” to “Name” and in the empty field, in the same line you type customer code or customer name
2 Likes
I followed your laydown instructions but I end up with zero result
Please is there any current update to see the list of items sold and qty to a particular customer?
The report has no data because you did not select a customer nor an item
Show a screen shoot for the sutup, to me it works fine.
Removing from ideas because this has been already possible for a while using Sales Invoices - Lines screen and Advanced Queries.