Articles by Andrew Karasev on ArticleSnatch.com

Microsoft Dynamics GP Nationwide Remote Support

Wed, 16 Dec 2009 16:55:19 -0500

This Corporate ERP application was also known as Great Plains Dynamics and Microsoft Great Plains, and its predecessor was Great Plains Accounting for DOS, Windows and Macintosh. Good news is - all Great Plains versions are supportable and help is close to you, just phone call away. This small publication should give you introduction about Dynamics GP web session based nationwide and international support: what is web session with phone conference number or skype phone, what is supportable remotely and what isn't, etc. In this article we tried to balance technical and functional information, so it should understandable for both IT people and Accountants: 1. Why remote support? Very good question. And the answer is different for different customers. For example, if you need quite complex customization programming and locally you have only Microsoft Dynamics GP functional consultants - natural way is to outsource custom add-on to Great Plains Dexterity developers, or Nationwide Dynamics GP Partner with Dexterity Software Development factory. Second typical reason is obsolete version and lacks of local Great Plains consulting expertise for that specific old version of GP. **End Summary** Topics: Microsoft Dynamics GP]]> Great Plains Dynamics]]> eCommerce]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum http://www.albaspectrum.com, help@albaspectrum.com 1-866-528-0577 - Microsoft Business Solutions Great Plains MS CRM Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Not-Profit, Beverages, Conglomerates, Apparels, Durables

Development for Microsoft Dynamics GP, formerly known as Great Plains: Dexterity, eConnect

Tue, 15 Dec 2009 17:19:28 -0500

Microsoft Dynamics Corporate ERP and CRM family of products includes Dynamics GP (formerly known as Great Plains Dynamics, eEnterprise, Great Plains Select on Pervasive SQL and Ctree), AX (formerly known as Axapta), NAV (known as Navision), SL (Solomon), Microsoft Dynamics CRM (this is CRM application, it might be part of Corporate ERP, but technically it is just CRM). In this publication we will be concentrating on Microsoft Dynamics GP Programming, Integration and Software Development tools: Dexterity, eConnect, Integration Manager, direct SQL Scripting and SQL Stored Procedures coding in such routines as ecommerce, EDI, Barcoding, generic integration and reporting: 1. Dynamics GP Dexterity, also referred as Microsoft Dexterity and Great Plains Dexterity. Dex is architectural fundament of Great Plains or Microsoft Dynamics GP. There is philosophical part in Dexterity, if you would like to know it - Dexterity mission to secure Computer Operating System (especially Graphical Operating System, such as Microsoft Windows, Mac, or Solaris) and Database Platform immunity (initially Great Plains was introduced on Btrieve and Ctree and quickly was expanded to cover Microsoft SQL Server DB platform). Dexterity has its own proprietary scripting and programming language Sanscript. **End Summary** Topics: Microsoft Dynamics GP]]> Great Plains Dynamics]]> eCommerce]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum http://www.albaspectrum.com, help@albaspectrum.com 1-866-528-0577 - Microsoft Business Solutions Great Plains MS CRM Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Not-Profit, Beverages, Conglomerates, Apparels, Durables

SAP Business One 8.8 for Multinational Company: Russia, Brazil, China Notes

Sun, 06 Dec 2009 18:27:52 -0500

With anticipated release of SAP B1 version 8.8 traditional separation into A and B lines will be merged. As you may know, that such languages and localizations as Russian, English, German for SB1 2007 and 2005 were in A and other languages, for example Brazilian Portuguese, Chinese were in B (SB1 2007B or SB1 2005B). Normally if you are multinational corporation with headquarters in USA, Canada, UK, or Continental Europe, you would prefer to host all your Corporate ERP application servers in the Headquarters and expose your international accounting application via Citrix or Microsoft Terminal Server (decent internet bandwidth is a norm in most of the countries nowadays). With previous versions of SAP BO you had to maintain at least two Servers, where you have SB1 A and SB1 B systems separated, however new version SAP Business One 8.8 allows you to have all international companies to be hosted on the same MS SQL Server. We plan to expand number of Web Session demos and localized versions of SAP B1 presentations in such regions as Brazil and Russia. This small publication should give you initial orientation: 1. **End Summary** Topics: Dynamics GP]]> SAP Business One]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum http://www.albaspectrum.com, help@albaspectrum.com 1-866-528-0577 - Microsoft Business Solutions Great Plains MS CRM Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical

