logo

database

MTS #01 C – Main Categories of SMARTSystem Data

SMARTSystem Management Training Series

Training Session #1C – Main Categories of SMARTSystem Data

 

The Seven Main Categories of Data in SMARTSystem

 

There are seven basic types of information that comprises the SMARTSystem database.  These are:

 

  • Staff
  • Customers
  • Vendors
  • Inventory
  • POs
  • Sales
  • Shipping

 

All other items in SMARTSystem will either look up or utilize one or more of the different types of information listed above. 

 

SMARTSystem tracks and associates all the above information with the customers, sales people, inventory, shipping, and POs (sometimes referred to as a LOT) for each transaction, managing the big picture of inflow and outflow of inventory, along with the “who, what, when, where, and how.”

 

The basic in and out process, and how the database flows, works as follows:

 

  1. A staff person, who is an authorized buyer, will create and place a Purchase Order with a vendor. The vendor will ship the inventory and it will be received. 

 

  1. A sales person will take an order from a customer, and will select from the list of available inventory, the items the customer is requesting.

 

  1. The order will be picked and packed, then shipped, from the warehouse. Inventory amounts will be reduced. 

 

Restoring Your Database From Backup

Restoring the database can be done in a few simple clicks.  You must be on the server to perform this function.

Click on “File” and select “Restore database:”

restore SMARTSystem database

Click on the “Select File to Restore” button:

restore SMARTSystem database file selection

Navigate to the location your backup files are stored and select the backup file.  Backup files will always have a date and time stamp as a part of the file name:

restore SMARTSystem database

 

Once you are back to the Restore Database screen, click on the button “Restore Database.”  You will then be prompted to enter a password.  This will be the password selected for the credit manager.

A warning will display:

warning

Click on the “Yes” button to continue the restoration.

Another warning message will pop-up.

warning2

Click on the “Yes” button to continue.

The restoration process will launch with the following message:

warning3

When restoration is complete the following window will pop-up:

backupSuccessful

SMARTSystem will restart once the “OK” button is clicked.

Once the program restarts, it will display the following message:

postRestoreMsg

The program will continue its startup once you click on the “OK” button.

The database will now have been successfully restored.