SAP Small business One particular – Revenue Commission and Customer Assertion Reports in Crystal Suggestions

As in the majority of mid-market ERP and accounting apps SAP B1 has customizable fee and bill kinds. Nevertheless staying adaptable in the perception of generating person defined fields and tables odds are high that your eyesight and formulation are based mostly on these objects. It is organic to decide design function to be carried out in CR as SAP owns this instrument and endorses for managerial reporting. We will try to occur via customization and structure pitfalls and tips to stay away from them. This paper is not meant to be a technological manual for programmer as it is alternatively FAQ fashion assortment of tips:

1. Fee formulation. Serious everyday living is wealthy in circumstance studies and we have noticed buyers where formulas have many tiers and they have effective day from and to just to open up the listing of feasible situations. If you realize your scenario then great strategy is to create number of user described tables and use them for calculations

2. Statement. In different industries you could possibly have parallel units that should really be present on the printed kind. For case in point it might be billed and actual minutes in advertising and marketing

3. Consumer described fields and tables. There is no require to do computer software enhancement in purchase to create these objects. They could be established in user interface: Equipment -> Customization Instruments -> User described tables and fields management and from here use your instinct or read user handbook. The nice thing in this article is the simple fact that these objects are created in SQL tables in metadata and they are neutral to variation improve. So feel free of charge to deploy this system. Frequently you are sending buyer invoices or sales orders from exterior databases or application. In this case it is fantastic plan to send out them initial to user described tables and then deploy Application Improvement Package C# or VB programming in Microsoft Visual Studio to change the rows into true Invoices and Orders

4. Style and design. Now let us discuss about the structure itself. It is paradoxical but our advice is start this course of action in SQL Server Management Studio queries. Crystal is ideal resource but if formulas adjust in the foreseeable future it may possibly be tricky to observe these improvements in Designer device. Significantly simpler is to develop SQL Look at or even saved course of action exactly where all the mathematics is accomplished and base report on these SQL models. If you are planning a little something intricate with formulation then you could be unhappy with style and design success having rows duplications and other frustrating bugs. SQL is superior positioned to do math. Normal strategy is the adhering to – consider your query in SQL until eventually you are contented with consequence and only immediately after open CR Designer tool to complete structure and this kind of cosmetics as firm logo and other graphical components

5. Now fields and tables constructions. There are two ways to learn these. 1st is to print it out from SDK in the variety of finish and really sophisticated diagram. And the second choice is to swap in menu Perspective Procedure Details. Then open the type with the table and industry in question and position cursor about. Take a search at bottom remaining corner in which you must be capable to study names. Check out it on your personal and see if you acquired the exact same benefits. Product sales Order header is hosted in ORDR and lines in RDR1 tables respectively.