As within the majority of mid-market ERP and accounting functions SAP B1 has customizable fee and bill types. Nonetheless being versatile within the sense of making person outlined fields and tables likelihood is excessive that your imaginative and prescient and formulation are primarily based on these objects. It’s pure to resolve design work to be performed in CR as SAP owns this device and recommends for managerial reporting. We are going to attempt to come by way of customization and design pitfalls and suggestions to keep away from them. This paper shouldn’t be meant to be a technical information for programmer as it’s slightly FAQ model assortment of suggestions:
1. Fee formulation. Actual life is wealthy in case research and we now have seen clients the place formulation have a number of tiers they usually have efficient date from and to only to open the listing of potential eventualities. In case you acknowledge your case then good thought is to create few person outlined tables and use them for calculations
2. Assertion. In varied industries you may need parallel models that must be current on the printed type. For instance it may be billed and precise minutes in promoting
three. Consumer outlined fields and tables. There isn’t a have to do software program improvement in an effort to create these objects. They could possibly be created in person interface: Instruments -> Customization Instruments -> Consumer outlined tables and fields administration and from right here use your instinct or learn person handbook. The great factor right here is the truth that these objects are created in SQL tables in metadata and they’re impartial to model improve. So be happy to deploy this method. Usually you might be sending buyer invoices or gross sales orders from exterior database or utility. On this case it’s good thought to ship them first to person outlined tables after which deploy Software program Growth Package C# or VB programming in Microsoft Visible Studio to rework the rows into actual Invoices and Orders
four. Design. Now let’s speak in regards to the design itself. It’s paradoxical however our suggestion is start this course of in SQL Server Administration Studio queries. Crystal is ideal device but when formulation change sooner or later it may be troublesome to observe these adjustments in Designer device. A lot simpler is to create SQL View and even saved process the place all of the arithmetic is finished and base report on these SQL models. In case you are designing one thing complicated with formulation then you definately may be disenchanted with design outcomes getting rows duplications and different annoying bugs. SQL is best positioned to do math. Basic thought is the next – strive your question in SQL till you might be glad with end result and solely after open CR Designer device to complete format and such cosmetics as firm brand and different graphical parts
5. Now fields and tables constructions. There are two methods to find these. First is to print it out from SDK within the type of full and really complicated diagram. And the second choice is to modify in menu View System Info. Then open the shape with the desk and discipline in query and place cursor over. Check out backside left nook the place it is best to have the ability to learn names. Attempt it by yourself and see in the event you obtained the identical outcomes. Gross sales Order header is hosted in ORDR and contours in RDR1 tables respectively.