DBIS Intranet

What is DBIS?

Scientel's Distribution Business Information System (DBIS) is an interactive, web-like wholesale distribution system that is designed to run on your in-house intranet. The program is diverse enough in its range and depth of applications to manage the entire distribution operation.

Because the program is web-based, it operates with the proven technology of internet browsers. Internet operations and conventions operate in DBIS. Therefore, if you can surf the Web, you can operate DBIS. However, because the operations are intranet, you have a system that is both stable and secure from outside hackers and other internet disruptions. Yet, you can transfer to the Internet for other work, when you need. In addition, the web-based configuration enables your system to connect many different hardware components without complicated local area network (LAN) configurations.


DBIS is an extremely efficient and fast system, designed to meet and exceed the requirements of distributors today and tomorrow. DBIS utilizes a single UNIX server to provide database management services along with a Windows™ server to carry out XML and SQL services. What is unique about DBIS is the intranet graphical user environment, in which DBIS supports users in true windowing mode. In the intranet mode, users access the applications, much like on the Internet, with graphical capabilities and imaging capabilities. DBIS highlights include:

"Shopping cart" concept allows creation of quotations, and orders on line.

Sales desk capabilities include item substitutions, related items and large descriptions.

Search engine to identify key data elements effortlessly and fast with very little knowledge about the element.

Compatibility with intranets allows expansion into network / true graphics environments without expensive conversions.

SQL interface to query language processors allows ad-hoc inquiries and extensive sales analysis.

Upgrade from existing DBIS systems without costly data re-entry and retraining.

High level security features.

All of the above features are packed into a single, cost-effective system that offers the features that distributors require in order to survive.

Too much computerization can wrap a company up in itself. DBIS is the best example of simple sophistication. Some companies offer loads of programs in order to sell loads of software. DBIS rightsizes the requirements of the typical wholesale distributor.

Because DBIS is efficient, it requires less maintenance. It is the correct balance of hardware, operating system, database and application software to provide the required response time, without unnecessary hardware and programs. Unnecessary hardware and / or software typically causes increased wait time for users and customers waiting on the phone for assistance and / or repairs.

DBIS is simple sophistication. The system is easy to learn and understand. it takes less time to train and get up and running. It is simple to operate and maintain, yet it is sophisticated enough to meet the needs of the advanced distributor.

DBIS includes what distributors need and omits what they do not need.



Features

1. Higher Level Security
Prevents unauthorized execution of protected programs and access to databases

2. Data Locating (Searches)
Ability to find Customer, Item and Vendors' transactions faster without ID numbers
Allows new sales personnel to locate an unfamiliar item the first hour on the job
Allows simple and fast location of customer records

3. Telephone Orders
Ability to take live phone orders and allows the customer to "shop" using our electronic "Shopping Cart"

4. Expediting
Instant access via hot links to detailed information to expedite transactions

5. Pop-up Displays
Display details of inquiry via pop-up displays
Drill several levels without leaving original query

6. Desktops
Customer Desk, Item Desk and Vendor Desk
Allows instant inquiry and full investigation of all related topics to these databases

7. Transaction Desks
Order Desk, Cash Desk, PO Desk, Payables Desk and Quote Desk
Inquire and review related topics while in these desks during the transactions entry / change mode
Access / change databases, display files, inquire ledgers, substitutions, prices, etc.

8. Customer's status
Interactive detailed customer credit status inquiry for the desktops

9. Inventory Tracking
Inventory movement ledger for transaction tracking

10. Customer Pricing
Best price scenario combining matrix, sale, list and contract prices

11. Distribution Functionalities
Enhancement in efficiency calculations throughout the system such as:
On-line service levels, accurate back-order control and reporting,
Better tracking of lost sales, etc.


12. Extended Database Capabilities

A. Item Long Descriptions
One page technical item descriptions

B. Related Items
Defines related items that could be prompted / sold during the order process (increases sales)

C. Substitute Item Chain
Defines item substitutions / prompting in case of stock out situations (ring substitution scheme)
Saves sales

D. Contract Pricing
Specific item prices for a customer for a given period
Expires automatically

E. Customer / Item Cross Referencing
Cross define items and descriptions

F. Sale Price
Promotional pricing for an item for a specific period
Expires automatically

G. Matrix Pricing
26 Customer Types
100 Item Types
2600 combinations
Total of seven (7) possible prices at each combination


DBIS is composed of the following module applications:


Order Entry

Quotation System

Inventory Management

Kitting System

Accounts Receivable

Purchase Order

Accounts Payable

