As in the vast majority of mid-marketplace ERP and accounting apps SAP B1 has customizable commission and bill varieties. Nonetheless currently being flexible in the feeling of building person defined fields and tables prospects are high that your eyesight and formulation are dependent on these objects. It is organic to make a decision style and design do the job to be performed in CR as SAP owns this tool and recommends for managerial reporting. We will consider to come via customization and style and design pitfalls and suggestions to steer clear of them. This paper is not intended to be a technical guidebook for programmer as it is relatively FAQ fashion selection of tips:
1. Commission formulation. Actual life is wealthy in circumstance scientific tests and we have observed buyers exactly where formulation have various tiers and they have successful day from and to just to open the list of probable situations. If you understand your case then very good strategy is to generate number of consumer described tables and use them for calculations
2. Statement. In many industries you may well have parallel units that really should be current on the printed type. For example it may possibly be billed and true minutes in marketing
3. User defined fields and tables. There is no need to have to do program advancement in purchase to create these objects. They could be developed in person interface: Equipment -> Customization Applications -> User outlined tables and fields management and from here use your instinct or read through user handbook. The awesome point listed here is the truth that these objects are made in SQL tables in metadata and they are neutral to variation update. So experience free to deploy this method. Usually you are sending customer invoices or sales orders from exterior databases or application. In this scenario it is great plan to mail them initially to user outlined tables and then deploy Application Growth Package C# or VB programming in Microsoft Visible Studio to completely transform the rows into true Invoices and Orders
4. Structure. Now let’s converse about the layout alone. It is paradoxical but our advice is commence this approach in SQL Server Administration Studio queries. Crystal is fantastic software but if formulas adjust in the upcoming it may well be tough to comply with these adjustments in Designer software. Significantly much easier is to make SQL Perspective or even stored method where all the arithmetic is finished and base report on these SQL models. If you are planning one thing elaborate with formulas then you could possibly be upset with design effects receiving rows duplications and other aggravating bugs. SQL is improved positioned to do math. Normal concept is the following – test your query in SQL right up until you are content with final result and only just after open CR Designer device to complete structure and these cosmetics as organization brand and other graphical things
5. Now fields and tables constructions. There are two means to uncover these. Initial is to print it out from SDK in the kind of finish and incredibly elaborate diagram. And the next alternative is to change in menu Look at Procedure Information. Then open up the form with the desk and field in concern and place cursor above. Get a seem at base remaining corner where you must be equipped to browse names. Try it on your have and see if you received the similar effects. Sales Buy header is hosted in ORDR and strains in RDR1 tables respectively.