From the course: SAP Business One: Reporting and Customization
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Challenge: Make a sales summary - SAP ERP Tutorial
From the course: SAP Business One: Reporting and Customization
Challenge: Make a sales summary
(upbeat music) - [Instructor] It's time for another challenge with the sales report. Let's look at some sales summary report data. We're going to look at this from the date to the current sales. Group the sales report by business partner, and by open and closed sales orders. You'll need to make a conditional function to determine closed or open, from the ORDR.DocStatus, and one to print open or closed for the group line. Change the details and group headers to show the correct data. Make a few labels to explain the groups. Find the total sales for all levels. Move the totals to the headers for all but the grand total, which you can delete if you really want to. I'll leave the pretty formatting to your discretion. Okay, give it a try.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
Create logic and calculation formulas5m 53s
-
IF, THEN, ELSE in formulas6m 3s
-
Conditional formatting3m 14s
-
Add selection criteria4m 56s
-
Use parameters for selection4m 56s
-
Sort a Crystal report2m 25s
-
Add groups and totals to a Crystal report8m 13s
-
Connect golden arrows in Crystal Reports5m 4s
-
Polish up the report3m 49s
-
Challenge: Make a sales summary49s
-
Solution: Make a sales summary6m 29s
-
-
-
-