Business One SIG

The focus of this meeting will be how to get more data from your system to enable you to make more informed business decisions.

David Carter, Piers Harwood and Matthew Brown from B1 Systems will present Data Analysis in SAP Business One. BVxL differs from other reporting products, such as Crystal Reports, as it combines data management capability with the reporting power and flexibility of Excel. This session will be broken into 3 parts including an introduction by David Carter, a Freelance Software Journalist, and will conclude with a demo of the solution.

Adam Pedersen from SAP will share with the group Tips & Tricks, further details of this sessionwill follow shortly.

Nicola Carlaw from SAP will give a SAP B1 Customer Satisfaction Council Update.

James Barnes from Invu and Matthew Brown from B1 Systems will present Document Management in SAP Business One. You can now add a legally admissible, fully audited, document management system seamlessly to SAP Business One, allowing you to scan, import, view and retrieve your documents from within the SAP Business One application. This session will discuss the Invo Series 6 solution and conclude with a demo. Please see below for full details:

Presentation of the Document Management Solution for SAP Business One

A legally admissible, fully audited, document management system seamlessly to SAP Business One. You can scan, import, view and retrieve your documents stored in Invu from within the SAP Business One application.

• View and retrieve your paper documents from within SAP Business One.
• Scan and attach paper-based documents to your SAP Business One system.
• Save money through more efficient use of electronic storage.
• Legally admissible document audit trail.
• Retrieve documents based on metadata or content, search by business partner or any fields that match the saved document.

By placing all your documents within easy reach, this Document Management Solution creates huge efficiencies. Less time searching and filing means more time in the areas of your business where you're needed most.

Introduction to Invu document management (James Barnes- Invu)

Demonstration with SAP Business One (Matthew Brown-B1 Systems Ltd)

Q+A

Presentation of the Data Analysis Solution for SAP Business One

BVxL differs from other reporting products, such as Crystal Reports, as it combines data management capability with the reporting power and flexibility of Excel.

Data Management.
The data manager enables tables to be linked by key fields, then Data Marts created by selecting specific fields from the set of linked tables. Field names and descriptions can be changed and new virtual fields created so users can be presented with an easy to understand source of data for their reports.

Reporting
BVxL connects Excel both to the core tables of SAP Business One and to the views created by the Data Management System. Once a spreadsheet has been created in Excel using BVxL it updates automatically if any of the parameters, such as date ranges or department codes are changed or if the source data changes.
The reporting tools provided by BVxL to assist with the creation of dynamic spreadsheets are contained within a drop down menu located from Excels main menu.

Add In Tables
BVxL also has the capability to create and add new reporting tables into the SAP database. Such tables can be used for grouping purposes or for general data capture and can be linked to and reported on the other core SAP tables.

Introduction by David Carter (Freelance Software Journalist) BVxL Background (Piers Harwood B1 Systems)

• Example of finished dynamic Spreadsheet
• Products linked to
• Roadmap
• BVxL Overview
• BVxl Consists of Two Components
• Data Management System
• Managing the data dictionary
• Creating user defined tables
• Excel Reporting Tools
• Pivot Builder
• Cell Builder
• Template/List Builder
• Demo (Matthew Brown B1 Systems)
• Q+A

Come armed with your Financial Reporting Tips to share with the group and learn from your pears in this interactive session Financial Reporting Tips from the group.

Mireille Forte from SAP will present SAP Customer Referral Programme. In this session Mireille will explain what the SAP Customer Referral programme is and how customers can benefit from being involved in it.