SAP Business One Customization Projects

May 8
09:32

2011

Andrew Karasev

Andrew Karasev

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

This small business ERP system is reasonably new and it has powerful custom programming instruments.

mediaimage

We also recommend you consider SB1 if your company is expanding internationally as it is localized in many countries and you can deploy international company databases on central server in US or Canadian Headquarters to save money on IT infrastructure and exercising control over accounting transaction Worldwide.  SAP B1 has easy way to export reports to Excel and this option gives you an opportunity to consolidate small international facility Balance Sheet or P&L with your Corporate ERP,SAP Business One Customization Projects Articles which could be Dynamics GP, AX, SL, or another platform.  Financial Reporting tools typically allow you consolidate small companies directly from Excel, for example FRx or Microsoft Management Reporter.  Let’s now take a look at modification and programming for this Corporate ERP system:

1. Settings in the standard user interface.  First of all we recommend you evaluate custom features available in the user interface, or in other words evaluate feasibility of custom programming.  Let me give you example.  Let’s assume that you would like to show additional fields on Sales Invoice Item lines.  In this case all you need to do is click on customization icon (having cursor on the Sales Line) and mark fields you would like to show in the grid.  If you would like to add additional fields to something like Customer record, you may just add them to the Business Partner table via user interface and they will be available (good example is when you want several salesperson to be associated with the customer with commission split by percentage).  You can even create custom table which is available immediately via user interface.  And then you can base something like Crystal Report over this table or include in into SAP BO SDK custom programming project

2. SAP Business One Software Development Kit (SDK).  Well, if you think that custom objects available via standard user interface in settings are not enough, there is SDK.  Programming could be done in your preferred language; we recommend you consider MS Visual Studio C# or VB.Net.  However we had project coded in Delphi (former Borland Pascal).  Based on our experience we also recommend you to consider combining Custom Tables (created directly via user interface) and their field integration logic with core B1 tables. 

3. Maybe Custom Reporting in Crystal should do the job?  Let’s consider such business case.  You want your Sales Invoice net profit amount to be based on the cost which you have in your custom table (as you may be reselling something and cost per unit of measure is set by your franchisor every month).  Very good, create this custom table in user interface, instruct your employees to enter cost amount every month. Then create Crystal Report, where you are pulling Sales amount from Invoices and cost from this custom table.  Pretty clear idea, right?  And no custom programming is required.

4. What you should not to do in customization.  This application doesn’t expect you to do direct SQL Insert or Update statements via SQL Query or Stored Procedure.  Consider SDK programming instead.  There is watch dog service which is recommended to be activated on each user workstation.  It role is to report to SAP illegal update, insert directly to the database tables.  Having said that, we do recommend you to deploy either Workbench or such tools as DI Server (XML friendly) for data import into Business One

5. How to find Customization Partner?  Well, SAP requires each partner to maintain certification level and SDK programming requires special certification.  This is why if you have the evidence that your original reseller is not certified in SDK programming, you may decide to look for second opinion and switch to another VAR

6. Where service is available?  Software Development is boundaries proof.  Having said that we could serve you in the USA all the states and in Canada in all the provinces.  We also have strong presence in Brazil, where Business One is in market gaining mode.  If you need local touch, we could help you in South West Michigan (St. Joseph, Kalamazoo, Saugatuck, Muskegon, New Buffalo, Holland area, plus we are travelling to Grand Rapids megapolis), Chicagoland (special attention to the customers in Naperville/Aurora area), Atlanta Georgia (covering the whole metropolitan area)

7. Please call us 1-866-304-3265, 1-269-605-4904. help@efaru.com We have local presence in Chicagoland, Southern California, West Michigan, Houston and Dallas areas of Texas. We serve customers USA, Canada, Mexico nationwide and internationally via web sessions and phone conferences (Skype is welcomed). Our consultants speak English, Spanish, Portuguese, Russian, Chinese