Skip to Content
Former Member
Mar 24, 2016 at 03:44 PM

Sales Frequency Report Query



I am trying to generate a query that shows the # of times a BP has ordered, the date of their first order, the amount, the date of their most recent order, the amount, and the total amount of all orders placed.

The Sales Analysis Report that is provided with Business One is close, but does not provide the dates of first order and most recent order. If I could get the SQL query of the report, I could probably tweak it to my needs, but it doesn't provide you with the SQL query used to generate the report.

Any ideas?