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: Changing the 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 reference datasets. I have found this particularly useful in reporting, though sometimes these datasources need to be updated. This training video walks through the update process of changing an existing view to contain more columns than the original. (it should be noted that changes like this that do not add additional data results, we are just exposing more existing data to the report which can be done without concern for affecting existing reports)