ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> FAX NUMBERS REPORT
http://www.istechforum.com/YaBB.pl?num=1069437211

Message started by RodRivero on 11/21/03 at 09:53:31

Title: FAX NUMBERS REPORT
Post by RodRivero on 11/21/03 at 09:53:31

I NEED TO PRINT A REPORT THAT INCLUDES THE FAX NUMBERS OF ALL MY CUSTOMERS. THERE IS NONE IN ACCOUNTS RECEIVABLE AND I DON'T WANT TO USE CRYSTAL REPORTS. HOW CAN I DO THIS? CAN I CHANGE THE DBA REPORTS? I TRIED BUT I SEE THAT IT DOESN'T ALLOW YOU TO INSERT FIELDS. THANKS

Title: Re: FAX NUMBERS REPORT
Post by aricon on 11/21/03 at 10:30:41

USe the DE module to export the data into a comma-demilited format and then open Excel and open the comma-delimited text file and Excel will bring up a conversion wizard that will populate each piece of data into a separate field.

The file you would be after is BKARCUST.

If you need to have this data refreshed on a regular basis, you could set up an ODBC to get this information and bring it into a linked Excel file that would ask you if you wanted to refresh the data when you open it.

You could also use Access to get the data. Again, set-up an ODBC connection and then link to the DBA table, and then create a query off the link and a nice pretty report off the query.

Title: Re: FAX NUMBERS REPORT
Post by Lynn_Pantic on 11/21/03 at 16:31:25

If you aren't using Contact manager, set up a single rep and password using SM-I-I and then CM-K to transfer customers to CM, then run CM-B-B or CM-B-J

Title: Re: FAX NUMBERS REPORT
Post by RodRivero on 12/01/03 at 13:39:29

THANKS SO MUCH :D