Crystal Reports For Sap Organization One particular Or Dynamics Gp Notes For Programmer
Crystal Reports is in our opinion one of the most beneficial industrial reporting tool, which has massive number of report designers to perform the job as well as Crystal Reports customers, that are familiar with Crystal Report launching, sorting, grouping (expanding and collapsing, and so forth.). CR permits you to abstract from your ERP application (in our situation SAP B1 and Dynamics GP formerly Good Plains) and built the mcitp certification report in pure SQL information selection (Microsoft SQL Server view or stored procedure on the SB1 or GP enterprise DB level). In this modest publication we would like to share together with your Crystal Reports design approaches:
1.Dynamics GP and SAP BO table structures. It is easy to assessment full structures in Dynamics GP SDK as well as in SAP Enterprise One particular SDK. However, if your report is rather simple and you anticipate to involve, say 5 tables or so, you can actually swiftly acquire the table in Dynamics GP: Tools->Resource Description->Tables or in SBO: in Menu choose show program specifics
2.SQL Views and Stored Procs approach. For anyone who is new to Crystal Reports, you’re able to try report wizard, in spite of this for anyone who is seeking out expert reporting, we advise you to abstract reporting tool from its DB queries by way of SQL View or SQL Stored Process (exactly where parameters are translated into CR parameters automatically). In Dynamics GP Fantastic Plains you may go ahead and make custom SQL objects in GP provider database directly. In SAP BO, in spite of this Early Watch service tends to make its policeman job and you do not want to location custom SQL objects into SB1 enterprise or program databases, rather produce new database (SB1Customization, for example) and place SQL View or Stored Procedure there. In the situation, whenever you have many providers in SAP Company 1, it’s best to consider working with Exec statement within the stored procedure to develop on the fly select statement with the business DB name, taken as parameter
3.Consolidated reporting. In Dynamics GP you’ve got FRx Financial Reporting to create Balance Sheet and P&L statements with preset link to GP General Ledger tables. SAP Small business 1 is very mcse 2008 comprehensive in exporting BS and PL statement into Excel worksheet. We advocate you to give some thought to FRx consolidated reporting in case your business enterprise includes various subsidiaries, where you could have mixture of Dynamics GP Great Plains and SAP Home business A single ERP and MRP applications. In FRx you could construct and deploy FRx reporting tree to analyze reports by branch or consolidated by the whole organization
Processing your request, Please wait....
