Plus Laser Scanner

Dynamics GP in Wholesale and Distribution: WMS, Barcode Scanning, EDI

Corporate ERP application in Distribution and Wholesale industries often requires advanced barcoding technology deployment, especially in such operations as Order Fulfillment, Inventory Counts and Transfers, Merchandise Replenishment.  These three are fundamentals of so-called Warehouse Management System.  Also you may require additional elements of Supply Chain Management: delivery route and time optimization, for example.  If you require your customers to supply purchase order in EDI (Electronic Document Interchange) format or this is what your major suppliers require from your Purchase Department – EDI integration should be also considered.  As excurse to history – Microsoft Dynamics GP is successor of Great Plains Dynamics and eEnterprise (Microsoft acquired Great Plains Software in late 1990th, earlier 2000th and Microsoft Dynamics GP is pretty much the same, including technology background, such as Great Plains Dexterity, Integration Manager, VBA/Modifier, Extender, except whatever was introduced with the introduction of the new versions, plus Microsoft Business Solutions introduced eConnect SDK, based on encrypted SQL Stored Procedures).  Let's take a look at Dynamics GP implementation in Distribution in general and your options in phasing in Barcoding, SCM, EDI and ecommerce technologies:

1. Dynamics GP Implementation in Supply Chain Management, Logistics and Distribution.  Here we are talking about standard Corporate ERP system implementation, with such steps as data conversion, user training, pilot month of using GP and legacy accounting system in parallel mode.  In this phase you can probably review general guidelines for the new Corporate ERP implementation.  In our opinion, the most critical and where you may expect your ERP and MRP implementation to fail are Data Migration and Conversion phase and deciding on appropriate level (the less the better) of Dexterity, eConnect, IM/VBA, Extender customizations.  Let's first speculate about data massage and conversion scenarios and complications.  If you are in budget oriented mode, meaning that you do not like the idea to pay for data migration services (Dynamics GP Technical Consulting hours), consider the plan to enter GL beginning balances (for the new fiscal year or even  new month or whatever is your fiscal period), importing the most critical master records (GL Accounts, Customers and Vendors with their addresses, Employees, plus potentially such master records as Service Contracts, Bills of Material, Manufacturing Routines, etc.).  We do recommend you (in decision on data conversion, massage and migration) to consider retaining the old computer (or probably Novell or Windows NT server) for data inquiry (locked for new transaction entry).  We do believe that paying for the electricity to support the old server is cheaper comparing to complex data conversion

2. Let's now move on to our next topic: Barcode Laser scanning and data upload to Dynamics GP forms.  Laser Barcode Scanners are available in various models, where you can decide to have basic USB barcode scanner (which is very close in its features to computer keyboard), or to purchase wireless Barcode device.  Currently you may consider smart scanners with Windows mobile ($800 and up) or cheaper version with text mode compatibility (should cost you up to $500, we recommend Symbol PDT 3000 Portable Data Terminal Series).  This paper is written in November 2010, so if you think that it is historical, please make your own research on modern barcode laser scanners

3. Warehouse Management System.  Talking about WMS for GP you can review two routes.  First – external WMS with integration module or connectors to Great Plains SOP, POP, Inventory module.  Good pluses hear are the facts, that these systems have large number of successful implementations USA, Canada nationwide and internationally, they also support large spectrum of Barcoding devices.  As minuses we have to mention high price (where you pay for the functionality in WMS, already available in Dynamics GP), some customers also shared the concerns about difficulties and unexpected budget in implementing integration between WMS and Dynamics GP.  And the second option is Dynamics GP WMS extensions, this is add-on, where barcoding logic works directly with Dynamics GP forms and out of GP tables (integration is not required, comparing to external WMS)

4. Electronic Document Interchange (EDI).  You can find several professional EDI products for Dynamics GP, where all or most of EDI protocols and communication methods are supported.  It is often the case, when yours EDI needs are really modest and you have only one or two protocols and one communication method (probably via FTP or even email).  In this scenario we are helping the customers to program EDI protocol directly in formatted SQL Select (or Insert) statement and we have small utility, which handles ftp communication for EDI documents

