Sales report help for a newbie

[steve_wilson]

Apologies in advance if i'm asking silly questions here, but i'm a total newcomer to Sage.

I've been asked to produce a sales report, in excel, from Sage line 50, one that includes not just sales, but also accounts for any credits or adjustments made to customer invoices.

What is the best option to pick?

If i understand correctly, simply picking customer invoices from day books will not account for the above credits and adjustments, yes?

So should i then pick Customer activity instead?

Will Customer activity account for credits/adjustments, without me having to make any alterations to the figurues....and is the figure shown for each account in the "debit" field, the actual total once all of above is factored in?

Thanks for any help.

[brucedenney]

The best option is to use ODBC to pull data from Sage data tables into Excel, (if you are going to need to reproduce the report time and time again.)

You can either use the Data in
the Invoices and Credit notes (which is nice as it includes product information as well and if people actually look at the reports then that will be the next thing they ask for.)
the Audit Trail (which is rock solid and will be penny perfect match to the management accounts)

You could do it using reports, you could do it with EIR but both are labour intensive.

Whichever way you are going to do it, you are facing a learning curve and some significant time.
The better way has a steeper learning curve, the easy way will take more time.

Is this a one off or is it a regular thing?

If you can define the report, you could get someone to write it for you without having to go through the learning curve.

there are several reports you could look at starting points for getting data out if you want to do it the long and easier way

Have a look at Customer Details Reports>Customer Sales (Gross) Report (12 Months) and Customer Sales (Net) Report as starting points.