I am planning to install Manager and use the desktop version, However i want to know if the data ( accounts, figures, customer names … etc) will be stored in a standard database ; like MySql or such. And if so, will be i be able to access this database and write my own SQL queries ?

Data is accessible via SQL. All you need to do is go to Custom Reports under Reports tab. For example, to select all customers, run SQL query SELECT * FROM Customers

Dear Lubos This is very assuring, but you calrify a bit more: what is the type of the database used, MS ACCESS, MySql … ? will there be available details of all tables in the database , Customers, Journals, Batches … ? and Where can i find these table details.

Manager is not using any SQL database. But custom reports will support SQL to query data however this is still work in progress and there isn’t documentation yet.

Hello, when can we expect this documentation to be ready, i dont mean to cause any trouble but having read through a number posts on this matter; the issue of documentation has been a long outstanding issue. Is there a time frame to the production of this much needed documentation?

it is onley one table " Customers" but if i want to query about sales invoices , i don’t know the exact table . can you provide the database schema so that we could query easiy.

[image] Custom Reports Where does it export to when I press the “export” button? Is there a sum() function or a “group by”? The list of tables looks like… use “select * from …” to get the list of fields. GeneralLedgerTransactions CashTransactions CashTransactionLine…

yes ,very good , sql queries on these tables working fine thanks

Cant find option to run sql query in desktop version, do we need to have cloud/server edition to run sql query now?

First of all, it’s a very old topic. Everything has changed since when it was generated. You cannot have direct access to Manager’s database. However you can extract data with Custom Reports that are available also under desktop edition. There is also the Report Transformation module but right now …

[image] Davide: is also the Report Tra thanks Davide, where is that module? also using that module can i include more data about customer e.g address in “Tax transactions” report?

Database Access

Eagle5 February 9, 2018, 4:34am 7

not all these tables are still functional, but I mostly work from these when I make SQL queries.

Topic		Replies	Views
SQL schema for creating custom reports	61	11713	March 5, 2018
Custom Reports	72	17087	May 17, 2018
Connection to another database/system	8	910	March 18, 2022
SQL Table Connection w/ LibreOffice Base For Custom Reports	16	2309	March 19, 2018
Export Data from Manager Desktop Software to SQL	8	984	July 2, 2019

Database Access

Related topics