Microsoft Dynamics GP Development: Dexterity, eConnect, Extender

Fri, 04 Dec 2009 17:41:42 -0500

If you have Microsoft Dynamics GP (earlier versions known as Great Plains Dynamics, eEnterprise, Great Plains Accounting for DOS, Windows and Mac) as your Corporate ERP, and you plan to undertake customization project, please read this small publication to get information session on Dynamics GP modification tools. We will concentrate on Microsoft Dexterity, eConnect SDK programming and Extender, as in our opinion other tools are derivative from either Dexterity or eConnect. If you need additional information on such tools as Integration Manager, Modifier with VBA, Web Services for Dynamics GP, please feel free to visit our web site or search official whitepapers on Microsoft Business Solutions portal: 1. Great Plains Dexterity, currently this Integrated Development Environment is known as Microsoft Dexterity. Dexterity was created as the shell to abstract Great Plains Dynamics from the Operating System and Database Platform layers back in earlier 1990th. Dexterity shell was programmed in C++ language, as it was common believe those days that C is operating system and computer platform independent (as in nowadays we believe that XML and HTML are computer platform independent as well). **End Summary** Topics: Microsoft Dynamics GP]]> Great Plains Dynamics]]> eCommerce]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum http://www.albaspectrum.com, help@albaspectrum.com 1-866-528-0577 - Microsoft Business Solutions Great Plains MS CRM Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Not-Profit, Beverages

Microsoft Dynamics GP ECommerce Partner in Chicago

Thu, 03 Dec 2009 17:13:57 -0500

e-Commerce web site integration is real challenge, especially when your Corporate ERP is Microsoft Dynamics GP (formerly known as Great Plains Dynamics, eEnterprise, Great Plains Select, Great Plains Accounting for DOS, Windows and Macintosh), and your ecommerce web application is PHP/MySQL/Linux or Unix/Oracle based. We are happy to connect Microsoft World with Non-Microsoft based platforms, Databases and concepts. We have several off the shelf products, as well as so-called solutions (where we are ready to deploy proven ecommerce integration codes and tune them to your business requirements). Let's take a look at typical Microsoft Dynamics GP eCommerce integration project: 1. ecommerce to GP integration frequency. Yes, you are right, this is one of the key ecommerce to Microsoft Dynamics GP integration questions or FAQ. Every customer would prefer real time or quasi real time integration (meaning that ecommerce shopping cart is sent to GP instantly or with very short time lag - let's say 20 minutes). Ideally - this is very cool, however the business is often about saving money on purchasing and in sales just the opposite - try to sell in marketing buzz as dear as possible. **End Summary** Topics: Microsoft Dynamics GP]]> Great Plains Dynamics]]> eCommerce]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum http://www.albaspectrum.com, help@albaspectrum.com 1-866-528-0577 - Microsoft Business Solutions Great Plains MS CRM Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical

Microsoft Dynamics GP Invoice Emailing Add-On Notes

Tue, 01 Dec 2009 19:16:16 -0500

If you have Microsoft Dynamics GP, formerly known as Great Plains Dynamics or eEnterprise, implemented in your organization as Corporate ERP, we would like to offer you this small publication, where we are describing our small add-on, allowing you to email Sales Order Processing invoices to your customers via SQL Mail (SQL 2005 or 2000) or MS SQL Server 2008 Database Mail. Troubleshooting SQL Mail and 2008 Database Mail, we figured out, that we have to clearly communicate to the customer, that both methods require SQL stored procedure to pick Adobe PDF file (SOP Invoice PDF print) locally on MS SQL Server 2008/2005/2000 hosting Server. This fact is clearly described in our documentation, but if you have additional questions or need installation help, feel free to check with us. Let's move on to the describing paragraphs: 1. Introduction. The Invoice Printer/Emailer module is created for printing and emailing of unposted sales invoices by batch range and/or by sales invoice number range. 2. On the Microsoft Dynamics GP menu, choose Tools >> Setup >> Sales >> Invoice Emailing Setup to display the Invoice Emailing Setup window The PDF Invoice Location is the path where the PDF invoices will be saved. **End Summary** Topics: Microsoft Dynamics GP]]> Great Plains Dynamics]]> eCommerce]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum http://www.albaspectrum.com, help@albaspectrum.com 1-866-528-0577 - Microsoft Business Solutions Great Plains MS CRM Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Not-Profit, Beverages, Conglomerates, Apparels, Durables

