SQL Stored Surgeries. Obviously you have unlimited control and possibilities with SQL queries. You need to know Great Plains tables structure and data flow. Launch Great Plains and check out Tools->Resource Description->Tables. Find the table inside the proper sections. If you are looking for the customers - it ought to RM00101 - customer master file. Should you require historical Sales Order Processing documents - they acoustic treatments tend to be SOP30200 - Sales History Header file, etc. Don't change existing tables - do not create new fields, If you have any kind of questions concerning where and ways to use environmental Noise Monitoring, you could contact us at the page. etc. Also you need to realise that each GP table has DEX_ROW_ID - identity column. Sometimes it is good idea to use inbound/outbound XML in the parameters - then doable ! deploy web service being a middle party between two systems.