|
Microsoft Great Plains Software development: typical scenarios in Sales Order Processing module Alba Spectrum
Microsoft Dynamics GP has a set of SDK and programming tools to enable business logic customization for software developers. You can utilize Extender, VBA with Modifier, direct SQL scripting as well as eConnect object calls from Microsoft Visual Studio C# or VB projects. However if the modification should be seamlessly integrated in Great Plains user interface, you should consider Microsoft Dexterity tool. Regardless of the tool, you need to understand which GP objects should be modified and where to find their description:
1. Great Plains Tables description. You can install Microsoft Dynamics GP SDK or Software Development Kit, which has comprehensive overview of GP tables and their relations. If you work closely with GP users, you can get tables snapshot in GP interface: Microsoft Dynamics GP->Tools->Resource Description->Tables.
2. SOP tables, often participating in modification. GP design distinguishes work, posted and historical tables. In the case of Sales Order Processing module you see Sales Work Documents: SOP10100 Sales header and SOP10200 Sales lines tables (to name key tables, there are other tables as well, outside of the scope of this article); and historical tables: SOP30200 Sales header and SOP30300 Sales lines
3. Modification technique. You actually never change original GP tables; instead you add your new custom tables and link them one-to-one with GP original tables. In the case of Sales header table, you link your custom table by these two fields: SOPTYPE and SOPNUMBE Sales document type and Sales number respectively
4. Typical modifications in business logic. Imagine you have return and you would like to associate it with invoice. Custom logic may have custom screen, where you select invoice number and click Create Return button. The logic copies all the items and qty from chosen invoice and creates reversing return. This is one of the typical scenarios, where your business has special automation requirements, not available in GP or any other generic ERP application. The example above is very good candidate to be considered and implemented in Great Plains Dexterity
5. Additional Considerations. As we are talking about mid-size MRP application, where Great Plains Dynamics GP belongs, altered business logic is not a five minutes change. GP objects model is relatively complex, plus if you decide on Dexterity programming it requires several years of extensive software development to get enough under your belt to consider learning curve to be finally behind. In any case do not hope on short cuts or easy ways to get by
Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com http://www.pegasplanet.com , help@albaspectrum.com , 10866-528-0577, 1-630-961-5918, serving Microsoft Dynamics GP Great Plains customers in USA/Canada nationwide. Local service is available in Houston, TX: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village; Chicago, IL: Naperville, Aurora, Bolingbrook, Romeoville, Joliet, Wheaton, Lisle, Downers Grove, Schaumburg, Elk Grove, Lombard, Woodridge, Darien, Westmont, Batavia, St. Charles, Elgin, Crystal Lake. Service is also available in Houston and Dallas metros, plus internationally in Canada, Australia, New Zealand, South Africa, Oceania and UK.
Company: Pegas Planet
|
| Related press releases |
Microsoft Great Plains Software development: typical scenarios in Sales Order Pr... [2008-01-14 08:29:55]
Microsoft Dynamics GP has a set of SDK and programming tools to enable business logic customization for software developers. You can utilize Extender, VBA with Modifier, direct SQL scripting as well ...
|
|
Microsoft Great Plains Boca Raton, FL Alba Spectrum Group [2007-12-23 04:52:45]
Microsoft Business Solutions Great Plains is gaining market share as we write these lines. Alba Spectrum Group is announcing its Florida GP consultants headcount increase. If you have concerns about...
|
|
eConnect Posting Extension: Alba Spectrum Autoposting Server [2008-05-21 22:54:55]
If you are ecommerce developer, who are programming in C# or VB.Net with some SQL stored procedures, then more likely you are deploying Microsoft Dynamics GP eConnect SDK to integrate eCommerce websit...
|
|
Linux PHP Sales Management System integration with Microsoft Great Plains overvi... [2007-11-13 08:06:05]
Microsoft Dynamics GP is Microsoft Windows and MS SQL Server application, it is heavily integrated with Microsoft Sharepoint and MS Office stack of products. If your Sales Processing system is based ...
|
|
Planning upgrade for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-08 04:56:42]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are on the way to upgrade GP versions 7.5, 8.0, 9.0 to GP 10.0, then you should read thi...
|
|
eConnect eCommerce Posting Server for Dynamics GP Alba Spectrum [2007-09-22 02:52:59]
Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are eCommerce .Net c#, VB or SQL developer, you need to know eConnect Microsoft Dynami...
|
|
Microsoft Dynamics GP Great Plains Integration and Upgrade Service in Chicago ... [2007-11-02 07:45:12]
Former Great Plains Software, later on Microsoft Business Solutions Great Plains and currently finally Microsoft Dynamics GP ERP application serves to midsize and large US businesses, also it has Cana...
|
|
eCommerce programming for Great Plains Dynamics GP Alba Spectrum [2007-09-09 04:10:56]
If your organization deploys Microsoft Dynamics GP Great Plains ERP and you are thinking on connecting it to your eCommerce site, we would like to give you initial introduction - where to start diggi...
|
|
Microsoft Dynamics GP 10.0 Visual Studio Development notes Alba Spectrum [2007-08-26 04:23:08]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are eCommerce programmer and plan to dive into Microsoft Great Plains e-commerce web des...
|
|
Web Design for Microsoft Dynamics GP: custom ecommerce solutions Alba Spectrum [2007-08-18 05:19:13]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
More articles are published about Microsoft Great Plains Dynamics GP 10.0. Very hot topic is e...
|
|
|
|
| Nesox Email Marketer Business Edition |
 Professional HTML email newsletter software and opt-in email marketing software for targeted mailing list building, email campaigns creating, bulk mailing and click tracking at your own computer. |
|
| Hermetic Word Frequency Counter |
 This software scans a file, or text on the clipboard, and counts the number of occurrences of different words. The text can be in a language other than English. The words which are found and displayed can be ordered alphabetically or by frequency. |
|
| XT Typing Tutor |
 Typing tutor inspired by guitar method. It teaches you how to use ALL YOUR fingers in order to get some true typing speed. It also shows you EXACTLY how to PLACE your FINGERS BEFORE TYPING parts of words (fingers are drawn on a virtual keyboard). |
|
| Melomania |
 Melomania is a handy music collection software for Windows, which allows you to catalog music collection of any kind, from vinyls to MP3s, and provides you with a quantity of facilities to manage music database. |
|
| CRM-Express Professional |
 CRM Software - CRM-Express Professional is the latest in CRM (Customer Relationship Management) software. CRM-Express can manage your marketing, customers, sales and orders. Features include SMS abilities, Email Client, Calendar, Address Book |
|
| Sendblaster |
 The best bulk email sender and mailing list management software. It?s so user-friendly that you can launch your email marketing campaign in minutes: create a newsletter, select a mailing list and start its fast mass emailing engine |
|
| QuickUML Windows |
 QuickUML is a software design tool that tightly integrates a core set of UML models with code generation. A project is presented through a tabbed window of use cases, class models, object models, dictionary and code and saved as an XML file. |
|
|
Latest press releases
