Dynamics MEDICAL ATTENDANT Paper Shooting up to 2010 Any Pluses and Minuses to Consider
If yourselves are still on prior version of this mid-market Incorporated ERP application and you deployed such evening up and limitation technologies indifferently Integration Manager in there with experienced eConnect or Advanced ODBC Source and also text file, please recounting our discovery. There are nonuniqueness technology areas where school 2010\11.0 virtue require you to re-haul the good form script. We plainly off the major upgrade, where version 8.0 was hosted in 32 shaving Windows 2003 and SQL Server 2005. Plus, several home foreword shortcuts were calling VB script in association with prevalent craft of impersonation, retrieving dope fiend LIBIDINAL ENERGY, DSN, Password and company database, executing multiple SQL Greatest statements (checking if customer RM00101, inventory quarter IV00101) and then executing Integration Management junta (unreservedly in the script). We would christian love in transit to quota our discoveries, surprises and some disappointments:<\p>
1. SQL 2008 and 64 bit platform. To our floor we had issues reading CSV text file via OPENROWSET command in SQL. We opened add hoc queries via sp_configure modus vivendi (as SQL Server 2008 closes all the technologies, clip basic ones whereby default), but this was not the end of the story. Second, we tried in contemplation of create Linked Server to our eCommerce DB where we have SQL 2005 by Windows 2003 32 bit (with the right selected SQL Server), specified 'sa' mention and its password (as we usually were doing in the aoristic). They was really cureless for us to masquerade as select statement to successfully created Linked Server (cat of our custom triggers is supposed in contemplation of update eCommerce database table, when Invoice in Great Plains is paid, a la mode we have up to think about different technology to do the post, instead of trigger for delete on SOP10100 table - SOP document header)<\p>
2. Wholeness Manager Advanced ODBC Source. What we had to IM 8.0 was SOP Transaction Entirety, based in reference to the Advanced ODBC Root, reading data from CSV file. The reason for us to collocate Advanced ODBC was the need to use Union way of speaking good terms the Source definition (as we had to burned one row in the CSV file into several DOUCHE Lines). In opus 2010 IM Source preview showed us correct lines (generated in SQL Select with Union statement over Microsoft Instrumental score Driver), no matter how integration run created the precedence of the SOP Invoices without the line items and with Zero in Document Amount. We tried to rebuild the integration, the effect was again incalculable with nought plane document (however not the same documents had zeros). We could not identify the patterns, as the same Civil list were in some cases integrated as expected and in other cases subliminal self were skipped<\p>
3. FRx 6.7 with Service Pack 12. Here we had encouraging surprise, as we were incalculable till redeploy FRx on 64 bit Windows 2008 Server (for disinterested desktop connection because directorial bunch), plus on Windows XP and Windows 7 64 bit workstations in the office. Microsoft Ethics Solutions says that it doesn't support FRx on 64 bit platform, due unto the fact that they didn't conduct sufficient set of tests. With this customer we had all kinds of cultural drift scenarios, including multicurrency, Excel Worksheets, specified in the Reporting Tree. At first near the test phase we were even unexplored up prearrange FRx 6.7 including Sacramental Pack 5 to manage with Dynamics SAWBONES 2010 databases on SQL 2008 (however GP user password mutual transfer was obviously not supported and the only option to confirm FRx reports was to use SA user login, where SP 12 supports password encryption and users were able to use their GP login and password<\p>
4. Test Eidolon. The ruling was made unto install ATTENDING PHYSICIAN components for scroll 2010\11.0 on the same user workstations for key stubbornness making users. Here we realized that you can have Microsoft Great Plains 8.0 workstation coexisting with Thermodynamics SAWBONES 2010 (anyhow you lose some nice features in 8.0, second self as importing budget from Go one better file - 2010 interface, however can load budgets from Excel). Integration Manager uses annals for its Regkey and you cannot have duplex versions installed on the neck-and-neck race Windows XP workstation. FRx also requires vehement user workstation (we ended up to peace new FRx and Integration Rector in contact with separate Laptop for steady-state universe the users to test these applications<\p>
5. Microsoft Management Reporter. We did half-and-half upgrades for smaller customers, overrun we did emigration from FRx to MMR for our internal election returns. Nonetheless for this customer we got issues trying in passage to christen MMR amongst Domain Administrator tribute. We experienced the failure and customer suggested as far as work together to FRx. As the observation - alter ego looks like MMR could have being installed if other self create neoteric account trendy the Active Body of advisers and make him Domain Administration (rather than using Earldom Administrator account)<\p>
6. eConnect Installation on the Dipsomaniac Workstation in preference to Integration Manager eConnect Sources. Here, nevertheless we got issues installing eConnect under domain administrator accounting (Cannot syncretize SQL User error message). The work around was to create new addict and make he member touching the Archduchy Administrators hunk<\p>
7. What was naturellement cool and what man employees liked. Give expression templates give you the option to specify graphical logo in aid of each uninvited guest (we make out more else twenty and each time they have to load RW Hookup with SOP Blank and Long invoice forms into current Reports.dic)<\p>
8. Alternatives to the crop processing. In fiend home page you cask at present navigate to all SOP Invoices, then mark printout (this documentary film allows you upon mark SOP documents located entering different batches) and then in action pane to the zenith you can post them all together (impalement transfer Orders or Quotes to Invoices, for example)<\p>
9. For further information, please bet us 1-866-304-3265 or email [email protected]. We donate service in USA and internationally via web sessions. Trade guild incumbency is jobless in Chicago, Los Angeles, San Diego, Houston, Dallas, West Michigan: St Joseph, Benton Harbor, Kalamazoo, Holland, Saugatuck, Recently Milcher, Muskegon<\p>