General Ledger

Business Intelligence

Label / Mailing System
 


These applications can be briefly summarized.



  This application allows for customer creation.
Relations are established between items and customers.
Prices and discounts established and set in matrix format.
Orders are entered, maintained and updated.
Invoices are created, maintained and updated.
Debits are issued for shipments, deliveries.
Credits are issued for returns.

  Prices are quoted for customers.
Quotations are converted to orders.

  Create new items.
Maintain inventory.
Bring in stock.
Track and maintain inventory locations.
Set and maintain item and inventory prices.

  Assemble new items from components (kit).

  Maintain customer ledger.
Transfer items and credits from OE to AR.
Take payments.
Make adjustments and discounts.
Create and update statements.
Perform billing and collections operations.
Track invoices.

  Create and maintain real purchase orders.
Create suggested purchases (bulk).
Receive goods into inventory.
Analyze sales trends by period.

  Create vendors.
Maintain vendor ledger.
Pay invoices.
Set up purchase terms.
Receive invoices from purchase orders (vendor invoice verification).

  Create Chart of accounts.
Log Cach Receipts from Accounts Receivable.
Log payments from Accounts Payable.
Maintain profit points from Order Entry.
Create Manual Ledger entries.
Maintain corporate balance sheets.

  Perform sales analysis.
Track sales declines.
Track performances.
Rank Customers,Sales Reps.,Products,Vendors, etc.
Make, maintain and update sales forecasts.

  Create, maintain and update labels.
Create marking systems.


   


DBIS e-Commerce


DBIS e-Commerce module offers users the ability to transact business over the Internet, with the aid of a secured server for protection of critical data.

The application features quick-access buttons and hyperlinks that link you directly to operations that are logically organized for the way you work

Internet users can find and view items with the facility of instant inquiry and search engine


Examples include:


View sales flier on line.
View master catalog on line.
View item by product line.
View item by catalog.
View item by manufacturer.
Search items using multiple key-word intelligent fuzzy search.

DBIS-ecom uses a database compatible to the DBIS Intranet system for fullfillment and backoffice support functions


   


Business Intelligence / Data Analytics


Business Intelligence (BI) is an umbrella term that includes the applications, infrastructure, tools, and best practices that enable management to analyze information needed to make improved/optimized decisions and maximize overall performance.

Analytics (aka Data Analytics) implies a variety of different business intelligence (BI) and application-related concepts/tools.e.g., websites; certain content areas (for example, sales, service, supply chain); etc. Increasingly, "analytics" is used to describe statistical/mathematical data analysis (pattern, time-series, clustering, graph, trending, etc.) that groups, segments, scores and predicts what scenarios are most likely to happen, in order to optimize profits or other metrics. Analytics is particularly useful in gleaning meaning from Big Data, which typically consists of vast amounts of both structured and unstructured data. It is generally the unstructured data that nowadays has most value for most organizations, in terms of optimizing competitiveness and relevance to real-time dynamics.

Dashboards are a reporting mechanism that aggregate and display metrics and key performance indicators (KPIs), enabling them to be examined at a glance by all manner of users before further exploration via additional business intelligence tools. Dashboard displays help improve decision making by revealing and communicating in-context insight into performance, displaying KPIs or other metrics using intuitive visualization, including charts, dials, gauges and "traffic lights" that indicate the progress of KPIs toward defined targets.



For example, in a Supply Chain/Wholesale Distribution environment, management can use our DBIS™ product to gain valuable insights via standard or custom reports that can easily be generated/formatted for most effective readout/presentation, trend analysis, predictions of inventory needs based on sales, and so forth:

  • Perform sales analysis.
  • Track sales declines.
  • Track performances.
  • Rank Customers,Sales Reps.,Products,Vendors, etc.
  • Make, maintain and update sales forecasts.
  • Etc.....

Such standard reports may be all that is required. Or, custom displays.dashboards.that communicate the same results visually may be better.

Scientel's GENSONIX™ NoSQL DBMS and related software tools can help perform real-time, agile, effective data mining, statistical, optimization, and forecasting functions/operations that allow enterprise leaders to manage their data better and make more competitive/higher-quality decisions! Transform your Big Data into reliable, easily-accessible, actionable Business Intelligence & Scientific Data Analysis with our Analytics capabilities!

Use GENSONIX™ to generate your own access / reportout toolbox; we can help or do this entirely for you. Links to standard data analysis / analytics packages can be implemented.

   

 
© 2013 by Scientel. All rights reserved.
Powered by GENSONIX, a product of Scientel