Crystal Reports for SAP Organization One particular Combining Regular and Custom Fields and Tables
In version 8.81 there’s no have to have to install unique Crystal add-on as typical logic allows you incorporate CR. We would prefer to offer you widely used Sales Commission report style case study, exactly where we are deploying such functionality as User defined tables and fields. These objects are open to designer too as end user for data entry modify or deletion. There is no need to have to complete programming in SDK or in other tools. Let’s start with requirement analysis and mapping it to B1 settings:
1. Let’s assume that your clients a practice exams
are served by the complete team of sales engineers and project managers and you may have complicated commission structure. Initially of all commissions are categorized and each category has distinct percentage. Second challenge is the fact that some categories are only applicable during the very first year of service, when other people might be permanent. Third function will be the truth that you are reselling time units for your clientele and each month your hourly cost varies depending on negotiated quantity with your franchisor
2. User Defined Commission Table. Programming just isn’t expected here. In user interface comply with the path: Tools -> Customization Tools -> User Defined Tables Setup. Right here create the table with the fields according for your specification. What is pretty amazing in our opinion – there’s no need to create user interface to this new table – it is already created by normal functionality. In order to fill commission table please comply with the path: Tools -> User Defined Windows and select Commission and you should be able to open table grid with editable fields
3. Assigning commission to Home business Partner/Customer. Now we will be adding User Defined fields to the Home business Partner table. Again Customization Tools -> User Defined Fields Management and right here expand Master Data and twice Business Partner. Highlight Organization Partner and you will see Add button on the bottom of the form. What is also amazing is the fact that fields are really appended to the table existing common fields and table structure changes. Right here you should add several commission categories and sales representatives for each one
4. Enabling User Defined fields on Business Partner form. Open Business Partner Master Data screen and in menu View mark User Defined Fields. Again we didn’t do or suggest any software development in SDK – it is all in Settings. At this point assuming that you simply already entered all the commission categories and specified them for each enterprise partner ccna exam answers we’re ready to go ahead with CR design
5. Best Crystal Report design practices. We strongly recommend you to create SQL View or Stored procedure as the base for your report and test result set directly in SQL Server Management Studio Query. Reporting tools are architected to be just for reports. They have reasonable information linking functionality especially for novice designer via wizards, but this is unlikely to be the best option in producing professional report. SQL Stored procedure is even more powerful as it allows you to deploy cursor in its body or create temporary table. Please, note that temporary tables are created in TempDB in SQL Server. However we discourage you from updating existing SAP B1 tables, as this is subject for being monitored by so-called SAP BO Watch Dog service
6. Conclusion. It is possible to accomplish advanced small business logic Reporting without programming by creating custom tables, adding custom fields for existing table and interface will be created automatically to expose these objects to the user. It is recommended to base report on SQL Stored Procedure or View. This method enables you to test result set prior to beginning the design itself. If you will separate design and data selection parts such possible annoying problems as duplicate rows should be eliminated by methodology
Processing your request, Please wait....
