The Last report that i need to create for this to be done will be: Single Sold Items Report which will include in a single page all sold items and each item will have its cost report with recipe items, quantity used, item unit, item cost and total cost.
Also i am planing to include in this a PHP POS based on same system structure MSSQL+SQL SRV Module+PHP this way you dont need to open Messaging server, you will only use SambaPOS and MSSQL Server. The Wamp server can be hosted on another PC.
My currently Setup is the following:
1 PC for SambaPOS and MSSQL Server + FREE SQL Backup Tool (http://sqlbackupandftp.com/) that will backup the DB to an FTP every day in case the HDD will fail (for this PC i also am using an UPS with management that is stabilizing the current intensity and don’t let the PC shutting down on power failure it will send shutdown command after 5 minutes of power failure)
1 PC for WAMP Server and SQLSRV module so i don’t overload the 1st PC
2 Tablets that are connected to the 1st PC - I am trying to lose the remote connection to the 1st PC which have the DB and use browser based POS instead of connecting remotely via tablets to the 1st pc this way the 1st PC will work like a charm.
I will also develop an Android APP for the Web BASED POS so in case the 2nd PC goes down the 3rd Backup PC will come in ( the 3rd PC is my personal home PC which is always opened - this will be only used for emergency situation )
I also am installing sambapos to a new location and all this setup will cost me around 1000$ ( PC + TouchScreen Monitor + UPS + Gigabit router + Router Range Extender + 2 Thermal Printer (1 for kitchen and 1 for customers) + 1 Tablet ) — I will keep this post updated with my progress 