Microsoft Dynamics GP Support: What is Possible and What is not possible in Remote Support

Mon, 30 Nov 2009 18:28:00 -0500

Formerly Microsoft Dynamics GP was known as Great Plains Dynamics. If you are looking for second opinion in Microsoft Dynamics GP support for your organization, please consider remote support as possible option, especially in country side, where walk in local service might be limited. This article should be certain orientation in what is possible via remote support and what is not: 1. Dynamics GP or Great Plains ongoing support needs. Assuming that you left behind successful or reasonably good implementation and now your concern is system maintenance (System Backup and Recovery, casual small data repair - unlocking batches, documents), plus moderate improvement: switching on FRx reports, add business logic customization, implement integration with legacy databases and systems, design nice invoice form report with your new Graphical Company Logo, add new user licenses, purchase and implement new module - these routines are simple enough and could be done via phone and web conferences 2. What is possible via remote support? **End Summary** Topics: Microsoft Dynamics GP]]> Great Plains Dynamics]]> eCommerce]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum http://www.albaspectrum.com, help@albaspectrum.com 1-866-528-0577 - Microsoft Business Solutions Great Plains MS CRM Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Not-Profit, Beverages, Conglomerates, Apparels, Durables

eCommerce Shopping Cart Integration to Dynamics GP Sales Order Processing Transaction

Sun, 29 Nov 2009 16:52:31 -0500

Microsoft Dynamics GP, formerly also known as Great Plains Dynamics, eEnterprise, is flexible and powerful platform for eCommerce B2B and B2C Shopping Cart integration. If you are ecommerce programmer, please read this introduction level publication on integrating ecommerce shopping cart into SOP Invoice or Sales Order in Dynamics GP. Being bound by article genre rules, we will try to be reasonably laconic and balance technical (for developers and programming) and functional (for IT managers) information. We will pay some attention to Microsoft Dexterity and its possible role in GP eCommerce integrations: 1. Sales Order Processing Invoice or Sales Order as ecommerce shopping cart destination. In our opinion this object is the most natural for being considered as shopping cart destination in GP. SOP Transaction has document header, where you specify customer, doc number, dates, addresses, shipping info, tax and other document level info. Plus, it has Items lines, where you add your shopping cart items and link them with the information on availability in stock, allocation (when applicable), back ordering, or you can even have your line items as services, or non inventory items, where you are not bound by Inventory tracking. **End Summary** Topics: Microsoft Dynamics GP]]> Great Plains Dynamics]]> eCommerce]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum http://www.albaspectrum.com, help@albaspectrum.com 1-866-528-0577 - Microsoft Business Solutions Great Plains MS CRM Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas

Microsoft Dynamics GP Ecommerce Custom Solutions and Coding

Fri, 27 Nov 2009 19:19:51 -0500

If your organization has functioning ecommerce website with shopping cart, price list and credit card processing and your Corporate ERP application is Microsoft Dynamics GP - you are probably favoring the idea of ecommerce integration on the level of connectors and custom scripts, versus implementing ecommerce website from scratch on new ecommerce off-the-shelf product. If this is the case - our small publication should give you orientation session, that should be applicable to both ecommerce B2B and B2C scenarios: 1. Dynamics GP eCommerce integration tools and methods. The most simple tool is GP Integration Manager, where you setup integration to push ecommerce shopping cart to GP Sales Order Processing Invoice or Sales Order. IM is very simple if you do not need real time integration and ready to launch integration by IM operator. Second tool to consider is GP eConnect SDK, where you program ecommerce integration in C#, or VB.Net. **End Summary** Topics: Microsoft Dynamics GP]]> Great Plains Dynamics]]> eCommerce]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum http://www.albaspectrum.com, help@albaspectrum.com 1-866-528-0577 - Microsoft Business Solutions Great Plains MS CRM Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Not-Profit, Beverages, Conglomerates, Apparels, Durables

