SAP Business One Custom Development Scenarios

These facts facilitate customization and integration where you have to appeal to programming in Microsoft Visual Studio.  Software Development Kit has code samples in VB and C# and this is one of the reasons why these coding languages might be recommended.  We would like to give you several examples where Business One was customized and they are taken from real life:

1. Alternative Cost and Profit calculation.  Let’s assume that you are selling minutes of advertising and your cost is negotiated with media portal every month.  You would like to see profitability of each invoice and summary by customer or group of customers.  The solution was the following.  You create new user defined table named ‘Monthly Cost.’  In Crystal Reports you design report based on custom SQL View.  In  this view you are summarizing invoices revenue and subtract the cost from ‘Monthly Cost’ table associated with invoice date

2. Sales Order import from external system.  Let’s assume that you are importing large number of sales orders every day from Linux based application.  You create user defined table matching Order Line table.  Via SQL cross platform query you are pushing order lines from external application.  Then you program integration in SDK.  Integration is taking lines one by one and creates or appends them to Sales Orders.  When you are using Software Development Kit there is no risk of data compromising as its methods validate business logic as it would be done if you are entering document directly in user interface

3. General Ledger transactions import to Dynamics GP from SAP B1.  Here let’s assume that you are multinational company with Dynamics GP as Corporate ERP implemented in Headquarters in the United States.  You have location in Brazil where Dynamics GP is not offered and is not localized.  You implement SAP BO in Brazil where it is available in Brazilian Portuguese, localized directly by SAP and to reasonably popular.  In Dynamics GP you create the company for your Brazilian subsidiary and setup General Ledger the same way as in SB1 or in other words with the same chart of accounts.  Every week you are exporting GL Entries from Business One into text file and mark them as exported directly from SQL Server Database.  Then you upload text file into ftp hosted on the server in the Headquarters.  From Great Plains side you are importing GL entries from text file via Integration Manager

4. Sales Commission Report with complex commission formulae.  Let’s assume that your commission is based on advanced calculations and each invoice might have up to five programs where each one is subject for sales commission.  Good idea here is to append user defined fields for commission formula to Invoice Header table.  When you are entering invoice in menu you mark show user defined fields and popup is showing up to the right from Invoice Entry form.  Next step is Crystal Report design where commission is calculated and shown on the report

5. Please call us 1-866-304-3265, 1-269-605-4904, help@efaru.com.  We have local presence in Chicagoland, Southern California, South 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 and Chinese