Posts Tagged ‘Microsoft’

Automatic Batch Posting in Great Plains Microsoft Dynamics Gp Overview

Tuesday, February 9th, 2010

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

Microsoft Dynamics Gp Autoposting Server Overview

Friday, February 5th, 2010

If 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, 2010

If 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

Microsoft To Integrate Rss Support In Windows Operating System

Tuesday, February 2nd, 2010

Last year Microsoft Corporation shocked the world when they revealed their intention to build RSS (Really Simple Syndication) support in the latest version of the Microsoft Windows operating system, which is under the code-name “Longhorn.” The announcement was fittingly made in Seattle at last years celebration of Gnomedex 5.0, an annual conference for avid technology buff and industry influentials that concentrates on RSS, blogging, podcasting and other new media models.
With the RSS functionality of Longhorn, it will make it simpler for end users to learn, view and subscribe to RSS feeds. Furthermore, it will also make it simpler for the developers to incorporate the rich capabilities of RSS into their applications.
Additionally, Microsoft also introduced Simple List Extensions. This is a set of extensions to RSS, which can be used to make it possible for web sites to publish “lists” like of photo albums, music playlists and top 10 lists as RSS feeds. This specification will be made freely available through the Creative Commons license, the same license under which the RSS 2.0 specification was released.
If you are wondering what the deal with RSS, well it’s simple. It makes things much simpler for both the users and applications developers. By adding RSS features throughout “Longhorn” Microsoft will be making it simpler for the broad group of users and developers to take advantage of RSS.
For example, while browsing the Web, “Longhorn” users will be able to easily learn RSS feeds through an illuminated icon and to read the feed even though they are still in the Web browser. Also, subscribing to an RSS feed will be as simple and simple as adding a Web site to their “favorites.”
Another advantage to having RSS features in the Windows “Longhorn” platform is that it will allow application developers to easily use the capabilities of RSS in their applications. Let’s take this as an example. A business user who is about to attend a conference will be able to subscribe to the conference’s event calendar. They can then use a “Longhorn” RSS-enabled calendar application to view the events in the RSS feed from within their calendar application. Another example is that business managers will be able to subscribe to sales data that notifies them through a line-of-business application when new deals have been closed.
Exactly what is included in this RSS support in the “Longhorn” platform? There are three vital features. The first one is the common RSS feed list. This core feature of Windows maintains a common list of the user’s subscriptions across all applications. This will enable users to subscribe to a feed once and have all RSS-enabled applications able to access the common list to view the subscriptions.
Another feature is the common RSS data store. This feature will provide a single location where applications can access content that has been downloaded to the PC through RSS. This would include text, pictures, audio, calendar events, documents and nearly everything else. All applications will have access to this content in order to make rich user experiences.
Lastly, there is the RSS Platform Sync Engine. Now, this feature will automatically download data and enclosures for use by any application. The engine is especially designed for efficiency, using idle network bandwidth whenever possible in order to limit the effect on the user’s Internet experience. Developers may use the platform in order to obtain RSS data without the need to manage details like synchronization schedules or subscriptions.
It was mentioned before that Microsoft has also developed the Simple List Extensions. What is this you question? Well, this is a set of enhancements to RSS to help Web sites publish lists of content that users can subscribe to, like top 10 songs from a music site, a wish list from an online retailer or a user’s ranking of favorite videos.
Since RSS is mainly designed for subscribing to time-based feeds, it only seems logical to have a Simple List Extensions. This expands the scope of RSS in two significant ways. First is that it boost RSS to capture information vital in representing lists like ordering of items. With the help of these extensions applications may become aware of changes in a list, for instance when an item has changed position or has taken off from the list altogether.
Secondly, it allows publishers to embed useful information about the list itself. For instance, an online retailer can supply additional information about each item in a list such as price, sales rank, average customer rating and type of merchandise. The extensions allow richer flexibility and capability for sorting and ordering. Thus, it makes it possible for users to easily sort their friends’ wish lists by sales rank or popularity.
Web sites that make lists using the Simple List Extensions will also find it quite beneficial. How so? Let’s say a music site will be able to deliver a daily top-10 tracks list to help drive increased sales. This is quite hard to accomplish today, since it requires significant work for both content providers and RSS solutions. Already shopping sites are enthusiastically voicing out their excitement and support for Longhorn.
A lot of people believe that RSS is indeed the key to how the public will use the Internet in the future, which is delivering vital information automatically. Microsoft recognizes this, which is why they are investing heavily in RSS for Windows “Longhorn” to make it simple for users to learn, read and subscribe to RSS feeds as well as enable developers to deliver powerful, smart applications that act on the information on behalf of the user.
Microsoft was founded way back in 1975. For more than three decades now they remain a worldwide leader in software, services and solutions. The company is dedicated to helping people and businesses realize their full potential by providing them with innovative technology. Windows, Windows Media and MSN are just among the many brainchild of this global leader. Today, Microsoft remains right to its promise by introducing their latest breakthrough – Longhorn!

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 …