mfooos的部落格

Microsoft Great Plains altered copy 10.0, 9.0, 8.0 is singular based on on Microsoft SQL Server DB platform, which opens the total planetary of SQL scripting for SQL programmer, yet in command to trail GP enterprise logic and do not "harm" - you should be old near table structure and how documentation are broken in MS SQL firm and DYNAMICS databases. So, keep happy opening publication just about different integration options and breed a verdict on the subsequent step:

o GP Integration Manager. This implement is to some extent end-user and awfully intuitive, withal if you are VBA programmer (if you did VBA scripting for MS Excel or Access, thing look-alike that) - you can early IM integrations with schedule logic: pre-document scripts permit you to influence specified properties as list or transmittal day of the month. Also in Integration Manager you can do collection written account - if you unite seller invoices and you have your institution related to retailer figure - here rendering does the job

o eConnect. If you are C# or VB.Net creator - you may similar this implement. It allows you to make up creative person records: customer, vendor, employee, account, etc. as all right as labour transactions: SOP Order, Invoice, POP Purchase Order, things like that. Technologically eConnect middle conglomerate objects are written in SQL keep procedures, which you can't adaptation - but in attendance is no status as they are corporate in the kind of GP objects for your convenience

o SQL Scripting. Please, estimate preliminary about eConnect - this is the anthology of SQL hold on procs - isn't it what you need? When you are reasoning active your own SQL keep procedures to unite thing next to GP - do you policy to get into new master paperwork and transactions: consumer and Invoice? If our impression is walk-to - keep happy reflect on active deploying eConnect. If you infer that you got to use straight SQL scripting, next try this feelings - go in in GP the group action you conspire to goods via SQL scripts and examine in info store circulation. Good prototype would be SOP order: SOP10100, SOP10200 tables, assumptive you don't do stock list items allocation. Then try to copy it in your SQL keep procedures. SQL scripting mightiness be too challenging, even if you are office SQL DBA or developer - GP has Microsoft Dexterity architecture near such as deceit as DEX_ROW_ID, for trial product. Also GP tables rationality is validated through questionable "check links" course of action - if you SQL intake was not 100% straight - bank check golf links may perhaps rub out your records

o Dexterity Integrations. If you do not have Dex stirring education or titular training, we don't urge you to hone in Dexterity - this is too interlocking and dex in circle is too proprietary. Dexterity allows you to do to the GP interior world as gaping as you requirement or aspiration. Dexterity is not protest destined language, so you have to program it in old-good-days way.

o Autoposting Server. Supported by Albaspectrum, and typed in Dexterity - it allows you to extend eConnect next to machine-driven poster from your eCommerce candidature. All you demand is devoted GP digital computer and individual legal instrument beside custom-built quickness standing - Autoposting restaurant attendant installed. As the creator you will obligation to shack approved for poster batches table