Partner Plus Processor

Ecommerce for SAP Business One and Microsoft Dynamics GP custom programming

Corporate ERP is typically open for ecommerce shopping cart, item catalog, price list integration.  However if you are SAP Business One or Microsoft Dynamics GP customer, you may not know the right tool or integration method.  We often hear from our customers very generic ecommerce integration questions and even requests.  We assume that you are midsize or small company, and budget is important for you.  And we think it is very practical to publish SB1 and Great Plains ecommerce FAQ and guidelines:

1. Do I have to purchase third party ecommerce add-on?  The answer is typically NO.  Both SAP B1 and  Dynamics GP have Software Development Kits (SB1 SDK and eConnect for GP), plus both have Integration modules: SAP Business One Data Transfer Workbench and Microsoft Dynamics GP Integration Manager.  Why we are appending the adjective Typically - because in some cases Dynamics GP ISV and SAP Business One ISV partners have wizards and tools, allowing you to facilitate ecommerce to Corporate ERP integration programming, however those tools are optional and technically not required

2. Which tables or objects should I target in ecommerce integration?  In the case of SAP Business One, you should target Marketing Documents (for customer orders and invoices), Business Partners for new and updating existing customers.  In the case of Great Plains - please consider Sales Order Processing Documents (Quotation, Sales Order, Invoice, Return, Back Order), for creating new customer (in B2B ecommerce scenarios), please consider Accounts Receivable Customer Master record (for B2C ecommerce you can use one generic Walk In customer and simply add new address to this generic customer).  In both cases of SAP Business One and GP we do not recommend you to feed data directly to SQL tables, as both SB1 and GP Corporate ERP applications business logic is quite sophisticated, and it is easy enough to violate it via direct SQL Insert statements

3. Shopping Cart Credit Card Payments - how to handle these transactions?  You should understand that Corporate ERP software vendors are not the same companies, who do Credit Card processing.  You should check with your credit card processor or the bank to understand to understand the mechanisms.  Likely that you will end up calling to such CC processing authorities as ICVerify, PCCharge

4. SAP Business One eCommerce relates SDK Programming.  SB1 is very selective to ISV partners certification, and SB1 SDK certification is required for doing any SB1 SDK programming (and you should consider subcontracting SB1 ecommerce integration to SAP B1 SDK authorized partner).  In the case of Microsoft Dynamics GP eConnect SDK, requirements are more flexible and you can do eConnect programming in-house

5. Microsoft Dynamics GP eConnect.  If your customer is on current Dynamics GP version (GP 10. as we are writing these lines in October 2009), Microsoft is typically open to reveal its technologies to newcomers, and as Microsoft Visual Studio C# or VB programmer you should be able to begin coding in eConnect right away

6. Hosting Questions.  In both scenarios: SAP Business One and Microsoft Dynamics GP Great Plains the question is actual.  Your SB1 or DGP internet hosting provider may try to charge you per page view or per ecommerce transaction, in our opinion this is the signal to you to change you web hosting partner

7. Special Consideration to Dynamics GP Integration Manager.  This tool allows you to run pretty sophisticate integrations on demand or schedule them (you can schedule via Windows Macro add-ons) to implement quasi real time integration.  If you base your integration on Advanced ODBC Queries, you can cross limitations of simple tab delimited text file

8. Special Considerations to Microsoft Dexterity extensions to Sales Order Processing.  Dexterity is semi proprietary (meaning that it is not feasible to force your internal IT programmers to begin coding in Dexterity over night, over week, over month or in short term perspective, as Dex requires year long extensive learning curve) and it is not recommended for in-house programming.  However, if you need SOP Document interface modified Dexterity might be optional tool, as it is naturally integrates into GP Security realm and it looks as native GP interface (you should grant user, who is supposed to use Dex modification so called Dynamics GP Alternative Forms)

