SAP B1 is popular small and mid-size business Accounting, ERP and MRP application. Typical configuration is on Microsoft Windows and MS SQL Server, and these two facts make SAP BO open for various generic reporting tools: Crystal Reports, Microsoft SQL Server Reporting Services, MS Access, or generic .Net web HTML and XML development with web reports.
CR seems to be the trend for current SB1 2007A/B versions as well as for the future releases. In this small publication we would like to give you Crystal Reports design orientation session:
1. SAP B1 tables structure. It is described in SAP Business One SDK, however you can easily identify the table in menu by checking Show System Information. Then, open SB1 form, associated with your targeted object, for example Business Partner – the table name will be shown on the left bottom cornet of the application
2. Early Watch and adding objects to SB1 company database. We believe that Early Watch, that reports direct access to SB1 tables through SQL custom stored procedures or updates should be respected. This is why we recommend you to create separate database – something like SB1Customizations and then place Crystal Reports basing SQL Views or Stored Procedures there
3. Crystal Reports SQL side. If you are new to Crystal Reports design, you should probably play with new report building wizard, and if your report is really simple, something like showing all Business Partners with specific flag, then CR wizard should do the job. However, if you are looking for professional SB1 CR, you should consider basing it on either SQL Stored Procedure (the most powerful way, as it allows you to deploy temporary tables for intermediary data aggregation) or SQL Views. Plus SQL abstraction opens the door for you to base Crystal Report on Heterogeneous or Cross-platform data pulling, when you are pulling data from SB1 and legacy CRM or Business Management Application, hosted in ODBC compliant or SQL drive compliant non MS SQL Server DB: Oracle, DBII, MS Access, Excel, Sybase, Ingress, MySQL/PHP, or other Linux or Unix database, deploying such drivers as Java JDBC-ODBC Bridge, etc.
4. If you have specific technology challenging question about SAP Business One reporting, Software Implementation, Customization, Data Conversion question, please give us a call: 1-866-528-0577, help@albaspectrum.com
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQ
Planning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.
Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella
