Version 8 Documentation
This page contains documentation for DDMS® Version 8. On this page, you'll find:
To open, read, and print portable document files (PDF), install the Adobe Reader software. Enable the browser plug-in or add-on as needed.
What's New
New! Announcing DDMS 8.23 The ECi DDMS Version 8.22.20 maintenance release is available now for Software Download via the ECi Support Portal. In this release announcement, you'll find 20+ new features and over 70 other software changes: ECi Remote Server Backup Solution for DDMS, Level III Item Detail for A/R Postings Lowers Credit Card Processing Fees, Display Partial Credit Card Number in Order Entry, Global Return Reason Streamlines Credit Returns & Fee Calculations, Specify Preferred Vendor for any Backordered Item in Order Entry, Flag items to Ship Direct in Order Entry, Manual Short Buy, System Warning Before Deleting Orders With A/R Deposits, Set Vending Delivery Date for Picking Manifest, New SQL Report: Customer Shipto w/Tax District, Canadian Harmonized Sales Tax (HST) in Accounts Payable Invoice, Export Monthly sales data to CCH for ease in sales tax reporting, Gross Profit Refigure Option Helps Manage Margins in Customer Price Plans,Password Protect Customer Price Plans — and keep confidential data secure, Add Supplies Network PSN Advance Ship Notice, Electronic Invoicing, Deliver to National Accounts for TriMega Point Nationwide, West Point Products offers PSN (Private Supply Network), Allsteel and HNI (HON, Gunlocke and Paoli) Dealers Specify Multiple Ship To IDs per Bill To ID, HNI & Allsteel Dealers Specify Deliver On/By Date with Ship Condition field, View Meter Readings in Call Detail tab of Last Ten Calls, Search for known calls in Machine Monitor Calls or Schedule tabs' Call Number, Improved Machine Work Orders Cursor Flow from Call Code to Text, System Warning Before Deleting Contracts With Machines.
Announcing DDMS 8.22.20 In this release announcement, you'll find features like Nine New SQL Limit Fields for Sales Tax Reporting By Address, Canadian Harmonized Sales Tax Added to Payables for July 1, and more than 20 other improvements to the usability of DDMS sales tax calculations, EDI communications, machine dealer BEI exports, and software upgrades.
Announcing DDMS 8.22 In this release announcement, you'll find features like graphical Delivery Manifest, SQL Sales Tax Per Customer Address, password-protecting A/R (Customer) Deposits in Order Entry, expanding (L4) Federal Withholding Tiers, Order Notes for Furniture Manufacturer Options, Searching Multiple Staging Bins, using 3rd Party Bill's Taxable setting to determine tax, Call Monitor Print Preview, Work Orders Caption Bar and Last 10 Calls, streamlined BEI Export installation, and more.
Announcing DDMS 8.21.60 In this release announcement, you'll find a short list of software changes.
Announcing DDMS 8.21.40In this release announcement, you'll find enhancements accommodate new requirements for new VISA Level 3 Government/Corporate Purchasing Card Requirements via Approval Link™, and for new HON® furniture ordering system logins via the ECi PSN (Private Supply Network).
Announcing DDMS 8.21 In this release, you'll find Windows 7 Pro compliant client workstation installation, enhanced sync between text-based and SQL period-end reports, location-specific sales tax improvements (formerly called CCH Taxing), furniture project management user security templates, machine Work Order Warranty Detail, ServiceTrak for Windows laptops, and over a hundred other high-priority improvements to the usability and flow of your DDMS business system software.
Announcing DDMS 8.20.40 In this release announcement, you'll find a short list of software changes.
Announcing DDMS 8.20.20 In this release announcement, you'll find a short list of software changes, including corrections Furniture Order Entry Change Mode and SQL synchronization.
Announcing DDMS 8.20.0 In this release announcement, you'll find a new Protect Date Limit on Customer Price Plans, an Option to Stop Updating Cost on United Stationers Pre-Receive, Contract Renewal in Graphical Serialized Order Entry, significant usability corrections to Bank Reconciliation. This release also includes dozens of improvements to the usability and flow of the installation program, EBS imports, CCH Taxing, order entry credits, short-buy and low-stock purchase orders, P/O Vendor Listings, P/O Receiving, AutoComm II, third party billing, SQL A/R Trial Balance, graphical order entry, quotes, Knoll PSN, HMI Communications, HNI communications, Job Costing Analysis, delivery tickets, graphical serialized work orders, accessories management, order entry, toner yield analysis, call monitor, machine detail, and more.
Announcing DDMS 8.19.60 In this release announcement, you'll find a short list of software changes, including a correction to an installation issue that caused SQL timeouts, mentioned in release notes for 8.19.40.
Announcing DDMS 8.19.40 In this release announcement, you'll find a short list of software changes to help your business be more efficient, whether you sell supplies, furniture, or equipment.
Announcing Version 8.19.20 In this release, you'll find that selected reports in SQL Report Preview have been updated to display Promotions data on orders where your ECinteractive or is.D-Force 2 customers have entered your coupon codes at Checkout.
Announcing Version 8.19.0 In the ECi DDMS Version 8.19.0 major release, you'll find the Executive Dashboard Monitors Your Cash Flow in Real Time, New SQL Reports for Accounts Receivable (A/R) Require EBS Import, Promotions Window Sets Up Coupon Codes for ECinteractive® Orders, and Seven New Furniture Reports Converted to SQL.
Announcing Version 8.18.60 The ECi DDMS Version 8.18.40 major release included enhancements to Installation Streamlining, Modify Tax Settings for Entire Orders, Removing Additional Salesperson, Replaced Microsoft SQL Linked Server in EBS SQL applications, Jan San Item Additional Info for Hazard Document Updates, Meeting New Furniture End Customer Data Requirement, Transmit Furniture Orders via PSN to HON, Gunlocke, and Paoli (HNI Companies), Furniture Order Entry Efficiency, Machine Covered Items Exclusions, BEI Data Transfer, and Recap Start Times and Dates.
Announcing Version 8.16.2 The ECi DDMS Version 8.16 major release included the EBS SQL Import Control Panel, Modern EBS SQL Project Management, and ServiceTrak™ 2.0 for Windows™ Mobile 6.
Version 8.16.2 Readme (pdf) Before installing DDMS 8.16.2, please read this flyer. Included with your software update CD, it highlights important steps you must take before loading this software update, as well as tasks to perform in order to use the new EBS SQL features.
Announcing DDMS 8.15.9 The ECi DDMS 8.15.9 maintenance release addresses a small number of design changes and software issues. Requires 8.13.0 - 8.14.46 be installed first; see Release Notes.
Announcing DDMS 8.15 The ECi DDMS Version 8.15.20 major release is available now at your request. This release Re-Branded DDMS as ECi DDMS, and includes the Modern Installation Wizard, Windows Vista Client Compatibility, Upgrade to SQL 2005 Express, Modern SQL Report Preview, Sorting of Purchase Order Postings, CCH Taxing Service, Customer Price Plans enhancements, United Stationers/Azerty Credits and Additional Charges via PSN, United Stationers Substitutions, LaGasse Jan/San PSN Services, Exceptions from Furniture Manufacturer Acknowledgements, Exclusion of Tags from SIF Import, Machine Toner Yield Enhancements, and Customer Machines Service Times enhancements. Requires 8.13.0 - 8.14.46 be installed first; see Release Notes.
Announcing ECi DDMS 8.14.46 The ECi DDMS 8.14.46 maintenance release addresses a small number of design changes and software issues.
Announcing ECi DDMS 8.14.43 The ECi DDMS 8.14.43 maintenance release addresses a small number of design changes and software issues.
Announcing ECi DDMS 8.14.41 The ECi DDMS 8.14.41 maintenance release addresses a number of design changes, minor enhancements, and software issues.
Announcing DDMS 8.14 The DDMS® 8.14 software update is available on request as of Monday, Feb. 11, 2008. In this major release, you'll find a number of improvements in several areas, including four new features: Furniture Tags (pdf), Quote Release, Warehouse and Manifest Notes, and Machine Billing Exceptions.
What's New in DDMS 8.13.44 The DDMS® 8.12.44 maintenance release addresses a number of design changes, minor enhancements, and software issues.
What's New in DDMS 8.13.40 The DDMS® 8.12.40 maintenance release addresses a number of design changes, minor enhancements, and software issues.
Announcing DDMS 8.13 The DDMS® 8.13 software update is available on request as of Friday, Nov. 16, 2007. In this major release, you'll find useful new features in general ledger, SQL sales reports, customer price plans, purchase order entry, order entry, and accounts payable.
What's New in DDMS 8.12.50 The DDMS® 8.12.50 maintenance release addresses a number of design changes, minor enhancements, and software issues.
What's New in DDMS 8.12.40 The DDMS® 8.12.40 maintenance release addresses a number of design changes, minor enhancements, and software issues.
What's New in DDMS 8.12.32 The DDMS® 8.12.32 maintenance release addresses a number of design changes, minor enhancements, and software issues.
What's New in DDMS 8.12.30 The DDMS® 8.12.30 maintenance release addresses 105 dealer-recommended design changes, minor enhancements, and software issues.
ECi Releases DDMS 8.12 AutoComm™ II and Approval Link™ 4.0 for NET1, S.P. Richards PSN Invoice & Advance Shipping Notice Data Handling, PPI and O Henry Electronic Invoicing Via PSN, Furniture Calculated Load Factor, Prorated Deposits, Haworth and Knoll P/Os via PSN, Machine BEI Export, and ServiceTrak™. Also highlights of previous maintenance releases: Streamlined EnsiteEBS, ECinteractive® Gateway, Furniture Order Modifications, Machine Graphical Development
ECi Releases DDMS 8.11 Customer Price Plans, Price Modeling, Kimball® and National™ P/Os via PSN, Machine Meter Enhancements, SQL Reporting of Sales Data
Version 8.11 EnsiteEBS Conversion Only Required for New SQL Applications ECi released DDMS® Version 8.11, Tuesday, Nov. 21, 2006, and began shipping in waves to customers who requested the software update. This message is from your ECi Technical Support team, to provide guidance as you implement groundbreaking new features.
ECi Ships DDMS® General Release Version 8.10 Bank Statement Reconciliation, Approval Link™ 3.0 for VeriSign™ Payflo Pro®, Pay Multiple Vendors on One Check in A/P, New Warehouse Bin Designations, Enhanced Furniture Order Entry Change Mode, Work in Progress, Job Costing, Bill by Estimated Copy Counts, Machine Disposition, Demo Picker.
Updated! What's New in Version 8 (pdf) A brief description of each new feature we have added to DDMS software.
Installing Version 8 DDMS (pdf) This document explains how to install Version 8, including information about the new EBS SQL Import Control Panel, as well as file conversion and journal parameter setup. It also includes important information about sharing a new folder on the server before installing the client software update. It also notes how to adjust your backup scripts to properly back up new SQL database files.
Feature-Specific Documentation
New! Setting Up and Receiving Invoices: Supplies Network (pdf) How to set up electronic invoicing with Supplies Network, and how to receive and process these invoices via PSN. To complete the process, see Posting Electronic Invoices (pdf).
Setting Up and Using the Supplies Network PSN (pdf) Set up appropriate parameters to transmit purchase orders, check stock availability and pricing, request acknowledgements, and receive carton counts, carton IDs, and carrier tracking IDs via the PSN with Supplies Network, a DMI company.
New! Processing Advanced Shipping Notice (ASN): Supplies Network (pdf) It's now easier than ever to process S.P. Richards short ships, carton counts and tracking information via PSN. When you receive the new Advance Shipping Notice data from SPR via PSN, DDMS can process short ships, carton counts, carton IDs, and carrier tracking IDs. The system automatically adjusts the quantities and special lines in your orders and your purchase order. You can use Report Writer to add the vendor carton counts to your printed shipping manifest. It allows more proactive handling of shorted orders, and simplifies package tracking.
New! TriMega Point Nationwide (pdf) TriMega Purchasing Association (www.trimega.org) launched a new company called Point Nationwide to fulfill orders from national accounts, where local member dealers in each region make the deliveries. If you participate in this TPA program, you can receive electronic purchase orders from Point Nationwide, and return Advanced Shipping Notices to communicate delivered lines, and how they were fulfilled, whether from stock or purchase order. Point Nationwide handles tax and billing, and pays dealers on collection.
New! Setting Up & Using West Point Products PSN (pdf) Now DDMS and OMD dealers can request stock/price checks, transmit purchase orders, and receive purchase order acknowledgements via the ECi Private Supply Network (PSN) with West Point Products (www.westpointproducts.com), an STMC certified manufacturer or premium replacement laser toner cartridges and provider of related imaging supplies and services.
New! Setting Up Your ECi Remote Backup Solution (pdf) Any dealer can take advantage of ECi Remote Backup for disaster recovery and peace of mind. However, this Web-based service is critical for those whose business system runs on Windows 2008 Server, since that operating system no longer supports tape backup solutions. Learn how to implement ECi Remote Backup's client software on your DDMS server with assistance from your ECi support team. You'll be able to log in to the remote Web service to view backup logs and restore files as needed. Rest assured that the ECi Remote Backup Solution retains your files in a secure location, daily files for 30 days, monthly for 18 months, and yearly may be retained for 7 years, depending on your subscription.
New! Setting Up PlanetPress Suite (pdf) ECi's partnership with Objectif Lune lets us offer you the variable data printing solution PlanetPress Suite. Documents created with PlanetPress Suite can be printed, archived, emailed and/or faxed as part of a sophisticated output management application driven by PlanetPress Watch or
PlanetPress Server. PlanetPress Suite enables easy creation and printing of transactional variable content documents in house, eliminating the need for preprinted forms. These in house documents can be produced using any printer so there is no need to dedicate a printer just for forms. ECi offers customization of several forms including invoices, statements, delivery tickets, and purchase orders. All documents can be generated from the same data file used to create an invoice, so information is entered only once. Since documents can be created in house, PlanetPress provides significant savings on printing costs and also provides greater work process efficiency. Learn how to configure DDMS with PlantPress report formats, printers and Dayend process, and begin to use the intuitive PlanetPress Design application in conjunction with DDMS text files.
New! Special Order with S.P. Richards ProductPro™ and FurnitureAdvantage™ Programs (pdf) Traditionally, office products wholesalers have offered only in-stock items to meet the need of speedy delivery. But the market demands more custom items, even those with longer delivery timeframes. S.P. Richards dealers can offer customers a more extensive variety of special-order products, with the ProductPro™ and FurnitureAdvantage™ programs. S.P. Richards releases these special order item price files monthly, for download via O/PUS PSNControl on the first Monday of the month. Learn how to update your DDMS inventory database and contracts, and use special order features. See how easily your ECinteractive and is.D-Force 2 shoppers can identify how long special order merchandise will take to ship. Certain items will be flagged as non-returnable, whether they are stocked foodstuffs or special-order custom work.
New! Setting Up Address Taxability (pdf) Sales tax rates vary not only from state to state, or city to city, but even within a zip code or city limits. The challenge is to keep up with local sales tax district rates for your nationwide customers' many remote locations. By default in DDMS, if you needed to change a tax rate, you had to create dozens of new tax districts and mass change your customers just to ensure your history would retain the original tax amount while new tickets reflect the new rates. Switching to the Address Taxability module allows you to more easily update tax tables on a regular basis. You can set up each tax authority (state, county, city, zip+4) with its own easy-to-maintain rate. You can set up individual items to be taxed correctly where they are only taxable in a specific jurisdiction. Item taxability is no longer tied to the general ledger department or item SIC code — eliminating double-use of these fields, and freeing you to use item departments and SIC codes for other purposes.
If you wish to use the SQL tables to maintain Address Taxability, it will require authorization with no additional charge from ECi DDMS Support. If you wish to automatically populate address-specific tax tables using CCH Tax Import subscription — instead of creating your own — please contact ECi Sales.
Using CCH Taxing with Your DDMS System (pdf) In DDMS 8.15 and higher, you can take advantage of the CCH Taxing feature, and use just the right tax rate according to your customer's tax jurisdiction. The CCH Taxing Service provides you greater flexibility of maintaining tax information for customers nationwide — without having to do the state-by-state research yourself. You can subscribe to services from CCH Group (cchgroup.com), to update your DDMS Server's tax tables on a periodic or monthly basis. The CCH Taxing feature allows you to set up individual items so that they can be taxed correctly by category, within each tax jurisdiction.
New! Delivery Manifests (pdf) The new graphical Delivery Manifest application is designed to help you streamline the delivery manifest. In line with our other EBS SQL products, including Price Modeling, Price Plans, SQL Report Preview, and Executive Dashboard, the Delivery Manifest application replaces a text-based screen with a graphical interface that has added functionality. The Delivery Manifest application replaces the text-based (TS) Shipping Manifest screen. The on-screen display is very flexible, allowing you to choose the display order of tables and determine what displays in each table. Using the Delivery Manifest applicaiton, you can scan tickets, add tickets based on limit criteria, or use manual entry. You can create a new manifest or append to an existing manifest.
Updated! Setting (L4) Federal Payroll Tables for 2010 (file: payFedTax10.pdf) The IRS has published its payroll tax withholding tables, from IRS Publication 15 (Revised Dec. 17, 2009), “Circular E, Employer's Tax Guide (Including 2010 Wage Withholding and Advance Earned Income Credit Payment Tables).” DDMS 8.22 enhanced the (L4) Tax Tables with another tier to reflect withholding for single employees who gross more than $375,700 in 2010, or married employees who gross more than $381,400 in 2010. If you have employees who meet this threhold, please update your (L4) parameters and reverse the temporary workaround according to the updated instructions. (When you perform your year-end procedures, you must update your (L4) Federal Payroll Tables screen to reflect annual tax changes according to the same instructions. The time to do so is after you have closed 2009 payroll and printed all 2009 payroll reports and W-2 forms, but before you run your first payroll of 2010.)
New! Setting Up & Using RouteTrak™ for Windows® Mobile (pdf) RouteTrak’s Digital Signature Handheld software can be installed on a Windows Mobile unit. Drivers can identify errors, shortages and overages at the point of delivery. RouteTrak synchronizes with your shipping manifests and your customer order data, so drivers no longer need to file multipart forms. Learn how to automate your delivery process and verify receipt, eliminating missed and misrouted shipments and the resulting billing disputes.
Using Promotions and Coupon Codes in DDMS (pdf) The Promotion window in DDMS 8.19 and higher lets you combine three different types of Order Requirements with six different kinds of Benefits for 18 different coupon or promotion combinations, along with a number of other thoughtful options that give you tremendous flexibility in designing coupons. You can launch the Promotions window from the Databases menu of the DDMS Master Menu. You can also use Promotion Error Message parameters to customize the error messages that appear to customers at Checkout. Promotion and Coupon codes are integrated for use with your ECinteractive and is.D-Force2® Web storefront. Note: You must set up the Discount Item(s) with a taxable G/L dept, and you must enable Split to a Separate Line Partial Backorders Y/N ?Y in the (LGØ) Order Entry Parameters screen.
Executive Dashboard (pdf) ECi DDMS now extends modern SQL and spreadsheet-like graphing capabilities to a high-level overview of your business — the new Executive Dashboard. You can easily monitor your company’s cash flow, and manage the display of (and access to) the data. The Executive Dashboard allows you to view and monitor the totals for your business. These totals are based on fiscal year totals, previously presented in the text-based (PD) President's Screens. However, the Dashboard includes a complete visual breakdown of all accounts receivable, accounts payable, bank totals, and sales totals. While the Sales tab pulls from the previous Day-End's closed business, all other tabs (Accounts Receivable, Accounts Payable, and Bank) pull data in real time. For a different way of looking at your business, you can add new panels and screens, adjust screen layout or columns, and customize the graph type. With user groups and user security, you can grant executives and salespeople access to read-only views of data essential to their aspect of your business.
Setting Up & Using SQL Preview Reports for DDMS (pdf) Including more reports for furniture dealers and accounts receivable, the new Preview Reports function in the Report Menu combines the current capabilities of the existing sales database report screens in DDMS with the new functionality of the SQL EBS database. It is designed to allow both new and experienced users to easily view and print SQL reports. It also allows users to make minor report changes on the fly that could previously only be made in more complex report designer applications. Information is displayed in an Excel-style grid with columns that can be fully customized using sorts and limits.
SQL Reporting Field Definitions (pdf) In DDMS 8.13 and higher, standard SQL reports print from their respective SQL tables. For example, the sales reports print from the current SQL SalesOrderJournal table and related supplemental files. This handout provides definitions for the fields in these new reports. In this handout, we provide field definitions for the sales reports and customer reports. For each of these reports, we provide a summary of the report, an example of the report, and field definitions. This document serves as a handy reference for experienced SQL query writers to use when using C1 Report Designer to compose SQL statements, design custom reports, and save them for other users to access from DDMS' SQL Report Preview application.
Using the EBS SQL Import Control Panel (pdf) Before you can use EBS SQL applications including Customer Price Plans, Price Modeling, Report Preview, Furniture Project Management and so on, your DDMS data must be initially validated, corrected as needed, and imported into the SQL database. After this initial processing, your data will be automatically synchronized thereafter. Use the EBS SQL Import Control Panel to confirm SQL connectivity to the server, ensure your data is valid before attempting to import it, and then import the data required to use the new applications.
Setting Up and Using Image Star PSN (pdf) Learn how to set up appropriate parameters, database records, and default settings to transmit purchase orders, check stock availability and pricing, and request acknowledgements via the PSN with Image Star. Notes: Requires DDMS Version 8.18 or higher. Image Star is an O/PUS supplemental vendor; to load Image Star items and pricing, ssee O/PUS Item Update Instructions for Image Star (pdf).
Setting Up and Using the Avery PSN, Custom Binder Microsite (pdf) Want to set up the Avery Signature Series Microsite for Avery Custom Binders? In this document, you'll learn how to set up appropriate accounts and parameters to transmit purchase orders to Avery (in DDMS 8.18 and higher). You'll also learn how to use the O/PUS FileMapper to load Avery item files into your DDMS inventory database. You'll also learn how to use the Dealer Station or is.D-Force Admin Control panel to activate the microsite for your Web storefront customers and to customize the microsite link text that appears on your storefront site. This document also includes the steps your Dealer Station or is.D-Force end customers will use to order from the Avery Signature Series Microsite.
Setting Up and Using HNI (HON, Gunlocke, Paoli) PSN (pdf) Learn how to set up appropriate parameters, database records, and default settings for communicating electronically with HNI Companies, Inc. You can import SIFs into the DDMS Order Entry window and automatically build purchase orders to upload into each of HNI's Websites, where you can view orders and item details, while keeping track of all your furniture sales in the DDMS order and accounting flow.
EBS SQL Furniture Project Management (pdf) Understand how to apply the power of DDMS's EBS SQL interface to ramp up project management efficiency. The Project Management feature is designed so that anyone in your company can quickly find and report on important information about any part of a project. For example, you can quickly view item delivery dates, acknowledgment information, order status, and items that have been added to an order. Project Management tasks display in an easy to use panel, with all the new functionality of the EBS SQL database. The hierarchy of views now falls into project, sales order, order summary (purchase order), and item levels. You now have unparalleled flexibility when limiting, filtering, summarizing, sorting, customizing, and updating your project data. You can even restrict salespersons to viewing only their customers’ project data. You can easily customize the display of columns and header information when you’re ready to save a report, or export to a spreadsheet or PDF file.
WARNING: Before you can begin using this EBS SQL Project Management tool, you must import your data through the new EBS SQL Import Control Panel. You must import your file information and then set a schedule for synchronizing on a regular basis to feed your project reports. For detailed instructions, see Using the EBS SQL Import Panel (pdf).
ServiceTrak™ Mobile Dispatching (pdf) As the mobile dispatching solution for DDMS, ServiceTrak™ gives technicians real-time access to service call and customer information while in the field. It also reduces paperwork and eliminates redundant data entry tasks, increasing overall service department efficiency. Not only that, but it features an updated interface that allows for stylus-free one-hand operation using softkey menus and device navigation buttons. Runs on any touchscreen device using Windows Mobile Professional 6 (or PocketPC 5).
Phase III: Setting Up and Using Furniture Acknowledgments via PSN (pdf) Once you have completed the steps in the Phase II handout for your individual furniture vendor, you can set up the acknowledgment program. The Furniture Acknowledgments function gives you the ability to default to a specific printer for acknowledgments by user or by vendor. It also gives you the option to update the cost on the purchase order and ticket automatically, allows you to print only exceptions on the acknowledgment report or print all items, and allows you to reprint the acknowledgment without requesting it again from the vendor. Learn how to set up the appropriate Global, Vendor, and User parameters.
Setting Up and Using the AOPD PSN for DDMS Contracting Dealers (pdf) You can use Private Supply Network (PSN) to communicate with American Office Products Distributors, Inc., the nation’s largest network distributor of office supplies. You may act as a contracting dealer. For example, at times you may be able to place and process a customer’s order but can’t deliver it. As a contracting dealer, you could have a servicing dealer deliver the customer’s order on your behalf. You would have direct contact with the customer, so the servicing dealer would rely on you for order information, billing, and so on. In this document, learn how to set up the identifiers and passwords to begin using AOPD PSN as a Contracting Dealer.
Setting Up and Using the AOPD PSN for DDMS Servicing Dealers (pdf) You can use Private Supply Network (PSN) to communicate with American Office Products Distributors, Inc., the nation’s largest network distributor of office supplies. You may act as a servicing dealer for another contracting dealer, delivering the order to the customer’s site. If so, learn how to set up the identifiers and passwords to begin using AOPD PSN as a Servicing Dealer.
11 Tips on Validating DBF Data With EBS SQL Import Control Panel (pdf) DBF data validation is the most important step in implementing the new SQL applications such as Customer Price Plans and Price Modeling. The new Microsoft SQL architecture has very rigid rules for database fields (or data types). By comparison, DDMS’s DBF flat-file database structure has been much more lenient. Before importing, you must make adjustments as needed to address validation exceptions, and test validation again until no more exceptions are found. Your ECi Technical Support teams offer several tech tips to help with this process.
Troubleshooting EBS SQL Validation Errors (pdf) In the EBS SQL Import Panel, the Validate DBF Data tool checks each record in the files you mark to import. If data is missing or invalid, you will see a specific error. Common errors include: Split Volumes, File Not Found, File Not Compressed, Duplicate Key, Invalid Date, Invalid Number, and no purchasing vendor. Sometimes the software can logically make up for invalid data. Sometimes it’s actually OK to import a blank record. In many cases, however, it means manually correcting or deleting specific records. See this document for details on how to read the Validation error log, how to address each error, and a table that describes the best application to view and change individual records per file.
Advanced SQL Reporting Guide (pdf) If you are familiar with SQL databases and queries, you can use C1 Report Designer to create custom reports that you can view and edit in the DDMS Preview Reports application. While ECi does not support C1 Report Designer, this document presents helpful rules and definitions that should be useful in designing reports that are compatible with the Preview Reports function.
Toner Yield (pdf) Toner Yield is a new analysis tool in DDMS that enables you to track toner cartridge performance and compare it to the manufacturer’s claimed yield—invaluable information when renewing service contracts. Customer service reps can also use this feature to see how much toner has been shipped for a particular machine.
Using Tags (pdf) Recently, the Office Furniture industry standardized its system of tagging items. In compliance with these industry standards, Version 8.14 and higher of DDMS Office Furniture Edition imports, stores, modifies, displays, communicates and reports on these new tag fields. If you use a specifier program, such as 20-20 Worksheet or Project-Spec, you can export* the standard five tag types into a SIF file that can then be imported into DDMS Furniture Order Entry. The tags appear in the Item Detail tab’s Description column as yellow text. You can access the tag information during Order, Change, Initial Verify, Final verify, and Delete modes, O/E History, Quote Release, P/O Entry, P/O History, and Report Writer. You can use tags when assigning Print Groups. New formats have also been created so you can print the new tag information. Tag detail can also be printed in Report Writer. This document includes examples and detailed instructions.
Closing G/L Periods (pdf) For many dealers, the G/L Posting window's new Close G/L Period menu option (and the logic behind it) represents a welcome change to the period-end flow for General Ledger. Before DDMS 8.13, only periods 12 and 13 were open to posting after closing G/L for the year. With version 8.13, it's easier than ever to close general ledger on the final day of the fiscal year. Although you can't release a batch to a closed business period, you can reopen it, release postings to it as needed, even adding new G/L accounts as needed, and close it again. You can set passwords for this new function in the new graphical General Ledger Close Period Passwords Parameters.
Note: After installing version 8.13, all of your previous year’s business periods will be open to posting. If, however, you wish to resume the previous G/L flow, take these steps: First, set your passwords in the General Ledger Close Period Passwords Parameters boxes. Then, go to the new Close G/L Period dialog box and close the period. This will limit prior-year postings to periods 12 and 13, just as before.
Third Party Carrier (3PC™) Manifests (pdf) 3PC™ is the interface between your shipping manifest program and a third party shipping service, designed to help you streamline your shipping and billing processes, and better track your customers’ packages. You can charge the customer for freight charges. You can determine the method by which to ship the order: overnight, ground, and so forth. You can set separate default shipping methods and freight settings for each customer in the Customer window. Using pick ticket information exported from your (TS) Shipping Manifest or your (TR) Order Entry Reports, 3PC automatically determines the package’s weight, the method by which to ship the package, insurance information, and freight charges. It also also automatically prints your shipping labels. When you then import third party carrier data back into DDMS, the 3PC software attaches delivery information to the invoice, and it can be viewed in Order Entry.
Sending Data to Business Equipment Information (BEI) Services (pdf) Version 8.12 of DDMS Machines & Equipment edition features a new application that extracts dealers’ serialized information to create reports of your machine service and performance data to BEI Services (www.beiservices.com). The information allows dealers to compare their performance with other dealers of the same type, geographic location, or other criteria. In addition, the generated report is used by BEI to determine rewards in their Intense Tech compensation program.
Calculated Load Factor (pdf) Version 8.12 of DDMS Office Furniture Edition introduces a simplified way to reflect your costs on a furniture order, as an alternative to detailed job costing. You can use your experience and benchmarks to assign different cost load percentages globally, to a customer, and/or to a vendor. When you end an order, and respond as needed to the prompt for additional charges, each line item’s load factor is calculated. The load factor may be multiplied by the line item’s list price, sell price, "a" cost or "p" cost, depending on how you set the standard load factor parameter. The results for each line item are added together to produce a total blended cost, which is automatically charged against commission. You can choose whether the load factor is printed on the invoices.
Setting Up and Using Credit Cards and Approval Link 4.0 (pdf) Released with DDMS 8.12, Approval Link™ 4.0 is the interface between your DDMS system and Verus/Net1 Payment Solutions automated authorization and capture software. Learn how to set up and use Approval Link™ software to process credit card transactions with Verus/Net1.
Installing AutoComm II (pdf) Learn how to set up the revamped fax/email server software for DDMS that eliminates the need for third-party software. AutoComm II introduces a new graphical wizard-like interface that simplifies setup of DDMS server information, backgrounds and attachments, fax settings, and email settings. The Autocomm II service runs in the background while its workstation is on, so there’s no need to launch it manually or even log in for the system to process emails and faxes.
Using AutoComm II (pdf) Learn how to send faxes and emails from both graphical and text-based applications using the AutoComm™ II fax/email server software for DDMS®. This document includes instructions on sending invoices from Order Entry, purchase orders from P/O Entry, and customer statements from Accounts Receivable. It also includes instructions for monitoring faxes and emails, and sending mass or batch messages.
Setting Up and Using Credit Cards and Approval Link 3.0 (pdf) Approval Link™ 3.0 is the interface between your DDMS system and VeriSign™ Payflo Pro® automated authorization and capture software. Learn how to set up and use Approval Link™ software to process credit card transactions with VeriSign.
Customer Price Plans (pdf) The contracts application (ET screen) has been completely redesigned using the latest technology available. With a new smart-client architecture and incorporating the .NET programming framework, the Customer Price Plan makes it easier than ever to create, configure and analyze your customer contracts in ways never before possible.
Price Modeling (pdf) Like its predecessor (SG) [J], you can use the new Price Modeling application to measure the profitability of past sales as compared to initial pricing. But now you have amazing spreadsheet ability for modeling pricing and profitability. Using actual sales statistics, you can create new pricing models and directly compare the results against initial and historical pricing models. You can apply numerous filters to past sales journals, contracts, and inventory files to target a very specific item or customer sales history. Flexible on-screen display lets you choose fields and types of totals to display. Once a satisfactory price model is created, the on-screen end results can be saved as a new contract or exported to an Excel® file.
Machine Meter Enhancements (pdf) To assist machine dealers with tracking performance data for the life of each serialized machine, some critical meter-related data has been shifted from the Customer Contracts Meter tab to the Machine Detail Meters tab. It's important to be consistent when setting up multiple meters per machine, setting one to track black copies and one to track color copies. Learn how to properly set up machine meters, convert existing meters if necessary, and set up the department break-out for meters in your Contract Types Department Tab. The system now prompts for meter readings and dates when you create a new machine record or sell a machine in Serialized Order Entry.
Exporting HP Data (pdf) HP PurchasEdge participating dealers can use the HPUSAGE program to track HP product information. This program creates an output file that contains customer contact information as well as total sales dollars for HP products. By exporting the data to a file, you can target those customers who purchase less than a specified sales amount. After the data is exported, you can forward the file to HP, who in turn, can assist you with marketing campaigns targeted to increase HP product sales to the customer.
HP PurchasEdgeIntegration (pdf) Learn how to integrate your Web storefront with PurchasEdge to help build stronger end-user relationships and drive supply sales by rewarding your end-users with free Hewlett-Packard products. See also the sign-up form on ECiSolutions.com, Register as an HP PurchasEdge Reseller.
Setting Up and Using the Global Industries PSN (pdf) Learn how to set up appropriate parameters, database records, and default settings for communicating electronically with Global Industries. You can import SIFs into the DDMS Order Entry window. When building a Global purchase order, you have the option to assign a vendor contract; you can also opt to exclude a P/O from being transmitted. When you are ready, you can transmit P/Os and receive acknowledgements in the Purchase Order Entry window.
Setting Up and Using the Haworth PSN (pdf) Learn how to set up your Haworth vendor record, furniture contracts, and purchase order communications defaults. Then you can import SIFs and automatically create P/Os that you can upload electronically into Haworth's order management system.
Setting Up and Using the Kimball PSN for DDMS (pdf) Learn how to set up your Kimball vendor record, furniture contracts with Kimball CDA numbers, and purchase order communications defaults. Then you can import SIFs, automatically build P/Os, transmit electronically to Kimball's order management system, and receive Kimball's P/O acknowledgements.
Setting Up and Using the Lagasse PSN (pdf) Set up appropriate parameters transmit purchase orders and request acknowledgements via the PSN with Lagasse Bros., Inc.
Setting Up and Using the National PSN for DDMS (pdf) Learn how to set up your National vendor record, furniture contracts with National CDA numbers, and purchase order communications defaults. Then you can import SIFs, automatically build P/Os, transmit electronically to National's order management system, and receive National's P/O acknowledgements.
Setting Up and Using the Pens Plus, Inc. PSN (pdf) Set up appropriate parameters to transmit purchase orders, check stock availability and pricing, and request acknowledgements via the PSN with Pens Plus, Inc. (PPI).
Setting Up and Using the TriMega PSN for DDMS (pdf) Set up appropriate parameters to transmit purchase orders and request acknowledgements via the PSN with TriMega on your DDMS system.
Setting Up and Receiving Invoices: S.P. Richards How to set up electronic invoicing with S.P. Richards, and how to receive and process these invoices via PSN. To complete the process, see Posting Electronic Invoices
Processing Credits and Freight Charges: S.P. Richards (pdf) It's now easier than ever to process S.P. Richards credits and freight charges. When you receive electronic invoices via PSN, DDMS can automatically post vendor credits to Accounts Payable, and post Freight charges to customer pick tickets in Order Entry. It eliminates several labor-intensive steps.
Processing Advanced Shipping Notice (ASN): S.P. Richards (pdf) It's now easier than ever to process S.P. Richards short ships, carton counts and tracking information via PSN. When you receive the new Advance Shipping Notice data from SPR via PSN, DDMS can process short ships, carton counts, carton IDs, and carrier tracking IDs. The system automatically adjusts the quantities and special lines in your orders and your purchase order. You can use Report Writer to add the vendor carton counts to your printed shipping manifest. It eliminates several labor-intensive steps.
Setting Up and Receiving Invoices: TriMega Purchasing Assn. How to set up electronic invoicing with TriMega Purchasing Association (TPA), and how to receive and process these invoices via PSN. To complete the process, see Posting Electronic Invoices
Setting Up and Receiving Invoices: United How to set up electronic invoicing with United, and how to receive and process these invoices via PSN. To complete the process, see Posting Electronic Invoices
Processing Credits and Freight Charges: United Stationers (pdf) It's now easier than ever to process S.P. Richards credits and freight charges. When you receive electronic invoices via PSN, DDMS can automatically post vendor credits to Accounts Payable, and post Freight charges to customer pick tickets in Order Entry. It eliminates several labor-intensive steps.
Processing Advanced Shipping Notice (ASN): United Stationers (pdf) It's now easier than ever to process United Stationers short ships, carton counts and tracking information via PSN. When you receive the new Advance Shipping Notice data from United via PSN, DDMS can process short ships, carton counts, carton IDs, and carrier tracking IDs. The system automatically adjusts the quantities and special lines in your orders and your purchase order. You can use Report Writer to add the vendor carton counts to your printed shipping manifest. It allows more proactive handling of shorted orders, and simplifies package tracking.
New! Setting Up and Using United Substitutions (pdf) United's substitution program works with the PSN service to allow dealers to have substitution lists assigned to their accounts in the United system. Dealers can select to use a custom substitution list or use the generic list that United provides. The list allows dealers to control what items are subbed when transmitted and which items are subbed for them. Since United assigns this list to the dealer's individual united account numbers, this feature works with National Drop Ship (NDS) accounts and any of the dealer's standard delivery accounts.
Machine Disposition Setup (pdf) You can assign dispositions to machines beginning in Version 8. A machine disposition shows the overall status of the machine, whether it’s on hand, rented, leased, sold, and so forth. The disposition is adjusted based on the changes to the status of the machine equipment. If you plan to use the new disposition feature, you must perform the steps described in this document after loading your software update.
DDMS® Machines and Equipment Edition (pdf) To supplement your system's core accounting applications, DDMS® offers powerful tools for managing equipment sales and service. These tools make it easy to track sales and leases of serialized equipment. They also provide management for your service department, including parts inventory, machine and technician tracking, call logging and dispatching, and contract management. All serialized tools are fully integrated with other system functions to provide a complete business solution.
Work in Progress for DDMS® Office Furniture Edition (pdf) Work in Progress” (WIP), a powerful add-on-accounting function for DDMS Furniture Edition, gives you the ability to view and compare your actual costs on an individual order basis prior to and after invoicing to ensure a more accurate bottom line. WIP also helps to eliminate over-payments to vendors, correct payment of commissions to salespeople and helps in the overall order process.
DDMS® Office Furniture Edition (pdf) This session handout showcases the remarkable changes to DDMS Office Furniture Edition’s new order entry, purchasing, and receiving functions. Topics include the new enhanced change mode, modify order function (mass changing cost, sell, list and gross profit), staging bins, PSN purchasing with Herman Miller, Allsteel, Kimball/National and other manufacturers), specifying drop ship orders, enhanced third party billing, rental/loaner/demo tickets, furniture contracts and many features available in Version 8.
Bank Statement Reconciliation (pdf) One of our most-requested enhancements is here. Bank Statement Reconciliation provides an on-screen worksheet that lets you quickly and easily mark cleared and outstanding checks and deposits to balance against your bank statements. Plus, this new application utilizes our smart-client, .NET architecture and intuitive interface design.
Setting Up and Using Credit Cards and Approval Link 3.0 (pdf) Do you know what your processing rates are today? Have they changed in the last year? Now dealers using ECi business systems have new options for processing credit card transactions — as well as other types of payments. Learn how to set up and use Approval Link™ software to process credit card transactions quickly and efficiently. Topics include software setup, the flow of credit card transactions, Level II and Level III credit card processing, and options for authorizing gift/reward cards, check conversion, and processing electronic fund transfers using the Internet.
Campaign Manager (pdf) New in Version 8: parameters to help coordinate with Microsoft Exchange Server. In tandem with Notes Everywhere and the system's email capabilities, Campaign Manager lets you create automated marketing tasks based on customer’s status, such as new customers or growth customers. You can send emails to both internal and external customers. For example, if a customer hasn’t made any purchases recently, you might email their salesperson internally to notify them. You could also email marketing flyers or perhaps a discount offer. Campaign Manager lets you automatically recognize and react to customers who haven’t purchased recently. You simply set up the campaign and limit to the customers that fit your criteria.
Notes Everywhere (pdf) New in Version 8: parameters to help coordinate with Microsoft Exchange Server. Once you set up Notes Everywhere, the Notes Everywhere dialog box can be set to automatically launch each time you open DDMS. This dialog box remains on top of other windows, so you can easily view notes for the selected customer, vendor, or invoice. What’s more, the selected customer or vendor is automatically recognized and the notes display for you when you retrieve a record.
GST, PST, and HST Setup Procedures (pdf) Canadian dealers may set up their system to calculate GST, PST, and HST taxes, and catalog invoice formats and reports to display these taxes.