If 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 made. So far everything is gorgeous, now you need just as small step to accomplish your work, post the batch made 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 defined 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
Posts Tagged ‘Microsoft’
Automatic Batch Posting in Great Plains Microsoft Dynamics Gp Overview
Tuesday, February 9th, 2010Microsoft Dynamics Gp Autoposting Server Overview
Friday, February 5th, 2010If you are integrating ecommerce web application with Microsoft Fantastic Plains and deploy such integrating SDK as eConnect, then you should know the option to automatically post batches in GP as they are imported from your e-commerce front end. In GP, as you should know the background technology is Fantastic Plains Dexterity with DYNAMICS.DIC where business logic is stored. eConnect itself is imitating Dex business logic in encrypted SQL stored procedures, but you typically can not or discouraged from modifying these SQL stored procs. Alba Spectrum Posting Server deploys Microsoft Dexterity internal logic and so it is simple and at the same time pretty version-proof. Lets come to highlights:
1. eConnect restrictions. Well, eConnect is fantastic tool and Software Development Kit, but it assumes that you are normal GP user and you post your SOP, POP, AR, AP, IV GL batches through Fantastic Plains user interface. In eCommerce scenarios it is often the requirement to post GP batches automatically on demand, triggered by eCommerce programmer
2. Dexterity Batch Posting programming. Dex is proprietary tool and it is really complex, so we do not recommend you to break through Microsoft Dexterity learning curve to come to the point of being able to program eConnect batches posting
3. Integration Manager batches posting. As SQL programmer, all you need to do is to place IM integrated batch to queuing table for triggering it to be posted by Posting Server
4. eConnect C# and VB programming. These programming languages are recommended to program eConnect integrations
Microsoft Dynamics GP eCommerce: Sales Order Processing integration and Autoposting
Thursday, February 4th, 2010If you are ecommerce developer, who is integrating ecommerce web front application with Dynamics GP (often referred historically as Fantastic 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 bought 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 make 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 want to review other options and Automatic Batch posting technology directly from ecommerce eConnect application:
1. Microsoft Dynamics GP Integration Manager in ecommerce scenarios. This tool could be either called on demand or scheduled with the scheduling application available for buy from Microsoft Business Solutions, or you can deploy third party (often free) Windows macro type of small shareware applications available in open software market for download and tryout. If you schedule IM to do ecommerce to GP integration say every twenty minutes – this method might be a way more powerful (assuming that GP plays master role for Inventory Items maintenance and update and Pricelists). If this is the case – IM can make or update such objects as Customer, Address, Inventory Item, Comments to Customer, Invoice, Invoice Line, Shipping Instructions. With Dynamics GP 10.0 Integration Manager deploys eConnect connectors, which are very efficient from performance standpoint (but eConnect SOP connector doesn’t have SOP Return, but you can realize return via IM OLE technology based SOP connector and for future versions of Dynamics GP IM we hope that that gap will be patched). Integration Manager also does the job, even if your ecommerce is hosted in Linux/PHP/MySQL. In this case you can either use cross platform ODBC bridge, or have Integration Manager integrate text or XML ecommerce shopping cart exports. And as the another excellent note about IM – if you deploy Advanced ODBC Data Sources in IM, you can base them on Microsoft SQL Server Linked Server to Oracle, Lotus or another non-Microsoft DB platform, which is ODBC compliant and which could be joined in SQL Server View
2. eConnect. This tool opens the door to real time ecommerce integration to GP, if this is something, that is absolutely required. eConnect might be more flexible comparing to Integration Manager, but it might require more programming time to cover all expected (and unexpected) ecommerce customer actions. If real time aspect is not critical, eConnect advantage could be additional flexibility, when eCommerce application is playing master role (new items, price lists, discounts, internet promotions are initiated in your ecommerce application and then propagated to Dynamics GP, as you post new ecommerce shopping carts and download them to Fantastic Plains)
3. Dynamics GP Automatic batch posting directly from ecommerce eConnect or Linux based application. eConnect by its architecture works with GP master records and so-called Work Transactions, where you place work SOP invoice (ecommerce shopping cart image) to the bath for GP user (choice maker or approver) review, approval and posting directly in GP user interface. Dynamics GP is mid-market Corporate ERP and it has layers of security and approval cycles, and eConnect doesn’t allow shortcuts in batch auto posting on eConnect level. We recommend you to deploy Alba Spectrum Posting Server which imitates batch approval and posting initiation through Dynamics GP User Workstation. Even if you are sending shopping carts from Unix, Linux/PHP platforms, you can still delight in Posting Server functionality, as all you need to do is to populate SOP10100, SOP10200 and other SOP work tables (we have Alba Spectrum Order Connector product, which allows you to do this work on SQL Stored Procedures level) and mark the batch as ready for being posted in custom Batch Prepared for Posting table. Posting Server deploys native Microsoft Dexterity (formerly known as Fantastic Plains Dexterity) batch posting initiation internal procedures
4. How to get additional help? We encourage you to search in google for Dynamics GP video demos and presentations. Our web engineers are deploying web casting technologies, similar to the ones used in Youtube and Google Video to provide free Dynamics GP internet video presentations. Feel free to call or email our office. Service is available virtually Worldwide via remote connections, web sessions and phone conferences. We will be pleased to travel to your USA, Canada, Brazil or international based office or facility, if required. Our consultants speak English, Chinese, Portuguese, Spanish, Russian, Filipino and other languages
WordPress Tutorial – How to Upload & Link to a PDF, Microsoft Word doc, or other doc
Wednesday, October 21st, 2009
This beginner-level WordPress tutorial is an update of the existing tutorial on mcbuzz.wordpress.com and YouTube called “WordPress Tutorial – How to Upload and Link to a PDF, Microsoft Word Document, Excel, PowerPoint or Other Doc Using WordPress”. That tutorial was done using an earlier version of WordPress. This tutorial uses WordPress 2.7. This tutorial shows three things 1) How to upload a PDF, Microsoft Word doc, PowerPoint, Excel or other Office-type document using WordPress 2.7. 2 …