Meeting Title: Brainforge AFS Calculation Sync Date: 2025-07-08 Meeting participants: Emily Giant, Felipefaria, Demilade Agboola
WEBVTT
1 00:00:27.480 ⇒ 00:00:29.899 Emily Giant: Morning or afternoon.
2 00:00:30.880 ⇒ 00:00:32.229 Demilade Agboola: Hi, Emily, how are you?
3 00:00:33.710 ⇒ 00:00:47.600 Emily Giant: Oh, I’m okay. I did not sleep last night. I’ve been on steroids from my poison ivy, and now I just like, don’t sleep. So I’m I’m fine, but I’m just waiting for the tiredness to hit. How are you.
4 00:00:48.367 ⇒ 00:00:53.949 Demilade Agboola: I’m doing alright. Definitely, not on steroids, but I’m alright.
5 00:00:55.090 ⇒ 00:01:00.140 Emily Giant: That’s good definitely not. I’m glad that there’s no mystery as to whether
6 00:01:01.358 ⇒ 00:01:07.960 Emily Giant: I did invite Felipe. Let me write him real quick and make sure that he, like
7 00:01:08.500 ⇒ 00:01:15.760 Emily Giant: received the zoom link. I sent it like 5 different ways, because I was worried that I couldn’t add someone to the invite, since it was from
8 00:01:15.880 ⇒ 00:01:18.050 Emily Giant: like Brainforge owned account.
9 00:01:18.320 ⇒ 00:01:19.620 Emily Giant: But let me see.
10 00:01:19.810 ⇒ 00:01:21.449 Emily Giant: Good morning.
11 00:02:00.400 ⇒ 00:02:04.300 Emily Giant: Let me just grab this meeting link again, just in case.
12 00:02:08.710 ⇒ 00:02:09.199 Emily Giant: Okay.
13 00:02:10.505 ⇒ 00:02:21.889 Emily Giant: so yeah, yesterday I did a bunch of Qa on on your work. And it it looks like it’s just the canceled orders that are throwing off those final amounts. So
14 00:02:22.030 ⇒ 00:02:42.990 Emily Giant: I tried I I met with Tazdek and the flag that he gave me to indicate that the orders were cancelled like. I checked a hundred orders, and none of them were canceled. So I was like Tazdeq. I’m not sure that this is a super reliable flag, but I don’t know what’s up with that. I don’t know if it’s like
15 00:02:43.170 ⇒ 00:02:59.999 Emily Giant: user error with netsuite or a source issue. Or I mean, it’s definitely a source issue, because we’re not getting the correct information from. But there’s like, no, just like redeliveries. There’s just no good way to indicate
16 00:03:00.120 ⇒ 00:03:03.959 Emily Giant: that an order was canceled without cross-referencing oms data right now.
17 00:03:04.250 ⇒ 00:03:08.909 Emily Giant: And I told him like, I would like to be able to do that because
18 00:03:09.270 ⇒ 00:03:10.919 Emily Giant: I want to know, like.
19 00:03:11.680 ⇒ 00:03:17.529 Emily Giant: if inventory is off from Oms, is it because the data from Netsuite is wrong?
20 00:03:18.011 ⇒ 00:03:23.559 Emily Giant: Or the source data in that system is wrong? Because at the end of the day. That’s what we’re going to be using for accounting.
21 00:03:24.030 ⇒ 00:03:24.660 Demilade Agboola: Yeah.
22 00:03:24.660 ⇒ 00:03:29.499 Emily Giant: I’m not gonna use a looker report to send to someone for accounting. So
23 00:03:29.700 ⇒ 00:03:42.519 Emily Giant: I’m gonna keep pushing on that end to get the like cancellation flag working, or at least like find some other way, because there there are other routes. I just was like this could take
24 00:03:42.820 ⇒ 00:03:50.770 Emily Giant: 3 days of discovery on this to find the correct combination of columns that indicate because there is
25 00:03:51.340 ⇒ 00:03:58.660 Emily Giant: in the transaction line table. There’s something that’s called like, fully shipped. And for the canceled orders it often said, No.
26 00:03:59.257 ⇒ 00:04:00.360 Emily Giant: so if you.
27 00:04:00.360 ⇒ 00:04:02.480 Demilade Agboola: Often, often or always.
28 00:04:02.830 ⇒ 00:04:08.999 Emily Giant: Exactly I don’t know. I didn’t have enough time to like IQ. 8, a hundred, but
29 00:04:09.320 ⇒ 00:04:18.969 Emily Giant: those were correct. But the the is closed, which is supposed to be like the flag of a canceled order, was
30 00:04:19.300 ⇒ 00:04:29.461 Emily Giant: all over the place. So I’ve got to figure that out with the team like the Dev team, because there’s nothing you and I can do about that. So did you want me to
31 00:04:31.210 ⇒ 00:04:33.509 Emily Giant: to go through like where the
32 00:04:34.000 ⇒ 00:04:40.480 Emily Giant: the cancel flags are, and I can. I can pull that in to the model. But I didn’t know like if
33 00:04:40.760 ⇒ 00:04:43.889 Emily Giant: you’d already done work there, or if you wanted to do that
34 00:04:44.700 ⇒ 00:04:47.849 Emily Giant: like during the meeting. But
35 00:04:47.980 ⇒ 00:04:53.279 Emily Giant: I can quickly like show where that is an oms, and it’s reliable.
36 00:04:54.850 ⇒ 00:04:58.519 Demilade Agboola: Sure you could show me that also, like another question I wanted to ask is
37 00:04:58.740 ⇒ 00:05:04.710 Demilade Agboola: so, since we have new values for things like quantity sold, and subscription quantity and all that?
38 00:05:05.202 ⇒ 00:05:10.550 Demilade Agboola: When we’re calculating, available for sale. Are we going to be using the total
39 00:05:10.690 ⇒ 00:05:21.220 Demilade Agboola: quantity sold? Or is it supposed to be the committed quantity sold or uncommitted like. Obviously, I don’t think it’s going to be uncommitted, but basically it’s going to be between the committed and the total quantity sold.
40 00:05:21.390 ⇒ 00:05:22.929 Emily Giant: Oh.
41 00:05:24.330 ⇒ 00:05:31.759 Emily Giant: that’s a good question for Felipe. I would think that we would want it to be the truth, which is the total quantity sold
42 00:05:32.400 ⇒ 00:05:36.700 Emily Giant: because the committed quantity sold is
43 00:05:38.020 ⇒ 00:05:46.850 Emily Giant: essentially like a system representation, whether it’s true or not. And I did see when I was qaing that, like
44 00:05:49.610 ⇒ 00:06:12.499 Emily Giant: inventory commit number 3 often means it went out. The door. If like. The delivery date is in the past, and the commit status is 3 that it didn’t properly commit inventory to that lot. So that’s like a down the line thing that again, I don’t feel like I had enough time yesterday to Qa, because I just wanted to get like the foundational stuff like over the line.
45 00:06:14.060 ⇒ 00:06:22.799 Emily Giant: but I would think they would want a true representation of what is available for sale. Not like
46 00:06:23.160 ⇒ 00:06:29.947 Emily Giant: a tidy system version of that. But I that’s why I wanted Felipe to join.
47 00:06:31.360 ⇒ 00:06:38.509 Emily Giant: I don’t know what? I don’t know where he is. Also Zach got jury duty. Did he send you guys an email.
48 00:06:39.370 ⇒ 00:06:40.409 Demilade Agboola: I didn’t see that.
49 00:06:41.350 ⇒ 00:06:47.799 Emily Giant: I I don’t know like if it was an open shut case. But yesterday he went in for like the preliminary thing, and I’m like
50 00:06:48.110 ⇒ 00:07:08.289 Emily Giant: 90% sure he got chosen, which, of course, he he’s like the perfect juror, like Stone faced like analytical. He’s getting chosen, but I hope he gets a good case. Do you have to do that in Nigeria, or is that a thing in other places? It’s like literal torture that they make us do.
51 00:07:08.530 ⇒ 00:07:14.212 Demilade Agboola: Yeah, I know I heard. I’ve heard about it that you get calls like jury. This, you know, it doesn’t happen in Nigeria.
52 00:07:14.630 ⇒ 00:07:18.509 Demilade Agboola: our legal system tends to be very.
53 00:07:18.820 ⇒ 00:07:27.380 Demilade Agboola: It’s based. It tends to be based on the judge, I believe, like the judges, judge on the law of cases. So we don’t require a lot of juries.
54 00:07:28.910 ⇒ 00:07:34.909 Emily Giant: We. Usually that’s the case here as well, like. We’re very reliant on judges, but
55 00:07:35.170 ⇒ 00:07:41.120 Emily Giant: and I never have gotten knock on wood. I’ve never gotten jury duty, and I think it’s because
56 00:07:41.410 ⇒ 00:08:07.760 Emily Giant: they think I’m crazy. I’m like, yes, let’s keep that narrative going. But Ian, my my former coworker when I was on the care team. He’s gotten it 2 times in the last year, like certain people they find them, and they’re like, you’re a good juror. You’re a good juror. They like find people that are good at working with others, and like I swear they just circulate them. But I got out of that I don’t know what I said or did in my twenties, but they’re like, not her.
57 00:08:07.870 ⇒ 00:08:09.750 Emily Giant: Don’t even send her a letter.
58 00:08:10.130 ⇒ 00:08:19.910 Emily Giant: but it’s crazy that you like can be the Vp of a department, and they’re just like you’re not going to work for a month.
59 00:08:20.290 ⇒ 00:08:22.460 Emily Giant: and there’s nothing anyone can do about it.
60 00:08:23.000 ⇒ 00:08:27.520 Demilade Agboola: How it lasts as long as a month, or is it like on certain days within the month.
61 00:08:28.130 ⇒ 00:08:35.239 Emily Giant: It is. Let me Google, I think it can go on a really long time. How long can
62 00:08:35.530 ⇒ 00:08:38.110 Emily Giant: jury duty last.
63 00:08:39.020 ⇒ 00:08:41.489 Demilade Agboola: I mean. I think it’ll depend on the case, too.
64 00:08:41.490 ⇒ 00:08:44.499 Emily Giant: Yeah, in Indiana. It’s only 5 days.
65 00:08:46.240 ⇒ 00:08:51.700 Emily Giant: But I know that Ian was out for like in Colorado.
66 00:08:57.350 ⇒ 00:09:02.140 Emily Giant: Okay, no, it’s it’s like 3 3 days to a week in Colorado.
67 00:09:02.420 ⇒ 00:09:04.929 Emily Giant: but it can go on and on.
68 00:09:05.310 ⇒ 00:09:15.620 Emily Giant: which just seems so unfair and disruptive to people’s lives. But yeah, I got like 10
69 00:09:16.210 ⇒ 00:09:28.050 Emily Giant: messages at 10 o’clock last night of people being like, what’s Zack’s case? Do you know anything I’m like? Do you think my boss calls me like and tells me about his jury duty. I don’t know like I’ll figure it out when he comes back.
70 00:09:28.150 ⇒ 00:09:46.179 Emily Giant: But anyway, I’ll keep you updated on that. So back to our combo. I I think it would be wise to just base Afs on the actual account of available. So we’re taking like the total quantity sold into account.
71 00:09:47.319 ⇒ 00:09:53.890 Emily Giant: Instead of the committed quantity sold did you
72 00:09:54.250 ⇒ 00:09:59.899 Emily Giant: get the flow chart? I wouldn’t, Felipe, to give like final words on that flow chart of Afs
73 00:10:00.050 ⇒ 00:10:06.039 Emily Giant: the like issues. I was having having it like accurately represent afs
74 00:10:07.990 ⇒ 00:10:12.570 Emily Giant: but it’s usable as is. I don’t think there are any other like fringe cases.
75 00:10:12.830 ⇒ 00:10:13.680 Demilade Agboola: Okay.
76 00:10:13.970 ⇒ 00:10:15.520 Emily Giant: But let me send you that.
77 00:10:15.850 ⇒ 00:10:22.149 Emily Giant: It’s in a Sigma board, so that I could just like draw all the ways that it goes like good and bad.
78 00:10:36.230 ⇒ 00:10:37.659 Demilade Agboola: Are you? Are you sharing the link.
79 00:10:40.730 ⇒ 00:10:49.390 Emily Giant: I was also screaming it, Matthew in the kitchen. So urban stems retro.
80 00:11:06.490 ⇒ 00:11:08.349 Emily Giant: All right. Link is sent.
81 00:11:10.270 ⇒ 00:11:11.060 Emily Giant: Oh.
82 00:11:16.560 ⇒ 00:11:17.520 Emily Giant: thank you.
83 00:11:22.460 ⇒ 00:11:29.700 Emily Giant: That’s not amazing. Today, I know, is that what that is?
84 00:11:30.320 ⇒ 00:11:42.479 Emily Giant: So we live like in a field. And there are clouds like covering the field today, and that goes made it into the living room. And I was like, really, he’s like, No, this is smoke from you making toast. I was like, Oh.
85 00:11:45.570 ⇒ 00:11:47.400 Emily Giant: but it is really pretty.
86 00:11:47.870 ⇒ 00:11:48.860 Emily Giant: Okay?
87 00:11:57.480 ⇒ 00:12:00.875 Emily Giant: So I put the
88 00:12:02.020 ⇒ 00:12:12.992 Emily Giant: the calculation we’re currently using, like, the biggest issue is when the system is lagging. And there’s nothing we can do about that.
89 00:12:14.430 ⇒ 00:12:20.489 Emily Giant: that’s just a a dev issue. There is a ticket, and they’re working on that concurrency so that it’s up
90 00:12:20.980 ⇒ 00:12:25.989 Emily Giant: up to speed. So that’s the top flow. It’s the second one that we have a lot more control over.
91 00:12:26.400 ⇒ 00:12:27.010 Emily Giant: And
92 00:12:27.830 ⇒ 00:12:36.630 Emily Giant: so the receiving short, it’s when we receive items. Qa right now. Qa units are lingering in the on hand.
93 00:12:37.206 ⇒ 00:12:41.130 Emily Giant: And they’re a different status so they can be removed. But
94 00:12:41.948 ⇒ 00:12:47.930 Emily Giant: the issue I was having. Is that like you can’t just subtract
95 00:12:48.230 ⇒ 00:12:53.539 Emily Giant: out the Qa. Because the Qa. Doesn’t disappear
96 00:12:53.690 ⇒ 00:12:56.889 Emily Giant: if that makes sense. So with
97 00:12:59.330 ⇒ 00:13:07.440 Emily Giant: if you how do I say it. You’ve got to separate it out by status, and as it’s
98 00:13:07.580 ⇒ 00:13:16.659 Emily Giant: own part of the equation, or else it will get into the negatives once the on hand is like super reduced.
99 00:13:16.770 ⇒ 00:13:22.079 Emily Giant: So that was, I think, how it’s set up right now. Is that like it says something to the effect of
100 00:13:22.590 ⇒ 00:13:25.529 Emily Giant: here are the committed units, subtract them from
101 00:13:25.970 ⇒ 00:13:35.617 Emily Giant: subtract all of the like used units from the on hand committed units, but because the Qa units never leave
102 00:13:36.290 ⇒ 00:13:40.940 Emily Giant: By the time a bunch of orders are sent out it will say, like.
103 00:13:41.110 ⇒ 00:13:52.630 Emily Giant: Okay, we have one on hand, one committed, and there’s still 3 sitting in Qa. So it pushes the Afs into the negatives falsely when those units aren’t actually
104 00:13:53.240 ⇒ 00:14:07.800 Emily Giant: in the building sellable. However, if you don’t subtract them out, they continue to be represented in the on hand. So that’s the biggest issue, and I think it’s just tweaking that intermediate model where
105 00:14:08.600 ⇒ 00:14:11.690 Emily Giant: where you do the like on hand. Count.
106 00:14:13.910 ⇒ 00:14:18.089 Demilade Agboola: Okay, so effectively, the on hand count needs to.
107 00:14:22.180 ⇒ 00:14:26.120 Demilade Agboola: We need a decision where, like once, it’s.
108 00:14:26.730 ⇒ 00:14:31.790 Demilade Agboola: I’m trying to think of, like, how how do we identify when we need to change the on hand? Count
109 00:14:31.990 ⇒ 00:14:34.650 Demilade Agboola: like in terms of the data flow.
110 00:14:35.170 ⇒ 00:14:41.300 Emily Giant: I’m gonna pull it up in Dbt, we we it.
111 00:14:43.090 ⇒ 00:14:49.840 Emily Giant: I know there’s a separate model, and it’s part of that like hub and spoke situation.
112 00:14:49.960 ⇒ 00:14:56.389 Emily Giant: and oftentimes the Qa. Is done at the Hub.
113 00:14:57.030 ⇒ 00:14:58.340 Emily Giant: Not the spoke.
114 00:14:58.450 ⇒ 00:15:04.068 Emily Giant: but sometimes it’s done at the spoke. Sometimes it’s done part way through the week. So
115 00:15:05.220 ⇒ 00:15:07.839 Emily Giant: it’s really like a moving target of when
116 00:15:08.260 ⇒ 00:15:13.730 Emily Giant: Qa, when when the status can change from good to bad.
117 00:15:14.201 ⇒ 00:15:15.950 Emily Giant: But I think it’s just like
118 00:15:16.410 ⇒ 00:15:26.169 Emily Giant: solidifying that all bad units are recognized by status and not taken into consideration in the on hand count, and somewhere along the way.
119 00:15:26.360 ⇒ 00:15:30.820 Emily Giant: We didn’t account for that.
120 00:15:33.870 ⇒ 00:15:34.630 Emily Giant: Down
121 00:15:37.640 ⇒ 00:15:43.059 Emily Giant: okay and hub and spoke quantities.
122 00:15:45.690 ⇒ 00:15:47.329 Emily Giant: Yeah. So
123 00:15:50.570 ⇒ 00:15:54.039 Emily Giant: the quantity on hand, the 1st calculation is done in
124 00:15:54.190 ⇒ 00:15:58.030 Emily Giant: intermediate or in hub, and spoke quantities.
125 00:16:01.090 ⇒ 00:16:02.129 Demilade Agboola: Are you sharing your screen.
126 00:16:02.470 ⇒ 00:16:03.430 Emily Giant: Oh, no!
127 00:16:21.800 ⇒ 00:16:26.619 Emily Giant: So this is the good count.
128 00:16:29.970 ⇒ 00:16:37.189 Emily Giant: And then I tweaked this a little from the original to like attempt to remove the not good, but most of it is
129 00:16:37.380 ⇒ 00:16:42.509 Emily Giant: with 98.5% of it is your original code.
130 00:16:43.022 ⇒ 00:16:49.380 Emily Giant: Case one location number is 2 quantity on order
131 00:17:02.160 ⇒ 00:17:06.579 Emily Giant: case. When location number is not equal to 2, then coalesce inventory number location, quantity on hand.
132 00:17:06.770 ⇒ 00:17:08.000 Emily Giant: 0.
133 00:17:16.599 ⇒ 00:17:21.969 Emily Giant: So it’s inventory balance.
134 00:17:30.500 ⇒ 00:17:39.080 Emily Giant: Is it potentially getting partitioned out like the second row with the Qa. Number.
135 00:17:41.620 ⇒ 00:17:46.069 Demilade Agboola: Well, you have to play test updated at 20.
136 00:17:48.850 ⇒ 00:17:50.389 Emily Giant: Say that again. Sorry.
137 00:17:50.390 ⇒ 00:17:57.809 Demilade Agboola: We don’t. You have the latest updated at status like cause we’re ordering by the updated at New Row comes in.
138 00:17:57.930 ⇒ 00:17:58.970 Demilade Agboola: That has.
139 00:18:00.870 ⇒ 00:18:07.540 Emily Giant: And status. Okay, that looks good. So I mean.
140 00:18:09.990 ⇒ 00:18:17.090 Emily Giant: maybe it would help if I found an example of this, because it’s convoluted to like
141 00:18:17.250 ⇒ 00:18:19.390 Emily Giant: describe it without seeing it.
142 00:18:22.400 ⇒ 00:18:24.150 Emily Giant: Let me see if I have an old
143 00:18:24.430 ⇒ 00:18:27.259 Emily Giant: spreadsheet. I keep all of my like
144 00:18:27.700 ⇒ 00:18:31.830 Emily Giant: work that I’ve done during sprints and spreadsheets, so I can go back and look at it.
145 00:18:31.980 ⇒ 00:18:32.670 Emily Giant: Gotten.
146 00:18:34.120 ⇒ 00:18:35.579 Demilade Agboola: That must be very helpful.
147 00:18:36.768 ⇒ 00:18:41.849 Emily Giant: Once a month, you know, every now and then.
148 00:18:43.150 ⇒ 00:18:44.830 Emily Giant: Base revenue.
149 00:18:45.540 ⇒ 00:18:49.090 Emily Giant: Nope, not that one
150 00:18:52.480 ⇒ 00:18:55.890 Emily Giant: So the other afs issue is
151 00:19:00.650 ⇒ 00:19:12.009 Emily Giant: people. I don’t know if it’s that people aren’t removing the Presale care buffers, but when things are received in in a full rejection like we can’t sell any of them.
152 00:19:12.550 ⇒ 00:19:16.090 Emily Giant: The Presale care buffers are remaining on the lot.
153 00:19:16.540 ⇒ 00:19:19.359 Emily Giant: It’s like they never get properly received.
154 00:19:19.540 ⇒ 00:19:22.569 Emily Giant: and because that’s 1 of the like
155 00:19:22.770 ⇒ 00:19:26.659 Emily Giant: considered sellable. Here, let me
156 00:19:27.630 ⇒ 00:19:34.389 Emily Giant: one of the considered sellable units that pushes Afs into the negatives as well. So
157 00:19:36.090 ⇒ 00:19:38.849 Emily Giant: I guess it’s inventory fields.
158 00:19:40.490 ⇒ 00:19:50.569 Emily Giant: I don’t know if that’s what you would consider like a system issue versus something that we could
159 00:19:51.190 ⇒ 00:20:02.639 Emily Giant: like override with the logic. But for one reason or another, Netsuite’s not removing those Presale care buffers, and they’re subtracting them from 0. So that was a big influence. And
160 00:20:05.320 ⇒ 00:20:08.130 Emily Giant: in pushing Afs into the negatives during the holiday.
161 00:20:09.180 ⇒ 00:20:14.300 Emily Giant: And honestly, anytime we get a rejection in full.
162 00:20:22.270 ⇒ 00:20:24.870 Emily Giant: But those were it. It wasn’t as
163 00:20:25.710 ⇒ 00:20:33.270 Emily Giant: I thought there were more when I started off, but it’s the care buffers, and
164 00:20:39.490 ⇒ 00:20:42.540 Emily Giant: I have somewhere as long as I didn’t erase it.
165 00:20:42.850 ⇒ 00:20:45.339 Emily Giant: An entire sheet that is just
166 00:20:45.680 ⇒ 00:20:49.450 Emily Giant: afs. And the negative. I feel like I shared it with you at 1 point
167 00:20:49.640 ⇒ 00:20:52.090 Emily Giant: like back in the day, but
168 00:20:53.730 ⇒ 00:20:55.410 Emily Giant: now I don’t know where it lives.
169 00:20:57.090 ⇒ 00:21:06.806 Emily Giant: but it had like a hundred rows, and each one was like, this is a presale or a Presale care buffer problem. This is the duplicate on hand number problem.
170 00:21:07.430 ⇒ 00:21:13.100 Emily Giant: I’ll find it. I don’t wanna waste your time right now looking for it. But it does, hey?
171 00:21:13.730 ⇒ 00:21:17.630 Demilade Agboola: I kind of have. I have a faint recollection of that.
172 00:21:17.930 ⇒ 00:21:18.660 Emily Giant: Yeah.
173 00:21:23.950 ⇒ 00:21:27.208 Emily Giant: I really did burn some toast. It’s like very smoky in here.
174 00:21:29.460 ⇒ 00:21:30.990 Emily Giant: Might be in this one.
175 00:21:38.340 ⇒ 00:21:42.139 Emily Giant: Okay, missing skew negative. Afs, bada bing! Bada boom!
176 00:21:42.520 ⇒ 00:21:43.480 Emily Giant: All right.
177 00:21:46.520 ⇒ 00:21:48.339 Emily Giant: let me reshare this with you.
178 00:22:03.240 ⇒ 00:22:07.550 Emily Giant: All right, I’ll save my bed.
179 00:22:08.290 ⇒ 00:22:10.269 Emily Giant: A good example of what I’m talking about.
180 00:22:16.500 ⇒ 00:22:19.989 Emily Giant: so we’re looking for one that has, like a quantity received with Qa
181 00:22:20.390 ⇒ 00:22:25.260 Emily Giant: quantity to receive. Okay, so line 7, there’s a bunch.
182 00:22:53.100 ⇒ 00:22:53.680 Emily Giant: Hmm.
183 00:23:02.170 ⇒ 00:23:07.029 Emily Giant: I’m gonna pull a current record of this and see that if this ever like self corrected in any way.
184 00:24:14.130 ⇒ 00:24:16.820 Emily Giant: all right, Felipe, it’s gonna be here in like 10 min.
185 00:24:16.820 ⇒ 00:24:17.630 Demilade Agboola: Okay.
186 00:24:19.130 ⇒ 00:24:24.030 Emily Giant: And in the meantime I need your query from yesterday.
187 00:24:28.570 ⇒ 00:24:33.180 Demilade Agboola: Or query for message. I mean, it’s live so you could just go directly to the.
188 00:24:33.590 ⇒ 00:24:35.669 Emily Giant: Oh, that’s right. The.
189 00:24:47.550 ⇒ 00:24:54.280 Demilade Agboola: But if you want to see all the like on non-committed stuff, you would need to go to the aggregate table or the email.
190 00:24:54.280 ⇒ 00:24:55.140 Emily Giant: Oh, yeah.
191 00:24:55.140 ⇒ 00:24:56.210 Demilade Agboola: Spend tables.
192 00:25:00.700 ⇒ 00:25:04.290 Demilade Agboola: But yeah, the data is, then it’s already fit in the inventory tables.
193 00:25:08.190 ⇒ 00:25:09.800 Emily Giant: This call oops?
194 00:25:11.050 ⇒ 00:25:12.749 Emily Giant: Is it the into ag.
195 00:25:12.930 ⇒ 00:25:14.980 Demilade Agboola: Yes, int ag adjustment apps.
196 00:25:24.640 ⇒ 00:25:27.059 Demilade Agboola: but it’s inventory number. There’s no
197 00:25:45.000 ⇒ 00:25:45.810 Demilade Agboola: hmm.
198 00:25:51.690 ⇒ 00:25:53.060 Demilade Agboola: That’s fascinating.
199 00:25:53.440 ⇒ 00:25:54.986 Emily Giant: Okay, what?
200 00:25:56.670 ⇒ 00:25:59.640 Emily Giant: Let’s try this again. Did I pull the wrong number?
201 00:26:14.850 ⇒ 00:26:15.530 Emily Giant: He’s.
202 00:26:25.190 ⇒ 00:26:27.289 Demilade Agboola: I think he puts it in court.
203 00:26:30.270 ⇒ 00:26:31.770 Emily Giant: Could be that.
204 00:26:41.210 ⇒ 00:26:45.680 Emily Giant: Is it an incremental model that may just weirdly have not.
205 00:26:47.740 ⇒ 00:26:49.130 Demilade Agboola: No, it should be fine.
206 00:26:49.815 ⇒ 00:26:51.870 Emily Giant: Always run it.
207 00:27:06.840 ⇒ 00:27:07.855 Emily Giant: Okay.
208 00:27:11.620 ⇒ 00:27:12.739 Demilade Agboola: Trust him.
209 00:27:16.820 ⇒ 00:27:22.550 Emily Giant: And this is also like an old version, isn’t it? This is like, not take. I need to run it in mine
210 00:27:22.880 ⇒ 00:27:25.150 Emily Giant: in in this because it’s that was like
211 00:27:25.900 ⇒ 00:27:28.519 Emily Giant: a 2 weeks ago version of that.
212 00:27:29.370 ⇒ 00:27:35.850 Demilade Agboola: Yeah. Just wondering why that version like why it’s vanished so.
213 00:27:46.840 ⇒ 00:27:53.285 Emily Giant: Okay, this is so organized that it’s definitely the one that you wrote. So let me just.
214 00:27:54.400 ⇒ 00:27:55.370 Demilade Agboola: Or.
215 00:28:00.290 ⇒ 00:28:01.990 Emily Giant: I think I just need to run it.
216 00:28:09.910 ⇒ 00:28:11.853 Emily Giant: Is it because it’s
217 00:28:12.340 ⇒ 00:28:18.129 Demilade Agboola: Oh, my bad! I I was testing with the where clause and I pushed the where close production that makes.
218 00:28:18.660 ⇒ 00:28:25.983 Emily Giant: Yeah, that makes sense. I was like, Oh, okay, best case scenario, right? Like.
219 00:28:27.890 ⇒ 00:28:31.750 Demilade Agboola: Yeah, usually I test it there and then I take it out. But for some reason.
220 00:28:31.750 ⇒ 00:28:32.900 Emily Giant: Oh, my! Gosh!
221 00:28:32.900 ⇒ 00:28:34.140 Demilade Agboola: To do that this time.
222 00:28:34.980 ⇒ 00:28:41.630 Emily Giant: It’s fine. Do you? Wanna do you want me to remove it? I don’t know what else is in this branch, so.
223 00:28:41.630 ⇒ 00:28:44.320 Demilade Agboola: That’s fine. I’m literally pushing that right now.
224 00:28:48.190 ⇒ 00:28:55.099 Emily Giant: I need 2 min to go put hot water on. It’s gonna be a big coffee day, big coffee day.
225 00:28:56.410 ⇒ 00:28:57.979 Emily Giant: I’ll be right back.
226 00:28:58.750 ⇒ 00:28:59.540 Demilade Agboola: Okay.
227 00:30:01.360 ⇒ 00:30:03.050 Emily Giant: Okay.
228 00:31:29.000 ⇒ 00:31:30.699 Emily Giant: what are you? I’m kidding. Oh.
229 00:32:08.031 ⇒ 00:32:13.010 Demilade Agboola: So I just pushed the model on. I’m running the inventory models again right now.
230 00:32:13.010 ⇒ 00:32:14.220 Emily Giant: Okay.
231 00:32:15.160 ⇒ 00:32:19.009 Demilade Agboola: So that takes about 5 min. So.
232 00:32:19.200 ⇒ 00:32:23.970 Emily Giant: Okay, well, I can find some other good examples on here.
233 00:32:24.663 ⇒ 00:32:27.556 Emily Giant: Of the Afs issue. I also added
234 00:32:28.110 ⇒ 00:32:43.750 Emily Giant: the link to the spreadsheet in the Figma file, and to our working session spreadsheet that I use all the time so that you don’t have to like chase down examples if you need them in that crusty sprint. 1 30 document.
235 00:32:45.770 ⇒ 00:32:46.160 Demilade Agboola: Yeah.
236 00:32:46.160 ⇒ 00:32:48.460 Emily Giant: Okay, so.
237 00:32:49.820 ⇒ 00:32:56.790 Demilade Agboola: I also need to like either re-watch this, or just kind of look at the some things are not just like sticking in my head
238 00:32:57.786 ⇒ 00:33:05.570 Demilade Agboola: about like this. Use case, or like this case, where, like the the quantity changes
239 00:33:06.821 ⇒ 00:33:10.910 Demilade Agboola: explanation, it’s just like there’s sometimes some things just don’t stick.
240 00:33:11.320 ⇒ 00:33:12.950 Demilade Agboola: And I’m trying to figure out like
241 00:33:15.680 ⇒ 00:33:21.910 Demilade Agboola: what that flow is, and that would also enable me to figure out like what we should be looking out for, to account
242 00:33:22.550 ⇒ 00:33:24.139 Demilade Agboola: for that scenario.
243 00:33:25.410 ⇒ 00:33:31.089 Emily Giant: Yeah. Let me add a dickie on here.
244 00:33:34.650 ⇒ 00:33:40.859 Emily Giant: So quantity on order, quantity on hand. The current. Dvg, logic is incorrectly registered items that received
245 00:33:41.390 ⇒ 00:33:45.890 Emily Giant: but are unsellable as part of available inventory. Okay, so this is.
246 00:34:01.020 ⇒ 00:34:03.329 Emily Giant: I’m gonna put like examples in these.
247 00:34:17.870 ⇒ 00:34:19.929 Emily Giant: Don’t sorry I,
248 00:34:22.080 ⇒ 00:34:30.889 Emily Giant: our outdoor cat is inside right now, for for no reason. But he’s looking at our indoor cats cat tree like he wants to do something bad to it, and
249 00:34:31.739 ⇒ 00:34:33.000 Emily Giant: he knows better.
250 00:34:35.870 ⇒ 00:34:37.040 Demilade Agboola: Does that happen often.
251 00:34:38.244 ⇒ 00:34:40.140 Emily Giant: He. No, he doesn’t.
252 00:34:40.650 ⇒ 00:34:46.569 Emily Giant: He’s usually a pretty good boy. Looks like a bulldog. He’s really cute.
253 00:34:49.125 ⇒ 00:34:51.679 Emily Giant: He’s got this like orange nose.
254 00:34:52.770 ⇒ 00:34:54.130 Demilade Agboola: Oh, that’s cute!
255 00:34:54.449 ⇒ 00:35:02.989 Emily Giant: Isn’t he cute? But he looks like a bulldog. He just sleeps on our porch, and he has for 9 months like he’s just not left our porch, so
256 00:35:03.109 ⇒ 00:35:08.229 Emily Giant: every now and then we’re like you can come and nap inside. You’re a good boy.
257 00:35:08.639 ⇒ 00:35:11.129 Emily Giant: but the only thing he’ll like
258 00:35:11.249 ⇒ 00:35:13.709 Emily Giant: do bad things, too, which is like
259 00:35:14.179 ⇒ 00:35:19.819 Emily Giant: we got. We got him neutered so I don’t know if he does it anymore, but he would pee on her toys
260 00:35:19.939 ⇒ 00:35:27.929 Emily Giant: like once in a blue moon, I’d be like, what is that smell? And it’s only on her toys, and he’s just like that’s mine.
261 00:35:28.239 ⇒ 00:35:32.659 Emily Giant: so mean like such a like a little brother thing to do.
262 00:35:32.919 ⇒ 00:35:34.139 Emily Giant: Rude?
263 00:35:34.269 ⇒ 00:35:43.179 Emily Giant: Alright, let me okay. These these are like the money shot ones, where, like some were received good
264 00:35:43.379 ⇒ 00:35:45.659 Emily Giant: and some weren’t like
265 00:35:45.909 ⇒ 00:35:51.059 Emily Giant: the ones that are fully rejected aren’t as big of a problem. Those are just like the Presale problem.
266 00:35:51.229 ⇒ 00:35:52.179 Emily Giant: But
267 00:35:53.439 ⇒ 00:35:58.979 Emily Giant: I definitely need to clean up this flow chart because I think the dev is gonna need it also to eventually, like
268 00:35:59.089 ⇒ 00:36:01.029 Emily Giant: fix some of the source issues.
269 00:36:02.120 ⇒ 00:36:02.850 Demilade Agboola: Yeah.
270 00:36:03.250 ⇒ 00:36:11.200 Emily Giant: And I know it’s a little bit. It’s even confusing for me when I read it. I tried to get like Perry and Jesse and Felipe to like
271 00:36:12.010 ⇒ 00:36:21.889 Emily Giant: Do Qa. And they’re they’re really busy. And they were like, I don’t know. Yeah, it makes sense. I’m like, I don’t think it does make sense. I think it needs to be better. But
272 00:36:22.030 ⇒ 00:36:27.380 Emily Giant: okay, so let’s call this the
273 00:36:36.940 ⇒ 00:36:41.040 Emily Giant: QA.
274 00:36:42.590 ⇒ 00:36:44.090 Emily Giant: During receiving.
275 00:36:59.390 ⇒ 00:37:01.510 Emily Giant: And stakeholders
276 00:37:05.110 ⇒ 00:37:07.710 Emily Giant: see operations team.
277 00:37:09.270 ⇒ 00:37:13.719 Emily Giant: And this is part of the logic that does it.
278 00:37:29.420 ⇒ 00:37:34.500 Emily Giant: Maybe this part is confusing. If I write like int
279 00:38:46.440 ⇒ 00:38:50.020 Emily Giant: maybe if I put like a sticky and explain, or like.
280 00:38:50.780 ⇒ 00:38:57.080 Emily Giant: I’ll put the examples on a sticky and explain, like what physically happened during these.
281 00:38:57.810 ⇒ 00:39:00.679 Emily Giant: It will make this all more clear.
282 00:39:02.510 ⇒ 00:39:03.400 Emily Giant: Maybe
283 00:39:54.580 ⇒ 00:40:00.319 Emily Giant: this is also not a great explanation. For this particular problem.
284 00:40:00.942 ⇒ 00:40:02.450 Emily Giant: It’s more like.
285 00:40:10.300 ⇒ 00:40:15.860 Emily Giant: So if you, if we work our way like backward from the negative. Afs.
286 00:40:27.660 ⇒ 00:40:30.490 Emily Giant: It’s saying there are 28 on hand.
287 00:40:35.760 ⇒ 00:40:38.870 Emily Giant: but what’s on hand is a combination of
288 00:40:39.120 ⇒ 00:40:42.300 Emily Giant: what was received good and what was received bad.
289 00:40:42.730 ⇒ 00:40:47.960 Emily Giant: So syllable quantity received
290 00:40:48.410 ⇒ 00:40:56.719 Emily Giant: because sellable quantity received is calculated as the on hand, and so is Afs. It’s continually counting
291 00:41:00.620 ⇒ 00:41:03.320 Emily Giant: unit. So why does that make it negative.
292 00:41:03.630 ⇒ 00:41:11.258 Emily Giant: That’s what’s confusing. Because you would think that it would not make it negative, because there’s more units available.
293 00:41:14.530 ⇒ 00:41:17.900 Emily Giant: so 28 on hand.
294 00:41:25.580 ⇒ 00:41:27.799 Emily Giant: But really, there’s only 14.
295 00:41:28.510 ⇒ 00:41:31.260 Emily Giant: So why is it negative? 3.
296 00:41:36.700 ⇒ 00:41:37.290 Demilade Agboola: So.
297 00:41:38.640 ⇒ 00:41:40.170 Emily Giant: So it’s quantity on order.
298 00:41:40.510 ⇒ 00:41:41.809 Emily Giant: This quantity on hand.
299 00:41:42.100 ⇒ 00:41:43.049 Demilade Agboola: Yeah. Mine. It.
300 00:41:43.190 ⇒ 00:41:49.659 Emily Giant: Resale committed on hand committed, and then the buffers.
301 00:41:50.810 ⇒ 00:41:54.129 Demilade Agboola: And how, how, how much are each of those right now, like.
302 00:41:54.560 ⇒ 00:41:57.030 Emily Giant: Yeah. Good. Good question.
303 00:41:59.140 ⇒ 00:42:03.220 Emily Giant: No care. Buffer, no hold. Buffer
304 00:42:12.040 ⇒ 00:42:16.880 Emily Giant: 28 on hand, 12 sold.
305 00:42:19.900 ⇒ 00:42:21.459 Emily Giant: 3 on hand committed.
306 00:42:29.170 ⇒ 00:42:33.700 Emily Giant: All right. I’m gonna plunk these numbers in 2.
307 00:42:35.070 ⇒ 00:42:41.020 Emily Giant: This equation so it would be
308 00:42:46.760 ⇒ 00:42:51.330 Emily Giant: quantity on order is what.
309 00:42:52.950 ⇒ 00:42:55.120 Demilade Agboola: Doing 28, always.
310 00:42:55.120 ⇒ 00:43:02.510 Emily Giant: Okay, wait. Is there, is it? 28? It should be 0.
311 00:43:04.750 ⇒ 00:43:08.119 Demilade Agboola: I was like no new problem.
312 00:43:10.450 ⇒ 00:43:14.050 Emily Giant: So probably that order should be 0. But let me just make sure.
313 00:43:22.840 ⇒ 00:43:26.219 Emily Giant: 0 plus 28
314 00:43:29.270 ⇒ 00:43:30.330 Emily Giant: minus
315 00:43:33.800 ⇒ 00:43:51.770 Emily Giant: presale committed, which is 0 plus on hand, committed just 3 plus quantity care buffer
316 00:43:58.630 ⇒ 00:44:00.239 Emily Giant: plus hold buffer.
317 00:44:03.300 ⇒ 00:44:10.670 Emily Giant: Am I crazy? Does this make any sense at all? It’s 0 plus 28 minus 3.
318 00:44:11.590 ⇒ 00:44:12.760 Demilade Agboola: 25.
319 00:44:16.970 ⇒ 00:44:23.580 Emily Giant: So quantity used. But why? Why is this happening? Why would it say 26.
320 00:44:26.400 ⇒ 00:44:27.080 Demilade Agboola: Wait.
321 00:44:28.560 ⇒ 00:44:33.600 Demilade Agboola: But why is Afs negative? If we’re subtracting 28, minus 3.
322 00:44:34.360 ⇒ 00:44:36.290 Emily Giant: It doesn’t make any sense.
323 00:44:40.810 ⇒ 00:44:43.930 Demilade Agboola: Is, that is, that up to date is that the latest.
324 00:44:44.200 ⇒ 00:44:50.040 Emily Giant: It can’t be. This has. This has to be like a system problem. Let me run this in.
325 00:45:06.860 ⇒ 00:45:09.190 Emily Giant: probably should have put it in quotes, Okay.
326 00:45:19.380 ⇒ 00:45:22.270 Emily Giant: oh, hey, how’s it going.
327 00:45:22.270 ⇒ 00:45:24.249 felipefaria: Hey, Emily, good! How are you?
328 00:45:24.740 ⇒ 00:45:30.575 Emily Giant: Good. Okay, let me make sure you have the meeting link for tomorrow. Demo lotto
329 00:45:31.160 ⇒ 00:45:36.929 Emily Giant: I invited him, but I think because it was through the Brainforge account. It didn’t go through.
330 00:45:37.030 ⇒ 00:45:43.700 Emily Giant: I should have. I don’t know why I didn’t validate with you, Felipe. I thought I sent it so many different ways that I was like. There’s no way.
331 00:45:43.930 ⇒ 00:45:46.430 felipefaria: It didn’t come through.
332 00:45:46.640 ⇒ 00:45:47.360 Emily Giant: I’m so sorry.
333 00:45:47.360 ⇒ 00:45:49.099 felipefaria: I don’t know why. No, no! Worries.
334 00:45:49.470 ⇒ 00:45:55.679 Emily Giant: You you missed just some angst about afs that’s what you’ve missed this morning. But we do have
335 00:45:56.400 ⇒ 00:46:00.070 Emily Giant: a question for you about what available for sale.
336 00:46:00.420 ⇒ 00:46:03.650 Emily Giant: Okay? So to back it up, we’re looking at.
337 00:46:04.960 ⇒ 00:46:09.720 Emily Giant: there are a lot of like instances where Afs is going into the negative.
338 00:46:10.323 ⇒ 00:46:21.849 Emily Giant: Sometimes it’s true, sometimes it’s not true. And we’re looking at is like what we can control from the data perspective. And that is
339 00:46:22.140 ⇒ 00:46:27.020 Emily Giant: what we were chatting through yesterday a little bit, which was when
340 00:46:27.440 ⇒ 00:46:36.639 Emily Giant: we’re receiving things as Qa before it hits the facility. Sometimes care. Buffers stay on the lot and then are subtracted out. Or it’s saying, like.
341 00:46:37.550 ⇒ 00:46:42.554 Emily Giant: it’s subtracting an amount. This is this is the equation. It’s
342 00:46:43.730 ⇒ 00:46:58.119 Emily Giant: the quantity on order, plus the quantity on hand. We split it like that because of the hub and spoke logic like, we need to account for things that are like at the Hub, but also have, like hit Manhattan. If it’s a partial shipment, 99% of the time. This is fine. The only time it
343 00:46:58.290 ⇒ 00:47:06.129 Emily Giant: is a problem is when netsuite lags which we saw over mother’s day. And that’s like what you’ll see
344 00:47:07.190 ⇒ 00:47:09.320 Emily Giant: when on hand
345 00:47:10.250 ⇒ 00:47:32.852 Emily Giant: and like. Let me share this working thing with you. You don’t have to open it up at the moment, but when quantity on order and quantity on hand are the same, it’s usually a system like source problem that we can’t really do anything about. But we are like pushing those instances to the Dev team because they can fix it on their end.
346 00:47:33.730 ⇒ 00:47:35.247 Emily Giant: Looking at is
347 00:47:37.000 ⇒ 00:47:40.869 Emily Giant: There’s some issues with like things received, Qa.
348 00:47:41.410 ⇒ 00:47:47.570 Emily Giant: Popping into the negatives. And so we were just taking an example and trying to figure out
349 00:47:47.680 ⇒ 00:47:55.740 Emily Giant: if a, the examples that we were using were up to date, because we haven’t seen those negative Afs instances as much lately.
350 00:47:55.740 ⇒ 00:48:17.049 felipefaria: Yeah, yeah, this is what I was gonna say would be because there’s like different causes for the Afs. I think we would have to go like, find the examples and dig through it and try to find like, what is the issue with that one, and then resolve it so, and then eliminating kinda like one issue by one issue, right? Because honestly.
351 00:48:17.090 ⇒ 00:48:38.149 felipefaria: the the system itself has changed throughout like the months in the years. So I don’t really understand sometimes how things interact with each other like the care buffer, for example, right? Which we didn’t use to to have or use. And now we do and like, I’m sure that there’s little like
352 00:48:39.000 ⇒ 00:48:41.660 felipefaria: interactions or integrations that
353 00:48:42.170 ⇒ 00:48:57.571 felipefaria: are not fully how we want it to be so. And and I was taking a look this morning. I didn’t see any negative afs as of right now in the looker reports. I did see one yesterday, though.
354 00:48:58.030 ⇒ 00:49:00.850 felipefaria: but it was just like a negative one
355 00:49:01.650 ⇒ 00:49:05.670 felipefaria: in in Manhattan for the Nantucket.
356 00:49:06.450 ⇒ 00:49:11.718 felipefaria: But this seems to be gone.
357 00:49:12.240 ⇒ 00:49:16.030 Emily Giant: Yeah, they seem to self correct at this point, which it means
358 00:49:16.160 ⇒ 00:49:22.194 Emily Giant: that it’s a netsuite lag, a lot of the time. It’s that like they’re they’ve pushed receiving. And
359 00:49:22.760 ⇒ 00:49:37.690 Emily Giant: the Tdlr is that the system is slow. So sometimes receiving and on hand will duplicate the quantity here. Yeah. Yeah. And then it’s like
360 00:49:37.970 ⇒ 00:49:43.749 Emily Giant: showing too many items are committed. It’s showing the presale commitments and adding it to the on hand committed.
361 00:49:44.030 ⇒ 00:49:44.620 felipefaria: And.
362 00:49:44.620 ⇒ 00:49:49.490 Emily Giant: Tables reconcile, and it’s like, Oh, whoops! These aren’t pre-sales anymore. They’re on hand.
363 00:49:49.810 ⇒ 00:49:53.970 felipefaria: How long does it take, do you know, like more or less for the system to do this? Update.
364 00:49:54.130 ⇒ 00:50:01.420 Emily Giant: So during mother’s day up to 8 h. So that was a problem. Yeah. So they.
365 00:50:01.420 ⇒ 00:50:01.900 felipefaria: Yeah.
366 00:50:01.970 ⇒ 00:50:04.510 Emily Giant: I changed the concurrency
367 00:50:04.670 ⇒ 00:50:10.760 Emily Giant: to run the script to every like. I’ll have to check with Alex to make sure, but I think they changed it
368 00:50:11.260 ⇒ 00:50:12.929 Emily Giant: to run like every 5
369 00:50:13.170 ⇒ 00:50:28.310 Emily Giant: minutes instead of like every 30 or something like that, because they didn’t realize how big of a problem it was. But like we kept seeing the negatives after mother’s day, and I was like, y’all, I can’t do anything about this like so working on that.
370 00:50:28.650 ⇒ 00:50:36.570 Emily Giant: But what Denver and I were trying to make sure is no longer an issue. Is qa units
371 00:50:38.530 ⇒ 00:50:47.650 Emily Giant: They tend to be represented in like the on-hand quantity, and that is sometimes making afs look like
372 00:50:47.780 ⇒ 00:50:53.041 Emily Giant: more, and sometimes it’s pushing it into the negatives. But either way, it’s like not real
373 00:50:53.480 ⇒ 00:50:57.219 Emily Giant: to to back it up to the question that we definitely need you to answer.
374 00:50:57.360 ⇒ 00:50:58.829 Emily Giant: and we could talk through it.
375 00:50:59.570 ⇒ 00:51:06.620 Emily Giant: So there is like we talked about the other day. There is the real quantity
376 00:51:06.780 ⇒ 00:51:17.860 Emily Giant: of units that were sent, and then there’s the committed quantity. What we use to calculate available for sale
377 00:51:18.440 ⇒ 00:51:23.858 Emily Giant: matters when it comes to committed versus like sent out the door.
378 00:51:25.220 ⇒ 00:51:29.760 Emily Giant: demo latte, like the only thing that seems to be out of
379 00:51:29.940 ⇒ 00:51:37.049 Emily Giant: sync with netsuite right now is canceled orders. So we’re just we’re gonna like work through that today. However.
380 00:51:37.340 ⇒ 00:51:43.659 Emily Giant: do you want afs to be calculated using
381 00:51:44.680 ⇒ 00:51:47.870 Emily Giant: what is committed on the lot
382 00:51:48.870 ⇒ 00:51:57.439 Emily Giant: or the actual amount of units associated with being sent out. The door on that lot, whether they were committed or not.
383 00:52:02.010 ⇒ 00:52:12.820 felipefaria: So obviously, we want the Fs to be as accurate as possible. Right? So if there are instances
384 00:52:13.070 ⇒ 00:52:28.939 felipefaria: where more units shipped than what is committed, and it seems like we have those instances right like that. Not necessarily everything. And and I would say we should account for those units that for some reason are not
385 00:52:29.310 ⇒ 00:52:35.980 felipefaria: committed to the lot, but if we know that they shipped out, and we don’t have that quantity available.
386 00:52:36.160 ⇒ 00:52:36.780 Emily Giant: Hmm.
387 00:52:37.430 ⇒ 00:52:45.040 felipefaria: I think, like we would want to have that reflected. The question now is like, why are those units not committed right.
388 00:52:45.580 ⇒ 00:52:52.478 Emily Giant: Yes, and I’m getting really close to narrowing down like every case in the data where
389 00:52:53.590 ⇒ 00:52:58.890 Emily Giant: where they’re not correctly committed. So we’ll have like a very
390 00:52:59.620 ⇒ 00:53:04.000 Emily Giant: good historical snapshot of that. But we’re
391 00:53:04.210 ⇒ 00:53:11.359 Emily Giant: we’re kind of trying to like push this foundational table this week and and work back with some of those fringe case things.
392 00:53:11.921 ⇒ 00:53:20.308 Emily Giant: Okay. So this was a lot that back when this was a problem, when we were seeing a lot of negative afs,
393 00:53:21.570 ⇒ 00:53:22.930 Emily Giant: we’re just checking to see
394 00:53:22.930 ⇒ 00:53:28.579 Emily Giant: if the new logic that’s been implemented over time has corrected for this negative. Afs
395 00:53:30.240 ⇒ 00:53:31.660 Emily Giant: and it looks like.
396 00:53:33.530 ⇒ 00:53:36.640 felipefaria: Total Sales, Total Delivery.
397 00:53:37.750 ⇒ 00:53:42.322 Emily Giant: Well, we only ever receive 14, I think so.
398 00:53:43.330 ⇒ 00:53:44.880 felipefaria: And we saw 23.
399 00:53:46.680 ⇒ 00:53:48.999 Emily Giant: I’m gonna pull this up in netsuite, too. Hold on
400 00:53:59.590 ⇒ 00:54:01.149 Emily Giant: here, let me send the
401 00:54:05.880 ⇒ 00:54:07.190 Emily Giant: and 6 down to 6.
402 00:54:11.280 ⇒ 00:54:16.969 Emily Giant: Here’s the lot. I’m gonna send it in the chat, so we can all do our sherlocking.
403 00:54:18.100 ⇒ 00:54:18.910 felipefaria: What that.
404 00:54:31.920 ⇒ 00:54:33.440 Emily Giant: Total quantity.
405 00:54:33.560 ⇒ 00:54:37.980 Emily Giant: 23 redelivery sales committed.
406 00:54:40.800 ⇒ 00:54:44.740 Emily Giant: Well done! A lot of yours looks beautiful. It all makes sense.
407 00:54:45.213 ⇒ 00:54:48.490 Emily Giant: I guess it means we’ve come a long way from that original.
408 00:54:49.330 ⇒ 00:54:53.600 Emily Giant: Qa. But let’s see.
409 00:55:02.260 ⇒ 00:55:10.809 Demilade Agboola: Also, we’ve been able to. I mean, we’ve been able to split it by committed and uncommitted. And so now you also have total quantity, which is the sum
410 00:55:11.100 ⇒ 00:55:13.360 Demilade Agboola: of both committee, and that’s it.
411 00:55:14.200 ⇒ 00:55:15.480 Emily Giant: Yeah, that’s
412 00:55:20.070 ⇒ 00:55:21.940 Emily Giant: Demo Lade.
413 00:55:22.900 ⇒ 00:55:24.310 Emily Giant: It looks like you did.
414 00:55:25.100 ⇒ 00:55:26.580 Emily Giant: Yeah, you changed
415 00:55:27.040 ⇒ 00:55:33.500 Emily Giant: what they’re called, okay, do you want to review like what these columns are with Felipe.
416 00:55:33.948 ⇒ 00:55:35.980 Emily Giant: To see if there’s any like
417 00:55:37.320 ⇒ 00:55:42.820 Emily Giant: feedback on naming conventions like what they represent, etc.
418 00:55:42.820 ⇒ 00:55:46.900 Demilade Agboola: Yeah. So I could quickly run by run that by him.
419 00:55:47.170 ⇒ 00:55:53.069 Emily Giant: Yeah. And I’ll keep doing Qa on a couple of these negative afs slots while you guys go over that like that.
420 00:55:53.940 ⇒ 00:55:59.080 felipefaria: And for this lot they sent on the chat. It seems we received 48 units right? So.
421 00:55:59.260 ⇒ 00:56:00.500 Emily Giant: We were supposed to.
422 00:56:01.420 ⇒ 00:56:02.290 felipefaria: Yeah.
423 00:56:02.290 ⇒ 00:56:03.830 Emily Giant: We only received.
424 00:56:05.650 ⇒ 00:56:08.100 felipefaria: Oh, let me see, on the receive side
425 00:56:11.350 ⇒ 00:56:13.980 felipefaria: could have had some qa units here.
426 00:56:14.170 ⇒ 00:56:15.210 felipefaria: Yep.
427 00:56:16.050 ⇒ 00:56:17.200 Emily Giant: Only 4.
428 00:56:17.200 ⇒ 00:56:24.180 felipefaria: Oh, yeah, no. Well, I I see 27 Qa. In netsuite.
429 00:56:24.180 ⇒ 00:56:24.860 Emily Giant: Oh, sorry!
430 00:56:24.860 ⇒ 00:56:25.650 felipefaria: And then.
431 00:56:26.080 ⇒ 00:56:29.890 felipefaria: And then 2121 good
432 00:56:31.741 ⇒ 00:56:35.599 felipefaria: and then it says, we have 23 total sales there, right.
433 00:56:37.020 ⇒ 00:56:41.900 felipefaria: Which is this? Mother’s day? Lots? No, it all are.
434 00:56:43.510 ⇒ 00:56:50.680 Emily Giant: Or most of them are. Some of them are further in the past. But yeah.
435 00:56:51.200 ⇒ 00:56:52.100 felipefaria: Let me see.
436 00:56:52.940 ⇒ 00:56:54.550 Emily Giant: Sellable quantity, receipt.
437 00:56:56.300 ⇒ 00:56:59.329 felipefaria: Well, this one is from week 24.
438 00:56:59.540 ⇒ 00:57:02.260 Emily Giant: A lot that you just sent. So it’s.
439 00:57:02.420 ⇒ 00:57:05.410 felipefaria: Fairly recent 1st week of spring.
440 00:57:07.660 ⇒ 00:57:14.040 felipefaria: Yeah. I wonder why there was 23 sales versus 21 good. Here.
441 00:57:14.630 ⇒ 00:57:15.310 Emily Giant: Yeah.
442 00:57:15.610 ⇒ 00:57:19.939 felipefaria: Because the thing with the with the Qa units is something
443 00:57:20.950 ⇒ 00:57:32.260 felipefaria: is verifying. The netsuite is correct, is correctly decrementing. That quantity from from dash right at the point of receiving when we do those Qas
444 00:57:33.012 ⇒ 00:57:41.480 felipefaria: just making sure, because ideally, how the system would work. And I know that there’s a lot of instances that that doesn’t happen is
445 00:57:41.660 ⇒ 00:57:45.260 felipefaria: regardless of how many units we have committed in the lot.
446 00:57:45.480 ⇒ 00:57:47.170 felipefaria: If we’ve only received.
447 00:57:47.510 ⇒ 00:58:01.599 felipefaria: like, you know, a certain amount of good units, and it’s less than the committed. We would expect the system to kick out any additional orders to exception, right and for info care to to take care of.
448 00:58:03.390 ⇒ 00:58:25.110 felipefaria: I know that that not always work, and we know for a fact that when it’s a full rejection that doesn’t work. But in I’ve seen instances where, even if it’s not a full rejection that doesn’t work. So what ends up happening is the team has to communicate with care that, hey? We only have 21 units good.
449 00:58:25.640 ⇒ 00:58:31.999 felipefaria: but we have, like, you know, 40 and 40 orders in this. In this slot.
450 00:58:32.180 ⇒ 00:58:41.079 felipefaria: as care move those orders out right? Depending on on kind of like variety of factors, they might
451 00:58:41.780 ⇒ 00:58:47.059 felipefaria: by some mistake or something, instead of moving like, like, let’s say, you know, 20
452 00:58:47.530 ⇒ 00:58:59.222 felipefaria: 25 units. They they actually move 23 for some reason. And then there’s like 2 lingering ones there and then. The team will essentially just
453 00:58:59.980 ⇒ 00:59:11.489 felipefaria: fulfill those units potentially with bouquets from a different lot, right? And then we might end up with kind of like more units sold than available in one lot. But that
454 00:59:11.670 ⇒ 00:59:16.309 felipefaria: probably compensates in a different lot, where we might have
455 00:59:16.590 ⇒ 00:59:26.320 felipefaria: then a shortage that gets adjusted via an Iia, or something like that. Right? So this is one of the the instances, and I think that if we really
456 00:59:26.430 ⇒ 00:59:38.820 felipefaria: narrow into, like the Qa. Process, working properly every time I think you will, it will probably help solve a lot of these issues, cause I don’t see any other
457 00:59:39.740 ⇒ 00:59:42.540 felipefaria: like real reason why we would have
458 00:59:42.820 ⇒ 00:59:45.999 felipefaria: these situations if it’s not for the
459 00:59:46.360 ⇒ 00:59:53.999 felipefaria: for these variances on good versus Qa. Units. I think that this might be probably the the main driven
460 00:59:54.770 ⇒ 00:59:56.440 felipefaria: and driven factor here.
461 00:59:57.230 ⇒ 01:00:02.230 Emily Giant: So we okay, I that makes total sense to me. So we think this is
462 01:00:02.390 ⇒ 01:00:05.429 Emily Giant: potentially like a process problem. If I were to sum it up.
463 01:00:06.317 ⇒ 01:00:28.369 felipefaria: Yeah. Yeah. Well, in a system, it it would be a a system problem more than a process problem. Right? Because if we if we are all in agreement of how Netsuite should work with Qa units, and we know that that is not working properly, then, I think, is a system issue where dive needs to ensure that
464 01:00:29.190 ⇒ 01:00:38.640 felipefaria: whatever the good units are on, the Ir is what the on hand gets updated to
465 01:00:39.840 ⇒ 01:00:52.420 felipefaria: and well did. And now, with the care, I guess it would be good units plus care units right? But in any case, just making sure that the Qa units are deducted
466 01:00:52.880 ⇒ 01:00:58.480 felipefaria: from the system, and all the orders that we don’t have units for
467 01:00:58.770 ⇒ 01:01:10.639 felipefaria: gets kicked out of that lot right? And and because once we rely in a manual process from care. Then it opens the room, and for some issues to to happen essentially
468 01:01:12.037 ⇒ 01:01:16.429 felipefaria: and and I’ll and I’ll pay closer attention. I’ll make a note here.
469 01:01:16.580 ⇒ 01:01:22.999 felipefaria: should try to be on top on the like at the time that Dfcs are doing the receiving to see if
470 01:01:23.970 ⇒ 01:01:40.199 felipefaria: Dash and at suite are working properly or not. I know that Herman is the one that does a lot of it for for the 3 piece, so so he might have some some insights on whether this is working or he’s still having to send units to care
471 01:01:40.430 ⇒ 01:01:41.250 felipefaria: for manual.
472 01:01:41.350 ⇒ 01:01:45.740 Emily Giant: I was pretty surprised when he said yesterday that
473 01:01:46.230 ⇒ 01:01:49.309 Emily Giant: the system wasn’t working, and I had to like
474 01:01:49.470 ⇒ 01:01:55.169 Emily Giant: actively stop myself from like taking the bait to ask more questions
475 01:01:55.290 ⇒ 01:01:58.249 Emily Giant: because I didn’t realize that was still happening at all.
476 01:01:58.736 ⇒ 01:02:05.670 Emily Giant: And that’s really not good. And I know that her mom is like the 1st person to just do the hard work and not say anything.
477 01:02:05.930 ⇒ 01:02:08.200 Emily Giant: Instead of being like the system is broken.
478 01:02:08.550 ⇒ 01:02:15.760 felipefaria: Yeah, yeah, we we need really need to flag those as he sees it. Yeah. But
479 01:02:16.262 ⇒ 01:02:23.530 felipefaria: I’m sorry, demalati, you’re gonna you’re gonna go through kind of like what all those columns meant. I think
480 01:02:23.720 ⇒ 01:02:31.410 felipefaria: it makes sense to me. But if you just want to do a quick run on on all of these columns, just to make sure that we’re on the same.
481 01:02:31.410 ⇒ 01:02:35.039 Emily Giant: I have to hop Demo. I have to hop to, but.
482 01:02:35.040 ⇒ 01:02:37.059 felipefaria: Oh, well, we can do this tomorrow.
483 01:02:38.016 ⇒ 01:02:44.220 Emily Giant: Can you join Thursday as well, potentially.
484 01:02:44.220 ⇒ 01:02:48.310 felipefaria: And just send me the meetings. And, you guys, you guys meet at 9 Am.
485 01:02:48.310 ⇒ 01:02:52.670 Demilade Agboola: Yeah, add your email to the invite, so it will just pop up on the calendar.
486 01:02:54.270 ⇒ 01:02:54.680 Emily Giant: Perfect.
487 01:02:54.680 ⇒ 01:02:56.034 Emily Giant: I will talk to you later.
488 01:02:56.260 ⇒ 01:02:56.580 felipefaria: Thanks.
489 01:02:56.580 ⇒ 01:02:58.370 Emily Giant: Join. Sorry for the late.
490 01:02:59.320 ⇒ 01:03:00.420 felipefaria: No no worries.
491 01:03:00.810 ⇒ 01:03:02.009 Emily Giant: I’ll talk to you all soon.
492 01:03:02.010 ⇒ 01:03:03.870 felipefaria: Okay. Have a good day. Bye, bye.