Hi,
I wanted to know how to get the report for all the sales orders by each customer for the entire year. I get alredy completed orders from sales invoices and the backorder from sales orders. But i want a report combined for all the orders.
Any help or insight is highly appreciated.
Thanks in advance!!
Since you are trying to pull multiple records from different, unrelated tables, you can only create multiple reports or multiple sheets to pull this data.
Otherwise, you could use Jet Reports (not Basics) to use the NL("Sum") function to pull totals from each table and then add them together, per customer.
Thanks for the suggestion. I will try that.