Distribution Management System

The Distribution System centers around a comprehensive Inventory module which includes Order Entry, “SKU Tracking”, integrated Purchasing, Special Orders, Complex Pricing and Back Orders. Order Entry creates Picking and Packing forms and integrates to AR, GL, Purchase Analysis and Sales Analysis. Immediate Emailing of most customer and internal reports is available. Basic processing follows the Orders as they are entered into the system, Picking Lists are printed, “On Hand” quantity is updated and the actual “Shipped” order is “Invoiced”.

Distribution Management System Features

The Order Entry module automatically generates Sales Order numbers and includes lookups to Existing Sales Orders, Customers, Inventory and other minor code structures. The “Entry” function includes multiple "Ship-to"/"Bill-to" Addresses and Discount methods (Line by line, Total order and Order value discounts). Pricing methods may be set up as either Simple or Complex.

Simple Pricing supports markup from cost or discount from list based on product price groups and customer price types.

Complex Pricing supports an eight-layer price matrix which allows prices to be set by customer and product, customer and product price group, customer price type and product, customer price type and product price group, customer, product, customer price type, and finally, product price group. Each price layer supports markup from cost, discount from list and an exact price based on up to 16 quantity   breaks.

  • Costs used for price markups may be Standard, Average, Last or a user-defined non-accounting cost.
  • Drop Shipments are controlled without affecting stock available quantities.
  • Automatic audit file of adjusted prices (if override feature is activated).
  • Mailing Database update for cash customers.
  • Order Weight is calculation.
  • Backorder subsystem controlled by both product and customer.
  • Orders may be processed singularly or by batch.
  • Prints Picking Slips, Acknowledgements, Packing Slips and Quotations.
  • Lot Sum pricing of total order is available.
  • System calculates and displays order value at the regular price and at cost    if activated).
  • Allows cross over to Purchasing system for out-of-stock, non-stock inventory or “Special Orders”.
  • System Tracks all inventory by serial number.
  • A "Notes" subsystem allows for printing of standard note information on all documents including picking slips, sales orders, purchase orders and invoices. Notes may be attached to customers, products and vendors as well as system notes.
  • "Available stock" popup and multiple substitution.

The Distribution Management System Reports includes daily, weekly and monthly operational reports, listing reports and management reports. Most reports include “User Filters” to focus the report to required information. Many reports exist in multiple formats and include reports by Order#, Order Type, Items Sold and Shipping Date. Other reports include Sales Summary, Detail Sold Report, Shipping Lists, Outstanding Lists, Back Order lists, Profit Analysis Report, Exception Reports, Audit reports, GL Distribution reports, GST Report and many more. All reports may be viewed on screen and pages selectively printed. Immediate Emailing of most customer and internal reports is available.

The Distribution Management System Integrates to the Inventory Control module, the Purchasing and Receiving Module and updates Purchase Analysis, Sales Analysis, General Ledger and Accounts Receivable Modules.