5. Business-to-Business ecommerce for Dynamics GP.  B2B ecommerce is picking up as more advanced alternative to EDI, where your wholesale customer could have self-service in placing Purchase Orders.  The nicety of ecommerce add-on for Dynamics GP is its seamless integration with your Warehouse Management Extensions, where ecommerce originated order goes automatically (if required conditions are met, for example it is prepaid or customer credit limit is not exceeded) to the WMS for fulfillment

6. Some practical recommendations.  If you plan to extend your Dynamics GP for the Warehouse Management, EDI or ecommerce, or introduce barcoding interface, we recommend you to upgrade GP to its current version 2010/11.0 or at least to version 10.  Theoretically you may stay with the old version and integrate WMS transactions via Great Plains Integration Manager (assuming that your WMS solution exports transactions into text files or opens its DB via ODBC connection and you are familiar with its table structure and documents flow).  In our opinion, upgrade overhead is not comparable with WMS price and if you would try to implement Warehouse Management System for older Great Plains Dynamics – you will have to pay more down the road, as you will have to find consultants and programmers, who are familiar with legacy technologies, such as Microsoft pre .Net ADO, probably VBA scripting in Modifier or Integration Manager, Great Plains Dexterity.  If you are growing and you are currently on Microsoft Small Business Financials, we recommend you to migrate to Dynamics GP and only then launch SCM, WMS or EDI project (by the way, SBF line is terminated and the last version was 9.0)

7. If you are expanding internationally.  International Corporate ERP market has its rules, where you may feel a bit confused.  Accounting system localization has two aspects: local language support and compliance with local legislation.  There are several flavors of Dynamics GP Add-ons, translating Great Plains to major world languages: Chinese, Japanese, German, Italian, French, etc.  But GP is officially localized only in USA, Canada, Australia, New Zealand, South Africa and other English speaking countries (including South East Asia where English is used as the language of business) most of Spanish speaking Latin America (except Brazil, where they speak Brazilian Portuguese).  So, if you plan to invest into new Corporate ERP application for your overseas branch, and if GP is not localized – we recommend you to consider other options – maybe Dynamics AX (former Axapta, this is one step up and it is a bit more expensive) or SAP Business One (for smaller overseas operations)

8. To request further support, please call us 1-866-528-0577, help@albaspectrum.com We need to discuss your cards in order to recommend you the best solutions, which is not contingent to our preferences.  We serve you USA/Canada nationwide via remote support (web sessions and phone/Skype conferences).  Local service is available in Western Michigan, Chicagoland, Southern California (LA, Orange County, San Diego), Houston area of the state of Texas

 

About the Author

Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving GP customers USA and Canada Nationwide: California, Minnesota, New York, Quebec, Ontario, Illinois, Texas, Georgia, Arizona, Nevada, Virginia, Florida, new Mexico, Iowa, Indiana, Alaska, Hawaii. Local service is available in Houston/Dallas: Richmond, Rosenberg, Katy, Galveston, Sugar Land; in Chicago: Naperville, Aurora, Plainfield, Romeoville, Batavia, Downers Grove, Schaumburg, Rockford, Elgin, Crystal Lake, Joliet, Hinsdale, Lisle, Montgomery, Oswego

WLS 9505 Laser Scanner - barcode scanner $299 Wasp WLS 9505 Laser Scanner - Barcode scanner - handheld - 200 scan / sec - decoded - USB

WLS 9500 Laser Scanner - barcode scanner $326.99 Wasp WLS 9500 Laser Scanner - Barcode scanner - handheld - 200 scan / sec - decoded - keyboard wedge

Intermec / SR61TL INDUSTRIAL LASER SCANNER / SR61TL-002 $463.25 Intermec - SR61TL INDUSTRIAL LASER SCANNER - SR61TL-002

