There is a set of default queries inside the database, accessible through the configurator – reports – queries to help tracing anomalies in the system.
Use it to search for bills where total payments don’t match total sales.
Deposit without products
Use it to scan for deposits that are given outside the normal sales. Most of the time these are manual corrections inside the system.
This query is very useful to find out what changes have been made on configuration during a certain period. For example, online booking behaves different, but nobody “changed” anything, use this query to find out what has been changed.
Records waiting for upload
Returns a list of all tables with data that is stuck and is not uploaded to the online platform. This is usually an indication that configuration is not propagated to the online booking or office.