If you have SAP B1 ERP carried out in your business, you are probably now common with inside stories, queries, XL Reporter and in this tiny publication we would like to give highlights on Crystal Reviews. Each individual reporting tool has its own pluses and drawbacks, and you really should test several instruments, if your reporting desires are broad: from Economic reporting (Trial Harmony, Harmony Sheet, Profit and Decline, Income Stream Statement) to Operation reporting (Profits by Areas and Products, Gross sales Commission Report, Task Profitability to title a couple of examples), additionally if you want business varieties, this kind of as Bill of Ladings, Agent Settlement Report:

1. XL Reporter. This reporting tool is quite finish user friendly and if you are accountant, who is neither at ease nor common with SQL scripting, this report should really healthy your wants. This report is deploys Microsoft Excel instruments and it has VBA extension to MS Excel. Nonetheless this stories style resource is effective with predefined SB1 objects: Company Associate, Account, Item, Selling price Checklist and related, and you are constrained in constructing custom hyperlinks. And this is easy to understand – if you will need innovative backlinks in your report, you will need to have SQL see or Saved process as the report base – you can accomplish this target in Crystal Report.

2. Crystal Stories. If you are getting Crystal Studies structure by way of report making wizard, then you need to pay attention SAP BO teaching course both on line or facial area-to-confront. On the other hand if you are report developer and function in IT office, then you should go to SQL look at or stored procedure scripting. Saved technique is the most impressive software and its parameters must be translated to Crystal Report parameter. Stored Treatment lets you to construct short-term tables in just its boundaries – this ought to resolve complicated unionizing and establish staging tables if required. Saved technique must be in a position to construct extremely elaborate report – attempt to style something like Product sales challenge profitability, primarily based on incurred charge in Invest in Get Processing, Output (performing hrs and probable overhead).

3. SQL Server Reporting Companies or SRS. This tool is world-wide-web dependent, which must give you selected rewards if your corporation has regional workplaces and intercontinental presence. SRS in its suitability is rather equivalent to Crystal Experiences and it bases its reviews on SQL Sights or SQL Saved Treatments.

4. Industry Kinds. If you are imagining which reporting resource to deploy and how, the trace is uncomplicated – these reports should depict only one particular document: Revenue Bill, Invest in Purchase, Vendor Bill in the format, demanded by your field regulation. You can use Crystal Report (which could be integrated in your SAP B1 interface) as very well as SRS (if you want to enable these reporting above the web).

Leave a Reply