|
|
| www.1001TopWords.com |
|
|
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
|
|
|
|
RELATED ARTICLES
Introduction To ISDN, Part II In the previous ISDN article, we looked at how and why one router dials another using ISDN. Just as important is knowing what keeps the link up once it is dialed. How to Backup Windows XP Home Edition Your computer cost you from hundreds to thousands of dollars, but the computer itself is not the most valuable part. The data on the hard disk is the most valuable part. How many hours of work did you put into creating that data? One little event, like a power line spike from a lightning strike, and all that work could be lost. Unfortunately, backing up with Windows XP Home Edition is not as simple as it should be. An Easy Way to Deal with Email Viruses and Worms If you feel intimidated when someone tries to teach you something new on the computer, this article is for you! Keep Your Software Simple! A Review of EditPlus I like my software simple. If it's too complex or difficult to figure out, I don't use it. IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business System or CRM: Lotus Notes Domino, Oracle, DB2 Secure File Transfer Using SSH Plus Additional Audit & Automation - FSA Reporting In order to meet regulatory and corporate compliance requirements reporting members will require a cost effective solution that may be installed at one side of the data transfer without being tied to any proprietary protocol. Microsoft Great Plains Logistics & Warehouse Management ? Implementation & Customization Highlights Logistics automation is often considered as barcoding extension to Sales Order Processing, Purchase Order Processing, Inventory Control modules. Software extensions makers may disagree with this simplification, but budget solution works exactly like barcoding extension and is usually done via Great Plains Dexterity, Modifier with VBA and SQL stored procedures. If your company is looking for implementing automated inventory bin/item pickup and conveyer ? then you need specialized software. However if you just envision your warehouse workers with barcode scanners ? then read this article to understand your options with Microsoft Business Solutions Great Plains. Huddle Up; Groupware on Three It could just be me, but my experiences with document collaboration remind me of a football game. It sounds crazy, I know, but working with a group and sending emails off to other members of the group caries with it that familiar uneasy sensation of Thanksgiving Day football games, where I often play quarterback and just as often wonder whether members of my family will catch the pass, and if they do, what they will do with the ball. Using groupware in document collaboration is similar to having a game plan that separates the "Turkey Bowl" family football team from the real competitors. Do You Know These Facts About Spyware ? Imagine something that follows you home and sets itself upin your house. It eats your food, enjoys your drinks, readseverything you bring home or purchase. It runs up yourphone bills and no matter where you go, it can follow youand takes notes on everything you do. Why Stick With Email Clients Like Outlook? Trying to figure out a stream in banning one email client or another is no easy job. As soon as somebody rises up saying Outlook is bad, somebody else comes saying it's good and the other one is bad. And the story goes on and on. The Truth: Netzero 3G We've all seen the ads on TV for Netzero 3G. You know the ones, "speeds so fast you sworn it was broadband" Well if your using it, you may not think it really is. We're going to break down the truth behind, Netzero 3G. Information Products: A Business Owners Best Friend We live in a post-industrial age where information is the coin of the realm. Knowledge is the most valuable asset that a business owns. For most businesses, that knowledge exists primarily in the heads of the people who work there. For entrepreneurs and sole practitioners, what's in their head usually is the business. That's both limiting and dangerous. RSS: Get Notified When Your Favorite Websites Are Updated RSS (Really Simple Syndication) is a way for a site to publish it's updates. RSS readers can read these notifications and display a listing of the updates to you, the user. Ukraine: a Prospective Player on the World Software Outsourcing Market The destruction of the Soviet Union about 15 years ago, made a huge country with a great level of IT science divided into small bricks. Nowadays, despite Russia's expansion into the world software development market, Ukraine keeps playing an important role here too. There are several prerequisites for this. Microsoft Great Plains implementation: Restaurants Supply Chain Management Example Microsoft Great Plains serves majority of US based horizontal and vertical markets. Being relatively flexible and customizable ? it can fit your specific business requirements with light or deep customization. You can have portion of the system customization done by your in-house developers (such tools as Modifier with VBA, MS SQL Server stored procedures, Crystal Reports do not require unique expertise) and the most critical and difficult part could be subcontracted ? especially Great Plains Dexterity. In this small article we would like to give you good example of customization scenarios, where client needs warehouse management, random weight purchasing and by-pond resale to end clients, barcoding. Lowering The Risks In Developing Do-It-Yourself Software Projects Mike Dunville* had a decision to make. As the new operations manager for Alpha Staffing, he wanted to make a difference at the dynamic staffing firm. The principals of the firm had charged him with making the day-to-day operations run smoothly and efficiently while they concentrated on growing the business in today's challenging economy. Crystal Reports for Microsoft Great Plains ? Overview for Developer Microsoft Great Plains is main accounting / ERP application from Microsoft Business Solutions, targeted to the US market. It serves the whole of vertical and horizontal market: most of the industries and company sizes. Crystal Reports on the other hand is the leader in the reporting software industry and Microsoft is willing to use Crystal as main reporting tool for Great Plains, Solomon, Microsoft CRM, .Net platform, etc.If you are developer who is asked: how do we extend Great Plains ReportWriter with somewhat more sophisticated ? read this and you will have the clues on where to look further.Great Plains Tables Structure ? first of all you need to know the tables to link. Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the proper series. If you are looking for the customers ? it should be RM00101 ? customer master file. If you need historical Sales Order Processing documents ? they are in SOP30200 ? Sales History Header file, etc. Create ODBC connection to GP Company database. Use the same technique as when you create standard ODBC connection for GP workstation ? but change default database to targeted company database. Consider SQL Views ? if you don't want complex links in Crystal Report itself or if you need unionization from several companies ? SQL view is the answer. Consider SQL Stored Procedures. Sometimes you can not pull the data in one view ? you need temporary tables to be created and the final query should be based on these temp tables ? this is when you need stored procedure. Call Crystal Report from GP Screens via VBA/Modifier ? if the user wants to call Crystal report for example - printing Invoices in GP and do it from SOP Entry window ? you can use Modifier and VBA to call Crystal Reports engine. Create SQL Query to probe the data ? we always recommend tuning your query and see that you are getting adequate results ? in any case ? Crystal Report is just a nice tool to show the results of your query.Happy customizing, querying and designing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com Microsoft Great Plains Customization: Project Organization ? International Business Example Microsoft Business Solutions Great Plains fits to majority of horizontal niches and clientele in the USA, Canada, Mexico, Latin America, U.K., Brazil, South Africa, Australia, New Zealand and Middle East. If you are project organization: Real Estate, Law Firm, Placement Agency with permanent clients, Construction or Freight Forwarding company ? you probably use or plan to deploy Project management or Project accounting extension for Microsoft Great Plains. If you have your business in one country ? this work relatively simple, however we see clients, involved into international business, when your headquarters is located in the US for example and offices and locations are in Mexico. Let's look at your options: 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. Crystal Reports For Microsoft Navision - Overview For Programmer/IT Specialist Let us give you - developer some hints in the report creation.
|
| © Athifea Distribution LLC - 2013 |
