Your #1 source for SAP Business One tutorial videos
Business One has updated to 9.0! Videos focusing on new features and changes are coming!
New videos uploaded covering Alerts and A/R!
Business One Training: Now with over 275 videos!
Welcome to the new Business One Training site! Please let us know if you encounter any issues.

SQL: Creating a Financials Foundation View

Thu, 02/14/2013 - 16:39 -- admin

SAP Business One is built on a SQL Server database and can be extended through custom views to create easy to query and reference datasets that I have found particularly useful in reporting. In this training video we walk through the creation of a custom view (derived table) to generate easy financial reports in Crystal reports. This is an intermediate-level video that has some more complex SQL statements and techniques to format the data in an efficient manner for reporting.