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

As within the majority of mid-market ERP and accounting functions SAP B1 has customizable fee and bill varieties. Nonetheless being versatile within the sense of making person outlined fields and tables likelihood is excessive that your imaginative and prescient and formulation are based mostly on these objects. It’s pure to resolve design work to be carried out in CR as SAP owns this instrument and recommends for managerial reporting. We are going to attempt to come by way of customization and design pitfalls and proposals to keep away from them. This paper is just not meant to be a technical information for programmer as it’s quite FAQ type assortment of suggestions:

1. Fee formulation. Actual life is wealthy in case research and we’ve seen clients the place formulation have a number of tiers and so they have efficient date from and to simply to open the listing of potential eventualities. Should you acknowledge your case then good thought is to create few person outlined tables and use them for calculations

2. Assertion. In numerous industries you may need parallel items that needs to be current on the printed type. For instance it may be billed and precise minutes in promoting

3. Person outlined fields and tables. There isn’t any have to do software program growth with the intention to create these objects. They may very well be created in person interface: Instruments -> Customization Instruments -> Person 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 system. Usually you might be sending buyer invoices or gross sales orders from exterior database or software. On this case it’s good thought to ship them first to person outlined tables after which deploy Software program Growth Equipment C# or VB programming in Microsoft Visible Studio to remodel the rows into actual Invoices and Orders

4. 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 instrument but when formulation change sooner or later it may be tough to comply with these modifications in Designer instrument. A lot simpler is to create SQL View and even saved process the place all of the arithmetic is completed and base report on these SQL items. In case you are designing one thing advanced with formulation you then may be upset with design outcomes getting rows duplications and different annoying bugs. SQL is best positioned to do math. Common thought is the next – strive your question in SQL till you might be happy with outcome and solely after open CR Designer instrument to complete format and such cosmetics as firm emblem and different graphical components Know More about sap cds views

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 advanced diagram. And the second choice is to change in menu View System Data. 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 be capable of learn names. Attempt it by yourself and see for those who acquired the identical outcomes. Gross sales Order header is hosted in ORDR and features in RDR1 tables respectively.