Wrong sales figure in both workperiod and sales report

[Frank_Mwarimbo]

Continuing the discussion from Misleading Workperiod and sales Reporting:

@QMcKay

Inventory Transaction Documents should not affect Tickets. They can possibly affect the Accounts though, depending on how they are set up (i.e. if you created an Inventory Document linked to an Account such as Sales, it could decrease the amount in that Account). I find this to be very unlikely though.

You are not getting the proper Ticket Counts, which is affecting the Sales figures, which has nothing to do with Inventory.

@Frank_Mwarimbo

the work period is only opened and closed once a day.

I realize you mentioned this already, however, please check again for the 11th, and also determine whether a previous Workperiod “spilled over” to the 11th before it was closed. Post a screenshot of your Workperiods.

Here is a work period for yesterday. Bare in mind that the correct sales figure for yesterday was 1,830,900 and ticket count was 154. PLEASE HELP

[emre]

PM me your database backup. I can check that.

PS: Please choose correct SambaPOS version category for your question.

[Frank_Mwarimbo]

The first image shows the the wrong report(Less money and less ticket counts) and the second one shows correct tickets and correct ammount.

NOTE:

1. Im using SambaPOS4 running on a windows 8 machine with SQL Server express 2012.
2. I open and close the work period once a day and i close the work period on the same day to avoid spill over.
3. The computer time is correct.
4. I have not modified anything aside of updating the menu and creating some user.
5. The Samba is running in a multi-user environment(One server and two touch desktop).

[Frank_Mwarimbo]

Sorry, I have not installed the database tools in my sambaPOS is there a way i can find the database backup so that i can send it to you. Thanks

[emre]

You can use SSMS (SQL Server Management Studio) to create backups. It creates a *.bak file and you can zip that file and PM me.

[Frank_Mwarimbo]

OK. Let me try that.

[emre]

So your backup is a txt file. Did you setup an SQL Server Database? I’m afraid you’re using demo database because SambaPOS uses txt file when it can’t finds a database and it is just demonstration purposes.

Read this post for more info.

SambaPOS Database Configuration

In this tutorial I want give some details about database configuration. tl;dr; See Step By Step SQL Server Express Setup document for multi user configuration. Introduction SambaPOS can work in three database modes. Demo mode, single user mode and multi user mode. Demo Mode You don’t need to install a database software just to evaluate SambaPOS. SambaPOS can work with a TXT file to let you understand basic SambaPOS functions. Some features might not work properly in demo mode so if you want…

[Frank_Mwarimbo]

May be my setup is wrong, but I’m using SQL server express 2012, All my computer are linked to one computer which acts like a server( this is where i installed the database) and all other computer connect to this server through a connection string (Data Source=192.168.0.1\SAMBAPOS4; User Id=sa; Password=Mypassword;)

[emre]

So your backup shouldn’t be a txt file. It should be a zip file. Please try again and before posting your PM wait until your file fully uploads.

PS: Read Determining Database Mode section of the tutorial to ensure it runs in SQL mode.

[Frank_Mwarimbo]

i have check the dates on my computer and it turns out the cashier computer was one day old, so the system run fine the whole day with correct reporting and everything but when i came to the office this morning the problem resumes and restaurant terminal dates are correct. I have message you the db backup so that you take a look at it. Thank you

[emre]

Wrong figure on workperiod and sales Reporting