Business Management Software For Value Added Resellers
CRM, Quote Processing, Order Processing, Procurement, Web Storefront, PSA and business process automation



Overview

Documentation

Tutorials

FAQ's

Trouble Shooting

Contact Tech Support

Search RA Web Site

ResellerAdvantage FAQ's (Frequently Asked Questions)

Reseller Advantage

General
1.  What are the system requirements for Reseller Advantage?
2.  Is database software included with Reseller Advantage?

System Set Up and Configuration

1.  When setting up Reseller Advantage, I built a new database device in SQL Server, started Reseller Advantage and tried to log in. Why do I get the error message "Statement Error"?
2.  How do I add additional branches for my company in Reseller Advantage?
3.  How do I assign a salesperson to a branch for my company in Reseller Advantage?
4.  After setting myself up as a Super User, I tried to edit my Contact record in Reseller Advantage and received the following error message: "Runtime error: Protection Violation - See error.log for run information".
5.  When I was trying to save a new contact in Reseller Advantage, I received the following error message: "[MICROSOFT][ODBC SQL Server Driver][SQL Server] Updated or inserted row is bigger than maximum size(126 bytes) allowed for this table."
6.  After setting up Reseller Advantage and running the license program on a test machine, I uninstalled the software from the test machine. Does that affect the license program?

Contact Management

1.  When I log on to Reseller Advantage, how can I see other User's calendars and Activities?

Importing / Exporting Information

1.  Do I have to install a copy of Reseller Advantage on the server machine in order to do the initial downloads from vendors (Ingram, Tech Data, etc)?
2.  To successfully set up the Reseller Advantage accounting package integration module - does PeachTree need to be installed on every machine that has Reseller Advantage?
3.  When running the product download from a vendor, I received the error message "Runtime error: index: 2 is outside of collection bounds".

Sales Orders

1. I know that I should set up a directory "C:\temp" to provide a holding area for exported sales orders. If we have several seats of Reseller Advantage with several sales people exporting sales orders, can the one "temp" directory on the server accommodate all users?
2.  When I create a sales order, deal, or purchase order, are they saved forever in the database?
3.  As a salesperson, when I log on to Reseller Advantage, can I see other salespeople's deals and sales orders?

Reseller Order Purchasing

Purchase Orders (POs)

1.  When I create a PO and the products are delivered, how do I close out that purchase order or confirm that the products were received?
2.  Is there a way to associate serial numbers with products on specific line items on a Sales Order or Purchase Order?

Reseller on the Web

General

1.  What are the system requirements for Reseller on the Web?

System Set Up and Configuration

1.  When I'm setting up Reseller on the Web, why do I get the error message "Cannot connect to database"?

FAQs for

Reseller Advantage

General

1.  What are the system requirements for Reseller Advantage?

A)  Reseller Advantage runs on almost any computer with Microsoft Windows 95, 98, 2000, NT 3.51, NT 4.0 or NT 4.0 Terminal Server. The minimum recommended configuration on a client machine is:
  • Pentium 166Mhz or higher
  • 32 Meg of memory (RAM)
  • 50 Meg of free disk space

Back to Top

2.  Is database software included with Reseller Advantage?

A)  No. Since many end users already have a database management software system (DBMS) installed, or prefer to use a specific brand or version that they are familiar with, we decided not to include it. Reseller Advantage can access any Open Database Connectivity (ODBC) compiant DBMS such as Microsoft SQL Server or Sybase SQL Anywhere to store and retrieve all the data used by the Reseller Advantage system. Because you can choose a DBMS that's right for you, as your business grows your chioce of DBMS will allow the Reseller Advantage system to grow with you to virtually any size. For multi-user set ups, the DBMS usually resides on a server such as Windows NT Server.

Back to Top

System set up and configuration

1.  When setting up Reseller Advantage, I built a new database device in SQL Server, started Reseller Advantage and tried to log in. Why do I get the error message "Statement Error"?

A)  Make sure you read the Getting Started Manual and follow the directions carefully. You missed two important steps.

1. You have to create a new ODBC entry on your machine to point to the new database device you created.

2. When you start Reseller Advantage, before you log in double click on the logo in the top half of the log in screen, type in the password ("guest" is the default), enter the Data Source name for the ODBC entry you created, the database Signon ID and Password, and click the "Create Tables" button.

Please refer to the Getting Started Manual for more details.

Back to Top

2.  How do I add additional branches for my company in Reseller Advantage?

A)  From the main screen in Reseller Advantage, click on File / Administration / List Box Items to bring up the List Box Maintenance window. On the left side of the window in the Tables section click on "Branches". On the right side of the window, click on the New button and enter a new, uniqe Short Name to identify the additional branch and then enter a Long Name that describes the branch for your users. Click OK to accept your changes and close the List Box Maintenance window.

Back to Top

3.  How do I assign a salesperson to a branch for my company in Reseller Advantage?

A)  Log on to Reseller Advantage as the salesperson. From the main screen in Reseller Advantage, click on File / User Preferences to bring up the User Preferences window. Click the List Box for the Default Branch field and select the branch to assign the salesperson to. Click OK to accept your changes and close the User Preferences window.

Back to Top

4.  After setting myself up as a Super User, I tried to edit my Contact record in Reseller Advantage and received the following error message: "Runtime error: Protection Violation - See error.log for run information".

A)  Make sure your database software is current. See the message for Microsoft SQL Server 6.5 Users at the top of this page.

Back to Top

5.  When I was trying to save a new contact in Reseller Advantage, I received the following error message: "[MICROSOFT][ODBC SQL Server Driver][SQL Server] Updated or inserted row is bigger than maximum size(126 bytes) allowed for this table."

