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 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.




SMS-Timing and BMI Leisure are brands of B&MI NV. We offer an all-in-one reliable software suite, covering all aspects of your karting & entertainment business, including strategic advising, and marketing. We help you deliver fun, relaxing, and entertaining experiences to your visitors that will keep them coming back for more!

Our system includes a comprehensive POS system, CRM management, online booking & website shop for family entertainment centers all over the globe.

More information?

Check out our website: BMI Leisure and SMS-Timing

Need more help with this feature? Click here:  24/7 Support service

Check out other updated features here: devblogs 

Remember also to check our Marketing blogs for some inspiration! 

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