18 AugDynamics GP SQL Scripting and Reporting

Article by Andrew Karasev

If you are experienced SQL developer or Microsoft SQL DBA with reasonable exposure to Transact SQL ad-hoc querying and if you are working for the organization, where Corporate ERP system is implemented on Microsoft Dynamics GP platform, your skills might be very valuable for internal Great Plains support. Even if you are on older version of Great Plains Dynamics on MS SQL Server and even Pervasive SQL 2000/Btrieve or Ctree, you can still access the database directly in SQL Server Management Studio, or via ODBC connection (Linked Server, especially when you are on ODBC compliant DB, such as Btrieve). Let

12 AugeCommerce B2B and B2C integration with Microsoft Dynamics GP technology notes

Article by Andrew Karasev

eCommerce existing websites with shopping carts, customer specific price lists and items catalogs integration projects are in rapid expansion mode, especially considering huge number of Great Plains Dynamics GP installations USA and Canada nationwide and internationally: Spanish Speaking Latin America, UK, Australia, New Zealand, South Africa, Oceania, English speaking South East Asia. This small article targeted to mid-size businesses IT departments, considering complete or partial ecommerce application integration to Dynamics GP, formerly known as Great Plains Dynamics and eEnterprise:

1. eCommerce integration technologies. Dynamics GP eConnect is perfect tool for Microsoft Visual Studio ecommerce programmer, it has scenarios and code samples in C# and VB, so feel comfortable to deploy your programming language of choice. In eConnect you probably want to program real time ecommerce shopping cart and customer invoice integration. If you are OK with batch level integration: one time per day or every hour or even every twenty minutes, please consider Dynamics GP Integration Manager. In this article we would like to share our philosophy, where we are trying you first to consider out of the box tools and modules, before you begin considering Dynamics ISV Partners Add-Ons and Custom Modules. eCommerce is not an exception from general Corporate ERP Implementation rule, where you stay away from customizations and third party products and try to consider native functionality and technology on the first place. As you know Dynamics GP ERP application requires customer participation in MBS Dynamics annual enhancement program, and each Dynamics GP ISV partner has its own annual enhancement program, and this simple fact may make your life really dependent on membership extension dates

2. Dynamics GP ISV Partners eCommerce Solutions selection process. If you think that Dynamics GP Integration Manager does not do the job for your ecommerce shopping cart integration, and eConnect SDK is too complex for your IT department programmers, or learning curve is too long, please consider Great Plains Partners maintained Add-ons, sometimes referred as GP Satellites/ Let’s talk about Dynamics GP ecommerce add-ons. Alba Spectrum offer wide range of products: Dynamics GP Posting Server (allowing you to post GP batches directly from ecommerce application code, as the reminder – eConnect cannot post Great Plains Batches, this logic is reserved architecturally to GP user), Great Plains Order Connector (where we are adding new Accounting and Corporate ERP applications to the list of connectable systems). Order Connector has multiple popular ecommerce templates and shopping cart integration plug ins, please check with us for details

3. B2B ecommerce integration via Microsoft Dynamics CRM 4.0. Here you have out of the box functionality, which allows you to integrate Customer Quotes and Sales Orders directly to Dynamics GP Sales Order Processing Module. There are add-ons for MS CRM, allowing you to run it as simple B2B ecommerce portal. If you do not have MS CRM implemented in your organization and you are not familiar with MS CRM as a user, please go on to the next paragraph

4. Dynamics GP Business Portal. We are enthusiasts of Microsoft Dynamics Business Portal. Even if at this time it is limited in its functionality and Dynamics GP ecommerce ISV partners could offer better logic, in the long run we are staking on native Microsoft Dynamics Business Portal solution. At this time, October 2009 we feel that we are one of the leaders pushing Dynamics GP Business Portal Modules: Electronic Document Delivery, Order Management, Requisition Management (with Requisition Approval Hierarchy), Human Resources Employee Self Service (Pay Stubs and W2 reports printing). There are several competing clones to Dynamics GP Business Portal Requisition management and Order Management modules from Dynamics GP ISV partners, we recommend you to take conservative approach. In GP Business Portal, please review Order Management module, as it is intended for B2B ecommerce

