Crystal,Reports,for,SAP,Busine computer Crystal Reports for SAP Business One or Dynamics GP notes fo
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
CR allows you to abstract from your ERP application (in ourcase SAP B1 and Dynamics GP formerly Great Plains) and built the report in pureSQL data selection (Microsoft SQL Server view or stored procedure on the SB1 orGP company DB level). In this smallpublication we would like to share with your Crystal Reports design techniques: 1. Dynamics GP and SAP BO table structures. You can review complete structures inDynamics GP SDK as well as in SAP Business One SDK. However, if your report is simple and youexpect to involve, say 5 tables or so, you can quickly find the table inDynamics GP: Tools->Resource Description->Tables or in SBO: in Menuselect show system information 2. SQL Views and Stored Procs approach. If you are new to Crystal Reports, you cantry report wizard, however if you are looking for professional reporting, werecommend you to abstract reporting tool from its DB queries through SQL Viewor SQL Stored Procedure (where parameters are translated into CR parametersautomatically). In Dynamics GP GreatPlains you can go ahead and create custom SQL objects in GP company databasedirectly. In SAP BO, however Early Watchservice makes its policeman job and you do not want to place custom SQL objectsinto SB1 company or system databases, instead create new database (SB1Customization,for example) and place SQL View or Stored Procedure there. In the case, when you have several companiesin SAP Business One, you should consider using Exec statement in the storedprocedure to build on the fly select statement with the company DB name, takenas parameter 3. Consolidated reporting. In Dynamics GP you have FRx FinancialReporting to build Balance Sheet and P&L statements with preset link to GPGeneral Ledger tables. SAP Business Oneis very comprehensive in exporting BS and PL statement into Excelworksheet. We recommend you to considerFRx consolidated reporting if your business includes several subsidiaries,where you have mixture of Dynamics GP Great Plains and SAP Business One ERP andMRP applications. In FRx you can buildand deploy FRx reporting tree to analyze reports by branch or consolidated bythe whole organization
Crystal,Reports,for,SAP,Busine