Unable to Generate custom report with Sales Order Totals and can't export as pdf
Hi,
I am trying to create a report from report builder that shows all the sales orders that have been input on a particular day. I would like the report to show details similar to the outstanding orders table on the dashboard.
However, in the report that I am trying to create, I can't find a table that has the sales order total. Maybe I need to multiply the qty in salesorderdetails with the unit price and sum it up for the total somehow? I am also unable to export the reports from report builder as pdf, but there is no issue in exporting it as csv.
Ideally, I would like the report to show the order number and the sales order total as a single line per whole order, instead of a line for each sales item, which has been the result that I have been getting. I would also include a few other columns for salesman, and customer name, but I don't have an issue in getting that to work.
Any help is appreciated.
Thanks,
Felix
|