Database Overview

Database Setup

There are several important databases that are the backbone of the ReSource Partner program.  

 

One you will build as you take care of the customers at the counter, called your Customer Database. This database includes their name, address, ship to information, phone contact information, discounts, On Account information and running totals as well as the last date in the store.  Every transaction you do should start with the selection of the customer in order to effectively use this database.

 

Another is Inventory.  Inventory is the source of pricing information at the Point of Sale.   It provides the Package Estimator with material information it needs to make the estimate calculations.   It is the place where sales tax is designated for the items you sell. The last one, Vendor Database, is only applicable to those who wish to have the system generate Purchase Orders for them.

Do I Have To Use All Of The Database Functions?

This is the most common question asked regarding the databases. The answer is No. You will determine how much information you want to enter and have the system track. How much information you as a business owner will be able to get out of your program will be directly tied to what you put in and what you collect at the Point of Sale.

 

 

Customer Database

This database includes customer names, address, tax status, discounts (if assigned), their first and last date in your store, how much the customer has spent in your store, the average transaction amount and all Account Receivable activity.

 

 

Inventory Database

This database is where Sales Category descriptions are entered, Sales tax is assigned to a sales category or product, the retail prices and cost for each item are entered. It also has several other useful functions that can make your job as store owner much easier.

Vendor Database

This database allows you to keep track of the vendors you use, and what and how much you've bought from them.   You will use the Vendor Database as part of the Purchase Orders module.

 

 

Coupon Database

This option allows you to enter bar coded coupons or use bar code simulation for recognition at POS and reporting to measure the effect of your marketing efforts.  Coupons can be for a dollar amount, a percentage, new selling price, or allow you to enter the end sale price or coupon value at the time of the sale.

 

 

 

Shipping Address Database

The Shipping Address database (Ship-To Lookup) contains your shipping addresses.  These addresses can then be associated back to Customer Database records as well.

 

 

 

 

 

ReSource Help System - Home Page

 

 

Sales: (800) 818-0492  

Customer Service: (800) 537-3621

Email: support@resourcesoftware.com  |  sales@resourcesoftware.com

 

 

 

Follow us @resourcehelp  | Subscribe To ReSource Software YouTube Channel

 

ReSource Partner Help System.  ©1996-2014, ReSource Inc.  All rights reserved.

ReSource Inc., 10465 Park Meadows Drive Suite 205, Littleton, CO  80124

Terms Of Use  |  Legal  |  About

 

ReSource Partner, Partner Express, QuickMail, and WebAssist are trade names of ReSource, Inc.   

All other trade names mentioned are property of their respective owners.

 

POS SHP MBX | PK | US

14.2.2 | 14.1.1