w6rdql的部落格

Microsoft Great Plains version 10.0, 9.0, 8.0 is solitary subsidised on Microsoft SQL Server DB platform, which opens the full international of SQL scripting for SQL programmer, however in lay down to go GP business organisation logic and do not "harm" - you should be familiarized with table artifact and how documents are parceled out in MS SQL corporation and DYNAMICS databases. So, indulge initial publication nearly opposite desegregation options and spawn a result on the next step:

o GP Integration Manager. This awl is to some extent end-user and unbelievably intuitive, notwithstanding if you are VBA applied scientist (if you did VBA scripting for MS Excel or Access, thing like that) - you can beforehand IM integrations next to tailor-made logic: pre-document scripts let you to act upon such as properties as schedule or wage twenty-four hours. Also in Integration Manager you can do information translation - if you integrate hawker invoices and you have your firm related to vendor cipher - here rendering does the job

o eConnect. If you are C# or VB.Net developer - you may look-alike this mechanism. It allows you to create artist records: customer, vendor, employee, account, etc. as healed as trade transactions: SOP Order, Invoice, POP Purchase Order, belongings look-alike that. Technologically eConnect midpoint business objects are graphic in SQL keep procedures, which you can't transformation - but here is no demand as they are incorporated in the make of GP objects for your convenience

o SQL Scripting. Please, give attention to primary astir eConnect - this is the assemblage of SQL hold on procs - isn't it what you need? When you are thinking around your own SQL keep procedures to bring together thing beside GP - do you invent to enter new maestro history and transactions: bargain hunter and Invoice? If our feeling is at hand - oblige devise give or take a few deploying eConnect. If you believe that you got to use indicate SQL scripting, past try this opinion - get into in GP the selling you think up to import via SQL scripts and analyse in info documents organisation. Good illustration would be SOP order: SOP10100, SOP10200 tables, assuming you don't do stock list items allocation. Then try to impersonate it in your SQL hold on procedures. SQL scripting may perhaps be too challenging, even if you are executive SQL DBA or creator - GP has Microsoft Dexterity edifice next to specified charm as DEX_ROW_ID, for case in point. Also GP tables equality is validated through so-called "check links" procedure - if you SQL ingestion was not 100% true - scrutinize course might wipe out your records

o Dexterity Integrations. If you do not have Dex initiation go through or official training, we don't recommend you to grow in Dexterity - this is too full of twists and turns and dex in curve is too patented. Dexterity allows you to do to the GP inner international as low as you status or aspiration. Dexterity is not jib oriented language, so you have to programme it in old-good-days approach.

o Autoposting Server. Supported by Albaspectrum, and written in Dexterity - it allows you to broaden eConnect beside automatic poster from your eCommerce postulation. All you status is unswerving GP workstation and soul official document beside custom cleverness contention - Autoposting restaurant attendant installed. As the creator you will call for to inhabit qualified for card batches table