Microsoft Dynamics GP Version Update Notes

Thu, 26 Nov 2009 18:35:18 -0500

Being on the current version of your Corporate ERP application is probably not mandatory, rather good recommendation and advice. However if you are on really outdated or antiquity accounting application version, upgrade is recommended and definitely wise step to do, and there are several factors to consider, please see them below in paragraphs. In the case of Microsoft Dynamics GP or as it was formerly known Great Plains Dynamics, eEnterprise or Great Plains Accounting for DOS, Windows and Mac - upgrade has another business decision related specific as the requirement to be current in Microsoft Dynamics GP annual enhancement program. Let's begin our review: 1. Outdate Corporate ERP version. Here, even if it works OK or even exceeds expectations, please consider the following potential problems: incompatibility with new Hardware and Server Operating System (Windows Server 2008, for example), SQL Server Platform (versions prior to Dynamics GP 9.0 are not compatible with Microsoft SQL Server 2005 and 2008), new printer drivers incompatibility, etc. What happens if you need new user licenses or new modules for outdated Great Plains version which is no longer supported (8.0, 7.5, 7.0, 6.0, 5.5, 5.0, 4.0)? **End Summary** Topics: Dynamics GP]]> Great Plains Dynamics]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum http://www.albaspectrum.com, help@albaspectrum.com 1-866-528-0577 - Microsoft Business Solutions Great Plains MS CRM Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Not-Profit, Beverages, Conglomerates, Apparels, Durables

Microsoft Small Business Financials 7.5 Migration to Dynamics GP10.0 Notes

Wed, 25 Nov 2009 15:19:56 -0500

If your organization has Microsoft Small Business Financials 7.5, 8.0 or 9.0, you should think about the future of your Corporate ERP application. Small Business Financials is finalized on version 9.0 and recommended migration path is to Microsoft Dynamics GP 10.0 Business Ready with Business Essentials license model. If you are current in Microsoft Business Solutions annual enhancement program you should expect refund for the price of your current Small Business Financials, when you purchase Dynamics GP licenses. In this small publication we will give you technical highlights on migration, and what to expect: 1. Upgrade Path. You should first upgrade Small Business Financials to version 9.0. Second Step is Migration Tool: SBF->GP 9.0. Next step is preparation of Dynamics GP 9.0 for upgrade (SQL Scripts). Next step is applying Service Pack 3 or 4 for Dynamics GP 9.0. And then final migration to Dynamics GP 10.0 SP3 or 4 2. Additional steps in Dynamics GP 10.0. As Business Ready comes with multicurrency, you may decide to disable it or enable (it is enabled by default to give you the option to deploy multicurrency). **End Summary** Topics: Dynamics GP]]> Great Plains Dynamics]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum, 1-866-528-0577, help@albaspectrum.com http://www.albaspectrum.com Please visit our info portal http://www.pegasplanet.com Serving Chicagoland and Northern Illinois customers in Chicago downtown, Naperville, Lisle, Schaumburg, Aurora, Joliet, Romeoville, Downers Grove, Plainfield, Evanston, Glenn Ellyn, Wheaton, Batavia, St. Charles, Elgin, Crystal Lake, Morris, Channahon, Kankakee, Lombard, Hinsdale, Des Plaines, Gary, Oak Park, Alsip, Lyons, plus San Diego

Microsoft Dynamics GP Modifications: Extender, Dexterity, eConnect notes

Mon, 16 Nov 2009 19:02:51 -0500

If you have Dynamics GP, formerly known as Great Plains Dynamics and eEnterprise implemented in your organization, the second phase is to think about precise business logic mapping and implementing via customizations and light modifications. This small publication is to get you some initial info on such Dynamics GP modification tools, as Extender, Microsoft Dexterity and eConnect. We are trying to keep balance between being too technical and not being too "executive level FAQ". Dynamics GP is Corporate ERP, designed for mid-market, and this should mean for you that GP programming might not be apparent and if you have generic Microsoft Visual Studio C# or VB.Net programmers in IT staff, you should be realistic and not expect them to become Dynamics GP Dexterity programmers over night, over week or even over month: 1. Extender. It is the shell coded in Microsoft Dexterity. You can modify Dynamics GP with Extender by building new windows, interfaced to major GP modules, such as Sales Order Processing Transactions. In the Extender version, available directly from Microsoft Business Solutions you do not have the option to attach Sanscript Dexterity scripts to the objects. **End Summary** Topics: Dynamics GP]]> SAP Business One]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our SAP Business One call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec http://www.sva-auto.su

