Business Accounting Database Modules Explanation

In the Product Purchases Module you create new and update existing purchase orders. You can create an order in just three mouse clicks, four if you have to select a new supplier or product, from ShopMate home page. It is that simple. You can select any supplier by either their Company Name or their Full Name.

The products in the grid reflect the supplier you select, only the currently selected supplier's products will be displayed here.

In the first task tab, the two months calendar is used to select a date for your new purchase orders. If the date's font is bold it contains one or more open orders for that date. The second task tab contains closed or open orders for the selected day only and the third task tab contains all the existing open purchase orders.

• Read Detailed Description of Product Purchases Module
  
  
• View a Screen Shot of Product Purchases Module

The Address Files Module holds together all the information files of various entities, things and people. The information in these files of entities is used throughout the ShopMate system.

There are several task bar tabs containing information on the individual entities and their summary. Click on each to review the information of the entity.

• Read Detailed Description of Address Files Module
  
  
• View a Screen Shot of ShopMate Address Files Module

In the Employee Payroll Module you create new and update existing employee Payroll daily entries. Making regular payments to employees in the ShopMate Database is a part of administering a database system.

Important Note
Please note that the Payroll part of ShopMate is Deprecated as of ShopMate Version 9, 2015 release. You still can use it for older data tax which is calculated according to the Australian tax laws and tax scales to the end of 2014.

The three task tabs available in this form help you to maintain the employees daily attendance time sheet, approve wage payment and check labour hours used in invoices for selected (booked) dates. Think of this section as a Bundy clock for employees.

Each day represents an attendance sheet which is automatically maintained by ShopMate as needed.

Important Note
In order to make sure that ShopMate always calculates the correct income tax, it is your responsibility to make sure the individual employee Payroll information is entered correctly, according to your own knowledge and according to what an employee actually declares. If you enter information that should not be there, incorrect tax will be calculated.

• Read Detailed Description of Employee Payroll Module
  
  
• View a Screen Shot of Employee Payroll Module

In the Database System Module you keep track of various aspects of correct running of the ShopMate Database System and the correct retrieval of the data from an Sql Server 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.

Important Note
ShopMate uses stored procedures and triggers of the SQL server ShopMate Database for its data retrieval. If you change any of these stored procedures externally, the forms and reports referencing them may not work properly if at all. This is also the case for the triggers. If you change any triggers the forms may not be getting the data they expect.

• Read Detailed Description of Database System Module
  
  
• View a Screen Shot of ShopMate Database System Module