Part three- the final part of my blog – Creating a query in SAP Business One:
Press the next button to move to step 5 of the wizard. This section shows the SQL syntax created by the wizard which will be used to interrogate the database. As users become more advanced with SQL queries, the query can be directly typed rather than generated – that is purely optional. Clicking the ‘Finish’ button will display our report on screen. The syntax is shown again in the top window and can be edited there. We can export this report to Excel by using the standard Excel icon on the SBO toolbar.
SAP Business One Screenshot
This brief tutorial shows how simple it is to extract information customised to the end users requirements directly from SAP Business One. This information can then be formatted in the print layout designer or simply saved as a query which can be viewed on demand.
Thanks for reading – I hope you found this series of three blogs useful. I am in the process of putting together multiple blogs on other technical areas of SAP Business One. Follow the Leverage team on twitter @Leveragetech to get regular updates.
Recognised by the top ERP Partners in Australia
Leverage Technologies is an SAP Business One and SAP Cloud ERP Gold Partner, a Sage Platinum Partner and an MYOB Acumatica Platinum Partner. Our team has won some of the most prestigious national awards as proof of our commitment to customer success.
Leverage Technologies partners with the best ERP solution providers in the world to deliver value and business benefits for our customers. In recognition of this, the team at Leverage has won over 16 partner industry awards for excellence in the ERP industry.
Brett has more than 20 years of business software sales and company management experience. Brett has been involved in more than 300 ERP projects. His passion is customer satisfaction, making sure every client is more than just satisfied. Brett wants our customers to be driven to refer their friends and peers because we offer the best services and technology available and because we exceeded their expectations.