Dynamics GP 10.0 on Microsoft SQL Server 2008 Notes

Fri, 13 Nov 2009 18:26:18 -0500

If you plan to deploy Microsoft Dynamics GP on Windows 2008 and Microsoft SQL Server 2008, most if not all possible questions and problems are resolved automatically. There were known issues when you were deploying Dynamics GP 10.0 on Windows 2008 and Microsoft SQL Server 2005 - to name it - you had to open 1433 SQL Server listening port. However, it looks like if you are installing Microsoft SQL Server 2008, port opening is happening automatically, so Microsoft is making progress in installation friendliness. The same should be said about Microsoft Windows 7 Operating System - you can now install Dynamics GP 10.0 from its original CD1 (work around is not required, comparing to Windows XP SP3 and Microsoft Office 2003 or 2007). Plus, we tested that for Windows 7 you do not have to disable User Account Control as it was required for Vista. Obviously Windows 7 is just released for deployment in October 2009, but so far most of the feed backs are positive. Hopefully Windows 7 will lead the parade of the technologies: 1. Testing depth. We had such customizations and reporting tools in place as eOne Extender Enterprise and Crystal Reports 10.0. **End Summary** Topics: Dynamics GP]]> SAP Business One]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our Dynamics GP and SAP Business One call center, http://www.sva-auto.su

Dynamics GP Consulting Chicago, San Diego, Los Angeles: Great Plains Technology notes

Thu, 05 Nov 2009 18:46:11 -0500

Microsoft Dynamics GP, formerly this Corporate ERP application was known as Great Plains Dynamics and eEnterprise. GP implementation often requires in depth technology expertise, in such tools as Microsoft Dexterity, GP Integration Manager, Crystal Reports, eConnect, FRX Financial Reporting. For Mid-size company initial data conversion may require several cycles of test migrations, and if this is the case, your Microsoft Dynamics GP Partner should be very versatile with Great Plains Integration Manager. Plus such modules as Manufacturing, Fixed Assets, Project Accounting may require advanced integration techniques, as they have their own integration methods or require SQL post migration data touches and GP Macros to reset parameters for all master records in specific class. In this small publication we would like to share with you our consulting experience, based on our practices in Chicago, Southern California and Houston areas: 1. Dynamics GP Initial Implementation: Data Migration from Legacy Accounting application, Test Period, User Training, Reports Design, Customization requirements, programming ongoing integration with such systems as eCommerce, External Sales Order Processing, EDI, etc. 2. Special considerations to GP Customizations and Modifications. Traditionally Dynamics GP add-ons are programmed in Microsoft Dexterity (formerly known as Great Plains Dexterity). **End Summary** Topics: Dynamics GP]]> SAP Business One]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our Dynamics GP and SAP Business One call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington

Microsoft Dynamics GP eCommerce: Sales Order Processing integration and Autoposting

Wed, 04 Nov 2009 18:35:32 -0500

If you are ecommerce developer, who is integrating ecommerce web front application with Dynamics GP (often referred historically as Great Plains Dynamics or eEnteprise), you probably target SOP or Sales Order Processing Invoice as target in GP for ecommerce customer shopping cart. Customer Credit Card payment becomes customer deposit to invoice and each item purchased becomes Invoice Line item. If you are using Microsoft Visual Studio C# or VB.Net web project for ecommerce application, then natural way for you to deploy Dynamics GP sConnect libraries and SDK (help info, available in eConnect) to review and imitate code samples. This technology should work in both B2B (where you create real customer, or work only in restricted partner channel) and B2C (where you send all the invoices to so-called Walk In customer, and if required add just new Walk In folk address). In this small publication we would like to review other options and Automatic Batch posting technology directly from ecommerce eConnect application: 1. Microsoft Dynamics GP Integration Manager in ecommerce scenarios. **End Summary** Topics: Dynamics GP]]> Great Plains Dynamics]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our Dynamics GP and SAP Business One call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington

