课程: SAP Business One: Reporting and Customization

今天就学习课程吧!

今天就开通帐号,24,700 门业界名师课程任您挑!

Challenge: Sales report with BP info

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.

内容