As within the majority of mid-market ERP and accounting functions, SAP B1 has a customizable fees and bill types. Nonetheless being versatile within the sense of making person-outlined fields and tables likelihood is excessive that your imaginative and prescient 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 it 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 technical information for programmers 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 an 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 a 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 improvement. So be happy to deploy this method. Usually, you might be sending buyer invoices or gross sales orders from the exterior database or utility. In this case, it’s a good thought to ship them first to person-outlined tables after which deploy the 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 to start this course of in SQL Server Administration Studio queries. Crystal is an ideal device but when formulation change sooner or later it may be troublesome to observe these adjustments in the 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 definitely may be disenchanted with design outcomes getting rows of duplications and different annoying bugs. SQL is best positioned to do the math. The basic thought is the next – strive your question in SQL till you might be glad about end result and solely after opening CR Designer device to complete format and such cosmetics as a firm brand and different graphical parts

5. Now fields and tables constructions. There are two methods to find these. The 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 the 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. The gross sales Order header is hosted in ORDR and contours in RDR1 tables respectively.