Custom Programming for Dynamics GP Notes

Tue, 03 Nov 2009 18:04:19 -0500

Microsoft Dynamics GP, or formerly this corporate ERP application was known as Great Plains Dynamics, eEnterprise, and its predecessor Great Plains Accounting for DOS, Windows and Macintosh, modern GP has vide variety of customization, integration, modification, report design tools: Dexterity, eConnect, GP SDK, Web Services for GP, Modifier with VBA. Plus you can in some cases create SQL Server View and Stored procedure (in EDI text file export or as reporting base scenarios). This small publication is intended to be an introduction. We will try to keep balance of being reasonably technical and at the same time not too technical: 1. eConnect programming for Great Plains Dynamics GP, eConnect is technology, which has encrypted SQL Stored Procedures in its foundation, and they are exposed to Microsoft Visual Studio developer via .Net libraries. Plus eConnect has SDK helper with C# and VB code samples. eConnect was introduced to Great Plains 7.XX versions as programming tool for eCommerce software developer to open Great Plains objects for ecommerce integrations: SOP Invoice (ecommerce shopping cart), Customer Deposit (credit card payment), Inventory Items (invoice lines), customer record and address. **End Summary** Topics: Dynamics GP]]> SAP Business One]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our SAP Business One call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington

Dynamics GP Technical Training: Integration Manager, Dexterity, Crystal Reports

Sun, 01 Nov 2009 15:15:59 -0500

If your organization requires custom Microsoft Dynamics GP training in such fields as Modification, Reporting, Integration, Data Conversion, ecommerce programming, eConnect, we would like to give you initial highlights on Dynamics GP technology architecture and tools. Advanced technical training is probably recommended for large organization, where you have to develop unique in-house ecommerce website, automate supply chain management processes (automatic packaging, barcode scanning in picking and delivery), advanced Electronic Document Interchange (EDI) integrations. Some of the tools, such as Microsoft Dynamics GP Dexterity is recommended for outsourcing to GP Technology Partner and if you absolutely need Dexterity customizations - these are not easy and not ready for quick learning curve for in-house developers. If you have huge internal Dexterity development project, then you may consider training your own programmers in Dex. Let's begin tools review and training methodologies: 1. Integration tools. GP Integration Manager is recommended to all GP customers, as it could be considered as end user friendly plus it has advanced integration even driven scripts and other methods to create very complex and sophisticated integration. **End Summary** Topics: Dynamics GP]]> SAP Business One]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our SAP Business One call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington

Dynamics GP Remote Support via Web Sessions and Phone Conferences

Sat, 31 Oct 2009 16:13:34 -0400

If you have Microsoft Dynamics GP 10.0, 9.0, 8.0 or Great Plains Dynamics 7.5, 7.0, 6.0, 5.5 on Microsoft SQL Server, Pervasive SQL 2000 or Ctree, or older version of Great Plains Accounting for DOS or Windows 9.5, 9.2 or earlier, we would like to offer this small publication to your consideration, where we are featuring remote support for Dynamics GP. This option is especially beneficial to large corporations with offices across the USA and internationally and to customers in USA and Canada countryside, where local service might be not available to not too advanced. We are specializing in Dynamics GP, SAP Business One, Microsoft CRM, Lotus Notes Domino, Microsoft Retail Management System (Microsoft RMS) USA nationwide and internationally: 1. How remote support works? Do you need conference room with expensive phone and video conferencing equipment? No, we just need you to have your computer with Windows XP, Windows 2000, Windows 98, Vista or Windows 7. We can always call your office phone, or if you are located internationally, we can call your skype number. Web conferencing software, it is Microsoft Internet (or Chrome, or Firefox) add-on. **End Summary** Topics: Dynamics GP]]> SAP Business One]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our SAP Business One call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington

Dynamics GP and SAP Business One Tandem as Corporate ERP for Multinational Firm

Thu, 29 Oct 2009 19:21:26 -0400

