From the course: SAP Business One: Reporting and Customization

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Challenge: Make a sales summary

Challenge: Make a sales summary - SAP ERP Tutorial

From the course: SAP Business One: Reporting and Customization

Start my 1-month free trial Buy for my team

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.

Contents