Queries to help tracing issues in the software

There is a set of default queries inside the database, accessible through the configurator – reports – queries to help tracing 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 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.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

en English
X