Wasp WWS850 Wireless Laser Scanner Kit 633808920203 $715.67 Wasp WWS850 Wireless Laser Scanner Kit 633808920203

Wdt2200 Barcode Scanner With Integrated Laser & Countit Invent $823.99 WDT2200 BARCODE SCANNER WITH INTEGRATED LASER & COUNTIT INVENT

Wasp Wpa1200 Pdt Winmbl 5-64mb & Laser Scanner $1228.99 WASP WPA1200 PDT WINMBL 5-64MB & LASER SCANNER

SR61TL Standard Range Laser - barcode scanner $491 Intermec SR61TL Standard Range Laser - Barcode scanner - handheld - decoded

GT 2500 Plus - flatbed scanner $802.99 Epson GT 2500 Plus - Flatbed scanner - Legal - 1200 dpi x 1200 dpi - Hi-Speed USB / 10Base-T/100Base-TX

Wasp WiFi 9500 Laser Scanner BarCode Scanner HandHeld 200 Scan / Sec Decoded Keyboard Wedge 633808121242 $315.71 Wasp WiFi 9500 Laser Scanner BarCode Scanner HandHeld 200 Scan / Sec Decoded Keyboard Wedge 633808121242

Wasp WiFi 9505 Laser Scanner BarCode Scanner HandHeld 200 Scan / Sec Decoded USB 633808121259 $315.66 Wasp WiFi 9505 Laser Scanner BarCode Scanner HandHeld 200 Scan / Sec Decoded USB 633808121259

Kodak i1220 Plus Sheetfed Scanner $932.99 12.13 lb 1200 dpi 13" 2" x 2.50" 30 45 6.38" 600 dpi 75 Sheets 8.50" x 34" 8259426 9.69" TWAIN, ISIS, WIA Drivers KODAK Capture Desktop Smart Touch Nuance ScanSoft PaperPort OmniPage i1220 Plus Sheetfed Scanner USB Cable Small, powerful and packed with features and benefits, the KODAK i1220 Plus delivers on your desktop scanning needs. It can auto-feed almost anything at speeds up to 45 pages per minute, including documents as small as an identification card or as long as 863 mm (34 in.). The i1220 Plus Scanner provide you with a wide range of output options including searchable PDF files for easy information access. CCD Eastman Kodak Company Energy Star Kodak PC Plain Paper Sheetfed Scanner Yes i1220 Plus i1220 Plus Sheetfed Scanner www.kodak.com

Panasonic / 3-in-1 Monochrome Laser MFP w/Flatbed Scanner / KX-MB2000 $148.52 Panasonic - 3-in-1 Monochrome Laser MFP w/Flatbed Scanner - KX-MB2000

Symbol / Symbol LS2208 USB Handheld Laser Barcode Scanner / LS2208-USB $82.7 Symbol - Symbol LS2208 USB Handheld Laser Barcode Scanner - LS2208-USB

Wasp Barcode Technologies / WASP WLS 9500-005 LASER SCANNER / 633808121259 $318.37 Wasp Barcode Technologies - WASP WLS 9500-005 LASER SCANNER - 633808121259

Lexmark X363DN MultiFunction Monochrome Laser Printer / Copier / Scanner 13B0501 $571.85 Lexmark X363DN MultiFunction Monochrome Laser Printer / Copier / Scanner 13B0501

Panasonic Laser MultiFunction Printer Monochrome Printer / Copier / Scanner KXMB2010 KX-MB2010 $211.75 Panasonic Laser MultiFunction Printer Monochrome Printer / Copier / Scanner KXMB2010 KX-MB2010

Symbol LS4208 Laser BarCode Scanner USB Kit (Black) LS4208-SBZU0100ZR LS4208SBZU0100ZR $163.52 Symbol LS4208 Laser BarCode Scanner USB Kit (Black) LS4208-SBZU0100ZR LS4208SBZU0100ZR

Wasp Waspnest With WLS9500 Laser BarCode Scanner Suite 633808390310 $404.21 Wasp Waspnest With WLS9500 Laser BarCode Scanner Suite 633808390310

