SQL: Creating a Multi-Document Line View

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.