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: Sales report in SQL

Challenge: Sales report in SQL - SAP ERP Tutorial

From the course: SAP Business One: Reporting and Customization

Start my 1-month free trial

Challenge: Sales report in SQL

“

(upbeat music) - [Narrator] Time for another challenge. This time you'll write a basic sales report. You'll use the table RDR1, the sales order rows to do this. I'd like the business partner code, posting date, item number, item description, quantity and row total. Have the user add a beginning date to find all posting dates from that date to today. Sort this report by the business partner and then by the date. Once you get that all set and running, in the first column of each row put the phrase dollar sign, dollar sign, dollar sign if the road total is over $10,000 and three dashes if it does not. Okay, try to figure this out. Pause the video and I'll give you a solution next.

Contents