Distribution Management System Return to DBMS Home Page - Call Us at 318-635-0757
DBMS Home
About Us
Products
Web Site Design
Support
FAQ
news
Contact Us
Search our Site
Search the Net
Guestbook

Raining Data D3 Compliant

Call Us at
318-635-0757


Distribution Management System

Sales Orders  Sales Analysis  Inventory  Purchasing
General  SB+ Option  Print Our Brochure
Integrated Accounting Add-On 
 
 


SALES ORDERS

DBMS Sales Orders is USER FRIENDLY, completely menu-driven and can be run in full color.

DBMS Sales Orders supports the following features:


u
Multiple setup options


u
Convenient online look up windows of valid data lists defined by you such as tax areas, sales personnel, etc.


u
Complete inquiry tracking and recovery subsystem integrated with order entry


u
Pre-shipment:
Order is entered into computer, inventory is committed, pick ticket is printed

u
Post-shipment:
Shipped orders are selected, inventory is adjusted, packing slips and invoices are printed

u
Backorder file is updated if appropriate


u
Sales order information by sales order number, customer account number, or item number.


u
Update or cancel sales order information prior to shipping inventory is adjusted


u
Fill partial or full pending backorder, inventory is committed or adjusted as appropriate, pick ticket or invoice is printed as appropriate


u
Credit/Debit memos entered in same fashion as sales order. Allows making accounting entries or process returned merchandise.


u
Programs for printing pick tickets, invoices, credit/debit memos, backorder pick tickets, and backorder invoices


u
Accounts Receivable, General Ledger, and Inventory Control systems are all posted as a result of the sales order activity

Reports include:


ü
Customer order status

ü
Open orders by item - summary and detailed

ü
Aged forecast

ü
Aged backlog

ü
Orders pending approval

ü
Open backorders by customer

ü
Backorders by item number

ü
Bookings by ...
  sales orders, salesman

ü
Bookings totals summary

ü
Orders in a hold status

ü
Invoices on hold

ü
Print sales order

ü
and more ...



SALES ANALYSIS



The sales analysis capabilities of the Distribution Management System are obtained as a result of all data entry normally occuring into the system. Many reports come from the data base of posted invoice details, while others are from summary type files.

Most of the reports have multiple sort and selection criteria options and therefore ...

each report listed may in fact provide several reports.

INVENTORY SALES ANALYSIS

  • Mtd/Ytd Sales By Item
  • Sales/Cost Analysis By Item
  • Sales By Item
  • Sales Analysis by Item #
  • Sales Analysis by Item with Multiplier
  • Sales/Inventory Report by Item
  • Sales Analysis by Product Group Codes

CUSTOMER SALES ANALYSIS

  • Sales By Customer By Product Group Code
  • Sales By Customer
  • Customer Trend Analysis
  • Customer Transactions by Invoice Detail
  • Summary Sales Analysis
  • Summary Sales Analysis by Sale Type
  • Customer Sales by Geographic Area
  • Customer Ranking

INVOICE SALES ANALYSIS

  • Invoice List (Stock, Direct, Special Order)
  • Sales Invoice Summary
  • Sales Invoice Detail
  • Invoice Summary By Salesman
  • Freight Allowed Invoices
  • Daily Invoice Analysis

SALES FORCE ANALYSIS

  • Inside Salesman Sales Analysis
  • Outside Sales Rep Sales Analysis

INQUIRY ANALYSIS

  • Inquiry Tracking
  • Inquiry Tracking by Item
  • Inquiry Register by Date
  • Representative Inquiry
  • Inquiries by State by City
  • Inquiries by Customer
  • Inquiries by Salesman by Tickler Date
  • Inquiries by Select Customers
  • Inquiry Averages by Salesman
  • Inquiry by Salesman by State

MONTHLY SALES

  • Sales Recap
  • Comparative Analysis
  • Inventory Review



INVENTORY



DBMS Inventory is USER FRIENDLY, completely menu-driven and can be run in full color if desired.

DBMS Inventory supports the following features:



u
Multiple setup options


u
Convenient online lookup windows of valid data lists defined by you, such as product groups, inventory classes, etc.


u
Account lookup windows:
User may enter description (instead of item number) or part of description.

u
Keywords or multi-level groups:
Item number may be selected from cascading windows of group(s) of items which meet user definable keyword classifications.

u
Multi-Division/Multi Warehouse:
Status and reporting can consolidate and/or report warehouses individually

u
User defined inventory item numbers


u
User may choose FIFO, LIFO, Average, or Standard costing.


u
Inquiry:
Complete status, current data, and sales history for any item along with complete activity audit trail display

u
Manual inventory adjustments captures data for inventory auditing purposes


u
Multiple cross reference numbers for any part number


u
Multiple alternate item numbers for any part number


u
Maintenance of current pricing and inventory cost data


u
Complete Physical Inventory Subsystem:
allows cycle counting

u
Optional integration with General Ledger, Order Entry, accounts Receivable, Purchasing, and Receiving

