课程: SAP Business One: Reporting and Customization

今天就学习课程吧!

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

Solution: Sales spreadsheet

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.…

内容