5. Dynamics GP ecommerce for legacy Great Plains Versions. If you are without Microsoft Business Solutions Annual Support and you still use old Great Plains Dynamics versions 8.0, 7.5, 7.0, 6.0, 5.5, 5.0, 4.0 3.2 or Great Plains Accounting for DOS, Windows and Mac (often referred as Macintosh), we strongly recommend you to upgrade first to Dynamics GP Version 10.0 or 9.0, where eConnect SDK came to its maturity. In our opinion it doesn’t make sense to program Great Plains eCommerce to pull data from GPA for DOS Btrieve tables. However we respect your opinion and case, if you have old Great Plains version, please give us a call: 1-866-528-0577

6. How to get help? Please, feel free to call us: 1-866-528-0577, outside of USA: 1-630-961-5918 or email us help@albaspectrum.com We are very technical and real Dynamics GP Dexterity, SAP Business One SDK programming gurus. We have Great Plains Software Development Factory and could support unlimited Dynamics GP Customization and Programming needs. Plus we speak English, Chinese, Spanish, Portuguese, Russian, and not only as native speaking sales folks, but as real technical consultants. If you prefer skype: albaspectrum

08 AugHTC Desire HD vs HTC Desire Z- Same Features, Different Design

Article by David boon

HTC Corporation has launched a very long range of superb smart phones based on Microsoft Windows Phone 7 and Android. HTC Desire HD and HTC Desire Z are two amazing handsets from the huge heap of HTC mobile phones. Both handsets are boasted with almost similar features but thy differ in their designs and looks.HD and Desire Z are the software upgrades(running Android v2.2, Froyo) of HTC that runs Android v2.1(

21 MayBest IT Solution to Handle your Computer

In an era where computers become one physical entity that most sought-after by human kind, it is important for us to immediately find a company that can manage these entities in better way, especially if you are someone who runs a company or engaging in particular business. With the aim to manage the computer network in a company, ASG IT has become one of the providers which willing to give computer repair CT services, which it can be trusted and has a good reputation.

ASG has been running for 14 years, and during that time, they are able to handle various problems of which related to computers. This company especially addressed their service for those whom engage business in Connecticut. In its development, they are not only able to provide computer repair services, but also provide network security CT services, which the latter has an important role to prevent some threat, whether arising from internal causes, as well as external causes.

Because of its ability, the ASG also complements its services with a number of software that serves to support the computer network in a company. Some products that manufactured by several company as Microsoft, HP, Sonicwall, and so on, are several types of software installation CT which used by the ASG to provide satisfaction for its customers.

26 AugWhy It’s Important to Update Drivers on a Regular Basis

Do you know what driver is? Driver is something that we always need to communicate with the operating system on your computer. You will need datel drivers to give and talk to the hardware and software when you want to use a program with your computer like games, internet, Microsoft word, excel, and so on.

All you have to do in order to use them well is always update the gemplus drivers regularly. If you have an outdate driver, then you can make your computer to break down. You will get error message and the software program cannot work properly for sure. As a result, you will be prevented from using your own computer.

If you do not update your computer driver, you will often get some technical phrases that seem like foreign language. You see, an outdated driver is always causing problem to your computer. Furthermore, you should know that windows will always update the operating system regularly for sure. When you have a new device, there is a possibility that your computer will give you some error message. This is because your computer has the old driver. Therefore, you need to get the newest driver so that your operating system is able to work properly with the proper codes. If you download the drivers that suit your new software or product, then you can give instruction well to your computer.

When you have the outdated driver, you will also get problem when you shut down your computer properly. Usually the expired driver always gives you problems. There are multiple problems you will get because of the outdated drivers.

For information, the easiest way to update your driver is downloading high quality software of driver updating. With this software, you do not need to check anything since it will scan your entire computer system automatically.