Phone: 416-490-1339

support@jeruzalski.ca

About us

Products Customizations Promotions Contact us Maintenance
Sage Accpac® Resellers and Consultants since 1987
Click here for more Sage Accpac ERP Tips and Tricks
 

How to export information from Sage Accpac ERP: useful for getting Accpac data to people (such as marketing) who don't use Accpac directly. 

To export information from Sage Accpac ERP, follow these general steps:

1.       Open the form that displays the kind of data that you want to export. The example below is based on the AR Customers form (the Customers icon in Accounts Receivable).

2.       On the File menu, click the Export command.

3.       On the form that appears, select the type of information to export.

4.       In the next form, enter the export file name and file type (in this case Excel but it can be CVS, Single CSV, ACCESS etc.), and select the fields to export. For example you might need to export your customers’ names and addresses and give it to the marketing department.  By default all  information will be exported.  To de-select everything unclick the check beside "Customers" then only check the boxes that you want i.e. name and address

5.       To limit the range of records to export, use Set Criteria. If you want to extract only customers with a certain city you would base your criteria on the City field.

6.       If you frequently export information with these specifications, use the Save Template button to create an export template that you can use next time you export the data.

7.       When ready, click OK to begin exporting.

                                                      

If you would like to be removed from our distribution list please reply to this message  specifying "Remove" in the subject of your email.