This small publication is intended to current Microsoft Dynamics GP Great Plains customers, who are expanding internationally and would like to choose ERP system for relatively small foreign subsidiary. As you know Dynamics GP is localized in English speaking countries (including South East Asia, where English is the used in business), plus in Quebec (in French Canadian), to some extent in Spanish speaking Latin America and Caribbean states, Oceania. There is good support for Arabic in GP (with some options for Dari and Persian as alphabet is the same). If your subsidiary is located outside of the area, especially if you need hieroglyph characters support (China, Japan, Korea), or support in Russian, we recommend you to consider SAP Business One. You can host both Dynamics GP and SAP B1 on the same SQL Server with SB1 version 8.0 (2005 and 2007 versions had A and B releases and you normally would install them on two separate SQL Servers): 1. Corporate ERP localization. It has two aspects: local language adoption (screens are translated, plus you can enter documents in local language) and compliance to local legislation (tax reporting, invoice required fields, etc.). **End Summary** Topics: Dynamics GP]]> SAP Business One]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our SAP Business One call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington, Missouri

Dynamics GP Implementation for Large Corporation: International ERP Notes

Wed, 28 Oct 2009 18:47:22 -0400

If you have Microsoft Dynamics GP (formerly referred as Great Plains Dynamics, eEnteprise, Dynamics C/S+) implemented in large company, which is expanding internationally, you should know your options in catching up with multinational Corporate ERP. Dynamics GP has its pluses (and minuses) and this small publication should help you with initial research. We will try to be maximally laconic, as subject is very broad and requires numerous pages: 1. Foreign Language characters notes. Dynamics GP is coded with ASCII standards consideration. If you are in the country, where Latin characters are used without accent marks, and these countries are English speaking: USA, Canada, UK, Australia, New Zealand, Oceania, some countries in South East Asia (where English is the language of business), then your alphabet is ASCII compliant. If you use accents in Latin alphabet (Spanish, Portuguese, French, etc.), then you are also fine with ASCII standard and you use characters over 127 (or in the second bit of the one byte, reserved by ASCII). **End Summary** Topics: Dynamics GP]]> SAP Business One]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our Dynamics GP and SAP Business One call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec

Dynamics GP Ecommerce Batch Automatic Posting

Tue, 27 Oct 2009 18:25:08 -0400

If you are eConnect ecommerce programmer and your goal is to do all the way directly from ecommerce web application code: Create New customer, Create Shopping Cart (probably equal to Sales Order Processing Invoice), Get Customer Credit Card Payment (deposit against Sales Order or Invoice) and finally post individual transaction or the whole batch of transactions from the customer. Transaction or Batch posting functionality is not available in Microsoft Dynamics GP eConnect SDK. In this small publication we would like to review Add-On, which should allow you to post batches directly from your ecommerce web front: 1. Dexterity programmed Posting Server. This application was developed in Sanscript programming language of Dexterity with detail reference to Dexterity internal scripts. This Server in fact calls the same Dexterity procedures, which are called by batch posting directly in Dynamics GP user interface (this technology allows Posting Server be bugs free, as we are not replicating the logic of batch posting, as directly using original posting scripts) 2. How to deploy Posting Server. You should dedicate special computer (or run one Dynamics GP workstation directly on the server ) with Posting Server add-on installed and integrated. **End Summary** Topics: Dynamics GP]]> SAP Business One]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our Dynamics GP and SAP Business One call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington

Dynamics GP Sales Order Processing Table Structure Notes

Mon, 26 Oct 2009 17:33:36 -0400

If you are Crystal Reports designer, or programmer who needs Microsoft Dynamics GP data export into EDI or XML interchange format, we would like to give you small introduction into Great Plains SOP module tables structure. We would also like to inform you that if you plan to feed in data into SOP tables via SQL insert statements, the idea is not that great, as you may violate business logic and compromise data integrity. For importing data into Dynamics GP in general, please consider Integration Manager (for end user friendly data conversion), or eConnect SDK (for direct programming, in eCommerce web application for example): 1. Work and Historical transactions. When you create Quote, Sales Order, Invoice, Return in SOP and place them into the batch for review and posting - these transactions are in Work phase, and when you post the batch (or individual transaction) then related transactions change the status to Posted and becomes historical. Work tables has prefix SOP1 and posted have prefix SOP3 2. Master records. SOP module works with several modules, from where master records are taken: Inventory control (IV00101 inventory item master), Receivable Management (RM00101 Customer Master table) 3. Table Structure Self Discovery. **End Summary** Topics: Dynamics GP]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our Dynamics GP and SAP Business One call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington

Dynamics GP Dari Language Support Options Recommendations

Sun, 25 Oct 2009 14:33:30 -0400

It looks like there is certain interest in Afghan economy recovery, especially for funded state enterprises in Kabul, to implement brand name Corporate ERP System. For mid-size and large operations you can chose one of the lower mid market ERP applications (as for large Corporate ERP system the cost of localization might be very high), such as Microsoft Dynamics GP, formerly known as Great Plains Dynamics, or its competitor SAP Business One (SB1 supports Unicode and Dari/Persian/Arabic characters, however in GP it is probably easier to place pictures with Arabic text on the existing screens with GP Modifier or Dexterity modifications). In this small publication we will be describing Microsoft Dynamics GP adaptation to Afghan accounting system: 1. Arabic characters support. Here you will need the extension to Dynamics GP, which is in use in Arabian peninsula. Characters should be reasonably the same in Dari and in Arabic as well as in Persian in Iran. **End Summary** Topics: Dynamics GP]]> Great Plains Dynamics]]> SAP Business One]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We are happy to help you with Dynamics GP project in Afghanistan, Iran, Tajikistan, Uzbekistan, Turkmenistan, Kazakhstan, Kyrgyzstan, Azerbaijan, Armenia

Dynamics GP Great Plains International Implementation: Afghanistan notes

Sat, 24 Oct 2009 17:59:40 -0400

With Arabic letters extension module, Dynamics GP could be deployed in Dari for customers and branches of multinational corporations in Kabul. We assume that you are familiar with Dynamics GP generic implementation and with such technologies as Great Plains Dexterity, Integration Manager, Modifier with VBA, eConnect. This article gives you highlights on international specific for Dari and Persian languages. We recommend the following options and directions: 1. Dynamics GP screens in Dari - attach graphical images of simple Dari text on critical GP forms: SOP Entry, POP Purchase Receipt, GL transaction, AR and AP invoices, Customer Payment, Apply Customer Payment to Invoice. We do not recommend Dexterity string resources translation to Dari or Persian, as you will face Unicode incompatibility issues 2. Crystal Reports or SSRS for printing Sales Invoices, Packing List, Picking Tickets, Purchase Orders. There are Dynamics GP add-ons available for automatically launch CR from GP, or they could be called via VBA scripts (Dynamics GP Modifier with VBA) 3. Dari alphabet characters storing in Dynamics GP Database. In Microsoft SQL Server you can change code page and collation on the table level, and you can create Dari language characters compatible tables. **End Summary** Topics: Dynamics GP]]> Great Plains Dynamics]]> SAP Business One]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We are happy to help you with Dynamics GP project in Afghanistan or Iran

FRx for Dynamics GP Great Plains Recovery notes

Fri, 23 Oct 2009 19:20:29 -0400

If your organization deploys old version of Great Plains Dynamics or eEnterprise: 7.5, 7.0, 6.0, 5.5, 5.0 or earlier and your user workstation, where you had FRx client installed crushed, we would like to recommend you several steps in FRx reinstallation and repair. In the case of eEnterprise your Database is likely MS SQL Server 2000 or 7, older versions of high end Dynamics we also known under Dynamics C/S+ name. If you are on Dynamics GP 8.0, 9.0 or 10.0 (current version as we are writing these lines in October 2009), FRx recovery issue is simple as all you need to do is to install FRx 6.7 and apply relevant service pack (for GP 10.0 FRx SP10 or 11) - all these service packs are available for download at Microsoft Business Solutions Partner Source (or if you have current service plan with MBS, you can download them from Customer Source pages). We will concentrate on the most challenging in FRx recovery versions 6.0 and earlier: 1. Identify your Great Plains Dynamics version. Open help->About Great Plains Dynamics. If you are on Dynamics 6. **End Summary** Topics: Dynamics GP]]> Great Plains Dynamics]]>]]> About the Author: ]]> Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.sva-auto.su