Page 1 of 1
exporting to excel
Posted: 29 Jan 2010, 12:58
by sheilad
have Line50 Financila controller, would like to export Aged Debtors/Creditos reports to Excel, but when open excel it doesn't show any details, have done the .csv save
It works on all other report but not these ones, is there any other way to do this.
Re: exporting to excel
Posted: 17 Feb 2010, 19:02
by brucedenney
What version of Sage 50 is this? Financial Controller was replaced by Pro, so it is "older" but is it the old or the new report designer?
Re: exporting to excel
Posted: 18 Feb 2010, 10:56
by sheilad
It is Line50 Financial Controller V12, but the Report Designer that's on it seems to be V9.
Re: exporting to excel
Posted: 19 Feb 2010, 19:58
by brucedenney
Run the Screen based Aged Debtors/Creditors NOT the report
Go to File>Send>Contents to Microsoft Excel
Re: exporting to excel
Posted: 26 Feb 2010, 13:22
by sheilad
Thanks, but can you tell how to get a screen based creditos/debtors,
Re: exporting to excel
Posted: 27 Feb 2010, 14:54
by brucedenney
In the customer module click on the 4th icon on the tool bar labelled aged
or right click on the customer area and chose aged analysis
Re: exporting to excel
Posted: 03 Mar 2010, 15:49
by sheilad
Thanks that worked great
regards
Sheila
Re: exporting to excel
Posted: 10 Mar 2010, 10:48
by Rarerims
Is it OK to sneak in to this thread now the original question is answered?
I export a stock list to CSV, but it converts all minus values to positive ones, which gives me a problem. I can get round it by ordering the stock list by quantity, but would rather be able to export everything!
Is there any way to make it keep the minus values?
Re: exporting to excel
Posted: 11 Mar 2010, 16:28
by brucedenney
What version of Sage 50 are you using?