|
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...
|
|
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 ...
|
|
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...
|
|
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...
|
|
|
|
| Mouse Explorer |
 Your personal interactive guide to Walt Disney World for your Pocket PC. The software features fully detailed, interactive maps of the four major Walt Disney World theme parks: Magic Kingdom, Epcot, MGM Studios, and Animal Kingdom. |
|
| Lizard Safeguard PDF Security |
 PDF document security software with DRM controls. Control who can view PDF documents & how they are used. Prevent copying, sharing, modifying, screen grabbing. Control the number of views and prints & when documents expire. No useless passwords. |
|
| Time Boss |
 Transcendent award-winning parental control software. Time Boss gives You an ability to manage exactly what, when and how long other user can do on the computer and offers adjusted powerful tools combining with user-friendly multilingual interface. |
|
| Fix Any Color |
 Fix Any Color lets you selectively adjust colors in your digital images. It combines sophisticated L*C*h* color processing with an easy-to-use interface. Simply click on the color to fix, then adjust lightness, saturation and hue of that color. |
|
| EDraw Flowchart Software |
 EDraw is a new flowchart software, which creates flowcharts and org charts with minimum time loss for you. Support basic flowcharts, organizational charts, business charts, hr diagram, work flowchart, programming flowchart and network diagrams. |
|
| Your Personal Job Searcher |
 Job Search, Jobs, Jobs, Millions of Jobs. Find Millions of Jobs and Work Quickly ..Free Trial Copy. Can be used with Windows 95/98/2K/XP and Vista. Your Job Searcher, is your Personal Job Searching Program. Instant Job Search Software. |
|
| AutoMe |
 AutoMe is a reliable and user-friendly windows automation software and macro recorder with task scheduler, color checker. AutoMe is very easy to use, you can record robot, and run it as many time as needed. No programing needed. |
|
|
Latest press releases
