Novo Gest is queried in read-only mode. ImaCash captures sales and refunds and separates cash from card in mixed payments without changing or confirming Novo Gest documents.
Requirements, configuration and validation
- Before configuration, obtain the SQL server, port or instance if applicable, database, a read-only user with SELECT permission and the sales table name. The ImaCash computer must be able to reach SQL Server.
- Configuration in ImaCash:
- Category: Retail
- Integration: Novo Gest
- Integration data:
- SQL server: Enter the host or IP, port 1433 unless configured differently, and the instance when one is used.
- Database name: Enter the Novo Gest transactional database containing the sales table.
- User: Use a SQL account with SELECT permission. For Windows authentication, enable its checkbox and run ImaCash under an authorized account.
- Password: Private information provided by the administrator. Enter it only in ImaCash.
- Sales table: In the historical Stations field enter schema.table. Leave it blank only when the database has exactly one table containing N_TICKET, CODEMPLE, EN_EFECTI, EN_TARJETA, CAJA, FECHA and HORA.
- Validate and save: Save the connection details and the selected table in ImaCash.
