Getting data out of Iris Accounts production
We currently use Iris accounts produciton to produce our accounts and we also have an excel workbook full of our workping papers and currently we have to enter the trial balance in to both and any adjustments into both.
What i would like to find out is if its possible to connect excel to Iris accounts production and pull the data out from there. I am not sure how Iris accounts production holds all the data. I can get into the practice management data via a sql connection but can not find the sql database for account produciton data (not even sure thats how it stores its data). Any pointers anyone can give me would be much apreciated even if its to say it cant be done.