Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

exporting to excel

Sage 50 general help forum - Free help and support for all general issues
Post Reply
sheilad
User
User
Posts: 10
Joined: 29 Jan 2010, 12:52
Sage Version: V11 UK/Europe/Africa

exporting to excel

Post by sheilad » 29 Jan 2010, 12:58

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.
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: exporting to excel

Post by brucedenney » 17 Feb 2010, 19:02

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?
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
sheilad
User
User
Posts: 10
Joined: 29 Jan 2010, 12:52
Sage Version: V11 UK/Europe/Africa

Re: exporting to excel

Post by sheilad » 18 Feb 2010, 10:56

It is Line50 Financial Controller V12, but the Report Designer that's on it seems to be V9.
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: exporting to excel

Post by brucedenney » 19 Feb 2010, 19:58

Run the Screen based Aged Debtors/Creditors NOT the report

Go to File>Send>Contents to Microsoft Excel
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
sheilad
User
User
Posts: 10
Joined: 29 Jan 2010, 12:52
Sage Version: V11 UK/Europe/Africa

Re: exporting to excel

Post by sheilad » 26 Feb 2010, 13:22

Thanks, but can you tell how to get a screen based creditos/debtors,
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: exporting to excel

Post by brucedenney » 27 Feb 2010, 14:54

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
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
sheilad
User
User
Posts: 10
Joined: 29 Jan 2010, 12:52
Sage Version: V11 UK/Europe/Africa

Re: exporting to excel

Post by sheilad » 03 Mar 2010, 15:49

Thanks that worked great

regards

Sheila
Top
Rarerims
User
User
Posts: 6
Joined: 08 Mar 2010, 17:56
Sage Version: v2008 14 UK/Europe/Africa

Re: exporting to excel

Post by Rarerims » 10 Mar 2010, 10:48

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?
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: exporting to excel

Post by brucedenney » 11 Mar 2010, 16:28

What version of Sage 50 are you using?
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
Post Reply

Return to “Sage 50 UK version General Help”

Who is online

Users browsing this forum: No registered users and 1 guest