Wasp WWS850 Wireless Laser Scanner Kit Usb 633808920210 $721.76 Wasp WWS850 Wireless Laser Scanner Kit Usb 633808920210

Symbol LS4208 USB HandHeld Laser BarCode Scanner (Beige) $58.25 Symbol LS4208 USB HandHeld Laser BarCode Scanner (Beige)

Brother MFC 9560CDW Color Laser Fax / Copier / Printer / Scanner MFC-9560CDW $708.73 Brother MFC 9560CDW Color Laser Fax / Copier / Printer / Scanner MFC-9560CDW

Wasp Wdt 2200 - Barcode Scanner - Single-Pass - Laser - Serial Rs-232 $704.99 WASP WDT 2200 - BARCODE SCANNER - SINGLE-PASS - LASER - SERIAL RS-232

X 658de - Multifunction - Monochrome - Laser - Fax / Copier / Printer / Scanner $4190.99 X 658DE - MULTIFUNCTION - MONOCHROME - LASER - FAX / COPIER / PRINTER / SCANNER

Pa600 Batch Windows Mobile 6.1 1d Laser Scanner $1223.99 PA600 BATCH WINDOWS MOBILE 6.1 1D LASER SCANNER

X 862DTE - MULTIFUNCTION - MONOCHROME - LASER - FAX / COPIER / PRINTER / SCANNER $8389.99 X 862DTE - MULTIFUNCTION - MONOCHROME - LASER - FAX / COPIER / PRINTER / SCANNER

American DJ X-Scan LED Plus DMX Scanner $399.99 American DJ X-Scan LED Plus DMX Scanner

American Dj X-Scan Led Plus Dmx Scanner $399.99 American DJ X-Scan LED Plus DMX Scanner

Epson GT-2500 Plus Flatbed Scanner 1200dpi USB Ethernet B11B181061 $592.97 Epson GT-2500 Plus Flatbed Scanner 1200dpi USB Ethernet B11B181061

Wasp WPS150 Omni-Directional Laser Barcode Scanner - Barcode Scanner - Desktop - 1500 Scan / Sec - Decoded - USB. Each $313.7 Manufacturer: Wasp Technologies. Each. The WPS150 Omni-Directional Laser POS Barcode Scanner is the ideal laser scanner for Point-of-Sale (POS) retail applications. Featuring a 20-line omni-directional laser scan pattern, this POS barcode scanner delivers

Epson GT-2500 Plus Sheetfed Scanner $782.99 1 Year Limited 11 120 V AC 1200 dpi 1200 x 1200 dpi 15.50" 16-bit 18.43" 23 lb 27 48-bit 5.84" x 5.84" 50 Sheets 7.87" 9600 x 9600 dpi Epson Scan TWAIN Driver Captiva ISIS Driver (Windows only) Adobe Acrobat ScanSoft PaperPort GT-2500 Plus Sheetfed Scanner 50-page Automatic Document Feeder Network Image Express Card (pre-installed) AC adapter and power cable Scanner installation CD-ROM Application installation CD-ROM Start Here poster User's Guide Hi-Speed USB 2.0 cable Light Source: White cold cathode fluorescent lamp ADF: Optical Resolution: 600 dpi Hardware Resolution: 600 x 600 dpi with Micro Step Drive technology Maximum Resolution: 1200 x 1200 dpi Reliability: Main Unit MCBF: 100,000 cycles ADF MCBF: 250,000 cycles Now, your workgroup can take advantage of high-speed document imaging without breaking the bottom line. The fast, affordable Epson. GT-2500 Plus delivers remarkable scans up to 8.5" x 14", plus networking capabilities for small business environments. The Epson GT-2500 Plus presents a remarkable solution for affordable document imaging. And, with its convenient compact design, it is the perfect fit for any office environment. A4 A4 8.50" x 11.70" AC Supply B11B181061 Book CCD Color Epson Epson Corporation Fast Ethernet GT GT-2500 Plus GT-2500 Plus Sheetfed Scanner Legal Legal 8.50" x 14" Mac PC Plain Paper Sheetfed Scanner Yes www.epson.com

