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 All Supplier Info

Sage 50 general help forum - Free help and support for all general issues
Post Reply
NotSage
User
User
Posts: 1
Joined: 10 Sep 2008, 17:01

Exporting All Supplier Info

Post by NotSage » 10 Sep 2008, 17:02

Is it possible to export all supplier data to excel. When I save it as Excel it doesn not save the Bank (or other similar) details.
Top
Lady Bea
User
User
Posts: 6
Joined: 11 Sep 2008, 15:09

Post by Lady Bea » 17 Sep 2008, 08:00

I am not sure what version you are on but in Line 50 2009 Supplier module ~ Reports ~ Supplier Details and run Pl_Ledg2.report and save it as a .csv file.

This seems to put the information into one line whereas exporting it via excel makes it look like a report. I must admit you may have to sift through the information exported as when I tried it there were some strange figures in there but at least the bank info comes out including the IBAN etc.

Hopefully, someone else may come along and make a better suggestion.
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 24 Sep 2008, 08:21

any report can be saved as CSV and then opened in excel as rows/columns of data. (much more useful than the excel export in some ways)

If the fields you want are not on the report, add them in with the report designer.

I suggest using one of the Supplier details reports as a starting point.
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: Google [Bot] and 1 guest