Reports include:


ü
Cross reference

ü
Price list by manufacturer

ü
Inventory price list by item type

ü
Inventory ...
price/cost, stock status, activity, quantity exception, adjustments transaction register, quantity adjustments journal, purchase detail, movement, audit trail

ü
Stock status by ...
ABC code, class code

ü
Selective stock status

ü
Physical inventory

ü
and more ...



PURCHASING



DBMS Purchasing/Receiving is USER FRIENDLY, completely menu-driven and can be run in full color if desired.

DBMS Purchasing/Receiving supports the following features:



u
Multiple setup options


u
Convenient online lookup windows of valid data lists defined by you, such as ship via codes


u
Requisitions


u
Complete entry of purchase order data and updating data prior to issuing purchase order


u
Inquiry of purchasing and receiving data by purchase order number, receiver number, or item number


u
Purchase order receipts and receipt corrections


u
Maintenance of vendor database (same file as found in Accounts Payable) including multiple purchasing addresses, vendor contact notes


u
Prepares suggested purchase requirements based on forecasts and re-order rules for buyer review


u
Optional integration with Accounts Payable, Inventory Control, and General Ledger

Reports include:


ü
Active ...
  requisitions, purchase orders

ü
Closed ...
  purchase orders, purchase
  order shipments

ü
Requisition detail

ü
Purchase order detail

ü
Requisitions by vendor

ü
Purchase orders by vendor

ü
Purchase receipts detail

ü
Weekly exposure detail

ü
Delinquent receipts

ü
Two-week receipts projection

ü
Purchase receipts journal

ü
and more ...



GENERAL



DBMS Accounting and distribution software systems are among the most reliable and flexible systems available.

Utilizing true multi-user technology on standard PC computer equipment, mini-computer systems or mainframes, the distribution and accounting systems from DBMS represent real software value.

The Distribution Manager System includes the following:


u
Sales and Transfer orders


u
Inquiry tracking and capture


u
Inventory control


u
Purchasing and Receiving


u
Accounts Payable


u
Accounts Receivable


u
General Ledger


u
Sales Analysis


u
Management & setup control


u
Over 200 reports and inquiries.

The distribution and accounting systems provide a very high degree of control, flexibility and automation which translates to savings in both time and money.

All systems from DBMS support the following general features:


ü
Multi-user up to 64 users (terminals, printers, workstations etc.) on a single standard 486 PC, hundreds on larger platforms.


ü
Multiple division, branch, warehouse capability


ü
High performance database with built-in query/reporting language.


ü
Departmental control over live, daily, monthly, and yearly processing and posting.


ü
Support and customization direct from the authors.


ü
Easy to learn and use.




SB+ Option



DBMS Accounting and Distribution modules are available with an SB+ option.

What that means is, certain aspects of the system have already been converted to take advantage of SB+ while we pursue the rewrite of the balance of our modules.

MENUS: All of the modules are available wrapped in SB+ menus. Our legacy menu drivers have been replaced by SB+ menu processes.

SALES ORDERS: Our new SB+ versions of Order Entry and Inquiry Capture also include new SB+ versions of inventory lookup and customer pricing processes. Your in-house salesman can lookup inventory, capture customer inquiries, price and/or take orders with practically no use of a keyboard. This is accomplished by using a mouse and pointing and clicking on choices from cascading selection windows. This "point and click" system can be accompanied by our customer dial in version. This more customer price specific "flavor" allows your customers to place their own orders from you using their own PC, SBTerm or SBTermite, and a mouse. No typing for them either!

Last, but not least, is an entity/contact database system that allows you to merge the functions of your rolodex and sales prospect tracking functions. This module allows you to record contacts with people and organizations, including dates and discussion notes, while allowing you to easily identify those entities for use as customers or vendors.

Development continues and new processes are deployed to our SB+ clients as they become available.

  Sales Orders    Sales Analysis    Inventory    Purchasing    General    SB+ Option
Integrated Accounting Add-On   Print Our Brochure

About DBMS Search DBMS Web Site Guest Registry Contact Us For More Information or Questions Our Product Index Frequently Asked Questions Contact Us for More Information Internet Multi-Search (search/open up to 6 sites) Email Our President Return to DBMS Home Visit Our Site Designer (www.kcwd.com) Disclaimer, Privacy Policies and Terms of Use News, Tips and Upcoming Events


MultiValue

Raining Data

KEY-POS Lite
The simple, user-friendly, inexpensive way to take your first step in computerizing your store.

ViaDuct 2000
Industry-leading terminal emulation and MultiValue connectivity tool.

wIntegrate
Brings the Power of Windows and the Mac to Character Based Applications

AccuSoft

Hardware
Sales & Support
Aopen
Aopen


Worthington PDTs
 
Logic Controls - Customer Displays
 
Axel Terminal Box
 
PREH PC-POS Keyboards
 
UniTech POS Keyboards
 
Okidata
Epson
Metrologic

Tripp Lite Power Management

MMF Cash Drawers

Zebra Label Printers