SAP Business One – Sales Commission and Customer Statement Reports in Crystal Recommendations

SAP Business One – Sales Commission and Customer Statement Reports in Crystal Recommendations

As in the greater part of mid-sector ERP and accounting apps SAP B1 has customizable commission and invoice kinds. Nevertheless becoming versatile in the feeling of developing person outlined fields and tables chances are higher that your vision and formulation are dependent on these objects. It is purely natural to determine style and design do the job to be accomplished in CR as SAP owns this device and suggests for managerial reporting. We will test to occur as a result of customization and design and style pitfalls and tips to keep away from them. This paper is not supposed to be a complex guidebook for programmer as it is alternatively FAQ model selection of suggestions:

1. Fee formulation. Genuine lifetime is loaded in circumstance scientific tests and we have found consumers wherever formulas have several tiers and they have powerful date from and to just to open up the checklist of achievable scenarios. If you understand your case then great notion is to generate couple user outlined tables and use them for calculations

2. Assertion. In numerous industries you may well have parallel units that need to be present on the printed kind. For example it may possibly be billed and genuine minutes in promotion

3. Consumer defined fields and tables. There is no need to do application advancement in purchase to produce these objects. They could be made in consumer interface: Resources -> Customization Applications -> Consumer defined tables and fields management and from here use your intuition or read through person guide. The wonderful thing right here is the truth that these objects are designed in SQL tables in metadata and they are neutral to version update. So truly feel no cost to deploy this method. Typically you are sending purchaser invoices or sales orders from external database or software. In this situation it is great idea to ship them very first to person outlined tables and then deploy Software program Improvement Kit C# or VB programming in Microsoft Visual Studio to completely transform the rows into serious Invoices and Orders

4. Layout. Now let’s speak about the style and design itself. It is paradoxical but our advice is start this approach in SQL Server Management Studio queries. Crystal is great instrument but if formulas alter in the potential it may be complicated to abide by these alterations in Designer device. Substantially a lot easier is to develop SQL See or even saved method where by all the mathematics is done and foundation report on these SQL units. If you are creating a little something complex with formulas then you may be unhappy with design benefits finding rows duplications and other bothersome bugs. SQL is far better positioned to do math. General plan is the adhering to – check out your question in SQL right until you are happy with consequence and only after open up CR Designer software to end format and these kinds of cosmetics as firm symbol and other graphical elements

5. Now fields and tables buildings. There are two means to learn these. 1st is to print it out from SDK in the kind of total and really complex diagram. And the second solution is to change in menu See Method Info. Then open the variety with the desk and area in query and position cursor in excess of. Get a look at base still left corner in which you ought to be able to read through names. Consider it on your have and see if you got the identical success. Sales Purchase header is hosted in ORDR and lines in RDR1 tables respectively.