[ad_1]
As in the greater part of mid-sector ERP and accounting programs SAP B1 has customizable fee and bill kinds. Even so getting adaptable in the perception of building user outlined fields and tables probabilities are significant that your eyesight and formulation are based mostly on these objects. It is all-natural to come to a decision structure perform to be done in CR as SAP owns this device and recommends for managerial reporting. We will try to arrive through customization and design pitfalls and recommendations to steer clear of them. This paper is not meant to be a technological manual for programmer as it is instead FAQ style collection of suggestions:
1. Fee formulation. True lifetime is prosperous in scenario research and we have noticed customers the place formulation have quite a few tiers and they have effective day from and to just to open the listing of possible situations. If you acknowledge your situation then excellent strategy is to produce several person outlined tables and use them for calculations
2. Assertion. In several industries you may have parallel units that need to be current on the printed type. For case in point it may well be billed and actual minutes in marketing
3. Person outlined fields and tables. There is no need to do computer software enhancement in purchase to develop these objects. They could be designed in user interface: Applications -> Customization Applications -> User described tables and fields administration and from in this article use your instinct or study user handbook. The wonderful detail right here is the point that these objects are created in SQL tables in metadata and they are neutral to version enhance. So experience free of charge to deploy this technique. Frequently you are sending consumer invoices or product sales orders from external databases or application. In this scenario it is great strategy to ship them very first to user outlined tables and then deploy Software program Growth Package C# or VB programming in Microsoft Visual Studio to transform the rows into genuine Invoices and Orders
4. Style and design. Now let us converse about the design alone. It is paradoxical but our advice is commence this process in SQL Server Management Studio queries. Crystal is ideal instrument but if formulation adjust in the long term it could be tough to adhere to these variations in Designer resource. Substantially easier is to create SQL Check out or even saved process exactly where all the mathematics is completed and foundation report on these SQL models. If you are building something advanced with formulas then you may well be upset with design and style benefits receiving rows duplications and other frustrating bugs. SQL is better positioned to do math. Typical strategy is the next – attempt your question in SQL till you are pleased with final result and only just after open up CR Designer resource to finish layout and these cosmetics as organization logo and other graphical elements
5. Now fields and tables buildings. There are two approaches to find out these. Very first is to print it out from SDK in the sort of comprehensive and quite complicated diagram. And the next possibility is to change in menu View Method Info. Then open up the type with the desk and industry in question and spot cursor around. Acquire a search at base remaining corner where by you should be equipped to browse names. Try out it on your own and see if you got the identical effects. Product sales Get header is hosted in ORDR and traces in RDR1 tables respectively.
[ad_2]