The Merchant Squad

Look no further for the best information

SAP Business One EDI Custom Integration – Overview For Programmer

Abeam SAP B1 ERP and MRP applications could be effectively incorporated with your Electronic Document Interchange channel, either for outbound (when you are requesting items from your merchants) or inbound (when your clients put in their requests in EDI code). In this little article, we might want to give your SB1 EDI programming and business features:

1. EDI as a fixed length fields group. This is conventional EDI, when you have a report header, lines and trailer. All the fields have foreordained fixed length and position

2. EDI as XML. This is a new pattern, where XML does likewise work as a fixed length group, referenced previously. On the off chance that your EDI channel requires XML, you are most likely increasingly adaptable in the instruments and coding strategies choice

3. Outbound EDI. You ought to either investigate SB1 tables structure, which is portrayed in SAP Business One SDK. Another alternative is to empower System data in SB: View – > System Information. On the off chance that it is empowered, open your Purchase Order and spot the cursor over the field you need to trade in EDI code – in the left base corner you should now observe the table and the field names. To design your records in a fixed field length way, use CAST or CONVERT SQL conditions. Spare your EDI send out in the content document – you ought to consider conveying DTS (Data Transformation) bundle to remove records and spare the document. For XML you have strong help in MS SQL Server 2005 or 2000

4. Inbound EDI. Here we suggest DTW or SAP Business One Data Transfer Workbench. Anyway you don’t use here CSV records (likewise regularly alluded to as Excel formats). Here you convey ODBC source to MS SQL Server. From the MS SQL side you ought to plan perspectives or SQL put away techniques. Once more, send a DTS bundle, which will initially move your EDI record into SQL arranging tables. At that point from these tables, use View to set up the outcomes for Workbench. To abstain from connecting and setup issues, in your SQL see – have field names to be equivalent to in Workbench Excel layout for a similar item, you are expecting to incorporate.

Lydia Jimenez

Back to top