Welcome to Softhard Solutions ShopMate Main Database System Module Screen Shot
Read Detailed Description of Database System Module...
In the Database System Module you keep track of various aspects of correct running of the ShopMate Database System and the correct storage, retrieval and backup of the data from your Sql Server's ShopMate Database. This module also allows you to set password for your database backup procedures so to avoid theft of your data. You can also make different connections to Sql Server in a Cloud Data Services or on your premises.
ShopMate uses stored procedures and triggers of your SQL server's ShopMate Database for its data retrieval. If you change any of these stored procedures in your Sql Server externally, the ShopMate's forms and reports referencing them may not work properly if at all. This is also the case for the database and table triggers. If you change any triggers the forms may not be getting the data they expect and fail to operate correctly.
Following is a screen shot picture of ShopMate Main Database System Module.
By default, at start up, each employee is marked as present at work, except for employees marked as Inactive and entries made on Saturdays and Sundays. It is your responsibility to see that the entries, employee attendance and wage Approval, are correct for each day of employee operations.
All your labour products should have the ItemsInUnit property set to a number greater than one. If we assume that the Items are minutes of a Unit (one hour), you can set the ItemsInUnit to 60 (minutes). Then in an invoice you can enter e.g. 2.3 (hours) into Units and the Items (minutes) will be correctly calculated in this invoice item.
The updatable grids may contain one or more fields that are too short to display fully. You can click into these fields and the editor will display all words fully below it, formatted (even if a field is not normally updatable - if you try to update such field the editor will simply return the previous data).
Before a product is being pulled into the invoices or orders via a bar code scanning device, make sure the designated bar code field receiving the number is in focus.
Although you may, it is advisable NOT to use dot (.) character as a first letter of the product names you yourself create.