Article by Alba Spectrum

If you have SAP B1 ERP implemented in your organization, you are probably already familiar with internal reports, queries, XL Reporter and in this small publication we would like to give highlights on Crystal Reports. Each reporting tool has its own pluses and drawbacks, and you should try multiple tools, if your reporting needs are broad: from Financial reporting (Trial Balance, Balance Sheet, Profit and Loss, Cash Flow Statement) to Operation reporting (Sales by Regions and Items, Sales Commission Report, Project Profitability to name a few examples), plus if you need industry forms, such as Bill of Ladings, Agent Settlement Report:

1. XL Reporter. This reporting tool is very end user friendly and if you are accountant, who is neither comfortable nor familiar with SQL scripting, this report should fit your needs. This report is deploys Microsoft Excel tools and it has VBA extension to MS Excel. However this reports design tool works with predefined SB1 objects: Business Partner, Account, Item, Price List and similar, and you are limited in building custom links. And this is understandable