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

As in virtually all mid-market ERP plus accounting applications SAP BUSINESS ONE has customizable payment and invoice sorts. However being bendable in the sense of creating end user defined fields plus tables chances are large that your vision plus formulas are based on these types of objects. It is organic to decide design job to be done in CRYSTAL REPORTS as SAP possesses this tool and advises for managerial coverage. We will try to break through customization and style and design pitfalls and advice to avoid them. This particular paper is not supposed to have been a technical tutorial for programmer currently rather FAQ fashion collection of recommendations:

1 . Commission remedies. Real life is abundant in case studies all of us have seen customers just where formulas have various tiers and they have efficient date from and to in order to open the list regarding possible scenarios. In the event you recognize your circumstance then good idea is usually to create few end user defined tables plus use them for measurements

2 . Affirmation. In various industries you could have parallel units which should be present on the printed out form. For example it would be billed and true minutes in marketing

3. Person defined fields plus tables. There is no need to accomplish software development as a way to create these things. They could be created inside user interface: Tools -> Customization Tools -> User defined platforms and fields supervision and from here make use of intuition or go through user manual. The good thing here is the idea that these objects were created in SQL platforms in metadata and perhaps they are neutral to variation upgrade. So twenty-four hours a day deploy this technique. Usually you are sending client invoices or product sales orders from outside database or program. In this case it is good option to send them initially to user explained tables and then utilize Software Development Package C # or even VB programming inside Microsoft Visual Facilities to transform the series into real Accounts and Orders

4. Design. Right now let' s discuss the design itself. Its paradoxical but each of our recommendation is start off this process in SQL Server Management Facilities queries. Crystal is a great choice tool but if remedies change in the future it would be difficult to follow these types of changes in Designer device. Much easier is to make SQL View and even stored procedure just where all the mathematics is completed and base review on these SQL units. If you are developing something complex using formulas then you might end up being disappointed with style and design results getting series duplications and other bothersome bugs. SQL is much better positioned to do figures. General idea is definitely the following – try out your query inside SQL until you are usually satisfied with result and later after open CRYSTAL REPORTS Designer tool to do layout and such makeup as company customized logo and other graphic elements

a few. Now fields plus tables structures. You can find two ways to discover these types of. First is to produce it out from SDK in the form of complete and also complex diagram. Along with the second option is to swap in menu Perspective System Information. Next open the form while using table and niche in question and place cursor over. Take a look at base left corner in which should be able to read labels. Try it on your own and find out if you got similar results. Sales Order header is hosted inside ORDR and lines inside RDR1 tables correspondingly.