Microsoft Dynamics GP 9.0 customizations and development - the most popular tables in your SQL scripts
The table design/architecture of Microsoft Dynamics GP, as we write the current version is Microsoft Great Plains 9.0, was done back in 1990th by Great Plains Software and what we are discussing here is applicable to the majority of Great Plains Dynamics / eEnterprise versions for MS SQL Server: 5.0, 5.5, 6.0, 7.0, 7.5, 8.0 and now 9.0. With so-called ‘Project Green’ Microsoft is enabling Microsoft Dynamics GP objects for Visual Studio C# or VB.Net developer via web services interface, while the middle-level set of stored procedures is known as eConnect. However you can still use old-good-way of creating your own set of stored procedures to feed in or pull data from Microsoft Great Plains 9.0 databases. If you are new to the subject – please be aware that you are not allowed to make a change to existing Great Plains tables – the reason is – Great Plains Dexterity (now referred as Microsoft Dexterity) uses DYNAMICS.DIC as metadictionary, where all the tables are described and if you make a change to the table – it will conflict with what table is known in DYNAMICS.DIC.
SOP, Sales Order Processing module. This is usually where all eCommerce developers start – you need to move the order from your e-Commerce application to Microsoft Dynamics GP SOP tables. Here the advice is – if you can’t afford eConnect – create Sales Order and Quote only (do not create Invoice). These documents do not require GL account distribution. Here are your tables: SOP10100 – SOP Header and SOP10200 – SOP work table. Another advice is – have your Great Plains guru setup special SOP Order type, where it doesn’t allocate inventory items on the fly. This second advice is not relevant if you are selling services and they are not tracked in inventory module.
Inventory Control. If you deal with so-called inventoried items (sales items, where you track quantities on-hand/allocated/committed by inventory site and across the company). Inventory tables are IV00101 – Item master and IV00102 – item QTY master table. Usually you have to deal with these two tables only, however in complex cases you can go deeper – our recommendation to purchase eConnect licenses if your logic in Inventory module is more complex
Receivables Management. From this module you just need customer record: RM00101 – Customer master and RM00102 – Customer Address Master
Payable Management. This usually goes beyond eCommerce sales process. In some cases you want to trigger purchasing side of it. If you know Vendor/Item association, take Vendor Master file: PM00200 and then if needed – but this is too complicated without eConnect – work with Purchase Order Processing module
Distribution Analyzing technique. Ask your GP operators to enter typical transaction and watch how it is distributed in SOP tables.
Posting process. This is usually the duty of the GP end user and in order to do posting – you have to go over the borders of eConnect limitations – eConnect creates Work documents as a rule
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies – USA nationwide Great Plains, Microsoft CRM customization company, serving Chicago, California, Arizona, Texas, Florida, Georgia, New York, Australia, UK, Canada, Germany, Continental Europe, Russia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer
Your Article Search Directory : Find in Articles
Recent articles in this category:
- Web Development Projects - Developers Tools Tips
Open source usually refers to software that is released with source code under a license that ensur - A Guide to Cnc Kits
Building a CNC machine means that you would require a lot of tools, parts or different components. - Xlphoto Printing, the Best Choice for Banner Printing and Poster Printing
Suppose, you have visited a tourist spot or a hill station; over there, you have witnessed some of - Reliable Software Programming
Software reliability is an important facet of software quality. It is defined as "the probability - Designing an Ecommerce Site
In a recent article I talked about Google AdSense placement based on eye-tracking research. Howeve - Asp.net Development Benefits
Rightway solution has been keenly looking out for. Microsoft ASP.NET is a free technology that allo - Choosing Offshore Software Development Company
To turn into successful and gain the full benefits of software outsourcing, you require preferring - E-commerce and Web Portal Development in Vietnam
VIETNAM, owing to its superior intellectual capital has emerged as the ultimate destination for - Types of Softwares
Computer software is a general term used to describe a collection of computer programs, procedur - Offshore it Out Sourcing Consultancy in Vietnam
Vendors who provide Off shore IT Outsourcing Consultancy services are referred to as outsourcing
Most viewed articles in this category:
- Oracle Applications (Oracle E-Business Suite) Customizations: What is it?
Oracle recommends every company that installs Oracle Applications to avoid any customization, but I - Offshore Outsourcing: An All Win Premise
The awareness that outsourcing can boost productivity sans forfeit of class has impelled MNC’s - Oracle E-Business Suite vs. Microsoft Dynamics AX - Axapta: LATAM and Brazil
In this small article we will only concentrate on Microsoft Dynamics Axapta (and will not consider M - SAP Business One vs. Microsoft Dynamics GP - highlights for consultant
In this small article we will not make side-by-side technical specs comparison. We would rathe - Microsoft Great Plains - licensing and product versions
Current Microsoft Business Solutions Great Plains has more that 10 years of history. Former Gr - OCR Software - Optical Character Recognition or Optical Crud Recognition?
Optical Character Recognition (OCR) refers to a software technology and processes that involve the t - Microsoft Dynamics AX - Axapta - technical notes plus customization
Axapta or current name Microsoft Dynamics AX has one of the newest ERP design and architecture among - Microsoft Dynamics AX-GP-NAV-CRM: trends and international recommendations
Microsoft Great Plains/Microsoft Dynamics GP, Microsoft Navision (former Attain) Microsoft Dynamics - Microsoft Moves to Small Business Accounting/Retail Market - stakes and thoughts
In this small article we will be looking at the new opportunities for Microsoft Small Business Serve - Microsoft Axapta - Dynamics AX: Brazilian Portuguese version - consultant highlights
Axapta/Microsoft Dynamics AX short overview. Navision Axapta was designed by Navision Software