From the course: SAP Business One: Reporting and Customization
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Challenge: Make a sales report - SAP ERP Tutorial
From the course: SAP Business One: Reporting and Customization
Challenge: Make a sales report
(upbeat music) - [Instructor] Okay, it's time for another challenge! This time, we'll make a variation of the sales report you made in SQL. So we're going to use sales orders for this, and so we'll be using ORDR and RDR1, and OCRD for business partner data. You're going to add the business partner name, the posting date in that format, the item number, the quantity, and the row total. Now for the detail, use Arial Narrow 10 point for the font, and for the page header, Arial Bold at 10 point. Your report title will be BP Sales Report, and make that font Georgia Bold 18 point. And use the dark background like we did before on the production order. Add that 150-pixel graphic that we had before, and the company name in Georgia Bold 14 point so that your report header looks the same as we had in the production order. Okay, and finally, remember that you can reuse that connection, so you're just going to click on the…
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
-
-
-
-
-
-
-
(Locked)
Launch Crystal Reports1m 51s
-
(Locked)
Connect to the database2m 13s
-
(Locked)
Select and link fields3m 3s
-
(Locked)
Crystal Reports navigation3m 25s
-
(Locked)
Add fields to an existing report3m 52s
-
(Locked)
Format and layout a report4m 13s
-
(Locked)
Add text objects to a header3m 20s
-
(Locked)
Add graphics and color5m 48s
-
(Locked)
Challenge: Make a sales report1m 12s
-
(Locked)
Solution: Make a sales report5m 26s
-
(Locked)
-
-
-
-