A)  Make sure your database software is current. See the message for Microsoft SQL Server 6.5 Users at the top of this page.

Back to Top

6.  After setting up Reseller Advantage and running the license program on a test machine, I uninstalled the software from the test machine. Does that affect the license program?

A)  No. The license program must be run on each machine that has Reseller Advantage installed. The licensing does not restrict the number of machines that you can install the software on. It restricts the number of users that can be added to the system.

Back to Top

Contact Management

1.  When I log on to Reseller Advantage, how can I see other User's calendars and Activities?

A)  If you are a member of a "User Group" in Reseller Advantage, you can click on the Goup View button on the Schedule/Mail tab within Reseller Advantage to see information for other Users in the User Group.

Back to Top

Importing / Exporting Information

1.  Do I have to install a copy of Reseller Advantage on the server machine in order to do the initial downloads from vendors (Ingram, Tech Data, etc)?

A)  Technically no you don't. However, all downloads (not just the initial ones) must be run from the same machine each day. Typically this is scheduled for the evening and therefore we recommend running it on the server because it will be less likely to be shut down at night. The product downloads do require a copy of Reseller Advantage to be installed.

Back to Top

2.  To successfully set up the Reseller Advantage accounting package integration module - does PeachTree need to be installed on every machine that has Reseller Advantage?

A)  No. Only the order administrator(s), or purchaser(s) need need to have both Reseller Advantage and the accounting package installed on their machines, since they are the people exporting Reseller Advantage orders to the accounting software.

Back to Top

3.  When running the product download from a vendor, I received the error message "Runtime error: index: 2 is outside of collection bounds".

A)  Make sure that you are keeping up with the "mapping" of product heirarchies from vendor's systems to your system. If you don't, you may wind up with too many new top level categories for the current system to handle. Although this should not be a problem for most users, to help avoid it we have made some modifications which will be available in version 3.3 of Reseller Advantage.

Back to Top

Sales Orders

1. I know that I should set up a directory "C:\temp" to provide a holding area for exported sales orders. If we have several seats of Reseller Advantage with several sales people exporting sales orders, can the one "temp" directory on the server accommodate all users?

A)  A separate "temp" directory on the server should be set up for each user (i.e. "C:\tempUserA", C:\tempUserB", etc.). This can be done from the "File/User Preferences" drop down menu from within the main window in Reseller Advantage. All the settings available in "User Preferences'" should be set separately for each user.

Back to Top

2.  When I create a sales order, deal, or purchase order, are they saved forever in the database?

A)  The system will not automatically delete any deals, sales orders or purchase orders. Currently, the only way to remove them from the system is to delete them manually. An archiving system is being considered for a future release.

Back to Top

3.  As a salesperson, when I log on to Reseller Advantage, can I see other salespeople's deals and sales orders?

A)  As a salesperson (without Deal Administration or Order Administration permissions), you can see and open other salespeople's Deals and add related Comments or Activities to them, but you cannot make any changes. If you are a member of a User Group, and that Group is assigned as the Owner of a Deal, you can make changes to that Deal before it becomes a Sales Order. If you have Deal Administration permissions, you can also make changes to other User's Deals.

Only Users with Order Administration permissions can see other User's sales orders.

Back to Top

FAQs for

Reseller Order Processing

Purchase Orders (POs)

1.  When I create a PO and the products are delivered, how do I close out that purchase order or confirm that the products were received?

A)  A PO's status is automatically marked "Ordered From Distributor" when the "Accept Order" button is clicked on the Buying Report tab in the Order Processing module. The status is changed to "PO Exported" when the "Export Order" button is clicked in the PO Workbook and the PO is exported directly to your accounting system to a comma delimited text file.

It is assumed that your accounting system is used to manage inventory and therefore will also be used to receive products from POs.

As a buyer or a purchaser for your company, it may be helpful to isolate POs by status such as "New Purchase Orders" that require further processing within the Order Processing module. You can do this by selecting a status from the status list box on the Purchase Orders tab and clicking the Search button.

Back to Top

2.  Is there a way to associate serial numbers with products on specific line items on a Sales Order or Purchase Order?

A) Currently serial numbers are not supported. It is being considered for a future release.

Back to Top

FAQs for

Reseller on the Web

General

1.  What are the system requirements for Reseller on the Web?

A) Reseller on the Web runs on Windows NT Server 4.0 with the web server Internet Information Server (IIS) 3.0 or 4.0 installed. Clients can access the web site with the browsers Internet Explorer 4.x or Netscape Navigator 4.x. Reseller on the Web uses any Open Database Connectivity (ODBC) Database Management System (DBMS) to store and retrieve information. The proper ODBC drivers for the DBMS must also be installed on the web server (they are usually installed automatically when the DBMS is installed).

Back to Top

System set up and configuration

1.  When I'm setting up Reseller on the Web, why do I get the error message "Cannot connect to database"?

A) In order for the system to make the connection, you have to have a "GUEST" user with a "GUEST" password entered in Reseller Advantage. For more information, consult your Reseller on the Web User's Manual.

Back to Top

2.  Can I install Reseller on the Web and my database on the same machine? 

A) Yes, this configuration is fine for most web sites. However, for web sites with a significant amount of traffic you can improve web site performance by separating the web server (with Reseller on the Web) and the database management system (DBMS) on to separate machines.

Back to Top

Home - Products - Services - Support - Downloads - News - About - Contact
Copyright 2003 ResellerAdvantage.com, LLC