SAP Business One Customization and Integration Projects Second Opinion

Apr 30
21:16

2012

Andrew Karasev

Andrew Karasev

  • Share this article on Facebook
  • Share this article on Twitter
  • Share this article on Linkedin

Small and mid-market ERP consulting in its generic approach could not necessary be associated with computer technologies and programming.

mediaimage

However sometimes you need your accounting system to be interconnected with external database including EDI,SAP Business One Customization and Integration Projects Second Opinion Articles ecommerce shopping cart and others.  Local resellers are often perfect in selling new software licenses as well as in generic implementation.  Sometimes we hear complaints from the customers that their VAR was not really technology savvy and software development project went into limbo phase or even failed completely.  We would like to give you some materials for your homework on coding in SAP B1 as well as the good advice on selecting consulting firm specializing in technologies such as Software Development Kit, Data Transfer Workbench and others:

1. Do I really need custom programming?  This question depends on the situation.  In best case scenario you should select reliable ERP which covers your specification completely.  If there are gaps in functionality try to look at add-ons available through ISV partner channel.  The number of add-ons should be limited to one or two as it might be difficult to manage them in the future and from annual contract standpoints.  If you cannot find ISV product then you need to decide if custom software development is the way to undertake or not

2. SDK programming in Microsoft Visual Studio.  Software Development Kit has code samples in VB.Net and C#.  It validates business logic and this is why it is immune to such problems as data corruption or compromising.  Popular scenarios are associated with ongoing real time or quasi real time integrations where you are feeding Sales invoices from ecommerce shopping carts or from Sales management systems

3. SDK coding and future version updates.  It is important to own source code as in the future when you are upgrading to new version you have to recompile the project with new DLL libraries and assemblies.  You may have harmonic relations with your current consulting partner but in the future this organization might go out of business or lose interest to your project

4. Cross-Platform integrations.  You may have something like ecommerce portal hosted in Linux server where DB is MySQL and coding was performed in PHP.  Business One is hosted in MS Windows and database is Microsoft SQL Server.  Consider creation of the SOAP XML web service which could be called over the internet from Linux

5. Data Transfer Workbench.  Every certified consultant knows how to use this tool in initial data conversion and import into SAP B1.  There are CSV templates for almost every master record and transaction.  Data massage is typically done in Excel.  However you can schedule ongoing integration where connection is done via ODBC to SQL View where you have to imitate exact format of CSV template related to the object to be migrated

6. Second Opinion.  Custom software development requires dedication and if your reseller doesn’t have expertise in-house it might be too risky to contract them to do the job.  We recommend you to seek for second opinion and be ready to contract nationwide technology firm which has software development factory or strong technical support department.  Try searching in Google or Yahoo or simply call SAP for references

7. Please call us 1-866-304-3265, 1-269-605-4904, help@efaru.com.  We have local presence in Chicagoland, Southern California, Atlanta Georgia, South West Michigan, Houston and Dallas areas of Texas. We serve customers USA and Canada nationwide and internationally via web sessions and phone conferences (Skype is welcomed).  We are working on Brazilian ERP consulting market in Sao Paulo since 2004