Need help designing a crystal report pulling from Peachtree's database. I would like to produce an annual sales analysis from 2008 to present showing: account name, quantity purchased (Q1, Q2, Q3, Q4, Yearly) and dollar amount (by Q1, Q2, Q3, Q4, Yearly).
If I could use excel and pull the relevant tables from Peachtree, that would be even better.
Sage 50 Accounting 2013 (Peachtree) and MS Excel 2007
I can't find a profit & loss report. Is this suppose to be under accounts receivable?
I've attached a screen shot of the standard reports. I like the customer sales by month report (if i could modify it to include YOY since 2008)
How about 3pm EST?
I really would prefer if we can create an ODBC link of the data to excel. The standard reports, like the ones I've shown, don't have many options in the column selections.
I've tried to use the crystal report designer but that was like drinking from a firehose. ha ha
My apologies. I had an unexpected supplier drop by.