Hi, I am new to Epicor, and have no knowledge of this system or BAQ’s. I am tasked with doing profitability analysis at a sales order level, where I can drill down into job lines as well. I need to be able to generate a report that gives me a list of all Sales Orders with the ability of selecting closed and open, Total Sales Order Amount, Job Lines (closed and open), and all revenue & cost incurred to date (actuals vs estimated), as well as any budget inputted in the system. I have found where I can do it one sales order at a time, but I do not have the manpower to do that. I need a report that will give me all above activity for all Sales Orders and Jobs on one report.
Any assistance is greatly appreciated. Thank you!