Product Sales

0:01 This video is how do we run sales reports and work out how much actual product we've actually sold through over a period.

0:09 We're actually gonna do this using two reports. The first one is just to look at the sales themselves and look at by products so that we can look at how many of our products we've sold.

0:19 However, because of how beer is, is done, what that will show you is that you might have shot sold one case of 24, a four pack in a single, but it won't actually sum that together for you and say that you've moved say 29 beers.

0:32 So we're gonna show you a way of being able to look at that as well. So first in one, this one's great for for packs.

0:38 One way it's just one item. And there's not those variants. So we're gonna do is come into this sales order details.

0:48 And what we wanna do is we wanna kind of, we wanna get rid of some of these fields we don't need, we just want the product field.

0:55 So we're gonna come in here and then what we're gonna do is we can choose our time period. So for this, what I'm gonna do is I'm gonna do month to date.

1:04 So I'm gonna do just December. So we're gonna run this and now this is showing you all the products that we've sold this month.

1:14 And this is great. For example, for say hottest 100, the hottest 100. We can see here that we've sold 101 of them or 81 24 packs.

1:25 However, tonight we did for some reason have this variant of the single created. So we've sold 12 of those and that makes it a little difficult to know that we did sell 113 of them.

1:35 But if we look at if day, we can see we've sold 52. So it's a really nice and easy way of showing that how many of that pack we've sold.

1:46 However, if I was to look at something like if Royal Hayes so that's right. So on this one we can see that we've sold four, four packs and five singles.

2:06 The grand total's only showing nine. So it's not entirely acc like you can work it out that you can do four times four is 16 plus five is 21.

2:14 But it's not great because it only shows you what what that is. So what, what we're gonna go through now is the other report.

2:21 So the sales order details report is great for packs but not so for beers. So we're gonna come back into the reports and we're gonna go to production cost analysis.

2:33 So this production cost analysis because all of those units are measures that we create actually every time someone buys it actually creates a production order.

2:43 We're actually able to see where the beer's gone and how it's moved. So what we can do is run last 30 days and get this and what we have is we have component skew and product.

2:55 So we can actually change it. We go, so we wanna go component. So we want drop in component, sorry, change these around.

3:11 So the order of these does affect it. We don't want that. Okay, so what we have these around the other way actually component and product.

3:28 Okay, so now if we were to search for that Royal Hayes, so you want component on the left and then product.

3:36 Cuz we are looking for components and it's how it was sold in the product. So if we were to go if royal search for that, okay, so we can now see here that we've got BFI, Royal Hayes and we've had 16 sold in here, 15 sold in here.

3:55 And if we actually do bring that where was it? The component skew back is if we leave that on it will summit.

4:06 But what this shows us is that we've used 285, but that's because this beer has also gone into packs. So it's a really good way of saying that we might be selling lots of beer, but we're not actually selling it because people are buying, it's only going through packs.

4:20 Or alternatively we don't use it through packs and we are actually sewing it through beer. So it's a really good way of showing that.

4:26 So if we were to look at, say Ali Griffin, maybe we haven't gone through any of that. Maybe crank shaft.

4:39 Crank shaft. So we've sold 12 beers. So three, four packs sold three, but it's also then gone through the hottest 100.

4:46 Maybe we can look at maybe some other half. We can see here that we've kind of sold bits and pieces and it shows you a sum for each of them as to where the singles were.

4:58 So that's a great report for running stock.