9. Modifier with VBA.  This is another option to modify SOP Entry form (you should have customization site enabler license to have access to VBA modifications).  Modifier allows you to place new buttons and editable fields on existing GP forms and VBA scripts could animate these fields.  In order to manipulate existing GP tables from modifier fields, consider traditional ADO connection to MS SQL Server database

10. Special Consideration to SAP Business One Data Transfer Workbench.  For ongoing integrations we recommend deploying DTW with Advanced ODBC queries - in this case you can base your integration on SQL Views in MS SQL Server (or even with heterogeneous queries, where data is joined from various platform: Oracle, MS Access, MySQL/PHP/Linux, etc).  If you integrate huge number of transactions (100+ per hour), consider switching over to DI Server (which could be programmed from SB1 SDK in XML)

11. Differences between SAP Business One and Dynamics GP in eCommerce integration business logic.  GP is more geared toward larger organizations and it has Batch Posting mechanism (with associated documents review and approval cycles).  SAP Business One doesn't have batch posting logic, each customer invoice is posted all the way through General Ledger.  This may mean to you that ecommerce integration in SB1 is more straight forward, as in general it should be for smaller organization Corporate ERP

12. How to get help?  Please, feel free to call us: 1-866-528-0577, outside of USA: 1-630-961-5918 or email us help@albaspectrum.com  We are very technical and real Dynamics GP Dexterity, SAP Business One SDK and Microsoft CRM programming gurus.  We have Great Plains Software Development Factory and could support unlimited Dynamics GP Customization and Programming needs.  Plus we speak English, Chinese, Spanish, Portuguese, Russian, and not only as native speaking sales folks, but as real technical consultants.  If you prefer skype: albaspectrum

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, Missouri, Iowa, Nebraska, Kansas, Colorado, Nevada, New Mexico, Utah, Arizona, Montana, Oregon, New York, New England. International clients welcome from Australia, New Zealand, Oceania, South Africa, UK, Brazil, Caribbean, Russia, Central America: Mexico, Honduras, Costa Rica, San Salvador, Panama, Nicaragua, Guatemala , South America: Chile, Argentina, Paraguay, Peru, Uruguay, Venezuela, Colombia, Ecuador, Bolivia

Choose Your Partner (Collection) $19.95 (A Collection of Partner Songs for Young Singers). By Alan Billingsley and John Jacobson. COLLECTION. Expressive Art (Choral). 56 pages. Published by Hal Leonard

All Aboard the Partner Express $19.95 "(Seasonal Partner Songs for Young Voices). By Kirby Shaw, Cristi Cary Miller, John Jacobson, Emily Crocker, Tom Anderson, Mac Huff, and Alan Billingsley. COLLECTION. Music Express Books. 56 pages. Published by Hal Leonard"

Partner $13.99 Partner

Partner Songs for the Whole Year Long $3.95 Arranged by Ruth Elaine Schram. Choir Secular. 2-Part Choir. This edition: Score. Choral Collection; Classroom/Pre-School; Partner Songs. Score. 44 pages. Published by Alfred Music Publishing

Spiritual Partner Songs $1.95 By Frederick Beckman. For 2-part choir (with optional C instrument). Spiritual. Octavo. Published by Heritage Music Press

Cuisinart DLC-2A Mini-Prep Plus Food Processor $39.99 Cuisinart DLC-2A Mini-Prep Plus Food Processor

Conair / Mini-Prep Plus Processor / DLC-2A $46.36 Conair - Mini-Prep Plus Processor - DLC-2A

MIDI Solutions MIDI Event Processor Plus $169 MIDI Solutions MIDI Event Processor Plus

Midi Solutions Midi Event Processor Plus $169 MIDI Solutions MIDI Event Processor Plus

