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

Challenge: Make a sales summary - SAP ERP Tutorial

From the course: SAP Business One: Reporting and Customization

Start my 1-month free trial

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