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: Sales spreadsheet

Solution: Sales spreadsheet - SAP ERP Tutorial

From the course: SAP Business One: Reporting and Customization

Start my 1-month free trial

Solution: Sales spreadsheet

“

(upbeat music) - [Instructor] Okay, let's take a look at a solution. Now, the easiest solution here is to use drag and relate. So what I'm going to do is first of all, get the drag and relate tab up here and we can see that we're probably going to end up using an invoice. So we can go over here and just get AR invoice ready and so we've got that one right there. And we'll go over here to modules and into business partners and business partner master data and we're looking for Maxi. There they are. Go back to drag and relate, hold down the cursor 'til you get the order on it, move it to an invoice and we get all of their invoices. Now this still has a lot of invoices on it and you can see there's plenty of stuff all the way to 2016. So what I'm going to do next is hit the filter and I'm going to go to the posting date, go to in range and then put my range in. So that'll be 1/1/00 and that'll be 12/31/09.…

Contents