AccPac data extract

[funnie]

I want to extract some data from accpac... with the following specs:

All records must be open item.

• Two files are required from the client every week: a Debtor’s Master listing (containing all debtor static/master information) and a Detailed Aged Analysis (listing all debtor open item transactions). Detailed history on the debtors ledger is not required – current records are sufficient.

• The files must be in a text (TXT) or a print (PRN) format.

• Receipts, credit notes, adjustments, discounts, etc. must all be referenced to the original invoice.

• Files are formatted as ASCII files or files with field’s comma delimited.

how do i go about it

 

[dgillz]

I would use crystal reports.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[ettienne]

If you are programmatically inclined then you can write a VBA macro to output the data to text files, this is relatively simple to do if you know how.

 

[DougHennig]

You can use Accpac Query for this:

http://www.stonefieldquery.com.

Doug