Database dump to Excel

SUGGESTED

I want to download the database into excel so that I can do some custom reports over several years. It would be nice to see all the transactions in an account spanning several years without having to download a years worth at a time.

Parents
  • 0
    SUGGESTED

    I do dumps, analysis and report compilation all the time and Simply Accounting is too simple for what you're asking … per se.
    It locks every year so I do a sloppy workaround - I set up a report, save it as a template for all users then run once year, copying and pasting into a template made to clean it up for compilation and sorting into one page. 

    Keep in mind that if you ever had that old bug where the database got overloaded, Simply probably went and performed a maintenance, literally deleting chunks and batches - this could affect your reports depending on what you're doing but to get around that, merely restore a backup of a previous year to a separate company and keep going.

Reply
  • 0
    SUGGESTED

    I do dumps, analysis and report compilation all the time and Simply Accounting is too simple for what you're asking … per se.
    It locks every year so I do a sloppy workaround - I set up a report, save it as a template for all users then run once year, copying and pasting into a template made to clean it up for compilation and sorting into one page. 

    Keep in mind that if you ever had that old bug where the database got overloaded, Simply probably went and performed a maintenance, literally deleting chunks and batches - this could affect your reports depending on what you're doing but to get around that, merely restore a backup of a previous year to a separate company and keep going.

Children
No Data