| |
| |
|
|
Software Information |
|
|
|
eCommerce development for Microsoft Great Plains: tools and highlights for programmer
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics and eEnterprise was designed in earlier 1990th as ERP, which can be easily transferable to the winning Database and OS platform and it was originally available on Mac and PC - Mac OS and Microsoft Windows respectively. Graphical platforms battle is pretty much over and now with eCommerce demands, we should look at Great Plains Dynamics tables structure: ? Naming Convention. Great Plains was designed to be ready to move to the winning database platform and probably this is why we see this a bit complicated naming convention in place: SOP10100, RM00101, IV00101 - these are samples: SOP header, Customer master, Inventory master. First - we see module prefix: SOP - Sales Order Processing, RM - Receivables management, IV - Inventory control, etc., then 0 stays for the master files, 1 - so-called work files (before transaction being posted), 2 - open files (after transaction is posted) and 3 - historical files (when you close the year in General Ledger - transactions are moved from open to history files). So as you see - logic is present and structured, but it is not friendly to the developer, who never seen and worked with Great Plains Dynamics. ? Tables Groups. Great plains was designed to first serve mid-size businesses and then with the availability of third party modules - the intention was to compete on corporate ERP market with Oracle, PeopleSoft, SAP and others big players. This is why we see the whole cluster of tables to store, say Sales Invoice: SOP Header, SOP Lines, SOP Distribution, RM Key file, etc. From the Forms side (or screens) you can see more human-readable names: SOP Entry, RM_Customer_Maintenance, POP_Entry or the like. But these legacy Great Plains Dexterity names do not help eCommerce developer - only probably as the reference on which table works with specific screen. Let's take a look at the tools available: ? eCommerce - together with eOrder, and other eXXX products it should be considered as legacy and phase out product, based on Microsoft eCommerce server and ASP technology, today Microsoft has new paradigm - .Net and ASPX World ? eConnect - was specially created for eCommerce developers, who integrate Microsoft Great Plains with eCommerce web interface. This tool covers a lot of Great Plains objects creation and retrieving functionality, however it does have restrictions, because it was not intended as replacement to Great Plains Dexterity shell. For example - if you create Orders in SOP via Web interface/eConnect - it is difficult manipulate these orders (transfers to Invoices, backorders, reallocations, etc.). Another issue with eConnect - developers are kind of used to the fact that Microsoft provides free SDK to its products, Microsoft CRM for example has freely downloadable Microsoft CRM SDK. For eConnect you have to pay license and be on Microsoft Business Solutions annual support to get version upgrades. Also if you are ISV and develop your GP integration to your customers - you have licensing issue with Microsoft. ? Custom SOP/AR stored procedures. Microsoft Business Solutions partners in their practice usually have several Great Plains integration projects implemented where integration is realized on the stored procedures level and transactions are created and manipulated in Great Plains SOP. So - you may end up seeking this type of help Good luck with implementation, customization and integration and if you have issues or concerns - we are here to help! If you want us to do the job - give us a call 866-528-0577 or 630-961-5918! help@albaspectrum.com Andrew is Great Plains specialist in Alba Spectrum Technologies ( http://www.albaspectrum.com ) - Microsoft Great Plains, Navision, Microsoft CRM Partner, serving clients in San Francisco, San Diego, Chicago, New York, Atlanta, Houston, Dallas, Miami, Orlando, New Orleans, Phoenix, Seattle, Minneapolis, Detroit, Los Angeles
MORE RESOURCES:
Software - Google News |
|
|
|
RELATED ARTICLES
Can Group Collaboration Software Meet Business Needs? According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric Collaboration," 51 percent of businesspeople utilizing technology such as Microsoft Office and e-mail collaborate almost daily as a part of their business operations and need group collaboration software to support electronic collaboration.The report indicated that the need would continue to grow over the next year. Photoshop Files and Formats People often ask me: What image file formats will Photoshop open or save in? What are the advantages/disadvantages?Photoshop has the capability to open and save many different graphic files. Here are some of the most popular ones. Microsoft Great Plains Integration Manager: Using Continuum - Overview for Developer Microsoft Business Solutions Great Plains has I'd say end user integration tool - Great Plains Integration manager. Integration Manager itself uses OLE functionality to validate text or ODBC integration files data through Great Plains forms behind the scenes. 3 Reasons Why Medical Billing Software is Leading the Way Since technology changes so quickly, it is hard to begin by saying "in the old days . . Microsoft Great Plains PM: Payables Management Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized).Great Plains Payables Management (PM) module improves control over your payables. How to Evaluate Staffing Software If you are in the market for new staffing software, I suspect that one of the most daunting of tasks will be to sift through the many vendors that are now servicing the staffing industry.You will find many very qualified companies with good staffing software products. Is Your Family Protected? When you think about Security, what do you think of? We all have one device or another to assist in keeping us safe. We have pad locks and security systems to safe guard our home, alarm systems to protect the equipment in our cars, parental controls on our cable TV and satellite accesses. Inherent Dangers Of File Sharing Via The Internet. Cyberspace has opened up a new frontier with exciting possibilities of "File Sharing." We can explore any interest imaginable and research any topic of choice. Microsoft Office Selecting Secrets Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it.. How to Get The Best Accounting Software For Your Small Business Buying accounting software is a major investment. It's an important decision and you need to be sure of all the facts before you buy. Microsoft Great Plains - Typical Problems And Fixes - Overview For IT Administrators How to delete the user? This is the first problem you encounter - when user shuts down the computer - Great Plains doesn't have the command to log off the user and when user tries to login the next day - she gets error message that user is already logged on. The fix: Microsoft SQL Server - open SQL Query Analyzer, switch to DYNAMICS database and run the following script: DELETE ACTIVITY WHERE USERID='KATHY'. RFID: Strengthen the Position for SAP; United States SAP Inc., a global leader in client/server enterprise application software that for years been the backbone to RFID application has seen a 1,000% spike year-over-year in customers, interested in RFID deployment. COSMIC: A Small Improvement on the Symons Method The COSMIC FP (function point) software quality metric, is no longer 'proposed' but an actual system in use and internationally recognised, whereas MarkII, like other older systems, is not recognised anywhere, and, even in the UK is in decline if not actually dormant, so this debate is already over.Historically, from my limited understanding of the situation, it seems that originally there were upwards of 35 variants of function point style metrics until the ISO developed criteria for a acceptable solution, ISO 14143: Parts 1 to 5 (1995-2002):The COSMIC group reviewed existing functional size measurement methods, namely the work done in the late 80's by Charles Symons in the UK. Microsoft CRM Modification - Overview for IT Specialist Microsoft CRM is now on the scene and it is increasing its market share, due to the Microsoft Business Solutions muscles and marketing strategy. It is tightly integrated with other Microsoft Business Solutions products such as Microsoft Great Plains, Solomon, Navision. The Dreaded Paper Label - Should it be Used? While paper labeling CDs and DVDs may appear to be a cost effective solution for printing on your media, there are solid reasons why you should consider other options.1) Hand application of paper labels can be time consuming and frustrating. Story Development Software: Good or Evil? In the early days of the personal computer, we're talking the mid-'80s here, there was speculation that someday books would all be writen by computers. It sounded a little too science-fictiony for most writers. Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW - ReportWriter - Tips for Developer Microsoft Business Solutions Great Plains is written in Great Plains Software programming tool: Great Plains Dexterity. Dexterity in turn was built with conception of graphical cross-platform transferability (in time - 1992 - mostly Mac and MS Windows). Microsoft CRM Integration with IBM Lotus Notes Domino - Machinery Dealership Example IBM Lotus Notes with Domino email server is traditional document workflow management solution for large corporate business, where you need audit trail on approval cycle and decision making. Microsoft Business Solutions CRM is very cost efficient solution to automate sales process. New Web-Based HR Tool is Max From NAS, Hannibal, and InfoLink Three highly respected names in Human Resources have joined forces to provide companies with a revolutionary blend of services that make the hiring process more efficient and effective. The partnership joins three companies: NAS Recruitment Communications, a recognized leader in the specialized field of human resource communications, Hannibal, Inc. Business Planning Software Once a business idea is selected, it is highly recommended that we sharpen the concept by a detailed planning process. The result of this step is a comprehensive business plan, with its major components being the marketing "mix," the strategic plan, operational and logistical structures, and the financial proposal.
|
| home | site map |
| © 2006 |
