There is a set of default queries inside the database, accessible through the configurator – reports – queries to help to trace anomalies in the system.
Bill overview
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.
Records changed
This query is very useful to find out what changes have been made on configuration during a certain period. For example, online booking behaves differently, 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.
You must log in to post a comment.