SAP B1 is committed to little and fair size businesses. This ERP and MRP enhanced bookkeeping application turns out to be increasingly well known, particularly since the arrival of SB1 rendition 2007A. The natural and extremely basic Abeam SAP Support BO interface frequently accompanies the reality that SAP Business One confirmed consultant comes without strong specialized foundation in information change, customization, SDK programming and furthermore in making impromptu SQL questions. We should make reference to here, that you can generally proceed to send SAP Business One SDK programming in reconciliation creation, anyway here we will focus on “low profile”. We should start:
1. SB1 Data Transfer Workbench: CSV record and Excel formats. Through our training, a huge number of Sap Business One useful consultants prescribes you just to follow layout Excel records topping off and sparing them in the CSV group as a favored approach to do combination. Furthermore, they additionally suggest it for one-time incorporation just in the underlying information transformation and movement. In the event that you needn’t bother with extra revelation and searching for second supposition in SAP Business One accomplices network – this prompt is acceptable and entirely dependable. Be that as it may – what to do on the off chance that you need progressing and even planned reconciliation?
2. Basic ODBC questions. We should move to one side and attempt ODBC in Source Data Type. On the off chance that you are IT proficient, SQL DBA or developer, you know, that ODBC association opens the totally different universe of such decent devices as MS SQL Server connected worker, SQL View to get through the limitations of text records
3. SQL Views Scenario. Presently envision, rather than relying upon CSV records, made by hand, you make SQL see, which will be the base for the coordination. In the event that you need to coordinate SB1 with front end inheritance database (counting SQL connected worker developments to such stages, as Oracle, DBII, Ctree, Pervasive SQL), you should query required SQL see structure in Excel layouts for the proposed SB1 objects and essentially make them on Microsoft SQL Server level
4. Planning Workbench progressing combination. Workbench help recommends you to spare mix structure in XML position (you do it on the stage 5: Run the information import – click Save catch and you will have the option to spare coordination in XML diagram). Make – bat (DOS group) document. At that point plan it in Start->All Programs->Accessories->System Tools->Scheduled Tasks. This would be the test line in the BAT record: C:\Program Files\SAP\Data Transfer Workbench\DTW – s C:\Program Files\SAP\Data Transfer Workbench\config.xml.…