Submitted by: Clintontb Hunt
If your EDI channel calls for XML, you are most likely more versatile in the tools and coding techniques assortment
3.Outbound EDI. You really should either study SB1 tables framework, which is explained in SAP Organization One particular SDK. A different solution is to enable technique information in SB: View -> System Info. If it is enabled, open your Obtain Purchase and place the cursor over the area you want to export in EDI code – in the left bottom corner you need to now see the table and the area names. To format your information in fixed field duration way, use Cast or CONVERT SQL clauses. Save your EDI export in the text file – you should take into account deploying DTS (Knowledge Transformation) bundle to extract information and help save the file. For XML you have sturdy assistance in MS SQL Server 2005 or 2000
four.Inbound EDI. Here we advocate DTW or SAP Enterprise A single Knowledge Transfer Workbench. Having said that you do not use right here CSV files (also frequently referred as Excel templates). Here you deploy ODBC source to MS SQL Server. From MS SQL side you must get ready views or SQL stored techniques. Yet again, deploy DTS package, which will initial transfer your EDI file into SQL staging tables. Then from these tables, use Watch to put together the final results for Workbench. To stay clear of linking and configuration issues, in your SQL view – have discipline names to be the identical as in Workbench Excel template for the similar object, you are intending to integrate.
If you have SAP B1 ERP applied in your organization, you are almost certainly already acquainted with inner studies, queries, XL Reporter and in this small publication we would like to give highlights on Crystal Reports. Each and every reporting instrument has its very own pluses and drawbacks, and you should try out various instruments, if your reporting wants are broad: from Financial reporting (Trial Balance, Stability Sheet, Revenue and Loss, Money Movement Statement) to Operation reporting (Product sales by Regions and Objects, Revenue Commission Report, Venture Profitability to name a few examples), plus if you require sector varieties, like as Bill of Ladings, Agent Settlement Report:
one. XL Reporter. This reporting instrument is incredibly end user friendly and if you are accountant, who is neither comfortable nor familiar with SQL scripting, this report must in shape your wants. This report is deploys Microsoft Excel instruments and it has VBA extension to MS Excel. However this reviews structure tool operates with predefined SB1 objects: Company Lover, Account, Item, Selling price Listing and comparable, and you are restricted in constructing custom back links. And this is understandable – if you need innovative one way links in your report, you will want SQL watch or Stored procedure as the report base – you can attain this goal in Crystal Report.
two.Crystal Reports. If you are discovering Crystal Reviews design and style as a result of report building wizard, then you need to pay attention SAP BO teaching class possibly online or face-to-confront. Even so if you are report developer and function in IT department, then you must go to SQL watch or saved process scripting. Stored process is the most potent tool and its parameters should be translated to Crystal Report parameter.
About the Author: The best la jolla personal computer restore web page on the World wide web