Author
Released
10/1/2019- Running included reports
- Working with databases
- Tables and fields
- Using basic SQL reports
- Opening the query manager
- Use the query generator
- Use SQL functions
- Creating reports in Crystal Reports
- Creating forms in Crystal Reports
- Adding a user defined field (UDF)
- Adding a UDF in SQL or Crystal Reports
Skill Level Intermediate
Duration
Views
- [Steven] SAP Business One is a powerful small business system. Accounting, sales, and production capabilities are all here. Hi, I'm Steven Lipton, Chief Information Officer of a medical device manufacturer using SAP Business One. I'll use a few reports I've made for my company, daily production lists, custom AR invoices, sales intelligence, and a bill of material pricing tool to show you how you can get the most out of SAP B One reporting. There are hundreds of reports and thousands of data objects to get the information you want, yet there's always that one report that doesn't exist, or that one bit of data that's missing. Being able to add that to your SAP Business One system adds huge value to your investment. Learn to pull exactly the data you need from SAP for further processing in a spreadsheet. Use Crystal Reports to make that report or professional looking invoice you're dying to have. I'll lead you where to find information, how to make reports, and design colorful printed forms. We'll add these directly to SAP Business One as menu items, and add a few custom fields along the way. So let's dive in and start producing, cool custom reports, fields and tables, in SAP Business One reporting and customization.
Related Courses
-
Scaling Your Small Business
with John Jantsch35m 35s Beginner -
Business Tax Foundations
with Michael McDonald1h 48m Beginner -
Accounting Foundations: Bookkeeping
with Jim Stice1h 39m Beginner
-
Introduction
-
Exercise Files1m 28s
-
Setting up your system3m 2s
-
1. SAP Reporting and Forms
-
Run included reports2m 21s
-
Use selection criteria2m 45s
-
Filter and sort reports3m 6s
-
Solution: Sales spreadsheet1m 31s
-
-
2. SAP B1 Databases
-
Use popular tables3m 26s
-
3. Basic SQL Reports
-
Use the Query Generator3m 2s
-
Open the Query Manager4m 5s
-
Debug a query4m 32s
-
Use SQL functions2m 50s
-
Sort a query with ORDER BY3m 29s
-
Make decisions with CASE4m 4s
-
Types in SQL3m 51s
-
-
4. Power SQL
-
Add comments for readability4m 14s
-
Text editors with SQL2m 38s
-
Date and string functions6m 13s
-
Handling NULL values4m 58s
-
Use JOIN for multiple tables5m 47s
-
Group data with GROUP BY5m 27s
-
Use aggregate functions5m 11s
-
5. Basic Crystal Reports
-
Launch Crystal Reports1m 51s
-
Connect to the database2m 13s
-
Select and link fields3m 3s
-
Crystal Reports navigation3m 25s
-
Format and layout a report4m 13s
-
Add text objects to a header3m 20s
-
Add graphics and color5m 48s
-
-
6. Polished Crystal Reports
-
Conditional formatting3m 14s
-
Add selection criteria4m 56s
-
Use parameters for selection4m 56s
-
Sort a Crystal report2m 25s
-
Polish up the report3m 49s
-
7. Customize Reports and Forms in SAP B1
-
Forms to SAP B13m 29s
-
Solution: Add a form2m 58s
-
8. Customize Fields in SAP B1
-
Add a UDF in SQL7m 44s
-
Add a user defined object7m 17s
-
Add a UDF in Crystal Reports7m 19s
-
Conclusion
-
Next steps2m 25s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Getting the most from SAP Business One