SAP Business One Atlanta Customizations Second Opinion
We will try to compose this paper in the form of short questions and answers or if you like in FAQ style. SAP B1 is popular in small and mid-size business environment as ERP, MRP and accounting software:
Q. We contracted programmer who assured us that he should be able to code integration in SQL Stored Procedures. When he begun to deploy the code we had to turn off Watch Dog service and plus we are currently experiencing General Ledger double entry dis balance. Are we missing something or what could be you input here?
A. Business One has three tiers architecture with SQL Database, Application Server and client interface. In custom development you should work with application server, meaning that programming should be done in Microsoft Visual Studio C# or VB with Software Development Kit libraries. SDK validates business logic and it is immune to data compromising
Q. We are designing Sales Commission Crystal report. Developer seems to be experienced in programming, but our report is producing rows duplications and we cannot trust it
A. Crystal is perfect design tool but it is up to developer to assure reliable data pulling from SQL database. Good recommendation is to start with SQL View or Stored Procedure in data extraction. Test the view directly in SQL Server Management Studio and when you are satisfied with results launch Crystal Designer. Records supplicates often happen when programmed is in learning curve and relies on all kinds of wizards
Q. We understand that SDK has code samples in C# and VB and this is why Microsoft Visual Studio is recommended tool. But is it possible to code in something different in Delphi for example?
A. General answer is ‘yes’. Delphi software developers especially the ones with reasonable experience can read and translate C# code to Delphi (formerly known as Pascal)
Q. We are on Business One in the headquarters in the United States and currently we are opening location in Campinas Sao Paulo area in Brazil. They have SPED (Public Digital Bookkeeping System) with pretty straight forward reporting in XML format. We plan to develop SPED compliance in our IT department. Is it doable?
A. We do not recommend this approach. SPED is automated in add-on available through Brazilian ISV channel. Theoretically it could be done but you don’t really want to mess up with government reporting
Q. We have customization but we lost our source code. Is it possible to upgrade it now to new version?
A. Without code it might be impossible. SDK module should be recompiled with new version DLL libraries
Q. We plan to integrate Sales transactions from our custom ecommerce shopping cart hosted in Linux on MySQL database and coding was performed in PHP. Could you give us general recommendations?
A. Sure. Consider creating SOAP XML Web Service project in MS Visual Studio with code snippets from SDK. You should be able to debug and deploy the integration module by calling web service over the internet from Linux server
Please call us 1-866-304-3265, 1-269-605-4904, firstname.lastname@example.org. 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
Andrew Karasev is SAP BO consultant and Great Plains Certified Master, MVP, email@example.com 1-866-304-3265, 1-269-605-4904. He is also the initiator of eFaru project http://www.efaru.com and founder of Alba Spectrum information space. Faru Corporation is join venture with M2-D2 http://www.m2-d2.com We have strong connection to our Software Development Factory in Sao Paulo, Brazil