I would like to run a report, That gives me the following information based on customers accounts. We use a SM for all of our jobs and sales.
1: customer account name
2: total invoice for the financial year,
3: total costs for that customer per year in three columns Stock, expenses and labor.
4: percentage profit on cost
and exported to excel. i sort of need this yesterday so any body with a price to do it would be great
Labor is booked out as a stock item sometimes so need to capture a few things separately also expenses some times are allocated instead of a stock item, but if the column configuration is as per the columns above then we should be able to work it out