On the Railroad (A Partner Song with 'I've Been Workin! On the Railroad') $1.65 "(A Partner Song with ""I've Been Workin' on the Railroad""). Arranged by George L.O. Strid. Choir Secular. For 2-Part choir and piano accompaniment (2-Part Choir). Choral Octavo. Choral Octavo. American Folk Song. Choral and Americana. Octavo. 8 pages. Published by Alfred Music Publishing"

Vortex Plus - processor cooler $27.99 Cooler Master Vortex Plus - Processor cooler - ( Socket 754 Socket 940 Socket 775 Socket 939 Socket 1156 Socket AM2 Socket 1366 Socket AM3 ) - aluminum - 92 mm

Choose Your Holiday Partner (Collection) $19.99 (Teacher Edition). By Alan Billingsley and John Jacobson. TEACHER ED. Expressive Art (Choral). 48 pages. Published by Hal Leonard

Partners in Spirituals... Again! (6 Spectacular Partner Songs for 2-part Voices) $14.95 "(6 Spectacular Partner Songs for 2-Part Voices). By Jean Anne Shafferman. Choir Sacred. Choral Worship Collection; Church Partner Songs; Worship Resources. Choral, Sacred; Spiritual. Book. 24 pages. Published by Alfred Music Publishing"

Used Digitech Dsp128 Plus Digital Signal Processor $69.99 In Store Used USED DIGITECH DSP128 PLUS DIGITAL SIGNAL PROCESSOR

Saddle Up, Partner! (Digital Sheet Music) $4.99 By Ernest J. Kramer. For piano. Classical. EDPNO. 3 pages. Published by Hal Leonard - Digital Sheet Music

Teacher's Partner: Basic Violin Studies, first year $14.98 For violin. Play Along. Sheet music and accompaniment CD. Published by Music Minus One

Teacher's Partner: Basic Clarinet Studies for the Beginner $14.98 For clarinet. Instrumental Solo Part and CD. Published by Music Minus One

Teacher's Partner: Basic Flute Studies, first year $14.98 For flute. Instrumental Solo Part and CD. Published by Music Minus One

DLC-XPBC Plus Food Processor Brushed $799 Cuisinart DLC-XPBC DLC-X Plus Food Processor Brushed Chrome DLCXPBC

Processor $9.49 Processor

Cuisinart DLC4CHB Mini Prep Plus 4 cup Food Processor $49.95 Cuisinart DLC4CHB Mini Prep Plus 4 cup Food Processor

Cisco Timing Communication And Control Card Plus Control Processor UBR10TCCT1 $4038 Cisco Timing Communication And Control Card Plus Control Processor UBR10TCCT1

The Partner $4.99 One bullet changed her life In a heart-stopping moment she'd never stop reliving, Risa Taylor lost everything—her partner, her friends, her career and her self-confidence. The family she was never close to has taken a step back and there's nowhere else to turn. Things can't get much worse. Except, of course, they can. Every officer-involved shooting is investigated by Internal Affairs, and the man in charge is Grady Wilson, who's known for his unorthodox methods and his unquestionable results. At first glance, the case seems like a slam dunk, especially when the ballistics report shows that the bullet that killed her partner came from Risa's gun. But a phone call from an anonymous informant, and the feelings he starts to have for Risa, have Grady looking a little deeper, determined to find out what really happened on that steamy night in Houston.

PowerPrep Plus 14-Cup Food Processor $351.32 This PowerPrep Plus 14-cup food processor from Cuisinart is a perfect addition to any kitchen to meet your cooking needs. Touchpad controls, three different settings, and more bring the needed features of any good food processor. Color: RedCapacity: 14 cupHow many settings: 3Dimensions: 10 inches long x 13 inches wide x 17 inches highMaterials: Plastic, metal, electrical componentsHardware finish: Stainless steel14-cup work bowl with handleTouchpad dough controlWork bowl cover with one-piece supremeWide mouth feed tubeLarge and small pushersPowerful induction motor for heavy doughTouchpad controlsDetachable disc stem2 discs2 bladesSpatulaRecipe bookThis high-quality item has been factory refurbished. Please click on the icon above for more information on quality factory-reconditioned merchandise.

This entry was posted on Tuesday, March 16th, 2010 at 8:54 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.