AR Statement in Excel

We have a couple of customers that are looking for their AR Statement in Excel format. The Crystal Report doesn't really export nicely. Is there a product or an easy way to get the AR Statement into Excel format?

  • 0

    I've done one in Excel where the user can type in a customer code and through-date, and all AR documents open in Sage appear along with customer address/contact.  Let me know if you'd like to discuss.  I don't know how clearly the image will be displayed, but here goes...  Click it to see larger.

     

  • 0

    We have written a SQL query that allow for extraction of aged documents. We originally used this as an email attachment for customers with a large volume of transactions (made for easier reconciliation).

    We would be happy to help if you are still looking for a solution - PM me.