SAP B1 is open for external data integration, such technologies as EDI, Sales and Purchase Order Processing in partner networks through several tools.
Assuming that you are small or mid-size business, likely that you would like to use free instruments, versus purchasing something comparable to your SAP BO software cost (iBolt for example). In this small publication we would like to review free SBO integrating methods: Data Transformation Workbench, SAP Business One SDK programming:
1. First of all we would like reassure you that in the integration you can go beyond simple Microsoft Excel templates filling up and saving them in CSV format. Instead you should think about flexibility of ODBC connection for SB1 Data Transformation Workbench or even direct manipulation of SAP Business One objects in SB1 SDK or Software Development Kit
2. ODBC connection in Data Transformation Workbench. SB1 DTW was intended for initial data conversion or ongoing data import to SAP Business One. You may also know that if you are using CSV files – you can schedule DTW integration in Batch file. In this scenario, if you have external legacy Database: Oracle, DB2, Lotus Notes, Pervasive SQL, Ctree, Microsoft Access, or even tab delimited text file – then using MS SQL Server Data Transformation Package you can reshape the export from your legacy application and save it into CSV templates to be imported in scheduled batch job. ODBC connection at this time is not supported for automatic scheduling by SB1 DTW. Instead, you can create SQL views, including cross-platform views (where data is pulled from non-Microsoft Database: PHP mySQL for example) and having simple DTW operator procedure import them on demand
3. SAP Business One EDI programming. If you are working in the small company, but you are at the same time reasonably technical, then you don’t have to purchase SB1 EDI add-ons and configuration tools. Instead you can deploy SQL DTS package, reading EDI text file and transforming it into CSV DTW templates or opening it to the DTW via ODBC SQL view
4. SAP BO SDK programming. SDK opens unlimited access to SB1 objects and their creation, modification and deletion. SAP B1 SDK programming requires programmer certification, which might lead you to the idea to subcontract SB1 SDK software development project to your SAP Business One Technology Partner and Reseller
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQ
Planning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.
Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella
