Daily Sales Reports

Sales Report Tab (REPORT CENTER)

Hourly Sales Report
Options:
All sales
Filter by Accounts/Department

All Sales with Include Username
All Sales with Filter by Accounts/Department


Daily Sales Report (Cash Sales)

Options:
All Sales
Include User name
Under Payment
Display Unpaid Invoice
Credits Only
Filter by Accounts

Filter By accounts and Under Payment
Filter by accounts and Display Unpaid Invoice
Filter by accounts and Credits only



Monthly Sales Report (Sales for the whole Month)
Filter by Accounts/Department

EMS Connection Error

 

How to fix this error:

1.) Make sure you are connected to your Local Area Network (check if Network Card is enabled)

2.) Make sure you can ping your MySQL Data Server

Click your Start Menu and type "CMD" on the Search Files/Run

 

then type 

ping 192.168.0.101 (EMS Data Server)

If everything is OK, you should see a Reply from the Data Server.

In this case we are using a class C IP Address for our Local Area Network and 192.168.0.101 is the IP address of our MySql Data Server. 

Note: you can change the Data Server IP address to anything if you know what you are doing. Just make sure all clients are on the same network and have the same subnetmask and can connect with each other.

3.) Open your EMS "config.ini" file located in the EMS installation Folder. Edit the Details in the file such as the Server (IP Address of the EMS Data Server), Username (UID), and Password (PWD). Make sure all details are entered correctly.  "Please reffer on MySQL GUI TOOLS on how to add users into MySQL Server"

 NOTE: don't forget to save the edited "config.ini" file.

4.) Go to your Control Panel, Administrative Tools, and click on ODBC

You will also need to set ODBC Data Source. Select the System DSN tab and click configure.

Enter the Details such as the TCP/IP Server( in this case enter the IP 192.168.0.101 if you are using 192.168.0.101 as your MySQL Data Server IP) also enter the Username and Password.

Remember:  Administrator should add the Username and Password for each client on the MySQL Server. This is needed in order for EMS to connect.

Click on Test button to test the connection.

5.) If the Connection Error is still Not Resolved, check your Firewall settings. You can disable your firewall or you can just open the following ports. 

Port 3306 and grant full access to EMS.
This goes same way with your MySQL Data Server.  You should also allow the MySQL from your Firewall.

What is a point-of-sale system?

A Retail Point of Sales system typically includes a computer, monitor, cash drawer, receipt printer, customer display and a barcode scanner,

The POS unit handles the sales to the consumer but it is only one part of the entire Inventory and POS system used in a business. Other functions of the POS system include inventory control, purchasing, receiving and transferring of products to and from other locations. Other functions of a POS system are to store sales information for reporting purposes. Customer information may be stored for receivables management, marketing purposes and specific buying analysis.

EMS – eManagement Inventory and Point of Sales Software

eManagement software (EMS) and Point of Sales (xPOS) is a complete enterprise solution program addressing all the needs of a starting or established business enterprise in its daily operations ( pharmacies, department stores, Hardware, restaurants etc.) It is a well organized user interface providing ease for operation. The functions of the program can be so easily located in the software’s interface making it very “user-friendly” inventory software.

The business owner is specifically provided with a function handling the Reports as to the total status of the enterprise, thus, giving the same a “Real-time” assessment of the business.

 

(EMS) eManagement eliminates the classical way of handling a business enterprise manually involving lots of papers and folders for reference can be set aside. A few of the many advantages given by this software are: an increase in the employee’s productivity; reduce turn-around time in processing orders; eliminates over-stacking or stack-outs; provide a just-in-time inventory; and increase customer satisfaction.

With eManagement software operating in a business enterprise, accuracy and certainty of its inventory is 100% guaranteed.


Download Free Trial

Buy Full Version for $599.00 USD ONLY!

For more information please contact us:
XPC Software Solutions
Mobile#: +639298183181
http://www.nsfive.net

Application enhancement

Application enhancement, when developing a multi-user application, always consider to clean your code, and get only the Data that your user needs, this will enhance your system performance. making your software runs faster than those without code enhancement.

Good day!.

Why MYSQL?

MySQL is by far the most popular database management system for small- to medium-sized web projects.  MySQL provides clear, concise tools needed to create and maintain a database. the functions it provides, enabling the user to get the most out of them. So that is why XPC software solutions choose MySQL for our Database Sever.