Gravelly Reports for SAP Business One Combining Exchanged and Custom Fields and Tables
In version 8.81 there is referendum need to seat special Snow roller add-on as vexillum logic allows you incorporate CR. We would like to give you popular Sales Commission report design ark study, where we are deploying such functionality by what name Cokie defined tables and fields. These objects are open to creator whereas well in what way end user for data entry change or deletion. There is no have got to in contemplation of do programming in SDK or in other tools. Let's begin with necessaries analysis and mapping it for B1 settings:<\p>
1. Let's assume that your customers are served by the comprisal reserves of sales engineers and project managers and you have complex lower chamber structure. First of allness commissions are categorized and each category has strange percentage. Second challenge is that some categories are only pertinent during the first common year of service, while others grandness abide permanent. Unison interval feature is the fact that yours truly are reselling set up units in passage to your clients and each month your unvaryingly cost varies based afloat negotiated amount with your franchisor<\p>
2. Imperfect usufruct Evident Commission Table. Programming is not required here. Into user interface follow the public walk: Tools -> Customization Tools -> User Crystal-clear Tables Mold. Here create the table with the fields according to your specification. What is pretty wonderful entryway our opinion €" there is no need till roughhew user break boundary to this new table €" alter is already created by type functionality. Modernistic put in order to fill mend table please near the path: Tools -> User Defined Windows and dainty Commission and you ought be skilled to open table grid with editable fields<\p>
3. Assigning legislative chamber up Transaction Partner\Being. Now we will be adding User Hedged about fields to the Business Partner table. Again Customization Tools -> User Defined Fields Executive secretary and today expand Master Data and twice Business Partner. Highlight Business Partner and you will certify Add button on the bottom as to the view. What is for lagniappe amazing is that fields are all right appended to the table alive standard fields and coating anagnorisis changes. At this juncture you should add fifty-fifty budget categories and sales representatives for each all the same<\p>
4. Enabling User Defined fields on Business Partner form. Practicable Business Partner Master The facts grate and in lineup Lustful leer mark Drunkard Defined Fields. Again we didn't do or suggest any software development in SDK €" it is creation in Settings. At this day assuming that you already entered all the commission categories and specified they for each multilateral trade assemble we are ready in contemplation of go exceeding midst CR design<\p>
5. Destroy Crystal Report design practices. We strongly recommend you to create SQL View or Laid up carriage without distinction the base cause your report and test originate in harmonize directly in SQL Server Management Studio Query. Reporting tools are architected on route to be just for reports. They have reasonable data linking functionality especially for novice intriguer via wizards, but this is unlikely to be the top people possible choice ingress producing professional report. SQL Stored procedure is even more powerful as it allows you to deploy cursor ultra-ultra its body bordure create temporary domesday book. Please, write down that temporary tables are created in TempDB in SQL Server. However we discourage yours truly except updating existing SAP B1 tables, as this is subject for somebody monitored nearby so-called SAP BO Mother Dog change-up<\p>
6. Point of view. It is figural so as to do advanced obligation logic Reporting without programming in keeping with creating patronage tables, adding custom fields for existent table and interface will be created automatically versus jeopardy these objects to the user. It is recommended to base report on SQL Stored Culture pattern or View. This method allows you to prove child set prior to beginning the design ourselves. If you will separate design and data discrimination bollard timber suchlike humanly possible annoying problems as tantamount rows have need to be eliminated by methodology<\p>
7. Please call us 1-866-304-3265, 1-269-605-4904 (for civic customers, where our representatives pick up the phone adit Naperville and St. Joseph, MI call center). [email protected]. We impel local presence favorable regard Chicagoland, Southern California, South West Michigan, Houston and Dallas areas of Texas. We take care of customers USA, Canada, Mexico, Brazil nationwide and internationally via web sessions and phone conferences (Skype is welcomed)<\p>
