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 Multi-Document Line View

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

Using SQL to create a view is an easy way to create a quick and efficient logical table that queries and reports can utilize just like any other table in the system. The benefits of speed and simplicity with large datasets can not be overstated when compared to using Crystal Reports in built command function! In this video, we walk through how to setup a view to reference multiple documents, specifically the row level information for a more detailed analysis of what is being bought, sold and returned.