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 with BP info

Challenge: Sales report with BP info - SAP ERP Tutorial

From the course: SAP Business One: Reporting and Customization

Start my 1-month free trial

Challenge: Sales report with BP info

“

(upbeat music) - [Instructor] It's time for another challenge. My marketing person comes to me and wants a tool to see the sales for a product by bill-to state. There's a few records that don't have a state. So, you'll need to mark those as unknown state. Also, spell out the name of the state. See if you can write a report to give that based on an invoice. To save you some time and give you one hint, you'll need the OCST table, which has a key named code for the state code and a column name for the name. Okay, give this one a try.

Contents