Traditionally, Microsoft Dynamics GP or former Fantastic Plains Dynamics and eEnterprise customizations were programmed in Fantastic Plains Dexterity, where you can make your screens working integrated into GP workstation and user security rules. Dexterity modifications are typically outsourced to Fantastic Plains Technology Partner and Certified GP technical consultant. If you are doing modifications on your own and your are technically comfortable with Fantastic Plains, then you can review eOne Extender. If you are engaged in ecommerce website integration project, then your tool of choice should be eConnect. In this small publication we want to give your technical highlights:
1. Dynamics GP Dexterity customizations. GP Dexterity has its own scripting language Sanscript, which is cursor like in the manner of database access. When Microsoft bought Fantastic Plains Software, Dexterity was enriched with MS SQL Server direct SQL code calls, COM objects access library and other features, facilitating integration with Microsoft .Net programming. Dexterity add-on is distributed via so-called chunk file, which should be copied into GP workstation directory to be involuntarily integrated on the next GP user login. The best practice is to make new Dexterity forms and windows and place triggers in order to modify existing GP tables. But you can also modify or alter existing GP forms, but if you do so – likely that you will come in conflict with other add-ons and third party module, plus there will be more work in Dex customization version upgrade
2. Extender. With eOne version you can proffer GP form, and make it intuitively. But in fact Extender is the bombard over Fantastic Plains Dexterity and behind the scenes you are making Dex objects
3. eConnect programming. It is advisable to have Fantastic Plains eConnect programmer or consultant to be involved at least in the tech specification writing and be available to help on case-by-case when programming is in progress. eConnect is written in encrypted SQL stored procedures and replicates Dexterity logic, but is more object oriented and so, more friendly to C# or VB.Net programmers, who are also familiar with MS SQL Server stored procedures. eConnect doesn’t post batches, so you will need Fantastic Plains Posting Server or Autopost
Posts Tagged ‘Reseller’
Great Plains Reseller Chicago, San Diego Newsflash: Add-ons Development
Tuesday, March 9th, 2010Great 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 Reseller News: Autoposting Server for Dynamics Gp
Tuesday, February 2nd, 2010Microsoft Dynamics GP implementation in ecommerce or EDI (Electronic Document Interchange) environments evenly requires documents creation in Dynamics GP from outdoor applications, such as e-commerce web site. We recommend you to make a research in the SDK and integrating tool, named eConnect. eConnect makes, deletes and updates GP master records: customer, vendor, employee, GL account, address for customer or vendor to name few examples. Also eConnect makes so-called work documents: Sales Order Processing Invoice, Sales Order, Buy Order, GL transaction, Payroll Payment and Check, etc. Please, note here, that these documents have work status, they are not posted and awaiting for your review and posting on the batch amount. It is evenly the requirements to post Fantastic Plains batch involuntarily from ecommerce or EDI integration application – and here you will get the limitation of eConnect – it doesn’t have batch posting functionality and it probably should not due to GP architecture. In order to post batches in GP you will need add-on GP Autopost
1. Autopost Technology. It deploys Microsoft Fantastic Plains Dexterity internal procedures to do posting, but it open the way to post batches genuinely through custom Dexterity programming. Autoposting Server is extremely reliable and it is immune to GP version upgrade, as Dex code, related to batch posting is virtually unchanged
2. EDI and other posting needs. Due to the fact, that Fantastic Plains Posting Server uses Dex procedures, it can post the batch of multiple origins, including some add-ons modules batches. This is why Autopost is standard in EDI scenarios
3. GP Autopost Support USA Nationwide and Internationally. This product is targeted to ecommerce programmers and developers, and doesn’t require our technicians stay onsite, and we are comfortable to sell and support it nationwide and internationally, where Fantastic Plains is localized: UK, Australia, New Zealand, South Africa, Midpoint East, India, Pakistan, South East Asia, Philippines, Singapore, Malaysia, Indonesia, Mexico, Caribbean, South America
4. GP customization and programming air force. Fantastic Plains Dexterity Software Development Factory is in your disposition
SSL Reseller: VeriSign, GeoTrust, Thawte, RapidSSL
Thursday, January 14th, 2010In the global competition for Web air force, providers compete on price and service options. If you place forward Web hosting, design, or application development air force, you can make more value and capture more business by offering premium-brand Secure sockets Layer (SSL) Certificates.
Here is excellent news for domain seller, hosting providers and affiliates that ClickSSL has started offering Free SSL reseller program. Selling security certificates from your website is proud thing as you help online web securities and protect buyers and sellers. As we know that ClickSSL by now place forward up to 80% discount on fixed pricing to end customers. Now guess what will be reseller pricing. Of course you will have unbelievable discount on reseller pricing.
We’re fully committed to the SSL business and our resellers. You may use our air force to integrate a wide range of SSL harvest into your portfolio.Best is what you can sell SSL direct from your website as account will be offered with free managed API system and user friendly fully automated control panel. Why you affiliate for others when you have chance to develop your brand name?
Well, I know now you are interested to know for this program. Here is reseller program features and more are available here
Zero set up fees: Free reseller account with $0 setup fees.
Instant Activation: Reseller account activation in 24 hours only
Commitments: No stanchness. No narrow. No target.
Special Price: Competitive Special discount price on RRP
Price Bargain: Customize product list and bargain price. NEW!
Safe Payments: Instant and volume payment conveniences – PayPal
Control Panel: Managed control panel and instant ordering system
SSL Issuance: Instant SSL enrollment and certificate issuance
API Interface: API interface reselling SSL direct from website NEW!
Brands: VeriSign, Thawte, GeoTrust, RapidSSL
Product Range: DV, OV, EV, MD, Wildcard SSL, SAN SSL, SGS
Support: Online email and chat support 24/7
Wow! I am interested for this white branding business, how much I have to invest?
ClickSSL offers zero set up fee reseller account (zero setup fees). We place forward honest discount price to resellers and you can sale SSL certificate at your own pricing. We place forward zero credit reseller account. Only pay when you order SSL. If you have existing website and you want more discount price, then we also place forward special price on volume payment in the following dominations. $0 $500 $1,000 $2,000 $5,000 $10,000
Let’s start with zero and earn in hundreds. Do not wait, zero price reseller account is limited time place forward.
The Program is hassle free for the Reseller – through your own white labeled website, we receive your customer’s application, we validate the application and we provide the customer support! All you need to do is promote SSL certificates and take payment from your customers!