If you plan to do ongoing data integration in SAP B1 without deploying SB1 SDK programming, try to research SAP BO Data Transfer Workbench ODBC source option.
This small publication should help you in SAP B1 partner, reseller selection – at least you should be able to ask the right questions about your SAP Business One VAR expertise
1. Initial Data conversion. Data Transfer Workbench has set of CSV templates and all you need to do is to fill them in Excel, paying attention to required and in necessary add values to optional fields. And good news is the fact that most of SAP B1 consultants are familiar and reasonably good with initial data conversion and migration and will help you with filling CSV templates
2. Ongoing data integration. Here, you should find people who are familiar with advanced Workbench techniques. For example, if consultant is saying you that she or he will help you prepare your ongoing integration files in Excel – this is probably not the answer you need to accept
3. ODBC source. Here you use the following technique. Create SQL view, which will prepare your data for import in exactly the same format as discussed above CSV template. ODBC source can work with text file, however the limitations of Text driver may lead you to importing source files into MS SQL Server staging tables. One of the limitations of ODBC source based integration is the fact, that SAP doesn’t support scheduled run for it
4. Workbench integration scheduled run. You can create batch file, where you call your XML integration saved file with –s parameter, please read Workbench help. If you like scheduled run for really complex integration, where you would have to deploy ODBC sources, please consider to deploy SQL data import, massage via SQL stored procedure or view and then export it to CSV files – the best tool to do the job is likely Data Transformation Services (DTS) package
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
