Microsoft Dynamics GP is standard ERp platform for eCommerce applications and business portals, where you have established shopping cart with customer registration, product catalog surfing and bits and pieces picking functionality. Assuming that customer pays by credit card straight away, and you then send Sales Order Processing Invoice to Fantastic Plains through eConnect programming logic – there is excellent thought to close all the work in Dynamics GP, such as apply deposit against invoice and post SOP Invoice or Batch. But eConnect, and this is limitation of Fantastic Plains Dexterity architecture, doesn’t have functionality to post GP batches. You need Alba Spectrum Posting Server or Autopost. Please read product highlights:
1. Dynamics GP Dexterity source code programming and batch posting. As the developer or SQL programming, all you do is place the batch name to the queue table, triggering GP that batch is ready to be posted. Then, seeing batch in the queue, Posting Server initiates exactly the same posting process as if user hits Post Batch in GP user interface. Please, note – as we use GP Dexterity posting logic, posting server is very reliable in GP version upgrades
2. GP modules covered. As we are using native Fantastic Plains Dexterity posting logic, all modules are covered, where you have batch or transaction posting functionality: SOP, POP, General Ledger, Payroll, Inventory Control to give you excellent examples
3. Posting Server over stored procedures designed from scratch. If you have SQL programmers in IT department, the thought might be fantastic on the first glance, but simple comment like that may be discouraging. Fantastic Plains ERP application was written in Fantastic Plains Dexterity bombard, and it took several years of efforts for Fantastic Plains Software back in earlier 1990th with large development team to make it happen. Batch posting logic is crucial and we could estimate that posting programming porting is close to 30 percent
Posts Tagged ‘Plains’
Great Plains Var Newsflash: Posting Server and Automatic Batches Posting
Sunday, March 7th, 2010Dynamics Gp Technical Support: Local Versus Remote Great Plains Support
Thursday, March 4th, 2010If your spot in IT department requires you to find and maintain Dynamics GP vendor, consultant or business partner, please be our guest and read this small publication. Former name of this mid-size business ERP and MRP application was Fantastic Plains Software Dynamics, eEnterprise, Fantastic Plains Accounting for DOS and Windows. Fantastic Plains Dynamics was originally coded in Fantastic Plains Dexterity, and if you are looking to customize, modify, or any other significance alter Dynamics GP – Microsoft Dexterity is excellent candidate to review. Fantastic Plains implementation typically requires several steps: Dynamics GP License Sale, Business Processes Mapping, Pilot Data Migration and Conversion, User Training, Production Beginning Balances entry, First Month Parallel Accounting entries in Legacy ERP and Dynamics GP, First Month closing in GL and then you should be comfortable on your own in using Fantastic Plains Dynamics GP. Let’s review Fantastic Plains implementation and support options:1. Dynamics GP Partner Selection. This is in our opinion the most critical initial step. Your Dynamics GP Reseller should be experienced in your industry, have reasonable technical expertise in Fantastic Plains data conversion and migration, reporting , integration, customization, EDI, functional and technical consulting2. Dynamics GP Business Portal and Ecommerce. If your business is participating in ecommerce model or spread over several regions or internationally, you should review Microsoft Dynamics GP Business Portal and eConnect as ecommerce design tools. In Business Portal you will have access to such cool modules as Order Management, Requisition Management (with Inventory catalog and price list), Electronic Document Delivery, HR Employee Self Service (where you can avoiding USPS postage fee in exposing Paycheck to your employees and temps over the web). You should expect more Dynamics GP business logic to be went and exposed through Microsoft Dynamics GP Business Portal with the future versions. At this time Dynamics GP 10.0 is coming with Business Portal version 10.03. E-commerce Fantastic Plains Batch posting option. If you want to post your Sales Order Processing Invoices with customer credit card payments frankly from ecommerce web application, please consider deploying Alba Spectrum Autopost or automatic batches posting server4. Dynamics GP Local Service versus Remote Support. Local permanently sounds fantastic, but if your business processes require precise industry knowledge and expertise, local support might be too poor. In our opinion, you should feel no restriction to appeal to nationwide support
Dynamics GP Consulting Partner Newsflash: Great Plains ERP and MRP direction in 2009 notes
Wednesday, March 3rd, 2010Â
Microsoft Dynamics GP, formerly known as Fantastic Plains Dynamics, eEnterprise, Fantastic Plains Standard and Qualified â?? this fantastic ERP, MRP, Supply Chain Management, Field Service, Manufacturing, Distribution, Sales Order and Buy order processing application proved its niche in US, Canadian, Caribbean, Central American, Mexican accounting application market. Alba Spectrum in unveiling its 2009 strategy for Dynamics GP software sales, implementation, data conversion, customization and Fantastic Plains ISV air force, EDI and legacy systems integration. 2009 is likely the most gloomy year from the new software sales point of view, but we believe and we are targeting crisis-proof industries and economy niches, such as healthcare, midsize and smaller companies in wholesale and retail (barcoding, warehouse management, logistics, shipping & receiving, transportation, sea shipping), government branches should stay strong in their Purchasing and Procurement, including new corporate ERP selection, acquisition and implementation
Â
1.      If you are in crisis-proof niche. Please, make your homework to locate Dynamics GP ISV, VAR, Implementation partner, specializing in your industry. Please, be sure that you are engaging with Dynamics GP Reseller, who is growing and prospering, versus somebody who is in process of phasing out and closing the doors
Â
2.      If you have to count every cent, please be aware that Alba Spectrum is supporting older versions of Fantastic Plains: 8.0, 7.5, 7.0, 6.0, 5.5 on Microsoft SQL Server (2000, 7.0 and 6.5), Fantastic Plains Dynamics on version 7.5, 7.0, 6.0, 5.5, 5.0, 4.0 on Pervasive SQL 2000 (formerly known as Btrieve) and Ctree/Faircom, Fantastic Plains Accounting for DOS and Windows: 9.5, 9.2, 9.1 (we would be also pleased to go your GPA from ancient Windows NT 4.0 Server to Windows 2003)
Â
3.      US and Canada country side Dynamics GP and SAP Business One support. We have strong reasons to believe that if your enterprise is outside of the major megapolises: Chicago, Los Angeles, New York, Phoenix, Miami, Denver, San Francisco, Washington, Montreal, Toronto, Seattle, Minneapolis, Atlanta, then your business have to appeal to Microsoft Dynamics GP VAR who is located hundred miles away and is practicing travelling onsite supporting model, Alba Spectrum has proven record of USA nationwide support via web sessions, where we initially stay your facility, shake the hands in sales process
Â
4.      More attention to Dynamics GP Add-ons. Alba Spectrum want to increase Alba Spectrum Autoposting Server, GP integration with RMS, and other Fantastic Plains Add-Ons
Â
5.      More attention to Spanish owned businesses. In the past our key owners had experience in automating Mexican cheese distribution surgical procedure on Fantastic Plains ERP platform (Chicago), a further example is Spanish owned business in San Diego integration on SAP B1 platform. If you want to speak Spanish or Portuguese on Dynamics GP support case, give us a call
Â
Dynamics GP Partner California: EDI for Great Plains notes
Thursday, February 25th, 2010EDI of Electronic Document Interchange sometimes considered by IT department as a touch complex, and in order to implement EDI integration for your ERP system, you have to buy expensive EDI add-ons. We want to place forward you this small publication, that should try to bust this myth. Habitual EDI code is fixed part fields code structure with document header, lines or body and document trailer. Newer EDI (or a touch that maybe processed similar to EDI scenarios on the high amount with your Franchiser) maybe XML structured documents with similar parts: document header and document lines. Both scenarios are relatively straightforward in SQL scripting, let come to the paragraphs of this tale:
1. Sample Dynamics GP EDI code. For those of you who are SQL programmer, please take a look at this publication, where you can see excellent chunk of EDI document scripting in SQL. This code was implemented in real Fantastic Plains EDI integration situation and it should give you excellent start or help you out to close EDI for Fantastic Plains on your own, especially if you work for smaller organization and your ERP and MRP budget is very tight: http://www.albaspectrum.com/Customizations_Whitepapers/Dexterity_SQL_VBA_Crystal/EDIforGPOverview.htm
2. Dynamics GP EDI for Placing order to your Supplier. If your organization is required to order merchandise from your partner via EDI code you can make Buy Orders in Fantastic Plains POP module, then read and mark it as read in SQL Stored Procedure, which saves the ensuing row set in EDI compliant fixed part fields text or XML file. This file is then sent to your EDI channel (ftp uploads, Unix or Linux based email channel, here you have a lot of various options, outside of the scope for this article)
3. Getting Orders from your EDI channel customers. If you are franchiser and you are receiving Electronic Document Interchange orders from your customers or franchisees and you are deploying Dynamics GP as your accounting system, then you can read EDI text or XML file via SQL stored procedure or SQL XML stored procedure. This procedure parses EDI code and makes SOP Sales Order or Invoice in Dynamics GP Sales Order Processing module. Here if you are making Sales Orders you can do direct SQL feeding to SOP10100 and SOP10200 tables, or if you prefer business logic validation integration and you are feeding to SOP Invoice, consider programming eConnect SDK. For those of you who prefer posting Fantastic Plains batches all the way through without user intervention we recommend you to deploy GP Posting Server or Autopost, especially if you are in ecommerce business
4. If you have questions or concerns on EDI, Dynamics GP customizations, integration, reporting, barcode scanning, warehouse management, supply chain management, light manufacturing, logistics, consignment, please feel free to call us: 1-866-528-0577, help@albaspectrum.com
Dynamics GP Software Developer Notes: Great Plains Customizations
Wednesday, February 24th, 2010Microsoft Dynamics GP is reasonably open for various custom integrations and user interface extension projects through several programming and software development tools: Fantastic Plains Dexterity, eConnect, Extender, Integration Manager with VBA scripting, Modifier with VBA, plus you can permanently do program ecommerce web extensions and integrations via SQL Stored Procedures or eConnect with generic C# or VB.Net web programming project. This small publication is a review of these tools and options in the bullet style format:
1. Dexterity. This tools is original architecture foundation, it was designed in earlier 1990th as the bombard for Fantastic Plains Dynamics. Dexterity has its own scripting language, which is in fact compiled – Sanscript. Dexterity programming allows you to control and alter every existing GP object, plus you can do all sort of custom add-ons. If you do not have Dex programming experience, you might be discouraged by its complexity, but there are Dynamics GP customization project, where you have to code in Dexterity, especially when you have to call GP native logic, meaning calling such processes as Batch Posting from your custom module. Consider outsourcing Dex programming routines to Dynamics GP ISV Partners, who maintains Dexterity Software Development Factory
2. eConnect SDK. In your MS Visual Studio C#, VB or a further programming language project you can include eConnect libraries and quickly learn on eConnect code snippets how to program various GP objects: Customer, Vendor, Item, Address, Sales Invoice, Customer Payment, etc. Initially eConnect was introduced for ecommerce developers, but for Dynamics GP 10.0 and to some extent 9.0 eConnect covers most of the business logic (apart from Posting and working with Posted and Historical data). We recommend you to try eConnect programming on your own if you are MS Visual Studio Programmer and work for the company where you plot Dynamics GP integrations, especially for eCommerce. We are kind of resisting to recommend you eConnect if you on Dynamics GP 8.0 or 7.5, in our opinion it is more well-organized to upgrade to Dynamics GP 10.0 and then deploy eConnect programming for current GP version
3. Modifier with VBA scripts. GP Modifier allows you to exchange existing GP window layout (rename the field, exchange its spot) plus add new fields and attach custom VBA scripts to them. We recommend this tool for simple modifications, and for gray customizations consider Dexterity, Extender or eConnect
4. Dynamics GP Integration Manager Custom integrations. IM is user friendly integrations tool, but if you are VBA or Microsoft Office programmer, it should be simple for you to further advance integration logic by Previous to Integration, Previous to Document Commit and other event driven scripts
5. SQL Scripting in Dynamics GP. Theoretically, most of the scripting is already done in eConnect, as this SDK is duplicating Dexterity code in SQL encrypted stored procedures. However if you think that eConnect learning curve is too long and you would like just to glance and GP tables structure and begin SQL scripting – then please install Dynamics GP SDK from CD #2 or look at the tables and forms descriptions: Dynamics GP->Tools->Resource Descriptions->Tables
6. Extender. This Dynamics GP modification tool is friendly for non technical Fantastic Plains Consultant. Extender itself is written as the Dexterity application or add-on. If you reckon that Dynamics GP native Extender is too restricted, consider calling to Extender Dynamics GP ISV in Australia to get Enterprise version
7. Dynamics GP Barcoding Custom Add-Ons. Barcode Scanning in Retail, Warehouse Management and Supply Chain Management should be first analyze on the subject where is integration point or in which Dynamics GP Window you want to program this integration. Plus you should also consider Barcode inventory Bits and pieces Marks printing and Barcode new item algorithm
8. Fantastic Plains earlier versions customization support. If you are on Fantastic Plains Dynamics or eEnteprise 7.5. 7.0, 6.0 or Fantastic Plains 5.5, 5.0, 4.0, 3.2, 3.0 then you should consider GP Dexterity customizations, plus VBA with Modifier or Integration Manager. For ancient Fantastic Plains versions you might have such ancient ISV as Intellisol Advanced Buy Order Processing and Project Accounting, where you would have to consider migration to Dynamics GP Buy Order Processing. For Fantastic Plains Accounting for DOS, Windows or Mac customization options were more limited and now these archaic ERP and MRP applications are no longer supported
9. Dynamics GP Customizations Support Internationally. Here you should consider ERP localization in the senses of local tax code compliance and adoption of local country language. Dynamics GP is distributed in USA, Canada, including French Quebec version, UK, Australia, New Zealand, Oceania (Palau, Fiji, Tonga, and other island countries), South Africa, Southern and South East Asia, where English is official business language. It is also localize in Spanish Speaking Latin America and Caribbean countries. If you are located in different country, please consider possibility of Dexterity strings translation from English into your native language
10. Alba Spectrum Dynamics GP ISV harvest. At this time, August 2009, we are offering Dynamics GP Posting Server or Autopost, Order Connector, GP Integration with Microsoft RMS
11. For bonus help, please call us 1-866-528-0577, help@albaspectrum.com skype albaspectrum. We specialize in Dynamics GP Customizations, Reporting, eConnect Programming, EDI, Integrations, International Support in Russian, Spanish, Portuguese, Chinese. Plus we are comfortable to help you with Fantastic Plains Integrations with PHP, Java, Linux, Oracle, MySQL, MS Access, Excel. We also support SAP Business One SDK, Workbench customizations and integrations
Dynamics GP Integration: Great Plains Technology Partner Notes
Tuesday, February 23rd, 2010If you have Microsoft Dynamics GP implemented in your organization and you plot to integrate GP ERP and MRP modules with your other IT systems: ecommerce, Sales Ordering, CRM, EDI Purchasing, Supply Chain Management, you should get initial introduction to Dynamics GP Integration Tools: Integration Manager, eConnect, Dexterity, Import Utility, direct SQL Scripting. In this article we will not be covering Dynamics GP ISV third party add-ons. It might look a bit technical to IT boss, and at the same time you, as programmer may expect more technical details, as we are trying to keep weigh:
1. Integration Manager. This tool is very friendly to GP User, and if this is your role, plus you are familiar with GP master documents and transactions types, you should try to build simple integration, use existing sample integrations as a reference and study materials. If you are on GP version 10.0, IM has two types of Connectors: traditional OLE based (require login to the GP workstation as OLE Server and launching IM from there – integration works with the current company) and eConnect (they are built upon eConnect technology stack, should be a way faster, do not require GP workstation, however you will need special procedure to install eConnect connectors, especially Admin domain account or your GP local server Admin account; if by whatever reason you change eConnect Account Password, please change it in also in Administrative Tools -> Component Services -> COM+ Applications – > Properties – > Identity – this is one of the most questioned questions). If you reckon about IM as very simple and pretty restricted tool, we want to give you advanced scenario. Consider the situation, when you have legacy Sales Order Management System in Oracle, and you need to go Sales Orders and New Customers to GP SOP module. In this case, consider to make MS SQL Server Linked Server to Oracle, and SQL Heterogeneous View, which will pull data from Oracle and will check the Invoice existence in SOP10100 (Work SOP Docs) or SOP30200 (Historical SOP Docs). This view should allow you to make ongoing integration of Customer Orders to GP. You can schedule integration with Windows Scheduling custom applications, available for moderate fee on Software market, or simply have GP IM user to launch integration every day or every few hours. Please, check with your Dynamics GP VAR on IM module license
2. eConnect. This tool is open for Microsoft Visual Studio C#, VB or other .Net programming language software developer. Initially it was dedicated to ecommerce programmers to open Fantastic Plains as back office accounting. We recommend you to look at eConnect if your current GP version is 10.0 or 9.0. If you are on earlier version: 8.0, 7.5, 7.0, 6.0, 5.5, 5.0, 4.0, 3.2, Fantastic Plains Accounting for DOS, Windows or Mac, please consider upgrade to version 10.0 or if you are on Fantastic Plains Dynamics, consider deploying either Integration Manager, Import Utility, Dexterity or direct SQL Insert. eConnect is simple in inclusion into MS Visual Studio project as Library, and then you should be able to program by examples, provided in eConnect SDK. In fact in Integration Manager 10.0 most of the objects are available in eConnect connector version, so you can try IM, but eConnect allows you to have more control over integration, and especially vital feature is real time integration option, where you could call eConnect methods upon ecommerce invoice and payment residency event
3. Dexterity. It is native Fantastic Plains development environment, and it has access to all the GP Objects, including master records, work, open and historical transactions, plus custom Dexterity add-ons produced tables, fields, forms and windows. You should not immediately consider to drop IM and eConnect as no longer feasible integration options, as Dex has some drawbacks – it is not open source programming language, it requires relatively long programming learning curve. You may consider to get Dynamics GP Dexterity training for your IT programmers, if you are facing huge Fantastic Plains implementation with numerous customizations and existing logic modifications, especially when you work for large organization with challenging ecommerce, logistics, warehouse management. For the rest of us, we recommend outsourcing Dexterity integration programming to Dynamics GP ISV with Dex software development factories. One of the excellent examples of Dex custom add-ons is Alba Spectrum Posting Server or Autopost, allowing you to break through eConnect limitations on incapacity to post Batches and individual transactions
4. Import Utility. This tool is in our opinion rather archaic and useful if you are on Ctree or Pervasive SQL 2000. Since Dynamics GP 8.0 the only supported DB Platform is Microsoft SQL Server: MS SQL 2000 for 8.0, 9.0 and 10.0, MS SQL 2005 for 9.0, 10.0, MS SQL 2008 for 10.0. We recommend you direct SQL insert for SQL Server based installations. IU doesn’t validate GP business logic and such is similar in its potential harm to business logic inconsistency as direct SQL insert statement
5. Direct SQL Scripting. Please, try not to be too enthusiastic about feeding data into Great Plains via SQL Query Analyzer. Consider the fact that eConnect is written in SQL Server encrypted stored procedures and likely the intended SQL feeding is already covered in one of its Procedures. Consider to invest some time in eConnect training, as if you do integration in eConnect libraries, versus custom SQL scripting – business logic validation should not be an issue, as eConnect is replicating Dexterity business logic. If these advises are not applicable to you, please go ahead with SQL scripting. Dynamics GP Tables structure could be found in GP SDK (install from CD#2), plus here: Dynamics GP -> Setup-> Resource Description -> Tables. We strongly recommend to be very conservative and try your integration first in the test company or in Fabrikam Lesson Company – here try to penetrate similar transactions in GP user interface and then review how records were recorded in the tables and irrevocably then start your coding
6. Dynamics GP Integration in International environment. Please note that GP is generally localized and supported in English speaking countries: USA, Canada (including French Quebec version), UK, Australia, South Africa, Oceania, New Zealand, India, Pakistan or English Business Specking South East Asia, plus it is translated and partially localized for Spanish specking Latin America. GP has potential to be translated to non-Unicode compliant languages: Russian, Lithuanian, German, Polish, Czech, Serbian, Turkish, etc. But we recommend you to consider ERP tax code compliance question. In some international situations SAP Business One with GL or transactions integrations to Dynamics GP might be better option, especially if SB1 is localized for your country
7. Alternatives to Dynamics GP Fantastic Plains. If you feel that GP is too expensive, consider Microsoft Small Business Accounting or if this is too simple, consider SAP Business One. If you believe that GP is too poor in its functionality, consider switching to next amount in Microsoft Dynamics ERP harvest hierarchy – AX, formerly known as Axapta
8. If you need bonus help, please call us: 1-866-528-0577, internationally 1-630-961-5918, help@albaspectrum.com or skype: albaspectrum. We would be pleased to give you your industry case from Fantastic Plains customization and integration perspective, as well as to give you second opinion, if you are not pleased with your current Dynamics GP Partner support amount
Dynamics GP Partner and ISV California, Illinois: Great Plains technical support
Sunday, February 21st, 2010If you have Microsoft Dynamics GP, formerly known as Fantastic Plains Dynamics, by now implemented or you plot to see executive or technical presentation, we want to give you some technology highlights, plus customization, integration, reporting options, technical support and upgrade info. We assume that you are in Southern California: LA and San Diego metros, Northern Illinois: Chicago metro or even USA, Canada nationwide and internationally (when you need custom programming in GP Dexterity, or need SAP Business One integration to US based Dynamics GP system). Please, also note that if you have ancient version of Fantastic Plains, you should know your database platform: GP 7.5, 7.0, 6.0, 5.5, 5.0, 4.0 and earlier were available on MS SQL Server, Pervasive SQL 2000/Btrieve and Ctree. Also, older product Fantastic Plains Accounting 9.5, 9.2, 9.1 and earlier versions for DOS, Windows and Mac is also supportable with some limitations, as we in turn cannot get any help frankly from Microsoft Business Solutions on GPA and cannot sell new user licenses, only support what you by now got historically
1. Local GP support in Chicago, Los Angeles, San Diego. Available from our locations in Chicago downtown, Naperville (Chicago suburbs), San Marcos (San Diego suburbs). Local support option is recommended when you need new Dynamics GP system implementation, plus if you have complex local integration needs: Barcoding, Integration with you Point Of Sale equipment, etc. If you have customization coding and support issues, or need one of our harvest, we prefer to support you frankly from our nationwide Dynamics GP technical support center and Fantastic Plains Dexterity Software Development Factory
2. Nationwide Dynamics GP remote support. This option is in fact beneficial to the customer, as you do not have to pay for our local travel and do not have to wait consultant to make her or his schedule and. Technical support is theoretically available immediately via Web Session and Phone Conference. If you are located Internationally, you can use such technologies as Skype for free VOIP phone conferences
3. Fantastic Plains Customizations support. We have Dexterity Software Development Factory with technicians trained in Dex and some of them came through Microsoft Business Solutions work experience. Dexterity is one of the most standard GP modification and programming tools. But, this is not the only tool we deploy for our customers. We also program in eConnect (tool of choice for ecommerce integration), .Net, VBA and Modifier, SQL Scripting and advanced Dynamics GP Integration Manager integrations
4. Dynamics GP Integration with Microsoft RMS. We have proven codes, as integration is very specific to your settings in RMS and how you want to map it to Dynamics GP objects. Integration works either on Dynamics GP SOP or Receivable Management module, plus it includes POP Buy Receipts integration and Barcode marks printing from Fantastic Plains frankly – we found that reasonable number of MS RMS customers prefer to control these processes in their ERP, in our case Dynamics GP
5. eCommerce extensions, and Automatic Batch Posting from your MS Visual Studio ecommerce, EDI, etc. projects. Fantastic Plains batch posting frankly from your eConnect web application is not available, you will need to turn your attention to the complexity of Posting process and its logic in GP Dexterity. Our Autopost or Posting Server prepares the batches and initiates Dex source code batch posting process
6. Fantastic Plains version upgrade. Here you need to be committed in Microsoft Business Solutions GP once a year support program, if not call us for the options to be reenrolled. Then you have access to new version reg key. Dynamics GP version update should be plotted, it should be done by Dynamics GP Reseller and its certified GP consultants, as there is upgrade patch and it is Service Pack and Patches specific. If you are on the version 7.5 on Pervasive SQL/Ctree or earlier, you should come through migration to GP on Microsoft SQL Server process. Upgrade should also include Dynamics GP ISV custom add-ons, GP ReportWriter modified reports, VBA Modifier, Integration Manager, FRx financial reports upgrade
7. Dynamics GP support internationally. Typically it includes cases where you have GP Corporate ERP in USA, Canada, UK, Australia, New Zealand, South Africa, Mexico or Spanish Speaking Latin America and want to implement GP for your foreign subsidiary or integrate non GP ERP with your Corporate ERP. In the case when you foreign subsidiary is located in Brazil, Eastern Europe, Russia, Kazakhstan, Central Asia, we recommend you to consider SAP Business One as local branch ERP and it should be pretty simple exercise to consolidate SB1 on General ledger transactions amount to Dynamics GP via Integration Manager. FRx could also be tuned to consolidated Weigh Sheet, Profit and Loss Statement with GP Companies GL and even foreign subsidiary Excel export sheet. Plus, consider the fact that Dynamics GP doesn’t support Unicode characters in its core functionality and architecture, so the plans to adopt GP for Plates, Japan, Korea and other hieroglyph alphabet countries might be too challenging. Some support is available for Arabic language, call Microsoft in Saudi Arabia
8. Fantastic Plains on Pervasive SQL or Ctree support. If you have reasons to stay with these no longer supported by MBS frankly DB platforms, we are pleased to help you with day-to-day support issues, such as unlocking the batch posting failure, general data repair, user training, FRx reports design and modification, SOP Invoice form modification in Report Writer. Plus if you choose in the future to get up to date, we are ready to help you with upgrade all the way through to whatever it will be the current version in the future
9. Fantastic Pains Accounting Support. If you are on really archaic Windows or Mac version, local stay might be recommended. GPA could be also transferred from Windows NT 4.0 Server to a touch more modern, like Windows 2003 Server, in this case you would need to deploy Pervasive SQL 2000 SP3 or similar DB version. Custom Pervasive SQL 2000 settings are required, you should call us for details and help. GPA migration to Dynamics GP 10.0 is possible, you will get discount for currently owned GPA modules in getting ownership of Dynamics GP, terms may exchange by Microsoft Business Solutions without notice, we are writing these lines in August 2009
10. Dynamics GP EDI or Electronic Document Interchange integrations. We place forward these scripts in MS SQL Server Views and Stored procedures, that should allow you to avoid high cost for EDI Add-Ons
11. How to get help? Please call us 1-866-528-0577, help@albaspectrum.com. Our consultants are fluent in English, Spanish, Portuguese, Chinese, Russian. We are experts in Dynamics GP implementation in international environment, its data conversions, customizations, precious stone Reports for GP, FRx, SSRS, Dexterity. Plus we have unique expertise in Dynamics GP consolidations with East European, Russian accounting systems. We could help you with Microsoft CRM implementation and integration with Dynamics GP and SAP Business One, plus Lotus Notes integration with MS CRM and Dynamics GP, Oracle custom DB and Oracle eBusiness Suite integration with Microsoft SQL Server based systems
Great Plains Reseller News: Edi Solutions for Dynamics Gp
Sunday, February 14th, 2010Microsoft Dynamics GP has various EDI (Electronic Document Interchange) add-ons and third party modules, where you can map your EDI code to either expose GP documents, such as Vendor Buy Orders to EDI complaint vendors or import Sales Orders or Invoices from EDI channel to your SOP module, as two standard examples. In certain cases purchasing add-on may not be feasible due to the simplicity of your requirements or ironically – their complexity, where you want to control EDI mapping in-house or with trusted Fantastic Plains Dynamics consultant. This publication is targeted to EDI technical people, and as such may look too programmer oriented, but we tried to make it readable for technology savoir-faire executive. Let’s review briefly both scenarios: export and import:
1. Exporting EDI compliant text code. Typically EDI code has fixed part format with Header, Lines, and various Trailers. Simple approach to produce this fixed part formatted text file is to save SQL select statement, where you unionize the parts and precisely format each field. If you are exporting Buy Orders, then likely you are dealing with Buy Order Processing module tables: POP10100, POP10110. Then what you need to do is to mark your exported Buy Orders in custom table as exported. Feel free to make this export status table in GP company database.
2. Importing EDI file to GP. Here you need to consider pushing documents to Fantastic Plains via eConnect programming, assuming that automatic batch posting is not required. If Autoposting is required, we recommend you to deploy Alba Spectrum Posting Server or Autopost. You open incoming EDI text file with OLEDB text driver. Then the options are multiple – our favorite is to read text file into temporary table. In this case you will have typical field names: F1, F2, F3 – to make your grouping, sorting and having clauses elegant. A further standard alternative is to establish SQL linked server to your text file, but this construction might be too powerful and not really required on that amount
3. ODBC text file driver limitations. ODBC supports the subset of standard SQL language only and you will see multiple limitations: case, text functions and other standard SQL constructions are not supported by ODBC SQL
4. EDI and Fantastic Plains Dexterity. If you need seamless integration with GP user interface, GP Dexterity might be the tool of choice. Dex allows you to call either Dex SQL compliant cursors, or call frankly SQL statements or stored procedures to do the job, by now described in the paragraphs above
Great Plains Automatic Batch Posting From Econnect Ecommerce Application
Wednesday, February 10th, 2010Alba Spectrum Autoposting Server is excellent enabler for GP batch auto posting from eConnect integration application as well as if you are deploying SQL or PHP coding to integrate your eCommerce web site with Microsoft Dynamics GP Fantastic Plains. Alba Spectrum is about to announce new version of Auto Posting Server release date with the list of new features. This publication is to describe general functionality of Posting Extension:
1. Batch Posting. It is done via Fantastic Plains Dexterity native code fragments call. Autpopost is Dex add-on. If you are programmer, what you need to do is to insert work transactions in the batch in GP (typically via eConnect, as it has encrypted stored procedures to make customers, vendors, SOP invoices, etc), and then place batch record into Autopost table – this will trigger batch posting process. Autopost checks table status every few seconds and if new record is found, batch posting process is initiated
2. Batch Origin. If you are thinking from eCommerce perspective – you are probably about SOP Transactions batch. But batch origin might be of any core GP module: POP, AP, AR, GL, Payroll, Inventory, Invoicing, etc. If you need batch posting, originated in add-ons or ISV GP extensions, please check with us, as each GP customization partner makes its own way of batch posting scenario
3. New Features. New Autopost release will include: email notification, posting error logging and automatic startup. Please check with us in two weeks from now as we plot to release detailed specs for new features
Automatic Batch Posting in Great Plains Microsoft Dynamics Gp Overview
Tuesday, February 9th, 2010If you are ecommerce developer and program web site integration with back office accounting system, Microsoft Dynamics GP, then likely you are deploying eConnect SDK software development to go placed orders and customer payments to GP Sales Order Processing module. eConnect does wonderful job – it makes or updates customer record, makes SOP batch and customer invoice with deposit in the batch produced. So far everything is gorgeous, now you need just as small step to accomplish your work, post the batch produced right from your e-commerce application, and here you got surprised by understanding that eConnect doesn’t post batches, it doesn’t has this functionality. We want to review Autoposting Server, designed and maintained by Alba Spectrum Dexterity development team
1. GP Dexterity Source code involvement in the batch posting. Dynamics.DIC dictionary has native GP Dexterity functionality to post batch of various origin and in essence all the origins. But it is not obvious, even for Fantastic Plains Dexterity programmer with decent experience in coding on how to design autopost and how to deploy native Dex posting logic. GP Autopost resolves this dilemma and all you need to do as programmer is to place batch record into custom batch posting status table
2. Posting all the way automatic from your e-commerce website. In GP posting path is certain in posting settings. If you set GP to post SOP invoices all the way through AR module to GP General Ledger – complete automating will be achieved
3. Third Party Add-Ons batch posting. Add-Ons, designed by GP ISV partners have their own ways to make and post batches within their satellite modules, but when transactions in the posting cycles will reach Fantastic Plains, Dexterity posting process will take over and so there is high chance that Alba Spectrum Autopost will do the job. We encourage you to check with us
4. Microsoft Dexterity Customizations. If you need customization design, support or upgrade, we are pleased to help you with it through our Microsoft Dexterity Software Development Factory