Difference between revisions of "How do I Export a Supplier List?"

From Catalyst
Jump to: navigation, search
m
Line 1: Line 1:
{{Review}}
 
 
== Summary ==
 
== Summary ==
This article explains how to export a list of your suppliers to a {{FileExt|CSV}} file for you to view in Microsoft Excel.
+
This article explains how to export a list of your suppliers to a {{FileExt|CSV}} file for you to view in any good commercial spreadsheet.
  
 
== More Information ==
 
== More Information ==
* Go to {{Menu|{{PL}}|Purchase Reports|Accounts Report Generator}} and type in {{DataValue|EXS}} in the {{DataPrompt|Filter on}} field and press {{KeyPress|Enter}}.
+
* Go to {{Menu|{{PL}}|Purchase Reports|Accounts Report Generator}}, type in {{DataValue|EXS}} in the {{DataPrompt|Filter on}} field and press {{KeyPress|Enter}}.
 
* Select the {{DataValue|Export Suppliers(EXPSUPP.CSV)}} and click {{Button|Start}}.
 
* Select the {{DataValue|Export Suppliers(EXPSUPP.CSV)}} and click {{Button|Start}}.
* This should open up a Microsoft Excel document with a list of all of your suppliers and their contact details. If you do not have Microsoft Excel on your machine it should open the information in Notepad for you to save to a suitable location.
+
* This should open up a spreadsheet document with a list of all of your suppliers and their contact details. If you do not have a spreadsheet programme on your machine it should open the file in a text editor such as Notepad for you to save to a suitable location.
  
 
== See also ==
 
== See also ==

Revision as of 15:06, 13 March 2013

Summary

This article explains how to export a list of your suppliers to a '.CSV' file for you to view in any good commercial spreadsheet.

More Information

  • Go to " Purchase Ledger Purchase Reports Accounts Report Generator", type in 'EXS' in the "Filter on" field and press <Enter>.
  • Select the 'Export Suppliers(EXPSUPP.CSV)' and click [Start].
  • This should open up a spreadsheet document with a list of all of your suppliers and their contact details. If you do not have a spreadsheet programme on your machine it should open the file in a text editor such as Notepad for you to save to a suitable location.

See also


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
Export, Purchase ledger, Supplier, List