JQS Exchange
Description:
The Job Quote System Exchange
permits remote sales persons the ability to create quotes and sales
orders on their laptop computers and transmit these quotes/orders via
the Internet back to the PCB manufacturing plant. The prices used for
quoting are transmitted from the main plant via the Internet to update
that price databases on the remote computers. These services provide
an automated method for sales persons to submit their quotes/orders
back to the plant for manufacturing and to quote with current prices.
Architecture:
Each remote sales persons notebook computer will have a single user
version of JQS installed. The software will be configured such that
all quotes and sales orders created will be uniquely identified for
the user. At any time the sales person may connect to the Internet and
run the JQS remote update program. This program will transmit the
quotes and sales orders to a database on the internet. It will also
check for any price updates and if found the new prices will be
downloaded to the sales persons computer.
At the manufacturing plant a program will run in the scheduler to load
the quotes and sales orders from the internet to the main Job Quote
System database. Also if any price changes have been made these will
be uploaded to the database on the web server.
Pricing:
$2,495.00 per remote computer.
Installation:
Installation is done using pcAnywhere or GoToMyPC.com. Upon receipt of your payment the Advantage Database Software for remote notebook computers will be shipped to you. Once you receive it call Bacon Software. We will connect, install the Advantage Database program and the JQS Exchange software.
Order Today!
Call Bacon Software 650-963-9013 or email your order requests.
Credit Cards Accepted.
Product Specification
Data Transfer Information:
Pricing Information Uploaded to the Web Server / Downloaded to Remote
Sales Persons computers:
(All files in Advantage data format)
| Table Name | Table Name | Table Name |
|
ADDERS |
ADDRANGE |
BASEMATL |
|
BASEPRIC |
BOARDTYP |
BPINPUT |
|
BPRDETL |
BPRHEAD |
BPSQINPT |
|
BPTFEINP |
LEADTIME2 |
LEADTIME |
|
LLMINS |
MVIA |
PNLLAYER |
|
PNLSIZE |
QTYDISC |
Quote/Sales Order Information Files on the Web Server:
(All files in SQL Server data format but in same structure as JQS
databases.)
| Table Name | Table Name | Table Name |
|
BBVIAS |
CUST |
MATCQDET |
|
NUMBERUP |
PTFEPRIC |
QAUDIT |
|
QDELIVR |
QDETAIL |
QDFMT |
|
QDTEMP |
QHEADER |
QMVIA |
|
QORDHIST |
QPRCFMT1 |
QPRCFMT |
|
QPRICING |
SHIPTO |
QUOTEWBRK |
|
QUOTMATL |
QUOTETXT |
QUOTEBRK |
|
QUOMEMO |
|
|
Remote Processing Overview:
Quotes and Orders created on the remote machine will use the "Sales
Rep ID" assigned in JQS Maintenance…Setup…User Security for the user
signed on to the machine. The format of the quote numbers will be ss-#######
where "ss" is the Sales Person ID and ####### is a unique number for
the quote. All orders created on the machine will have job numbers in
the format ss-######### where "ss" is the Sales Person ID and
######### is a unique number for the job.
For example if the sales persons ID is "28" and quote 12345 is created
then the quote number will be 28-0012345. All quote numbers will be
zero filled to create a 7 character quote number.
WEBPARMS.ADT: A file of
configuration information must be setup for each remote machine.
RQPVERS.ADT: Configuration File on each remote machine to identify the
last price update.
RQUPSTAT.ADT: Quote Upload Information
RSUPSTAT.ADT: Sales Order Upload Information
The sales person will connect to the internet as he/she would normally
and then will start the JQSRemote program.
The remote program will perform the following:
Read the RQUPSTAT file to find quotes that have not been uploaded yet to the web and for each one not uploaded yet the information is written to the corresponding files on the web server. At the completion of this the RQUPSTAT file is updated to indicate that the quote has been uploaded and the WQUPSTAT file is updated to indicate the quote is ready for download to the main plant.
Read the RSUPSTAT file to find sales orders that have not been uploaded yet to the web and for each one not uploaded yet the information is written to the corresponding files on the web server. At the completion of this the RSUPSTAT file is updated to indicate that the quote has been uploaded and the WSUPSTAT file is updated to indicate the sales order is ready for download to the main plant.
The WQPVERS file on the server is compared to the RQPVERS on the local machine to see if a price update is required. If so then the needed pricing files are downloaded and installed to the remote PC.
Changes to JQS to accommodate remote processing:
A new System Parameters will be added to indicate that the system will perform remote processing.
All quotes and sales orders (Jobs) entered in the system will include the Sales Person ID prefix.
All quotes and sales orders (Jobs) entered / updated in the system will be written to the RQUPSTAT and RSUPSTAT file to indicate that file upload is required. Each time these are changed the flag in the RQUPSTAT and RSUPSTAT files will be reset to indicate that file upload is required.
Main Plant Processing/Web Server Processing:
Files on Web Server in SQL Server Format:
WQUPSTAT.SQL: Configuration File on web server used to identify which quotes have been loaded to the main system.
WSUPSTAT.SQL: Sales Order Upload Information.
WQPVERS.SQL: Configuration File on web server used to identify price update information.
Files on File/Server at main plant:
WEBPARMS.ADT: A file of configuration information must be setup for each remote machine.
Main Plant processing overview:
The Main Plant update program will run in the task scheduler and will
perform the following functions:
Read the WQUPSTAT file to identify quotes that need to be loaded to the main system. For each quote identified in the WQUPSTAT file read each of the corresponding quote records in the quote files on the web server and load to the main database on the server of quotes.
Read the WSUPSTAT file to identify sales orders (Jobs) that need to be loaded to the main system. For each sales order identified in the WSUPSTAT file read each of the corresponding sales order records in the quote files on the web server and load to the main database on the server of sales orders.
If new prices are to be uploaded the program will ftp all the required price files to the web server. A new system parameter will be added to JQS that indicates that the price files should be uploaded. "UpdateWebPriceInfo".
