Meeting Title: Urban Stems Inventory Audit Sync Date: 2025-07-03 Meeting participants: Demilade Agboola, Emily Giant
WEBVTT
1 00:00:29.670 ⇒ 00:00:30.620 Emily Giant: Hello!
2 00:00:34.040 ⇒ 00:00:34.530 Demilade Agboola: Hello!
3 00:00:35.640 ⇒ 00:00:36.729 Emily Giant: How’s it going.
4 00:00:37.836 ⇒ 00:00:39.169 Demilade Agboola: Pretty good! How are you?
5 00:00:39.970 ⇒ 00:00:41.603 Emily Giant: Good good
6 00:00:42.750 ⇒ 00:00:46.069 Emily Giant: I haven’t had my coffee yet. Today. I just poured it so I’m like.
7 00:00:46.520 ⇒ 00:00:47.240 Demilade Agboola: Oh, okay.
8 00:00:47.240 ⇒ 00:00:50.208 Emily Giant: I’m sure, like 15 min, I’ll be okay.
9 00:00:51.200 ⇒ 00:00:55.820 Demilade Agboola: Actually, I just got back home went to go pick up some of like
10 00:00:56.830 ⇒ 00:01:00.980 Demilade Agboola: I have a like an identity card I needed to pick up. So I went to go pick that up
11 00:01:02.640 ⇒ 00:01:05.010 Demilade Agboola: life admin stuff. You know the fun stuff.
12 00:01:05.019 ⇒ 00:01:06.799 Emily Giant: Yeah, fun.
13 00:01:07.809 ⇒ 00:01:26.579 Emily Giant: anytime I have to do that. It’s not my favorite like going to the Bureau of Motor Vehicles here. If you ever do that in the United States. It’s like a special realm of hell. It’s they made it to be terrible like. I don’t know how they managed it to be just so bad. But
14 00:01:26.829 ⇒ 00:01:29.577 Emily Giant: yeah haven’t done it in a while.
15 00:01:30.729 ⇒ 00:01:42.329 Emily Giant: I had to drive Minoxhi around in California a couple of years ago, and I had to get my driver’s license renewed, and they wanted me to take the test again, and I was like No, no.
16 00:01:43.419 ⇒ 00:02:08.119 Emily Giant: because I had moved from New York to Indiana, and I was so afraid that I would have to like call me our CEO and be like I’m so sorry. I know I was meant to drive you around while you were here, but like I failed my driver’s test so, but I passed. I did it but they make you like retake it every now and then. It’s so cruel. But anyhow, I saw you had like a giant Starbucks yesterday. Was that just coffee.
17 00:02:08.660 ⇒ 00:02:09.370 Demilade Agboola: Yes.
18 00:02:09.949 ⇒ 00:02:18.119 Demilade Agboola: I I the thing is, I only get this the Venti that’s the only size that works for me. It feels like lots of you know.
19 00:02:18.690 ⇒ 00:02:30.350 Emily Giant: They have. Those drinks have so much caffeine in them like I drink good coffee, but there’s something about Starbucks that like when I get a venti. I feel like a rocket ship like nuts.
20 00:02:30.350 ⇒ 00:02:32.490 Demilade Agboola: Is is this? Is this a safe space.
21 00:02:32.680 ⇒ 00:02:33.939 Emily Giant: Yes, of course.
22 00:02:34.380 ⇒ 00:02:37.535 Demilade Agboola: Sometimes I ask for extra shots of espresso.
23 00:02:37.930 ⇒ 00:02:44.280 Emily Giant: No, no, no! This is an intervention. I lied to you.
24 00:02:45.820 ⇒ 00:02:48.120 Emily Giant: That is wild.
25 00:02:49.350 ⇒ 00:02:56.550 Emily Giant: I if ever you like, go Awol, I’m gonna be like. I know what it was. It was.
26 00:02:56.950 ⇒ 00:02:57.560 Demilade Agboola: Like this.
27 00:02:57.560 ⇒ 00:02:58.590 Emily Giant: Starbucks.
28 00:02:58.590 ⇒ 00:03:01.910 Demilade Agboola: This is why I would never try hard drugs, because I know myself.
29 00:03:02.150 ⇒ 00:03:03.409 Emily Giant: Yeah, no, we’re.
30 00:03:03.410 ⇒ 00:03:06.189 Demilade Agboola: I’m not a moderate user of things. I I got extra.
31 00:03:06.870 ⇒ 00:03:08.360 Demilade Agboola: I’m just, you know.
32 00:03:08.410 ⇒ 00:03:09.130 Emily Giant: Yeah.
33 00:03:09.850 ⇒ 00:03:10.410 Demilade Agboola: Perfect.
34 00:03:10.410 ⇒ 00:03:20.789 Emily Giant: I can’t do hard drugs, because I’m already like this, close to Crazy, and it would just like tip me over the edge forever, like I would just be off the reservation forever if I didn’t.
35 00:03:20.930 ⇒ 00:03:25.790 Emily Giant: Anything to my weird brain that was born this way. So yeah.
36 00:03:25.980 ⇒ 00:03:36.819 Emily Giant: right there with you. And oh, I was talking like Zack and Alex. They both love coffee, and Zach likes to roast his own coffee like he’s really really into it, and I
37 00:03:37.480 ⇒ 00:03:41.190 Emily Giant: but yesterday about when I worked at the coffee company, and how I was just like
38 00:03:41.640 ⇒ 00:03:51.390 Emily Giant: enraged the whole time, because I had so much caffeine that like by 3 o’clock every day. I was just like mean to people, and like just
39 00:03:51.490 ⇒ 00:03:54.410 Emily Giant: totally enraged. So
40 00:03:54.540 ⇒ 00:04:04.409 Emily Giant: if ever you find yourself in a big fight with your girlfriend at like 4 in the afternoon, because you’ve had extra shots of espresso. Just know it’s not you. It’s.
41 00:04:04.410 ⇒ 00:04:04.850 Demilade Agboola: It’s the.
42 00:04:04.920 ⇒ 00:04:05.810 Emily Giant: So.
43 00:04:05.810 ⇒ 00:04:15.990 Demilade Agboola: You know that that might that might actually be to be fair. Yeah, I think after a while. So you need higher levels. But yeah, it does make you like jittery. And like.
44 00:04:15.990 ⇒ 00:04:16.630 Emily Giant: Yeah.
45 00:04:16.630 ⇒ 00:04:21.510 Demilade Agboola: Potentially more irritable sometimes. So that could also be, yeah.
46 00:04:21.510 ⇒ 00:04:35.460 Emily Giant: Totally does to me, and like I’m a big sugar eater, so like when you pair my bad diet with all that caffeine, I’m just like a complete nutcase, but I don’t.
47 00:04:35.570 ⇒ 00:04:50.300 Emily Giant: I don’t seem to knock on wood. I don’t gain the weight from the sugar, so I just don’t change my habits. I just keep eating it, and just I guess my teeth will probably fall out or something, but I don’t know. So maybe if I ate real food with
48 00:04:50.670 ⇒ 00:04:54.270 Emily Giant: with the caffeine, I’d be in a better situation. But
49 00:04:54.744 ⇒ 00:05:02.669 Emily Giant: anyway. Okay. So I have a couple of questions for you at the end of this that you’ll probably be able to answer.
50 00:05:02.840 ⇒ 00:05:05.780 Emily Giant: but they’re not a hundred percent related to
51 00:05:06.718 ⇒ 00:05:15.870 Emily Giant: inventory. They are related to revenue, so I’m willing to hold off. But I’m just getting some duplicates in a model that I can’t figure out like
52 00:05:16.570 ⇒ 00:05:21.202 Emily Giant: I can’t figure out why it’s happening.
53 00:05:23.210 ⇒ 00:05:28.060 Emily Giant: but it might be a rabbit hole. So let’s audit models and.
54 00:05:30.650 ⇒ 00:05:33.930 Demilade Agboola: Okay, I think we could start off with the
55 00:05:34.570 ⇒ 00:05:40.460 Demilade Agboola: the like spoiled shrinkage of entry, and just kind of see if the numbers make sense.
56 00:05:40.770 ⇒ 00:05:41.410 Emily Giant: Okay.
57 00:05:46.520 ⇒ 00:05:47.850 Demilade Agboola: So.
58 00:05:53.160 ⇒ 00:06:03.473 Emily Giant: Oh, my gosh! I just looked at my schedule, for this morning I have meetings until the half day is over, so I definitely am not taking a half day like from right now until noon.
59 00:06:04.580 ⇒ 00:06:05.990 Emily Giant: Yeah. Well.
60 00:06:11.400 ⇒ 00:06:13.679 Emily Giant: okay. So we’re looking at the
61 00:06:16.080 ⇒ 00:06:19.059 Emily Giant: I’ll pull it up on my end, too, in Dbt. The
62 00:06:22.730 ⇒ 00:06:29.000 Emily Giant: intermediate model with all of the different adjustment types.
63 00:06:31.020 ⇒ 00:06:31.780 Demilade Agboola: Yeah.
64 00:06:32.600 ⇒ 00:06:38.249 Emily Giant: Okay, do you want to share screen? You take the driver seat.
65 00:06:39.400 ⇒ 00:06:45.380 Demilade Agboola: I mean, unless you’re gonna I’m not necessarily signed into dash right now or.
66 00:06:45.380 ⇒ 00:06:46.000 Emily Giant: Okay.
67 00:06:50.710 ⇒ 00:06:52.190 Emily Giant: I can.
68 00:06:53.460 ⇒ 00:06:56.050 Emily Giant: Yeah. Once you sign in, we’ll figure out
69 00:06:56.700 ⇒ 00:07:00.160 Emily Giant: how you wanna audit this, but we can do it from both
70 00:07:00.980 ⇒ 00:07:04.960 Emily Giant: directions. If you want me to like, look stuff up in mode, and dash.
71 00:07:05.240 ⇒ 00:07:06.700 Demilade Agboola: Sounds good.
72 00:07:33.840 ⇒ 00:07:38.870 Demilade Agboola: let me see. Yes, yes, try and look for the exact models.
73 00:07:39.350 ⇒ 00:07:40.080 Emily Giant: Okay.
74 00:07:40.080 ⇒ 00:07:46.890 Demilade Agboola: Also, also, yesterday the models weren’t running. I had to run a Dbt. Seed before.
75 00:07:47.310 ⇒ 00:07:59.010 Demilade Agboola: cause you know I I added a seat. The seat had to have. It has its separate like a DVD run. Doesn’t like run it. You need to, unless I did. A DVD Build plus which would build everything before it.
76 00:08:00.146 ⇒ 00:08:02.630 Demilade Agboola: That wouldn’t cover it, so
77 00:08:04.120 ⇒ 00:08:08.969 Demilade Agboola: I kind of had to go in there and restart the process, and that worked.
78 00:08:08.970 ⇒ 00:08:13.137 Emily Giant: Oh, yeah, I I forgot about that with seeds.
79 00:08:14.230 ⇒ 00:08:19.050 Emily Giant: I learned that the hard, the hard way the 1st time I added a seed file and
80 00:08:19.170 ⇒ 00:08:22.420 Emily Giant: like combed the Internet for why? It was happening to me.
81 00:08:24.200 ⇒ 00:08:25.489 Demilade Agboola: Well, you learn now. So.
82 00:08:25.490 ⇒ 00:08:32.169 Emily Giant: But I learned now, but I deployed all of that, and guess what I didn’t do. Run the seed job. So
83 00:08:32.360 ⇒ 00:08:35.719 Emily Giant: did I learn, I know, but I don’t know if I learned.
84 00:08:37.989 ⇒ 00:08:42.579 Demilade Agboola: Okay? So I mean, right, let me share my screen. So I’m in redshift. Now, we can kind of like, just
85 00:08:44.739 ⇒ 00:08:48.989 Demilade Agboola: no, not this screen share screen, too.
86 00:08:51.359 ⇒ 00:08:52.759 Demilade Agboola: Okay, can you see my screen.
87 00:08:53.575 ⇒ 00:08:54.170 Emily Giant: Yes.
88 00:08:54.170 ⇒ 00:08:59.189 Demilade Agboola: All right. So what model do we want to use to?
89 00:08:59.990 ⇒ 00:09:06.020 Demilade Agboola: It’s the analytics, Dot, and it’s.
90 00:09:07.320 ⇒ 00:09:08.660 Emily Giant: It’s either.
91 00:09:08.830 ⇒ 00:09:10.120 Demilade Agboola: Is it just a second.
92 00:09:10.120 ⇒ 00:09:12.439 Emily Giant: Yeah, ag, adjustment types is fine.
93 00:09:13.030 ⇒ 00:09:17.029 Demilade Agboola: So let’s do, okay, it’s 100 automatically. So it’s just
94 00:09:39.670 ⇒ 00:09:45.300 Demilade Agboola: okay. So 1st of all, we should actually try and do quality says it’s 0 set of null.
95 00:09:45.630 ⇒ 00:09:46.400 Emily Giant: Yeah.
96 00:09:46.890 ⇒ 00:09:50.359 Demilade Agboola: But which ones we want to look at.
97 00:09:52.315 ⇒ 00:09:54.223 Emily Giant: Let’s look at
98 00:09:55.520 ⇒ 00:10:04.390 Emily Giant: La! Can we pull numbers from last week? Let me get in, dash! I’ll pull some like or netsuite.
99 00:10:04.630 ⇒ 00:10:06.640 Emily Giant: Just look at some more recent
100 00:10:07.030 ⇒ 00:10:09.229 Emily Giant: adjustments. I think the best way to do.
101 00:10:09.230 ⇒ 00:10:12.780 Demilade Agboola: While you’re doing that, let me give me like 10 seconds. I want to go get something from the fridge.
102 00:10:12.780 ⇒ 00:10:15.609 Emily Giant: Go for it. I’m gonna go get the rest of my coffee.
103 00:10:15.610 ⇒ 00:10:16.350 Demilade Agboola: Oh, okay.
104 00:10:16.520 ⇒ 00:10:17.210 Emily Giant: Good.
105 00:11:22.310 ⇒ 00:11:25.059 Demilade Agboola: Or just pronounce on water.
106 00:11:25.340 ⇒ 00:11:27.680 Demilade Agboola: Alright! Have you found any that we could like.
107 00:11:27.680 ⇒ 00:11:32.730 Emily Giant: I’m looking in. I’m trying to find one that I know we have spoilage.
108 00:11:34.690 ⇒ 00:11:38.870 Emily Giant: Let me go back a little further, just to make sure that it’s actually been spoiled out.
109 00:11:41.530 ⇒ 00:11:44.320 Emily Giant: Okay, we’re gonna try.
110 00:11:44.650 ⇒ 00:11:48.100 Emily Giant: I’m gonna have to look up the inventory number id here
111 00:11:50.660 ⇒ 00:11:59.509 Emily Giant: this summer by design. I literally don’t even know what we sell anymore. Done a lot. I’m like looking at our inventory like, what is this product? I’m so out of it.
112 00:12:00.163 ⇒ 00:12:05.229 Emily Giant: The Dev team does not need to know what the bouquets are comprised.
113 00:12:07.350 ⇒ 00:12:12.969 Emily Giant: priced up, but I used to know every single product and what was in it
114 00:12:15.790 ⇒ 00:12:21.749 Emily Giant: here. This is the well, I’ll just send you the inventory number. Id. One second. So everything from
115 00:12:33.480 ⇒ 00:12:47.349 Emily Giant: so one annoying thing about using the inventory number Id. And all these tables is that like I always have to reverse? Look up the netsuite lot Id, when we’re doing things like this, because that is not what the like user facing number ever is.
116 00:12:47.600 ⇒ 00:12:48.030 Emily Giant: Yeah.
117 00:12:51.210 ⇒ 00:12:53.850 Emily Giant: Okay, sending it in the chat.
118 00:12:56.350 ⇒ 00:13:02.572 Emily Giant: So this is like a lot from last week that unless we sold through which I highly doubt it.
119 00:13:05.020 ⇒ 00:13:11.510 Emily Giant: Pull some other ones to dash it zeroes out so you can’t ever see spoilage numbers, and it’s like a crapshoot
120 00:13:12.460 ⇒ 00:13:16.290 Emily Giant: with whether or not we spoiled it.
121 00:13:26.980 ⇒ 00:13:28.130 Demilade Agboola: See.
122 00:13:37.660 ⇒ 00:13:38.570 Demilade Agboola: where.
123 00:13:38.960 ⇒ 00:13:39.740 Emily Giant: Oh.
124 00:13:44.160 ⇒ 00:13:48.056 Emily Giant: you know what some of these are still available. I need to go back even further.
125 00:13:48.930 ⇒ 00:13:54.189 Emily Giant: They shouldn’t be, but it looks like the team hasn’t spoiled some of them out yet.
126 00:13:58.360 ⇒ 00:14:02.110 Demilade Agboola: So I have the number for the 1st step, the numbers for the 1st one you just sent.
127 00:14:02.110 ⇒ 00:14:05.128 Emily Giant: Oh, okay, let’s see it, and I’ll look it up in netsuite.
128 00:14:07.010 ⇒ 00:14:07.830 Emily Giant: All right.
129 00:14:12.860 ⇒ 00:14:15.020 Emily Giant: Okay, that shrink makes sense.
130 00:14:21.470 ⇒ 00:14:26.009 Emily Giant: Oh, wow! Okay. So something happened to that shipment
131 00:14:28.430 ⇒ 00:14:33.159 Emily Giant: that, like they, they had to spoil it all out before. Let me make sure that’s true. Sorry.
132 00:14:42.510 ⇒ 00:14:46.980 Emily Giant: So internal quantity sold subscription delivery sale
133 00:15:07.760 ⇒ 00:15:10.579 Emily Giant: almost there. Sorry Netsuite is really crunchy.
134 00:15:10.790 ⇒ 00:15:11.560 Demilade Agboola: That’s fine!
135 00:15:41.250 ⇒ 00:15:47.360 Emily Giant: Purchase order. Item, receipt image. Yep, I have negative. Oh, Nope, Nope, Nope, there you go. Yeah.
136 00:15:49.860 ⇒ 00:15:56.667 Emily Giant: And then 1, 2. I own. Yep, that’s right. Okay? So what I see is
137 00:15:58.760 ⇒ 00:16:07.700 Emily Giant: I want to look at that other one, too, because there’s 2 different inventory adjustments. But it’s 39 in total, we received
138 00:16:08.900 ⇒ 00:16:09.910 Emily Giant: 40.
139 00:16:11.870 ⇒ 00:16:18.099 Emily Giant: 2 of them were damaged out right when they received it. We sold 3, and then the rest were damaged out
140 00:16:18.430 ⇒ 00:16:20.909 Emily Giant: or spoilage. So, yeah, that’s correct.
141 00:16:24.740 ⇒ 00:16:25.840 Emily Giant: Yeah.
142 00:16:31.220 ⇒ 00:16:42.118 Emily Giant: as far as a unique identifier for those adjustments. I don’t see them in Netsuite, but still on the lookout for that. I know we were talking about that yesterday.
143 00:16:43.000 ⇒ 00:16:49.210 Emily Giant: yeah, because it even like, it’s very odd.
144 00:16:50.930 ⇒ 00:16:59.080 Emily Giant: There are like separate adjustments on this that have the same external id. So maybe maybe that’s what it is like. If it’s 1 lot.
145 00:16:59.620 ⇒ 00:17:03.159 Emily Giant: it will have the same Id. Anyway, I’ll figure it out and
146 00:17:03.330 ⇒ 00:17:06.240 Emily Giant: report back. But yeah, that’s great. You want to do another one.
147 00:17:07.180 ⇒ 00:17:07.615 Demilade Agboola: Definitely.
148 00:17:08.270 ⇒ 00:17:11.530 Demilade Agboola: Let’s try like different cases and stuff.
149 00:17:12.790 ⇒ 00:17:15.760 Emily Giant: That sounds good.
150 00:17:17.550 ⇒ 00:17:20.589 Emily Giant: All right, these are Urd.
151 00:17:34.720 ⇒ 00:17:37.870 Emily Giant: I just sent a new one in the chat, and then I’ll pull it up
152 00:17:44.980 ⇒ 00:17:46.669 Emily Giant: in the Netsuite.
153 00:17:48.900 ⇒ 00:17:51.179 Demilade Agboola: Okay, that’s see if
154 00:18:18.100 ⇒ 00:18:19.450 Demilade Agboola: well, we’re waiting.
155 00:18:20.250 ⇒ 00:18:20.590 Emily Giant: Hmm.
156 00:18:20.590 ⇒ 00:18:25.120 Demilade Agboola: I’m going to stop playing tennis this weekend, so I’m looking forward to that.
157 00:18:25.390 ⇒ 00:18:26.730 Emily Giant: Have you ever played before?
158 00:18:27.590 ⇒ 00:18:31.390 Demilade Agboola: Yes and no, like nothing serious. But I’ve stepped on
159 00:18:32.000 ⇒ 00:18:35.969 Demilade Agboola: before I tried. I tried it like 12 years ago.
160 00:18:38.660 ⇒ 00:18:42.039 Demilade Agboola: And I used to. I love because I love watching tennis. So I used to.
161 00:18:42.040 ⇒ 00:18:44.090 Emily Giant: My gosh! Me, too! So much.
162 00:18:45.100 ⇒ 00:18:50.749 Demilade Agboola: So I tried playing it. It wasn’t as easy as like what I saw on TV, and I just kind of left it alone.
163 00:18:50.960 ⇒ 00:18:51.430 Emily Giant: Okay.
164 00:18:51.430 ⇒ 00:18:52.435 Emily Giant: Yeah.
165 00:18:53.440 ⇒ 00:19:00.010 Demilade Agboola: I just want something to. I also want to learn how to swim. So I’m starting swimming classes as well. Very soon.
166 00:19:00.010 ⇒ 00:19:00.990 Emily Giant: Wow!
167 00:19:01.140 ⇒ 00:19:02.330 Demilade Agboola: I’ll I’ll.
168 00:19:02.330 ⇒ 00:19:03.483 Emily Giant: It’s awesome.
169 00:19:04.060 ⇒ 00:19:08.890 Demilade Agboola: But I’m I’m planning to do swimming classes, tennis classes and go karting classes.
170 00:19:09.260 ⇒ 00:19:18.190 Emily Giant: Go karting. Oh, my God! Now, if I were to say like, you only can have 2, I would make you not do go karting that just seems like.
171 00:19:18.830 ⇒ 00:19:32.429 Demilade Agboola: I like. Here’s the goal. Because I was talking to like the person who’s going to start teaching me that the goal is to get me to the level where I need a license to drive carts like the faster cars, the ones that you can’t just come in. And yeah, those are. That’s the goal. So I’m like.
172 00:19:32.630 ⇒ 00:19:34.660 Emily Giant: Let’s do it, my gosh.
173 00:19:35.410 ⇒ 00:19:41.440 Emily Giant: that is a boy thing like I don’t usually like subscribe to like gender role things, but like
174 00:19:41.560 ⇒ 00:19:45.040 Emily Giant: that is a boy thing I don’t know. This.
175 00:19:45.040 ⇒ 00:19:48.839 Demilade Agboola: I’m also I’m also a huge like formula, one fan. So I was like, you know.
176 00:19:48.840 ⇒ 00:19:53.119 Emily Giant: Did you see the movie, the f, 1 movie that came out.
177 00:19:53.120 ⇒ 00:20:08.280 Demilade Agboola: I I’ve heard about it, and it’s cause cause I watch from the one. And it’s their movie. So they’re putting in your faces. So I I heard about it. I haven’t watched it, though I might, though. My girlfriend went to watch it like 2 days ago, and she she was texting me about it, and she’s like it was great.
178 00:20:09.240 ⇒ 00:20:23.380 Emily Giant: I’ve heard that like, it’s really fun. I’ve heard different things from different folks like movie movie people are like, No, but if you just want like a fun summer blockbuster. Then it’s Brad Pitt, and apparently like
179 00:20:23.570 ⇒ 00:20:31.860 Emily Giant: there was a lot of really good footage of driving. And you can like, really like, feel it like what they feel when they’re driving so.
180 00:20:32.270 ⇒ 00:20:36.410 Demilade Agboola: Here’s the fun. Fact. I went to work from lawn like last year.
181 00:20:38.420 ⇒ 00:20:49.590 Demilade Agboola: Because I’m a huge for my own fan. I didn’t just get there for the races, and leave, or like for the qualifying, and leave. I come early and stay behind and stuff they were shooting it at the tracks.
182 00:20:49.880 ⇒ 00:20:53.140 Demilade Agboola: so you’ll see them. I they would like prop cars like driving.
183 00:20:53.140 ⇒ 00:20:54.540 Emily Giant: No way.
184 00:20:55.520 ⇒ 00:20:58.049 Emily Giant: Yeah. Oh, that’s awesome.
185 00:20:58.050 ⇒ 00:21:06.529 Demilade Agboola: Yeah, that’s super cool. Yeah. Formula One. Is that like, is that what Indy? 500 is
186 00:21:07.558 ⇒ 00:21:16.160 Demilade Agboola: Indy. 500 is another form of racing. But the difference between Formula One and Indy 500 is Indy. 500 has rules as to
187 00:21:16.490 ⇒ 00:21:23.080 Demilade Agboola: everyone has like, for instance, the same chassis, and like it’s quite the cards are quite similar. The huge differences tend to go from
188 00:21:23.430 ⇒ 00:21:33.700 Demilade Agboola: the drivers themselves, but from low on you can. There are rules as to I mean limits to what you can do and how much you can. You know, innovate. But it’s really about how well you can build a car.
189 00:21:33.700 ⇒ 00:21:34.330 Emily Giant: Hmm.
190 00:21:34.940 ⇒ 00:21:36.370 Demilade Agboola: I think it’ll drive us. Take the rest.
191 00:21:36.370 ⇒ 00:21:37.330 Emily Giant: Okay?
192 00:21:38.240 ⇒ 00:21:43.520 Emily Giant: Yeah. Cause cause that’s obviously huge where I live like huge deal.
193 00:21:43.710 ⇒ 00:21:47.480 Emily Giant: Yeah, we have a practice back pretty close to our house.
194 00:21:47.830 ⇒ 00:21:48.850 Demilade Agboola: All right.
195 00:21:48.850 ⇒ 00:21:57.179 Emily Giant: Yeah, like, thankfully, you can’t hear it. It’s drowned out by the sound of like the National Guard base. That’s right. By our house that does like.
196 00:21:58.480 ⇒ 00:22:12.229 Emily Giant: it’s Air Force, not Air Force. It’s National Guard, but they fly the F. Something or others. It’s there’s just a lot of like vehicle noise for being in the country. You can just hear the military jets practicing all the time. And
197 00:22:12.480 ⇒ 00:22:14.020 Emily Giant: yeah, the track is like.
198 00:22:14.160 ⇒ 00:22:22.369 Emily Giant: I don’t even know if they still use it, but they used to when I was growing up like there’s just so much space in the Midwest. There’s so much country to like put
199 00:22:22.670 ⇒ 00:22:29.479 Emily Giant: car tracks and like airplane landing strips that they’re just everywhere. Okay, I have this pulled up.
200 00:22:30.880 ⇒ 00:22:37.740 Emily Giant: It’s not a very exciting lot. Let’s see what you’ve got. So quantity sold is 67, which?
201 00:22:43.140 ⇒ 00:22:45.419 Emily Giant: So that that okay
202 00:22:46.560 ⇒ 00:22:54.050 Emily Giant: is quantity sold is 67. But yeah, okay, I see what you’re. I see what we’re doing. It says they only received
203 00:22:54.340 ⇒ 00:22:55.630 Emily Giant: 64.
204 00:22:59.100 ⇒ 00:23:03.349 Demilade Agboola: But it’s the received. Yeah.
205 00:23:03.720 ⇒ 00:23:05.910 Emily Giant: God, I hate Netsuite. Sorry
206 00:23:06.760 ⇒ 00:23:13.130 Emily Giant: I have to like go through like line by line, and like. Add these sales orders together by hand.
207 00:23:14.540 ⇒ 00:23:23.070 Emily Giant: but it does say 64 in the system. I’m going to go back. And just I mean, we oversell it happens so.
208 00:23:25.250 ⇒ 00:23:26.936 Emily Giant: and also
209 00:23:30.330 ⇒ 00:23:34.740 Emily Giant: no quantity sold. Shouldn’t account for that, I was. Gonna say, sometimes we
210 00:23:35.190 ⇒ 00:23:39.350 Emily Giant: send things out without it being assigned to a lot, and that could have been what happened. But
211 00:23:40.980 ⇒ 00:23:44.499 Emily Giant: unless you corrected for that I haven’t yet, so it would still show it.
212 00:23:45.930 ⇒ 00:23:48.320 Emily Giant: Lot number activity sales only. Okay.
213 00:23:49.170 ⇒ 00:23:52.010 Emily Giant: I gave myself a bunch of shortcuts in
214 00:23:52.680 ⇒ 00:24:01.160 Emily Giant: in netsuite. So do you have any interest in like scuba diving with the the swimming lessons, or like? Is it more? For, like triathlon type, stuff.
215 00:24:01.810 ⇒ 00:24:02.469 Demilade Agboola: Or just.
216 00:24:02.950 ⇒ 00:24:03.803 Emily Giant: Hey! Brian.
217 00:24:04.230 ⇒ 00:24:11.109 Demilade Agboola: I like the fact that you’re thinking so highly of me. I literally kind of just like for me. It’s survival like
218 00:24:11.320 ⇒ 00:24:18.520 Demilade Agboola: I want to be able to do things that involve water and not just worry, that if I fall in, that’s the end of me.
219 00:24:18.850 ⇒ 00:24:20.290 Emily Giant: Yeah, I’m I’m.
220 00:24:20.290 ⇒ 00:24:26.600 Demilade Agboola: Boat cruises things like that. Just if I fall into the water.
221 00:24:26.720 ⇒ 00:24:29.319 Demilade Agboola: let me know what to do to be alive.
222 00:24:29.810 ⇒ 00:24:37.772 Emily Giant: Oh, God, cruises. So I was thinking, like, this guy’s gonna do it. Triathlon, although.
223 00:24:38.480 ⇒ 00:24:45.420 Emily Giant: okay. Now, I’m seeing only okay. I see 64 sales orders on this, and it says 60.
224 00:24:45.870 ⇒ 00:24:51.799 Emily Giant: So something’s up here where like something got canceled, I bet, and there’s no way to like
225 00:24:52.550 ⇒ 00:25:01.299 Emily Giant: know when something gets canceled in netsuite it has to be. I’m sure there is a way to know I have not found it. I’m going to write that down. Because
226 00:25:04.250 ⇒ 00:25:08.740 Emily Giant: I bet you that that’s what it is.
227 00:25:09.694 ⇒ 00:25:15.479 Emily Giant: Okay, yeah. I see 64. I don’t see any other adjustment types. So the rest should be null
228 00:25:16.860 ⇒ 00:25:17.990 Emily Giant: or 0.
229 00:25:20.540 ⇒ 00:25:21.290 Demilade Agboola: Oh, okay.
230 00:25:21.510 ⇒ 00:25:32.477 Emily Giant: What we should do is go back to Mother’s Day, when it was all types of system mismatch that people had to reconcile all the time and see how those like stack up. But
231 00:25:35.220 ⇒ 00:25:37.850 Emily Giant: all right, I’m going to write down this lot and see
232 00:25:39.750 ⇒ 00:25:41.549 Emily Giant: 1, 5, 4, 3, 9, 1.
233 00:25:43.130 ⇒ 00:25:46.800 Emily Giant: And this is too many sales
234 00:25:49.390 ⇒ 00:25:54.200 Emily Giant: there is in transaction table. There’s a status field
235 00:25:54.740 ⇒ 00:26:02.220 Emily Giant: and it’s meant to like indicate. If an order is canceled and I have yet to see it correctly populate
236 00:26:02.450 ⇒ 00:26:04.239 Emily Giant: with an order that’s canceled.
237 00:26:04.710 ⇒ 00:26:07.200 Emily Giant: So I don’t know if that’s like a polytomic thing.
238 00:26:07.510 ⇒ 00:26:10.010 Emily Giant: but I’m I’m guessing it is
239 00:26:10.646 ⇒ 00:26:25.220 Emily Giant: last time when records were getting erased and we had to ask them to like persist certain rows once they got deleted. Once I find out why canceled orders are still showing. I’ll reach out to them and see if, like.
240 00:26:26.540 ⇒ 00:26:28.880 Emily Giant: there’s anything that they could do about it.
241 00:26:30.420 ⇒ 00:26:33.460 Emily Giant: Okay, let me find another lot.
242 00:26:38.240 ⇒ 00:26:45.959 Emily Giant: I’m I can scuba dive because it’s like wearing I mean, you’re practically wearing a floating device. You can like.
243 00:26:45.960 ⇒ 00:26:46.819 Demilade Agboola: Thank you.
244 00:26:46.820 ⇒ 00:26:57.920 Emily Giant: But I’m not a great swimmer like I can do it, but I’m not a strong swimmer. It scares me for sure, mostly because I’m terrified of whales, which I know is not like a rational fear, but
245 00:26:58.100 ⇒ 00:27:01.179 Emily Giant: they’re just so big. It doesn’t make any sense to me.
246 00:27:01.720 ⇒ 00:27:02.879 Demilade Agboola: I mean to be fair.
247 00:27:03.190 ⇒ 00:27:05.580 Demilade Agboola: I I can. I understand why.
248 00:27:06.921 ⇒ 00:27:16.769 Demilade Agboola: But no like, I think, growing up. The reason why I can’t swim is growing up. Our parents were. My parents were so scared of like us drowning that they kept us away from water.
249 00:27:17.210 ⇒ 00:27:20.349 Demilade Agboola: and so none of my siblings, and I
250 00:27:20.450 ⇒ 00:27:26.989 Demilade Agboola: could swim. But I’m the last one who can swim because my sister went to work for an oil and gas company
251 00:27:27.220 ⇒ 00:27:31.240 Demilade Agboola: and have to learn how to swim like it’s mandate. It’s part of what?
252 00:27:31.430 ⇒ 00:27:35.500 Demilade Agboola: Because if you’re gonna because she was an engineer, and if you’re going to work in like.
253 00:27:35.840 ⇒ 00:27:41.320 Demilade Agboola: go to the Rigs. You need to understand how to swim. It’s compulsory. So
254 00:27:42.148 ⇒ 00:27:45.650 Demilade Agboola: so she learned how to swim there and then my brother
255 00:27:45.850 ⇒ 00:28:02.580 Demilade Agboola: decided to learn how to swim with his wife because she could. Also she could also not swim, because, you know, on like family vacations, and their kids could swim, and they’ll hop in the pool, and it would be nice to just hop in the pool with the kids, so decided to learn how to swim. So I’m the only one who can’t swim, I said. You know what.
256 00:28:02.870 ⇒ 00:28:05.792 Emily Giant: It’s gone on for far. It’s time.
257 00:28:11.270 ⇒ 00:28:15.590 Emily Giant: Did you say that your sister was getting married or got married recently?
258 00:28:15.770 ⇒ 00:28:18.800 Emily Giant: I remember you talking about like a wedding.
259 00:28:19.260 ⇒ 00:28:24.190 Demilade Agboola: Oh, no, no! My sister got married like 10 years ago, 2020 14.
260 00:28:24.939 ⇒ 00:28:27.530 Demilade Agboola: Both of my siblings got married in 2014, actually.
261 00:28:27.660 ⇒ 00:28:29.430 Demilade Agboola: And yeah.
262 00:28:29.920 ⇒ 00:28:31.190 Emily Giant: I feel like.
263 00:28:31.620 ⇒ 00:28:39.679 Emily Giant: somehow, maybe we were just talking about weddings and how much they cost, and that it’s absurd. And you were like, oh, no, no! We spare no expense.
264 00:28:40.910 ⇒ 00:28:49.589 Demilade Agboola: Oh, yeah, yeah, I did see that my sister’s wedding was quite big. It actually was on like Instagram, and like some of the like social blogs in Nigeria.
265 00:28:51.030 ⇒ 00:28:54.219 Demilade Agboola: Yeah, it it. Yeah.
266 00:28:54.520 ⇒ 00:29:01.389 Demilade Agboola: Weddings are a big deal, and my sister’s wedding was one of those weddings where, like it was like, Oh, let’s go out.
267 00:29:03.420 ⇒ 00:29:05.050 Emily Giant: It’s very cool.
268 00:29:06.790 ⇒ 00:29:15.479 Demilade Agboola: My father, because my father is very like always a very like simple man. He didn’t like a lot of those things, but it’s not his wedding, so.
269 00:29:18.670 ⇒ 00:29:25.680 Emily Giant: No weddings are so fun. I feel like I’m just past the age, like most of my friends are married now, and now it’s just like children.
270 00:29:26.330 ⇒ 00:29:26.940 Demilade Agboola: Yeah.
271 00:29:27.230 ⇒ 00:29:29.198 Emily Giant: But none of them were like that.
272 00:29:30.390 ⇒ 00:29:32.798 Emily Giant: Maybe 1 1 of my friends is from
273 00:29:34.890 ⇒ 00:29:38.720 Emily Giant: Nicaragua, and I’ve never
274 00:29:38.830 ⇒ 00:29:47.999 Emily Giant: had so much food thrust upon me in my. It was like a 6 h reception, and every single room we went into was like a new meal, like nobody.
275 00:29:48.780 ⇒ 00:29:51.660 Emily Giant: We were just like rolling on the floor. We were so full.
276 00:29:52.630 ⇒ 00:30:00.450 Emily Giant: but it was South American, like huge, impressive. I’ve never been to anything like it.
277 00:30:01.130 ⇒ 00:30:14.949 Demilade Agboola: I think I think weddings are such a big deal for other cultures outside. Probably the Us. Like, it’s a really big deal to get married and, like the celebrations go crazy. They’re more. Sometimes. They last like multiple days.
278 00:30:14.950 ⇒ 00:30:20.180 Emily Giant: Yeah, I might as well cause you’re presumably only doing it once. So.
279 00:30:20.450 ⇒ 00:30:23.809 Demilade Agboola: Fair enough, fair enough. Yeah, it’s it’s it’s it’s a huge deal.
280 00:30:24.280 ⇒ 00:30:24.950 Emily Giant: Yeah.
281 00:30:25.310 ⇒ 00:30:28.849 Emily Giant: Wild. Have you ever been to like a traditional Indian wedding.
282 00:30:29.430 ⇒ 00:30:39.140 Demilade Agboola: No, I haven’t actually my sister has. I’ve seen like, because my sister went to one. And she took like videos and stuff. So I did see from that perspective. But, like I haven’t personally been in one.
283 00:30:39.990 ⇒ 00:30:50.249 Emily Giant: I went to one, and I’m I couldn’t even say it was traditional because they were definitely wealthy. And it was a Bronx Zoo in New York. It was so cool.
284 00:30:50.670 ⇒ 00:30:56.019 Emily Giant: but it was beautiful. However, the girl she was like a model, and
285 00:30:56.490 ⇒ 00:31:09.440 Emily Giant: I think she just didn’t know like what she. She was like giggling the whole time that she was like speaking during the ceremony. And I was like, Come on, guys, I’m taking this more seriously than you. Okay, let’s check this out shrinkage.
286 00:31:10.050 ⇒ 00:31:12.419 Emily Giant: Oh, we’ve got some good numbers on this one.
287 00:31:12.550 ⇒ 00:31:14.280 Emily Giant: Let’s do this 1 1st one.
288 00:31:16.750 ⇒ 00:31:20.170 Emily Giant: I have that Mozart song stuck in my head. That’s like dude.
289 00:31:20.280 ⇒ 00:31:28.299 Emily Giant: I have no idea why, but it’s just like going through my head.
290 00:31:30.800 ⇒ 00:31:37.360 Emily Giant: I don’t listen to a lot of classical music. So I don’t. To wake up with like Mozart in my head makes very little sense.
291 00:31:40.580 ⇒ 00:31:46.049 Emily Giant: Okay, do, do, do, do do
292 00:31:47.753 ⇒ 00:32:07.480 Emily Giant: tennis is so I played volleyball in high school and a little bit in, just like recreationally. And my biggest thing is, when, whenever I hit the ball, I always wind up hitting it with my hand instead of the racket, because I’m so used to bringing my hand all the ball to hit it that like just the whole time it’s like.
293 00:32:08.990 ⇒ 00:32:12.170 Emily Giant: is a really really hard habit to break.
294 00:32:14.370 ⇒ 00:32:15.520 Emily Giant: But it is
295 00:32:15.730 ⇒ 00:32:21.477 Emily Giant: difficult. I think you’ll like it because you’re just running around. It’s like football in that way, or soccer.
296 00:32:23.940 ⇒ 00:32:29.490 Demilade Agboola: I’m excited. I I got my racket yesterday.
297 00:32:31.470 ⇒ 00:32:33.820 Emily Giant: Oh, yes, look at that!
298 00:32:34.190 ⇒ 00:32:35.410 Emily Giant: It’s nice.
299 00:32:35.720 ⇒ 00:32:39.549 Demilade Agboola: My over grip and everything, so I’m ready to go. I’m ready to go.
300 00:32:40.640 ⇒ 00:32:41.600 Emily Giant: You’re ready.
301 00:32:41.810 ⇒ 00:32:43.670 Demilade Agboola: He ready?
302 00:32:44.750 ⇒ 00:32:45.100 Emily Giant: Yeah.
303 00:32:45.100 ⇒ 00:32:46.210 Emily Giant: Which one did I?
304 00:32:46.590 ⇒ 00:32:48.979 Emily Giant: This the wrong one? Because I’m not seeing
305 00:32:49.230 ⇒ 00:32:51.880 Emily Giant: quantity sold is 41 sale, quantity, 35.
306 00:32:53.780 ⇒ 00:33:05.950 Emily Giant: That’s exciting. I used to go when I lived in South Carolina, I would go with my other friend, who was like a gymnast and a volleyball player, and we would just smack that ball with our hands for hours we were so terrible. But it’s very fun.
307 00:33:08.730 ⇒ 00:33:10.880 Emily Giant: I’m trying to figure out which one I’m looking at here.
308 00:33:17.620 ⇒ 00:33:22.180 Emily Giant: The mythology is there a way to see like the skew?
309 00:33:25.880 ⇒ 00:33:28.389 Emily Giant: I’m only seeing.
310 00:33:29.260 ⇒ 00:33:33.520 Demilade Agboola: An adjustment of 30 sale.
311 00:33:33.940 ⇒ 00:33:34.895 Emily Giant: For
312 00:33:36.220 ⇒ 00:33:41.109 Emily Giant: Let me return to the criteria. Maybe it didn’t. Maybe it didn’t update
313 00:33:41.290 ⇒ 00:33:43.540 Emily Giant: the criteria or something, because that’s
314 00:33:43.890 ⇒ 00:33:51.419 Emily Giant: it was for 1116, 0 8, 8, 4. So that is the equivalent of
315 00:33:55.910 ⇒ 00:33:58.169 Emily Giant: 1, 5, 2, 7, 9, 8.
316 00:33:58.860 ⇒ 00:33:59.809 Demilade Agboola: So, okay, so this.
317 00:34:00.810 ⇒ 00:34:06.450 Emily Giant: Okay, this might be all right, so that redelivery sale.
318 00:34:08.239 ⇒ 00:34:17.340 Emily Giant: But I’m getting a quantity of 30.
319 00:34:18.080 ⇒ 00:34:20.789 Emily Giant: Let me rerun this. I don’t trust it.
320 00:34:21.000 ⇒ 00:34:22.080 Demilade Agboola: Of 30? What.
321 00:34:23.844 ⇒ 00:34:24.719 Emily Giant: Sales.
322 00:34:25.109 ⇒ 00:34:29.949 Emily Giant: But let me let me rerun this. I don’t. I don’t trust what I’m seeing with my eyes.
323 00:34:36.039 ⇒ 00:34:40.829 Emily Giant: It says, Oh, no, no, no, no, this is good, this perfect. Okay, that one’s perfect.
324 00:34:43.059 ⇒ 00:34:45.769 Emily Giant: So now let’s do 9, 6,
325 00:34:54.819 ⇒ 00:34:58.329 Emily Giant: that one’s got some good other adjustment types.
326 00:35:09.119 ⇒ 00:35:10.799 Emily Giant: Have you ever done pickleball?
327 00:35:11.290 ⇒ 00:35:12.370 Demilade Agboola: No, I haven’t.
328 00:35:13.230 ⇒ 00:35:15.600 Emily Giant: Well, if tennis is too much.
329 00:35:16.750 ⇒ 00:35:20.639 Emily Giant: pickleball is very fun. And you feel like you’re playing tennis.
330 00:35:21.430 ⇒ 00:35:25.800 Emily Giant: Okay? So we’ve got item receipt of 32.
331 00:35:28.030 ⇒ 00:35:31.239 Emily Giant: So already we’re looking at maybe too many sales.
332 00:35:31.400 ⇒ 00:35:33.000 Emily Giant: Item fulfillment item fulfillment.
333 00:35:33.270 ⇒ 00:35:34.619 Emily Giant: I don’t see.
334 00:35:36.280 ⇒ 00:35:41.140 Emily Giant: Maybe this isn’t the best record to check for other adjustment types.
335 00:35:41.340 ⇒ 00:35:45.719 Emily Giant: because I’m not seeing the shrinkage. And I don’t know why that would ever show.
336 00:35:47.200 ⇒ 00:35:49.030 Emily Giant: Wait, hold up.
337 00:35:49.520 ⇒ 00:35:51.060 Emily Giant: I know what’s happening.
338 00:35:52.270 ⇒ 00:35:59.239 Emily Giant: Okay, so 32 is the number that was received. They sold 37,
339 00:35:59.960 ⇒ 00:36:06.200 Emily Giant: and somewhere there has to be a reflection of oversell.
340 00:36:06.330 ⇒ 00:36:10.350 Emily Giant: And that’s what’s happening in that shrinkage column is.
341 00:36:10.550 ⇒ 00:36:16.939 Emily Giant: they were like, wait a minute. We don’t actually have these, even though we sold 37.
342 00:36:17.350 ⇒ 00:36:19.479 Emily Giant: So there should actually be
343 00:36:22.890 ⇒ 00:36:26.059 Emily Giant: adjustments all the way down to
344 00:36:26.500 ⇒ 00:36:35.580 Emily Giant: the number 32 there should be like 5, unless there’s like a buffer somewhere in there that’s still hanging around. But that makes sense to me that
345 00:36:36.090 ⇒ 00:36:44.890 Emily Giant: there would be shrinkage against the oversell, because there has to be an adjustment to level it out and say we only ever got 32.
346 00:36:45.670 ⇒ 00:36:46.530 Demilade Agboola: Okay.
347 00:36:48.550 ⇒ 00:37:01.099 Emily Giant: Okay, that makes sense, even though the number is not as I would think it would be, negative. 5. But I bet anything that there’s just like a stupid buffer like hanging out on those that was never adjusted out. So I’ll look into that one, too.
348 00:37:04.340 ⇒ 00:37:09.909 Emily Giant: Gosh! Dang it! Urban stems or netsuite like, why are these all so weird?
349 00:37:12.340 ⇒ 00:37:22.409 Emily Giant: I’ve had to do like last round interviews for several people to backfill, some of like the front end and back end developers that we lost over the course of the year.
350 00:37:22.530 ⇒ 00:37:31.639 Emily Giant: And every time, like cause, I don’t really ask the technical questions I’m like. So how do you feel about systems that like don’t do what they’re supposed to do? Have you worked with that before? Because
351 00:37:32.290 ⇒ 00:37:34.599 Emily Giant: that’s what we’re looking at here. People.
352 00:37:36.990 ⇒ 00:37:42.100 Emily Giant: Okay. Last one is 4, 7.
353 00:37:47.800 ⇒ 00:37:54.029 Emily Giant: Well, I’m really excited for you to start playing tennis and swimming. I don’t know how I feel about the go-karts, but
354 00:37:54.240 ⇒ 00:37:55.500 Emily Giant: but I’m.
355 00:37:55.930 ⇒ 00:38:04.770 Demilade Agboola: I mean it’s too. It’s too late for me to go pro in cartoon, but you know you never can tell how far I might just take it, you know.
356 00:38:04.990 ⇒ 00:38:07.870 Demilade Agboola: I’m actually really excited, especially because oh.
357 00:38:07.870 ⇒ 00:38:08.880 Emily Giant: Exactly.
358 00:38:08.880 ⇒ 00:38:12.989 Demilade Agboola: There are like levels to cartoon, and they are faster cards.
359 00:38:13.942 ⇒ 00:38:19.590 Demilade Agboola: It’s just nice. And like even the place I I went. I sometimes I go karting
360 00:38:19.800 ⇒ 00:38:23.719 Demilade Agboola: at. They have the faster cars, but you need a license to drive them.
361 00:38:24.910 ⇒ 00:38:28.419 Emily Giant: Oh, man! So that’s that’s good for you, cause there’s like a goal.
362 00:38:28.420 ⇒ 00:38:38.562 Demilade Agboola: Yeah. So it’s just like, when I go to certain places I’m like, Oh, do you have the faster carts? And they’re like, yeah. And I’m like I have my license.
363 00:38:39.000 ⇒ 00:38:49.720 Emily Giant: Yeah, but you can’t use them still. This one’s looking good. So is there a negative? 8 somewhere? Yep, system, mismatch shrinkage. Yep, and then
364 00:38:51.500 ⇒ 00:39:00.159 Emily Giant: let me back this up to just view the sales orders, because the oversell, which is
365 00:39:01.100 ⇒ 00:39:07.600 Emily Giant: there’s going to be an oversell of whatever those shrinkage and system. Mismatch is from quantity sold
366 00:39:08.635 ⇒ 00:39:13.094 Emily Giant: and so already, like the math is mathing in my head.
367 00:39:15.280 ⇒ 00:39:18.510 Emily Giant: because we only got 20. So there should be
368 00:39:19.410 ⇒ 00:39:26.369 Emily Giant: 11, right or no. Excuse me. 21 adjusted out that didn’t exist.
369 00:39:35.177 ⇒ 00:39:53.490 Emily Giant: So I didn’t grow up in the country, but I had cousins that did, and they all had go-karts, and my brother and I were like the 2 cousins that were like from the city, and when I drove the go-kart the 1st time I ran it into my aunt’s brand new air conditioning unit, and.
370 00:39:53.490 ⇒ 00:39:54.290 Demilade Agboola: Joined it.
371 00:39:54.290 ⇒ 00:40:14.100 Emily Giant: And had to pay like $10,000 to get them a new one, and then my brother, the 1st time he drove it they had a barn, and he drove in through the side of the barn and put a giant hole in it and out the other side put like 2 giant holes in the sides of their barn. So like I think it’s just not for my family to be driving fast cars.
372 00:40:15.040 ⇒ 00:40:21.589 Demilade Agboola: Or or maybe you need to do training. Have you considered that maybe training is what you guys need.
373 00:40:21.730 ⇒ 00:40:24.047 Emily Giant: You sound crazy.
374 00:40:28.160 ⇒ 00:40:28.495 Emily Giant: hey?
375 00:40:29.230 ⇒ 00:40:32.689 Emily Giant: Alright! It’s only showing 29 sales orders.
376 00:40:34.510 ⇒ 00:40:36.519 Demilade Agboola: And so 35.
377 00:40:39.450 ⇒ 00:40:56.149 Emily Giant: Well as opposed to 41 total, because the subscriptions and those will have sales orders against them, too. But something is up with this. We’re like Netsuite is changing the records. It’s not showing the oversell. But I bet you, if we run in
378 00:40:57.190 ⇒ 00:41:09.829 Emily Giant: the inventory adjustment Mark, if you ran that quantity sold. I bet you it would pull 41 orders, and that oh, that 21 of them wouldn’t have a lot assigned anymore, because it was oversell during mother’s day.
379 00:41:11.100 ⇒ 00:41:12.170 Demilade Agboola: Oh!
380 00:41:12.170 ⇒ 00:41:14.530 Emily Giant: Look into all of these, because this is
381 00:41:14.750 ⇒ 00:41:19.179 Emily Giant: what I’m seeing is like correct. But it’s that our system
382 00:41:19.520 ⇒ 00:41:28.899 Emily Giant: has reconciled itself inside Netsuite, even though this was reality, like we really did sell 41 off of this lot and then had to kick.
383 00:41:29.020 ⇒ 00:41:34.182 Emily Giant: So we only have 20 that they removed instead of 21, whatever
384 00:41:34.840 ⇒ 00:41:39.500 Emily Giant: that they had to remove 20. But what didn’t happen was that
385 00:41:40.230 ⇒ 00:41:43.169 Emily Giant: the quantity sold, the lot didn’t get removed.
386 00:41:43.410 ⇒ 00:41:47.630 Emily Giant: It stayed, but there was no lot anyway.
387 00:41:48.510 ⇒ 00:41:56.609 Emily Giant: So it’s like, what does the stakeholder want to see? Do they want to see the truth that our system assigned 21 units that should never have been assigned to that lot?
388 00:41:57.210 ⇒ 00:41:58.790 Emily Giant: Or do they want to see?
389 00:41:59.300 ⇒ 00:42:04.199 Emily Giant: Because those are sales? Those were revenue producing sales that went out the door.
390 00:42:04.370 ⇒ 00:42:16.430 Demilade Agboola: Yeah, so I think this is part of why we talk about like having different inventory models for different people. I think someone like Perry, who is doing forecasting, would want to see this.
391 00:42:16.730 ⇒ 00:42:17.380 Emily Giant: Yeah.
392 00:42:17.630 ⇒ 00:42:21.539 Demilade Agboola: Right but obviously anyone who is doing content the actual
393 00:42:22.247 ⇒ 00:42:27.789 Demilade Agboola: like I I don’t know. I think we should do it this way, and if we can explain the discrepancies
394 00:42:29.210 ⇒ 00:42:30.579 Demilade Agboola: that would be helpful.
395 00:42:30.920 ⇒ 00:42:35.620 Demilade Agboola: I don’t know who would want to see it. In the in the way where it shows that
396 00:42:36.730 ⇒ 00:42:44.390 Demilade Agboola: where you deducted like 20 or 21, and shows the the numbers before the system regularized. I don’t know.
397 00:42:45.477 ⇒ 00:42:47.280 Demilade Agboola: Stakeholder would like to see that way.
398 00:42:47.790 ⇒ 00:42:49.310 Emily Giant: Honestly, the Dev team.
399 00:42:49.816 ⇒ 00:42:56.780 Emily Giant: They might need to see that, like the concurrency rate is such that, like, we’re overselling by this amount.
400 00:42:57.275 ⇒ 00:43:04.749 Emily Giant: So maybe what we need. Let me know what you think of this is like a a balance column of like
401 00:43:05.350 ⇒ 00:43:08.870 Emily Giant: 41 minus 20.
402 00:43:09.170 ⇒ 00:43:18.450 Emily Giant: So like some kind of representation of the sold minus the system. Mismatches.
403 00:43:18.770 ⇒ 00:43:19.670 Demilade Agboola: Okay.
404 00:43:19.670 ⇒ 00:43:21.320 Emily Giant: But it wouldn’t be all of them.
405 00:43:21.730 ⇒ 00:43:27.270 Emily Giant: It would only be the like inventory, discrepancy columns.
406 00:43:28.160 ⇒ 00:43:34.170 Emily Giant: So that would be like shrinkage system, mismatch, reconcile manual.
407 00:43:38.710 ⇒ 00:43:42.059 Emily Giant: How about like damage logistics and career quantity?
408 00:43:42.060 ⇒ 00:43:50.689 Emily Giant: Those are to be honest with you. I don’t even know if anyone’s ever used those. But I’ll ask Felipe, because those went out the door.
409 00:43:51.340 ⇒ 00:43:56.940 Emily Giant: It would be the ones that got damaged in the facility. But damage logistics.
410 00:43:57.120 ⇒ 00:44:00.079 Emily Giant: No, you’re right. You’re right. I need to ask Felipe
411 00:44:01.270 ⇒ 00:44:02.399 Emily Giant: He would know.
412 00:44:02.933 ⇒ 00:44:06.690 Demilade Agboola: Declined. Do you know if Philip is coming to the call today.
413 00:44:06.890 ⇒ 00:44:11.830 Emily Giant: He is. He only has worked one day this week. Which is good. He works way too much.
414 00:44:11.950 ⇒ 00:44:12.520 Demilade Agboola: Okay.
415 00:44:13.020 ⇒ 00:44:17.440 Demilade Agboola: I just wanted to know who we couldn’t, who we can expect, so I should go run this by Felipe.
416 00:44:18.620 ⇒ 00:44:26.320 Emily Giant: Yeah, let’s show him if there’s time like even running, this example is a good visualization of like
417 00:44:28.200 ⇒ 00:44:30.649 Emily Giant: this is what actually happened.
418 00:44:31.070 ⇒ 00:44:31.920 Demilade Agboola: Okay.
419 00:44:31.920 ⇒ 00:44:34.179 Emily Giant: What should be deducted from
420 00:44:35.100 ⇒ 00:44:47.329 Emily Giant: the sales that successfully were assigned to the lot, because none of the receiving ones. Well, that’s not true, that’s not true. I think the only one is spoilage. Spoilage is the only
421 00:44:48.011 ⇒ 00:44:58.900 Emily Giant: kind that can’t be sold, because even the receiving, rejected like you can pre-sell literally every single bouquet on a lot, and then, if it gets rejected when they receive it.
422 00:44:59.070 ⇒ 00:45:01.190 Emily Giant: it should be kicked off that lot.
423 00:45:02.430 ⇒ 00:45:03.100 Emily Giant: The sale.
424 00:45:04.480 ⇒ 00:45:08.159 Demilade Agboola: So how? But if it’s kicked off the law, how is that still accounted for.
425 00:45:09.390 ⇒ 00:45:13.390 Emily Giant: That’s the issue that I need to look into here because
426 00:45:13.610 ⇒ 00:45:26.869 Emily Giant: I’m concerned that the the sales orders that didn’t get kicked off this lot are on a different lot, too, and that they’re over representing sales. So when I see 41 and I know that, like.
427 00:45:27.520 ⇒ 00:45:33.219 Emily Giant: there’s no physical way, we could have sent 41 out the door. Either, wasn’t
428 00:45:34.000 ⇒ 00:45:39.560 Emily Giant: I mean, we can. We have time? I can just pull up those sales that are assigned to that lot and see if
429 00:45:40.310 ⇒ 00:45:44.880 Emily Giant: see which one didn’t actually get assigned to that lot
430 00:45:45.450 ⇒ 00:45:49.179 Emily Giant: or should have the record should have updated. And it didn’t.
431 00:45:49.490 ⇒ 00:45:57.549 Emily Giant: Okay? So if I do select everything from inventory adjustment mark.
432 00:46:05.070 ⇒ 00:46:06.430 Emily Giant: where
433 00:46:12.750 ⇒ 00:46:13.660 Emily Giant: of
434 00:46:34.380 ⇒ 00:46:36.557 Emily Giant: alright, I’m gonna add this to
435 00:46:37.600 ⇒ 00:46:42.400 Emily Giant: that spreadsheet and just share the link with you so you can see what I’m seeing.
436 00:47:17.900 ⇒ 00:47:19.729 Emily Giant: I there it is. Okay. Sorry.
437 00:47:20.190 ⇒ 00:47:26.100 Emily Giant: Zoom was being a little laggy. The tab is
438 00:47:28.320 ⇒ 00:47:34.250 Emily Giant: called sheet 13. I haven’t renamed it yet. Adults of the sales on that lot for the melody
439 00:47:36.990 ⇒ 00:47:40.659 Emily Giant: transaction line 92 wtf.
440 00:47:41.538 ⇒ 00:47:49.000 Emily Giant: And then in column n, these are the suborder ids. So I’m just gonna start like plunking them into dash to see which one like
441 00:47:49.620 ⇒ 00:47:51.380 Emily Giant: says, like not committed.
442 00:47:54.210 ⇒ 00:47:58.583 Emily Giant: I’m guessing the one with 92 transaction lines is one of them.
443 00:48:00.470 ⇒ 00:48:05.910 Demilade Agboola: Yeah, that looks off quite a bit, just a bit.
444 00:48:05.910 ⇒ 00:48:09.419 Emily Giant: Yeah, I’ve never seen more than 6
445 00:48:10.106 ⇒ 00:48:14.750 Emily Giant: and these all look jacked up. What is happening?
446 00:48:20.810 ⇒ 00:48:24.580 Emily Giant: Nope, that one is fine, unreal.
447 00:48:24.580 ⇒ 00:48:29.140 Demilade Agboola: These all all have adjustment ids as well as sub order, ids.
448 00:48:31.890 ⇒ 00:48:36.990 Emily Giant: Oh, and there’s only okay. So they all will.
449 00:48:38.260 ⇒ 00:48:47.459 Emily Giant: I think that this model somehow has only chosen the ones that are correctly assigned.
450 00:48:48.654 ⇒ 00:48:50.619 Emily Giant: Where’s the quantity?
451 00:48:57.500 ⇒ 00:49:04.790 Emily Giant: Okay? So if I do, oh, there’s lots of doubles. It is 41. It’s 41 units.
452 00:49:05.270 ⇒ 00:49:07.009 Demilade Agboola: Yeah, it’s 41.
453 00:49:10.950 ⇒ 00:49:12.319 Emily Giant: Let me try this one.
454 00:49:22.610 ⇒ 00:49:24.730 Emily Giant: This one’s on there twice.
455 00:49:25.590 ⇒ 00:49:26.850 Emily Giant: -Oh
456 00:49:30.040 ⇒ 00:49:31.170 Emily Giant: duplicates.
457 00:49:35.510 ⇒ 00:49:37.980 Emily Giant: Look at the 27 and 28.
458 00:49:38.640 ⇒ 00:49:40.250 Emily Giant: May hmm.
459 00:49:45.070 ⇒ 00:49:46.810 Demilade Agboola: 27, and 28
460 00:49:52.160 ⇒ 00:49:54.000 Demilade Agboola: available quantity.
461 00:49:55.230 ⇒ 00:49:58.609 Emily Giant: Also. This order was never sent. It is.
462 00:49:58.610 ⇒ 00:50:01.230 Demilade Agboola: I mean the the product. Skews are different, though.
463 00:50:01.680 ⇒ 00:50:07.009 Emily Giant: Yeah, one’s a forced upgrade. So one this is what’s happening.
464 00:50:07.860 ⇒ 00:50:14.969 Emily Giant: All of the grower’s choice. Peony should not be on this lot. It’s not a lot for the grower’s choice peony. So
465 00:50:15.960 ⇒ 00:50:25.380 Emily Giant: what’s happening is items that were forced upgraded are not getting removed from the lot interesting
466 00:50:29.230 ⇒ 00:50:29.930 Emily Giant: like.
467 00:50:31.830 ⇒ 00:50:36.719 Emily Giant: So if I were to remove anything. That’s not the melody and the quantity.
468 00:50:37.340 ⇒ 00:50:38.060 Demilade Agboola: Yeah.
469 00:50:38.060 ⇒ 00:50:39.290 Emily Giant: I thought it would balance.
470 00:50:44.450 ⇒ 00:50:47.419 Demilade Agboola: So it’s just it should be the melody alone.
471 00:50:47.840 ⇒ 00:50:51.410 Emily Giant: It should only be the melody. There’s only one item on a lot.
472 00:50:51.730 ⇒ 00:50:53.360 Demilade Agboola: There’s also the Gov.
473 00:50:53.860 ⇒ 00:50:54.200 Demilade Agboola: Yeah.
474 00:50:54.660 ⇒ 00:50:55.570 Demilade Agboola: Laura.
475 00:50:56.300 ⇒ 00:51:00.850 Emily Giant: Alright! So that’s not correct.
476 00:51:04.900 ⇒ 00:51:05.450 Emily Giant: Let me.
477 00:51:05.450 ⇒ 00:51:11.690 Demilade Agboola: For every, for every lot Id. Is there a product skew associated with it?
478 00:51:11.910 ⇒ 00:51:19.379 Emily Giant: Exactly. Yes, the item Id. So anywhere where the item Id isn’t 3, 8, 6, 1. It’s wrong.
479 00:51:20.640 ⇒ 00:51:22.689 Demilade Agboola: It’s been moved to a different lot.
480 00:51:22.900 ⇒ 00:51:25.150 Demilade Agboola: Is there? Is there a mapping for this.
481 00:51:27.214 ⇒ 00:51:28.699 Emily Giant: For item id.
482 00:51:29.060 ⇒ 00:51:32.900 Demilade Agboola: Is it mapping for like the item id that should be on every lot.
483 00:51:33.390 ⇒ 00:51:42.400 Emily Giant: Yes, in inventory number Id. The staging model. There should be an id associated with that inventory.
484 00:51:42.400 ⇒ 00:51:46.199 Demilade Agboola: So if I, if I use that here.
485 00:51:47.820 ⇒ 00:52:00.859 Demilade Agboola: or if I use that in our model to ensure that we’re only looking at the appropriate. I also another question. 2 questions. One is, if I use that here to ensure only looking at the appropriate Id. I think that moves us
486 00:52:01.170 ⇒ 00:52:06.390 Demilade Agboola: much, because that’s our final answer. But how do we account for these
487 00:52:07.180 ⇒ 00:52:09.559 Demilade Agboola: ids that were like forced upgrades.
488 00:52:11.040 ⇒ 00:52:13.306 Emily Giant: Yeah, that’s a good question.
489 00:52:15.980 ⇒ 00:52:21.209 Emily Giant: because doing the logic of like, if item Id is not.
490 00:52:21.440 ⇒ 00:52:25.799 Emily Giant: if item Id in the transaction line model where this is coming from
491 00:52:26.385 ⇒ 00:52:31.919 Emily Giant: is coming from transaction line, not from inventory number. Id does not match.
492 00:52:32.170 ⇒ 00:52:33.110 Demilade Agboola: Then it’s.
493 00:52:33.230 ⇒ 00:52:37.820 Emily Giant: Right, and shouldn’t be on the lot, but that feels
494 00:52:38.720 ⇒ 00:52:43.620 Emily Giant: janky and like it should come from the source instead of.
495 00:52:44.530 ⇒ 00:52:45.370 Demilade Agboola: I mean.
496 00:52:45.720 ⇒ 00:52:47.550 Emily Giant: It’s fine, but.
497 00:52:47.830 ⇒ 00:52:51.000 Demilade Agboola: I think the question. I think my question is like, How do we
498 00:52:51.950 ⇒ 00:52:57.480 Demilade Agboola: make the proper association to the inventory calculation? I think that’s probably what I want.
499 00:52:58.610 ⇒ 00:53:06.950 Emily Giant: So if the item number yeah, that’s a good question. So let me look at the Flora.
500 00:53:07.420 ⇒ 00:53:10.440 Emily Giant: the No Row 11,
501 00:53:14.580 ⇒ 00:53:17.320 Emily Giant: I’m gonna see what actually happened on that order.
502 00:53:23.250 ⇒ 00:53:28.450 Emily Giant: So it was originally the melody, and then it got force upgraded to the flora.
503 00:53:28.980 ⇒ 00:53:34.910 Emily Giant: So presumably, if I were to pull that suborder. Id
504 00:53:36.210 ⇒ 00:53:41.810 Emily Giant: it should also have a record on the Flora lot. Not just.
505 00:53:44.170 ⇒ 00:53:47.590 Emily Giant: I guess. What I don’t understand is why it didn’t update
506 00:53:48.490 ⇒ 00:53:51.629 Emily Giant: like the inventory lot. Id should have updated
507 00:53:52.218 ⇒ 00:53:55.410 Emily Giant: with the most recent line on transaction line.
508 00:54:00.720 ⇒ 00:54:02.890 Demilade Agboola: Sorry. Can you repeat that? Please.
509 00:54:03.030 ⇒ 00:54:11.500 Emily Giant: On row 11, I mean example. So I pulled that up in dash. And the life cycle of the order was that
510 00:54:12.380 ⇒ 00:54:16.100 Emily Giant: it was originally going to be the melody, which is the correct lot.
511 00:54:16.340 ⇒ 00:54:22.190 Emily Giant: but then, like Ham, changed it to the flora in
512 00:54:22.440 ⇒ 00:54:27.360 Emily Giant: the model or in the table, that this pulls from the source table is inventory transaction line
513 00:54:27.640 ⇒ 00:54:29.570 Emily Giant: and inventory assignment.
514 00:54:29.970 ⇒ 00:54:42.050 Emily Giant: But if it changes, the record should update to the correct inventory number Id. So either the join to inventory number Id is incorrect
515 00:54:42.320 ⇒ 00:54:50.450 Emily Giant: or the record didn’t update correctly when the item was changed. So I don’t know what caused this
516 00:54:51.110 ⇒ 00:55:00.290 Emily Giant: model. To think that the inventory number Id is correct.
517 00:55:01.245 ⇒ 00:55:04.889 Emily Giant: My my expectation would be that if I pulled.
518 00:55:05.200 ⇒ 00:55:13.039 Emily Giant: If I search inventory mart adjustments for just that suborder id that it’s going to come up with 2 rows.
519 00:55:13.700 ⇒ 00:55:21.969 Emily Giant: because the way that these are unique are the suborder id the item
520 00:55:22.330 ⇒ 00:55:30.569 Emily Giant: and the inventory number. Id, so the uniqueness is failing because
521 00:55:30.690 ⇒ 00:55:36.770 Emily Giant: the forced upgrade is saying, this is a different item. Therefore this is a unique record.
522 00:55:36.940 ⇒ 00:55:39.090 Emily Giant: But really that record should be gone.
523 00:55:41.050 ⇒ 00:55:43.230 Demilade Agboola: Oh, hey!
524 00:55:44.920 ⇒ 00:55:47.679 Demilade Agboola: Is this overdried in eventual lots? Table.
525 00:55:48.700 ⇒ 00:55:52.059 Emily Giant: Yeah, that’s no inventory adjustments. Sorry.
526 00:55:55.480 ⇒ 00:55:59.659 Emily Giant: And what we’re trying to do is kill the inventory lot table and
527 00:55:59.890 ⇒ 00:56:07.480 Emily Giant: make it so that it all rolls up into that right? But that way you won’t have to go to 2 different tables to do this in the future.
528 00:56:09.610 ⇒ 00:56:10.380 Emily Giant: Yeah.
529 00:56:10.730 ⇒ 00:56:12.189 Demilade Agboola: We do have 2. Yeah.
530 00:56:12.190 ⇒ 00:56:17.020 Emily Giant: Mother effer. So really the line with the flora.
531 00:56:17.490 ⇒ 00:56:21.799 Emily Giant: But what’s wrong and very incorrect is that the inventory number Id
532 00:56:22.410 ⇒ 00:56:27.149 Emily Giant: should not be the same for those, because the Flora doesn’t have a lot with that lot. Number.
533 00:56:27.490 ⇒ 00:56:44.259 Demilade Agboola: Well, my, okay. So in this case, I guess what we can do is we can also join on item Id, so it forces it to only recognize the item id associated with the inventory number. Id. But the question now is, so, what happens to the flora like? How would the Flora be counted
534 00:56:44.390 ⇒ 00:56:45.740 Demilade Agboola: on a different lot.
535 00:56:46.833 ⇒ 00:56:49.659 Emily Giant: It’s got its own inventory number. Id.
536 00:56:50.070 ⇒ 00:56:51.250 Demilade Agboola: Gotcha.
537 00:56:51.250 ⇒ 00:56:56.809 Emily Giant: Yeah. So in netsuite, it will say which one it should be. I’ll tell you what
538 00:56:57.130 ⇒ 00:56:58.609 Emily Giant: it actually should be.
539 00:56:59.470 ⇒ 00:57:00.370 Demilade Agboola: Gotcha.
540 00:57:03.820 ⇒ 00:57:05.769 Emily Giant: It should be this lot number
541 00:57:11.770 ⇒ 00:57:17.029 Emily Giant: Nope, which is inventory number id.
542 00:57:53.660 ⇒ 00:57:57.259 Emily Giant: This is what it’s the inventory number. Id. That it should be. I’m sending it in the chat.
543 00:57:57.980 ⇒ 00:57:58.670 Demilade Agboola: Okay.
544 00:58:23.750 ⇒ 00:58:29.759 Emily Giant: So I’m saying this before. I hop, because I have to go to my next call, but
545 00:58:30.070 ⇒ 00:58:35.699 Emily Giant: I am interested, and so are stakeholders in the amount that we actually sold.
546 00:58:36.320 ⇒ 00:58:51.280 Emily Giant: even if there was a forced upgrade and it didn’t get sent out the door there is interest in. We actually sold 41 of these we had to kick 29 of them off the lot, or whatever the number was, but the demand was higher than what we could provide.
547 00:58:51.770 ⇒ 00:58:52.730 Emily Giant: and
548 00:58:52.870 ⇒ 00:59:14.170 Emily Giant: that would be for the revenue model. So that’s like what we’re working on next. But like just to keep that in our pocket of like. Yes, we sent the Flora for the inventory. Felipe’s like. That’s what’s important. But for the Perry’s like the fact that we didn’t give the customer 21 customers. What they ordered is important, and that we the demand was off for the melody.
549 00:59:15.590 ⇒ 00:59:16.580 Demilade Agboola: Okay.
550 00:59:16.790 ⇒ 00:59:22.690 Emily Giant: Yeah, I wouldn’t worry about that while we’re debugging, of course, but just wanted to like cast that as a.
551 00:59:23.300 ⇒ 00:59:31.839 Demilade Agboola: Alright. So for so just quick. So for the game plan for today with Felipe, are we just gonna show him these numbers and explain what’s going on.
552 00:59:34.870 ⇒ 00:59:37.110 Demilade Agboola: We try and make sure the numbers are
553 00:59:37.350 ⇒ 00:59:41.739 Demilade Agboola: much closer, like we filter out, based on the item Id.
554 00:59:44.090 ⇒ 00:59:52.556 Emily Giant: I think if we are able to, which seems unlikely since that meeting is like relatively soon. Update the logic.
555 00:59:53.130 ⇒ 00:59:57.230 Emily Giant: then we’d show him. Let’s just show him where we’re at with it.
556 00:59:58.081 ⇒ 01:00:02.219 Emily Giant: So just going through and like taking
557 01:00:02.370 ⇒ 01:00:06.776 Emily Giant: some examples that have too many sales on them, and then
558 01:00:08.250 ⇒ 01:00:22.740 Emily Giant: no scratch that I think we should find. I will find examples and send them to you of lots that have oversell, and then the adjustments to balance them. And let’s ask Felipe how he wants that represented.
559 01:00:22.850 ⇒ 01:00:25.629 Demilade Agboola: Because that’s the question to answer is like.
560 01:00:26.210 ⇒ 01:00:36.469 Emily Giant: If you subtract the number of inventory adjustments from the oversell, it evens out. Do you want to see the oversell, or do you want to see only
561 01:00:36.800 ⇒ 01:00:38.439 Emily Giant: the sales that were.
562 01:00:38.590 ⇒ 01:00:40.310 Demilade Agboola: Those. Yeah. A lot, Eddie.
563 01:00:40.630 ⇒ 01:00:42.270 Demilade Agboola: Okay. Fair enough. Fair enough.
564 01:00:42.870 ⇒ 01:00:45.030 Emily Giant: All right. I will see you in 30 min.
565 01:00:45.030 ⇒ 01:00:46.150 Demilade Agboola: Alright, sounds good.