Xerox WorkCentre 3550 Laser MultiFunction Printer USB Ethernet Monochrome Laser Fax / Copier / Printer / Scanner 3550/YX $1081.79 Xerox WorkCentre 3550 Laser MultiFunction Printer USB Ethernet Monochrome Laser Fax / Copier / Printer / Scanner 3550/YX

Used Omnisistem Skyscan Dmx Aerial Laser Sky Scanner 042112 $499.99 In Store Used USED OMNISISTEM SKYSCAN DMX AERIAL LASER SKY SCANNER 042112

Thumblock Scanner $400 Thumblock Scanner Only For Use With USB Thumblock Door Locks! Enroll Thousands Of Users From A Central Computer The Thumblock Fingerprint Scanner lets you enroll all users quickly and easily from a central PC. Register thousands of fingerprints and or PIN codes at a centralized PC with one fingerprint scanner, set access control rights, and then simply upload all information to the included flash drive. Set-Up Keyless Users Quickly & Easily From A Central PC For Increased Security & Fast Report Downloading Quickly Upload User Rights To All Your Thumblock Keyless Locks Once you've set all preferences and access rights on a central computer, download the information onto the included 1 Gb flash drive. Bring the flash drive to your Thumblocks and download all access information to the keyless lock quickly and easily by simply plugging it in. All your settings will be saved on the lock for future use. Easily Review Up To 20,000 Access Reports On Any PC Insert the flash drive into any of your Thumblocks and easily download all access information including who, what, where, and when accessed a particular door. Once you download this information from your keyless locks, plug the flash drive into any PC and quickly download all information. This MS Access-based AT software provides excellent tracking information and is exportable to an Excel sheet quickly and easily. Includes: Access Control/ Audit Trail software, USB Fingerprint Scanner and 1GB Flash Drive How It Works: Register all fingerprints (and/or PIN codes) of all users at one centralized PC with the fingerprint scanner Set access control rights at the PC of each individual user to each individual lock When finished, upload those access control rights to the flash drive Bring the flash drive to the lock and program the lock from the flash drive Plus AT records can still be offloaded from the lock to the flash drive

Dell 2155CDN Color Multifunction Laser Printer (Fax/Copier/ Printer/ Scanner). Each $538.42 Manufacturer: Dell. Each. Get crisp and fast color laser printing from the 2155cdn Laser Printer from Dell. With a native print resolution of up to 600 x 600 dpi, your color documents will always look sharp. Plus you can get crisp graphics, text, and phot

Dell 2155CN Color Multifunction Laser Printer (Fax/Copier/ Printer/ Scanner). Each $534.14 Manufacturer: Dell. Each. Get crisp and fast color laser printing from the 2155cn laser printer from Dell. With a native print resolution of up to 600 x 600 dpi, your color documents will always look sharp. Plus you can get crisp graphics, text, and photo

Multifunction Laser Printer 1133 - multifunction ( printer / copier / scanner ) ( B/W ) $124.99 Dell Multifunction Laser Printer 1133 - Multifunction ( printer / copier / scanner ) - B/W - laser - copying (up to): 23 ppm - printing (up to): 23 ppm - 250 sheets - Hi-Speed

Laser Fax UF-5500 - multifunction ( fax / copier / printer / scanner ) ( B/W ) $479.99 Panasonic Laser Fax UF-5500 - Multifunction ( fax / copier / printer / scanner ) - B/W - laser - printing (up to): 24 ppm - 250 sheets - 33.6 Kbps - Hi-Speed USB 10/100 Base-

X 264dn - multifunction ( fax / copier / printer / scanner ) ( B/W ) $309.99 Lexmark X264dn - Multifunction ( fax / copier / printer / scanner ) - B/W - laser

This entry was posted on Saturday, April 11th, 2009 at 4:36 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.