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.

Solution: Make a sales summary

Solution: Make a sales summary - SAP ERP Tutorial

From the course: SAP Business One: Reporting and Customization

Start my 1-month free trial

Solution: Make a sales summary

“

(upbeat music) - [Instructor] Okay, so here's my solution. I'm going to first go over here on the tab for the BP Sales Report. I'm actually going to make a new copy of this so I'm going to do a save as and I'm going to change this to sales summary and save it as that. All right, first I'm going to do some formulas. So I can close this up and head over to the formula fields and go new. First, I'll make the formula isOpen, hit OK. I'm going to just go down here to ORDR, doc status equals O. Then I'm going to save and close that. Then I'm going to add another formula for doc status printing. So I'm going to go formula fields, new, and I'll call it document status. Again, it'll be doc status is what we'll be using but I can actually just go straight here to isOpen and put that there and I can do a if isOpen then, tab, open, probably better with a capital O, else, closed. And I'm going to save and close that. Next, I'm…

Contents