SAP,Business,One,Integration,a computer SAP Business One Integration and Data Conversion Notes
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
We expect that your issue is rather data conversion andongoing integration from EDI source, ecommerce application, etc., in this caselet's first review the power of Data Transfer Workbench, and only after, if youfeel that this is not enough we will move to SDK: 1. SAP Business One Data Transfer Workbench. If you are SBO certified consultant, youshould remember your exercises in initial data import: business partners, GLaccounts, Inventory Items, Price Lists, Initial Item Quantities, GL InitialBalances. In all these examples you weregiven CSV templates, which should be filled in with required and optional fields,then when you come through Data Import Wizard, you provide connection to yourCSV filled in templates. However, if youare also familiar with such concepts as ODBC Connection, MS SQL View, pleaseconsider SQL views creation, which will resemble exactly the same pattern asfilled CSV files. Let's assume that youare placing purchase orders via your EDI partner channel, select oPurchaseOrderbusiness object, then highlight Document and switch Source Data Type to ODBC,click Browse and in Simple Select Statement use your SQL knowledge to selectdata from the view created above - PO header should be taken care about. Now required element is Document_Lines - herefollow the same approach, plus take care if additional objects are needed inyour case. Now, the trick - if youfollowed exact Column Names in the SQL View, then columns mapping will be alsorecognized automatically in the Wizard. Then, assuming that you are familiar with CSV data conversion way in SB1- you will get work done. Here we haveto admit to our displeasure, that for 2007A SAP recognized that ODBCintegration scheduling is not supported, and as we figured out it doesn'twork. But, even so, in our opinion fiveminutes of SB1 Data Transfer Workbench of operator time will allow you toimport your desired objects and it worth the time spent. Please, at this point review objects exposedvia CSV templates, and give us a call if something is not covered that you needto be covered. So, maybe next step - SAPBusiness One SDK certification and programming is optional for you? 2. SAP B1 SDK. Here please consider the option to find really good SB1 ISV andTechnology partner with Software Development Factory. SDK has access to virtually all SB1 objectsand you can do real time data integration from your legacy ecommerceapplication, change user interface 3. Direct SQL data feeding. Please avoid this, as SAP Business One hasEarly Watch service, which is tracing SQL DB data intervention, instead revisitWorkbench or SDK Programming options4. Extra SAP Business One Modification Tips. You can extend existing tables by adding UserDefined fields, and these fields automatically will be assigned data enteringinterface. If you add custom fields toyour Business Partner, for example, simply pull BP records and in menu clickView -> User Defined Fields. If youhave to create new User Defined Table, it also gets data entry interfaceautomatically 5. We are restricted by Article genre, so, pleaseif you would like to hear your business case study, or SAP Business OneExecutive or Technical presentation, please feel free to call us:1-866-528-0577, [email protected]
SAP,Business,One,Integration,a