Meeting Title: Brainforge Inventory Data QA Session Date: 2025-07-23 Meeting participants: Demilade Agboola, Emily Giant, perry
WEBVTT
1 00:01:08.230 ⇒ 00:01:09.390 Emily Giant: Good morning!
2 00:01:13.120 ⇒ 00:01:14.230 Demilade Agboola: Hi, Emily!
3 00:01:15.580 ⇒ 00:01:18.919 Emily Giant: Hi! I just pinged Perry again to say like
4 00:01:19.530 ⇒ 00:01:23.239 Emily Giant: sent you the link, because I confirmed with her yesterday that she could come today.
5 00:01:23.400 ⇒ 00:01:27.630 Emily Giant: But then bond up getting all
6 00:01:27.870 ⇒ 00:01:31.770 Emily Giant: caught up in that payroll issue, which is resolved.
7 00:01:31.870 ⇒ 00:01:38.259 Emily Giant: But haven’t heard back from her, so she may join a little late.
8 00:01:39.000 ⇒ 00:01:45.476 Emily Giant: but I did ping her wanted to tell you that I sent through another pr last night for the
9 00:01:45.960 ⇒ 00:01:47.979 Emily Giant: identifying uncommitted orders.
10 00:01:49.830 ⇒ 00:01:50.199 Demilade Agboola: Okay.
11 00:01:50.880 ⇒ 00:01:51.480 Demilade Agboola: I’ve.
12 00:01:51.480 ⇒ 00:01:51.970 Emily Giant: But.
13 00:01:52.760 ⇒ 00:01:53.340 Demilade Agboola: On!
14 00:01:53.340 ⇒ 00:01:53.890 Emily Giant: Okay.
15 00:01:53.890 ⇒ 00:01:55.780 Demilade Agboola: In the Channel this morning.
16 00:01:56.250 ⇒ 00:01:59.489 Emily Giant: Sweet the thing is I didn’t I?
17 00:01:59.710 ⇒ 00:02:02.470 Emily Giant: I put it in the
18 00:02:03.200 ⇒ 00:02:11.170 Emily Giant: the like inventory mart adjustments flow, but I haven’t added the logic to the in ag
19 00:02:12.650 ⇒ 00:02:20.400 Emily Giant: So I wanted to just go over that, maybe before Perry gets here to see if like
20 00:02:20.550 ⇒ 00:02:23.670 Emily Giant: wanted to. Just show it to you to make sure it all like
21 00:02:24.110 ⇒ 00:02:31.480 Emily Giant: makes sense what I’m seeing. But there’s no identifier at all in the data. It’s all like the logic of
22 00:02:31.860 ⇒ 00:02:39.949 Emily Giant: if if it’s still marked as like on order committed when it gets delivered. So
23 00:02:40.090 ⇒ 00:02:41.999 Emily Giant: what I did was just like here.
24 00:02:43.790 ⇒ 00:02:45.100 Emily Giant: How’s your voice?
25 00:02:46.528 ⇒ 00:02:48.411 Demilade Agboola: It’s much better.
26 00:02:49.230 ⇒ 00:02:49.890 Emily Giant: Okay.
27 00:02:49.890 ⇒ 00:02:53.099 Demilade Agboola: It’s still not a hundred percent, though. But it’s much better
28 00:02:53.690 ⇒ 00:02:58.660 Demilade Agboola: like if I talk, for, like extended periods, I can feel the strain on, my my like, on my.
29 00:02:58.660 ⇒ 00:02:59.470 Emily Giant: Yeah.
30 00:02:59.670 ⇒ 00:03:00.420 Demilade Agboola: But.
31 00:03:00.930 ⇒ 00:03:06.701 Emily Giant: It’s wild. How much like environmental factors can mess with things like that.
32 00:03:07.880 ⇒ 00:03:16.289 Emily Giant: I’m in South Carolina right now, and my allergies like I have to use my inhaler for the 1st time in.
33 00:03:17.080 ⇒ 00:03:27.469 Emily Giant: I don’t know 10 years, because usually when I come and visit, it’s for like 2 days. But yesterday I was like, Oh, my gosh! My asthma is like fully back. It’s crazy.
34 00:03:28.383 ⇒ 00:03:29.409 Emily Giant: Excuse me.
35 00:03:31.195 ⇒ 00:03:36.729 Demilade Agboola: Sorry to hear that does it help, though, like using your inhaler and all that.
36 00:03:36.910 ⇒ 00:03:41.220 Emily Giant: It does, but it makes me feel nuts because it has like
37 00:03:42.121 ⇒ 00:03:45.129 Emily Giant: albuterol. It’s like a steroid inhaler.
38 00:03:45.410 ⇒ 00:03:52.010 Emily Giant: And look, I’m just constantly on steroids. I feel like I should be like a weightlifter or something.
39 00:03:52.160 ⇒ 00:03:53.010 Demilade Agboola: Bye.
40 00:03:53.510 ⇒ 00:04:14.770 Emily Giant: Yeah, it definitely definitely helps. But it’s weird, because you’d think when I live like in the middle of a farm, that that would be like all the allergies. But, Nope, it’s when I’m like I can see like a marsh, and like the sea next to the place I’m staying. It’s actually very pretty. And can’t.
41 00:04:15.120 ⇒ 00:04:24.750 Emily Giant: And I’m like I’m just meant to be a simple Midwestern farmer. I guess you’ve seen it on me.
42 00:04:25.560 ⇒ 00:04:30.160 Emily Giant: all right. So what it did, of course.
43 00:04:35.590 ⇒ 00:04:46.000 Emily Giant: but I’ll have to ask Tazdek if what I think is that Dev believes that indicators are working, and they’re not like.
44 00:04:46.670 ⇒ 00:04:51.977 Emily Giant: 1st of all, this is funny, the order that I pulled as the example, because in dash
45 00:04:52.570 ⇒ 00:05:03.349 Emily Giant: it was showing as uncommitted it actually had successfully committed to the lot, and that one was a tech issue. So I was like, Oh, my gosh, I’ve been like looking for this identifier
46 00:05:03.470 ⇒ 00:05:04.760 Emily Giant: in a
47 00:05:04.980 ⇒ 00:05:12.820 Emily Giant: in an order where it actually did successfully claim the problem was in dash, not the data, but there are still like plenty of orders.
48 00:05:13.159 ⇒ 00:05:19.140 Emily Giant: So I just added it directly to the mart model, and I can move it if you think it’d be like cleaner to have that
49 00:05:20.400 ⇒ 00:05:25.870 Emily Giant: like start higher up in the lineage. But I have.
50 00:05:25.870 ⇒ 00:05:31.989 Demilade Agboola: As you can tell, I’m always a big fan of like, as much logic happens before the marked yeah.
51 00:05:31.990 ⇒ 00:05:32.395 Emily Giant: Yes.
52 00:05:32.800 ⇒ 00:05:38.149 Demilade Agboola: Easier to just identify and clean up when things are going askew.
53 00:05:39.030 ⇒ 00:05:41.910 Emily Giant: Okay, cause I can move this like as far up
54 00:05:42.030 ⇒ 00:05:47.870 Emily Giant: as lotted orders. Start. So I will. This was more like A,
55 00:05:48.450 ⇒ 00:06:05.469 Emily Giant: we need to. Qa this. So just like putting it out there so that we can do Qa, and then move it up. But I had in. So these. Let me move these in order. So in sub orders, with lots, it’s the 1st downstream of, like the staging models
56 00:06:06.350 ⇒ 00:06:19.912 Emily Giant: I had had to separate out, because, of course, you know, like pre sales the lot. Id will be in the transaction line model. And then, once it’s at the facility on hand. It will be in the
57 00:06:20.950 ⇒ 00:06:27.890 Emily Giant: the inventory assignment model. So I had already created a thing called like has assigned quantity which
58 00:06:28.280 ⇒ 00:06:37.419 Emily Giant: just indicates that, like it, is successfully joining the inventory assignment model, since it will fail to do that. And then I
59 00:06:38.280 ⇒ 00:06:41.940 Emily Giant: with the actual fulfillment date. So
60 00:06:42.850 ⇒ 00:06:49.230 Emily Giant: I thought that this was a coalesce. But anyway, it must be a coalescing transaction line.
61 00:06:49.500 ⇒ 00:07:04.230 Emily Giant: So there’s a fulfillment date and an actual fulfillment date. And then this won’t get populated until the order is physically fulfilled. So I was like, Okay, and this is where I’m like looking for.
62 00:07:04.590 ⇒ 00:07:10.920 Emily Giant: Does this make sense? And I will say, I tested 50 orders, and they were all uncommitted, but.
63 00:07:11.070 ⇒ 00:07:14.169 Emily Giant: I said, has assigned quantity is false.
64 00:07:14.550 ⇒ 00:07:17.670 Emily Giant: so it’s still joining inventory transaction line
65 00:07:17.800 ⇒ 00:07:20.810 Emily Giant: is lauded. Product is true, since
66 00:07:20.910 ⇒ 00:07:26.120 Emily Giant: unloaded, will never have an inventory assignment and never be pulled from that model. Canceled is 0,
67 00:07:26.560 ⇒ 00:07:30.910 Emily Giant: and then the actual fulfillment date is less than or equal to today.
68 00:07:31.300 ⇒ 00:07:38.080 Emily Giant: That’s the part that I’m like. Am I wrapping my head around this correctly because you can’t fulfill an item that’s not there. So
69 00:07:38.860 ⇒ 00:07:45.760 Emily Giant: they’re never going to fulfill an item. The same day it arrives at the facility because it goes through like a process of hydration.
70 00:07:46.540 ⇒ 00:07:51.660 Emily Giant: So to me, that felt like the most like accurate
71 00:07:52.390 ⇒ 00:07:56.619 Emily Giant: way of saying this left the facility. So if I run
72 00:07:57.280 ⇒ 00:08:03.689 Emily Giant: this model, it’s like everything from but yes.
73 00:08:12.896 ⇒ 00:08:17.893 Emily Giant: I have uncommitted quantity and uncommitted Boolean at this point, because I was like
74 00:08:18.460 ⇒ 00:08:24.309 Emily Giant: I don’t know what people need sometimes, so I just add more than what might be necessary, because
75 00:08:24.740 ⇒ 00:08:27.950 Emily Giant: I don’t necessarily have to reveal those in looker.
76 00:08:28.300 ⇒ 00:08:30.259 Emily Giant: But we’re uncommitted.
77 00:08:34.429 ⇒ 00:08:35.260 Emily Giant: True.
78 00:08:57.170 ⇒ 00:08:58.329 Emily Giant: Harry wrote back
79 00:09:02.070 ⇒ 00:09:03.740 Emily Giant: Harry.
80 00:09:05.920 ⇒ 00:09:08.990 Emily Giant: Okay, oh, shoot hold on
81 00:09:55.530 ⇒ 00:09:57.690 Emily Giant: so we’ll do some tile action here.
82 00:10:06.360 ⇒ 00:10:12.739 Emily Giant: All right. So if I pull up these orders, they should like accurately show.
83 00:10:14.190 ⇒ 00:10:17.620 Emily Giant: Yep, delivered on order committed. So
84 00:10:21.160 ⇒ 00:10:26.869 Emily Giant: yeah, thing is, I still haven’t thought of a way to like
85 00:10:27.380 ⇒ 00:10:31.110 Emily Giant: flag. Well, I guess this is the way to flag that, like
86 00:10:31.290 ⇒ 00:10:34.129 Emily Giant: the spoilage against this lot, is related to like
87 00:10:34.660 ⇒ 00:10:41.060 Emily Giant: X order. But I think you’d mentioned doing like a list Ag, or something like that of orders on the lot
88 00:10:41.320 ⇒ 00:10:43.660 Emily Giant: that were uncommitted.
89 00:10:45.140 ⇒ 00:10:47.350 Emily Giant: Maybe I understood that wrong, but like.
90 00:10:47.680 ⇒ 00:10:56.660 Demilade Agboola: Yeah, there is a there is a list tag, but like it’s based off, you can have you seen it. It’s in the March inventory lot table.
91 00:10:57.490 ⇒ 00:10:58.260 Emily Giant: Okay.
92 00:11:00.110 ⇒ 00:11:07.009 Demilade Agboola: But it’s like inventory sub borders, but it’s based off our previous definition of uncommitted, based off.
93 00:11:07.010 ⇒ 00:11:07.650 Emily Giant: Hmm.
94 00:11:08.630 ⇒ 00:11:15.089 Demilade Agboola: Okay, kind of just see it. So if you go to, if you query the.
95 00:11:18.420 ⇒ 00:11:24.049 Emily Giant: Mark and go on a new line. I don’t want to rewrite those dates.
96 00:11:34.830 ⇒ 00:11:37.409 Emily Giant: Is it like we’re uncommitted? Is greater than one.
97 00:11:39.934 ⇒ 00:11:45.909 Demilade Agboola: Yeah, no, we’re uncommitted. It’s not uncommitted, uncommitted
98 00:11:46.100 ⇒ 00:11:50.350 Demilade Agboola: subscription, or like the quantity sold credit on.
99 00:11:52.290 ⇒ 00:11:53.060 Emily Giant: Trade.
100 00:12:16.410 ⇒ 00:12:25.570 Emily Giant: Okay? So since, that last pr, these are like, there’s definitely more than 4. It’s because of how I fixed
101 00:12:25.880 ⇒ 00:12:32.039 Emily Giant: the lot thing. It’s not identifying the uncommitted orders anymore.
102 00:12:32.740 ⇒ 00:12:34.910 Emily Giant: because the logic that it’s using
103 00:12:35.050 ⇒ 00:12:40.760 Emily Giant: it’s only going to pull like the most recent record. And before what I fixed it wasn’t.
104 00:12:41.140 ⇒ 00:12:49.599 Emily Giant: It was like not joining to. It was not like fully joining to inventory assignment, which was part of the problem. So
105 00:12:50.280 ⇒ 00:12:51.549 Emily Giant: once I fix.
106 00:12:51.680 ⇒ 00:13:03.650 Emily Giant: So if I go to where the logic is and like in Ag, then implement the new.
107 00:13:08.190 ⇒ 00:13:10.490 Emily Giant: the new logic. It will come back
108 00:13:11.760 ⇒ 00:13:18.010 Emily Giant: so it’d be some case when, and I would just put that same criteria that’s in.
109 00:13:18.260 ⇒ 00:13:18.990 Demilade Agboola: Yeah, but.
110 00:13:18.990 ⇒ 00:13:20.250 Emily Giant: Yes, once, all right.
111 00:13:20.520 ⇒ 00:13:31.090 Demilade Agboola: Great question. If you go to line 92 thereabouts. 3rd line. Item, yeah.
112 00:13:31.930 ⇒ 00:13:35.389 Demilade Agboola: Oh, no. Okay. So can you go to int ag adjustment types.
113 00:13:35.820 ⇒ 00:13:36.400 Emily Giant: Yeah.
114 00:13:49.410 ⇒ 00:13:51.579 Emily Giant: I think it’s called sub order adjustment types. Now.
115 00:13:52.730 ⇒ 00:13:53.720 Demilade Agboola: Okay.
116 00:13:59.760 ⇒ 00:14:01.789 Emily Giant: In allotted adjustments.
117 00:14:02.120 ⇒ 00:14:03.620 Emily Giant: Let me look sorry.
118 00:14:13.550 ⇒ 00:14:16.469 Emily Giant: So there’s ant add lot of adjustments.
119 00:14:30.320 ⇒ 00:14:35.340 Emily Giant: Probably this one, this one.
120 00:14:38.920 ⇒ 00:14:39.670 Emily Giant: No!
121 00:14:40.300 ⇒ 00:14:42.400 Emily Giant: What logic are you looking for.
122 00:14:42.900 ⇒ 00:14:45.279 Demilade Agboola: So it’s can you go to the lot details?
123 00:14:48.085 ⇒ 00:14:55.189 Demilade Agboola: Folder like right there. Can you scroll down? Can I see all the so on the left a lot details.
124 00:14:57.110 ⇒ 00:14:59.494 Emily Giant: Sorry. Where is it?
125 00:15:02.610 ⇒ 00:15:04.209 Demilade Agboola: You’re talking, dag.
126 00:15:04.420 ⇒ 00:15:08.510 Demilade Agboola: No, no, on the no, not the dag, the on the left side, the folder structure, the directories.
127 00:15:08.510 ⇒ 00:15:10.190 Emily Giant: Oh, oh, yeah. Yeah. Sorry.
128 00:15:14.550 ⇒ 00:15:18.739 Demilade Agboola: Can you go up like I pressed the entire like, you know.
129 00:15:21.500 ⇒ 00:15:24.079 Demilade Agboola: No, still, lot lot details.
130 00:15:27.980 ⇒ 00:15:33.810 Demilade Agboola: Interesting cause. I did have a a list ag portion
131 00:15:34.290 ⇒ 00:15:38.799 Demilade Agboola: where I listed out the on computer supporters
132 00:15:40.100 ⇒ 00:15:42.920 Demilade Agboola: and canceled so border. So I’m wondering where that is.
133 00:15:43.060 ⇒ 00:15:44.820 Demilade Agboola: Give me one second.
134 00:15:50.340 ⇒ 00:15:52.520 Emily Giant: I might need to refresh my git state, too.
135 00:15:55.090 ⇒ 00:16:04.090 Demilade Agboola: Yeah, I I think that’s been taken out. No problem. Let’s see.
136 00:17:23.530 ⇒ 00:17:25.420 Emily Giant: In dimensions. Somehow.
137 00:17:26.710 ⇒ 00:17:27.619 Demilade Agboola: What?
138 00:17:27.800 ⇒ 00:17:32.099 Emily Giant: I was like. Maybe it wound up in dimensions somehow, but it’s not there either.
139 00:17:32.360 ⇒ 00:17:37.480 Demilade Agboola: And it’s not bad. I just searched entire github thing, and there’s no
140 00:17:38.440 ⇒ 00:17:42.380 Demilade Agboola: there’s no list ag function used anywhere, so I’ll have to recreate it.
141 00:17:42.690 ⇒ 00:17:44.180 Emily Giant: Oh, my! Gosh!
142 00:17:44.800 ⇒ 00:17:47.220 Demilade Agboola: It’s fine. It’s just it’s just a function.
143 00:17:51.440 ⇒ 00:17:53.670 Emily Giant: And I keep checking this to see if Perry.
144 00:18:28.750 ⇒ 00:18:35.099 Emily Giant: okay, well, while you’re doing that, I can work on moving that logic back into the like intermediate model.
145 00:18:37.430 ⇒ 00:18:38.210 Demilade Agboola: Okay.
146 00:20:38.260 ⇒ 00:20:45.769 Demilade Agboola: have we done? I know I was going to do the filtering out of floral types. Is that still necessary?
147 00:20:46.250 ⇒ 00:20:47.170 Emily Giant: It’s not
148 00:20:48.510 ⇒ 00:20:54.620 Demilade Agboola: Okay, so what I’m guessing, why is it not necessary anymore?
149 00:20:54.920 ⇒ 00:21:10.020 Emily Giant: We know it is. I’m sorry I was thinking about something else I thought you meant in the Mart model. It’s not necessary for uncommitted. Yeah, it needs to be is allotted. So it doesn’t necessarily need to be floral. But you can use this like is lotted boolean.
150 00:21:10.380 ⇒ 00:21:15.439 Emily Giant: because unloaded products will not have commitments.
151 00:21:16.100 ⇒ 00:21:19.029 Demilade Agboola: Yeah, but like, in terms of, I think the thing is
152 00:21:19.530 ⇒ 00:21:24.930 Demilade Agboola: in terms of the commitment numbers or the trying to count commitments.
153 00:21:25.580 ⇒ 00:21:29.900 Demilade Agboola: If it’s not floral. For instance, if
154 00:21:30.580 ⇒ 00:21:36.238 Demilade Agboola: someone was trying to buy a the peony and then they use
155 00:21:37.030 ⇒ 00:21:39.870 Demilade Agboola: they get the firecracker and a vase instead.
156 00:21:41.180 ⇒ 00:21:45.350 Demilade Agboola: just it would counter vase against the uncommitted counts.
157 00:21:49.130 ⇒ 00:21:54.460 Emily Giant: Hmm, yeah, we don’t want that but vases are not allotted.
158 00:21:56.700 ⇒ 00:21:59.980 Emily Giant: So it wouldn’t. If you use the islatted.
159 00:22:01.740 ⇒ 00:22:07.860 Emily Giant: Does that make sense, can you? Can you show me what you mean like? In a query?
160 00:22:08.140 ⇒ 00:22:13.809 Emily Giant: I feel like unlotted and lotted is like a proxy for for floral.
161 00:22:14.850 ⇒ 00:22:16.140 Demilade Agboola: Gotcha.
162 00:22:16.300 ⇒ 00:22:23.809 Demilade Agboola: So basically, we’re not counting any non-lotted fair enough, fair enough? Fair enough.
163 00:22:24.000 ⇒ 00:22:25.220 Demilade Agboola: Yeah, exactly.
164 00:22:25.220 ⇒ 00:22:30.170 Emily Giant: It’s the same thing, I think, is what I’m saying. It’s just an easier way to
165 00:22:31.470 ⇒ 00:22:44.390 Emily Giant: in the event that we get like gummy bears or chocolate like those also have lots because they expire so that way it captures anything with an expiration date, or with a lot rather
166 00:22:45.170 ⇒ 00:22:50.090 Demilade Agboola: But then, once once the inventory team like in the in that case, right?
167 00:22:50.300 ⇒ 00:23:00.680 Demilade Agboola: If if an order was meant to be fulfilled with, say, a certain lot.
168 00:23:01.270 ⇒ 00:23:01.940 Emily Giant: See.
169 00:23:01.940 ⇒ 00:23:12.159 Demilade Agboola: Item, and maybe it wasn’t. But it was fulfilled another lot, plus maybe chocolates. Wouldn’t that count against that initial lot as an uncommitted.
170 00:23:13.260 ⇒ 00:23:17.170 Emily Giant: It shouldn’t because it has a separate lot.
171 00:23:20.140 ⇒ 00:23:23.890 Demilade Agboola: Okay. I think the reason I’m asking, because I I noticed there were times when
172 00:23:25.200 ⇒ 00:23:30.780 Demilade Agboola: the Council was much higher than the numbers. I mean. Sometimes it just looked like it was a function of
173 00:23:31.120 ⇒ 00:23:39.310 Demilade Agboola: the non lotted like, not well non-lotted, but non floral things and inflicting the number.
174 00:23:40.660 ⇒ 00:23:41.560 Emily Giant: I think.
175 00:23:42.112 ⇒ 00:23:44.709 Emily Giant: That was also part of what
176 00:23:44.960 ⇒ 00:23:47.810 Emily Giant: I was troubleshooting with that last pr.
177 00:23:48.090 ⇒ 00:23:56.509 Emily Giant: so you’re not wrong. It’s just that the logic required some tweaking on my end. But it was about the
178 00:23:57.510 ⇒ 00:24:04.869 Emily Giant: So somewhere along the way, in suborders with lots, this one, the join for
179 00:24:06.300 ⇒ 00:24:28.120 Emily Giant: the join for inventory assignment. It it has 2 parameters, and there was only one in one of the upstream models so like it needs to join on transaction line and transaction. Id, and it was only transaction number, and they will be the same transaction number. But when I added the transaction line to the join it fixed that problem.
180 00:24:30.090 ⇒ 00:24:33.329 Emily Giant: But that’s why they were showing up. It’s because of the bad. Join.
181 00:24:34.900 ⇒ 00:24:36.299 Demilade Agboola: Okay. Gotcha.
182 00:24:36.300 ⇒ 00:24:39.299 Emily Giant: But we should probably test it just in case.
183 00:24:39.820 ⇒ 00:24:40.210 Demilade Agboola: Yeah.
184 00:24:41.110 ⇒ 00:24:46.869 Emily Giant: I actually have in my working session, Doc, an order that has
185 00:24:47.160 ⇒ 00:24:51.570 Emily Giant: like chocolates and all sorts of other crap on the order.
186 00:24:54.000 ⇒ 00:24:54.720 Emily Giant: Let’s see?
187 00:24:58.500 ⇒ 00:25:00.109 Emily Giant: Yeah, should be this one.
188 00:25:00.860 ⇒ 00:25:09.470 Emily Giant: So this one has 3 different, as like, I need one with chocolate bar, though.
189 00:25:11.390 ⇒ 00:25:13.529 Emily Giant: or like an expiring food.
190 00:25:18.050 ⇒ 00:25:26.700 Emily Giant: Well, I think we could probably still test to make sure that the vase isn’t also showing up. But it would be really helpful if I had one with 2
191 00:25:26.810 ⇒ 00:25:28.939 Emily Giant: separate lotted products on it.
192 00:25:29.370 ⇒ 00:25:37.380 Demilade Agboola: Yeah, those also doesn’t necessarily have to be the vase. It’s just more of like hopefully.
193 00:25:39.020 ⇒ 00:25:43.549 Demilade Agboola: we’re like not counting anything that isn’t non floral against.
194 00:25:43.830 ⇒ 00:25:44.610 Emily Giant: Yeah.
195 00:25:47.220 ⇒ 00:26:03.822 Emily Giant: Well, now, like with the new pr, it’s counting like, nothing is the problem. It’s showing 4 total. Because now they’re all just filtered out if it’s not joined, which is not the point, like we also want to be able to
196 00:26:04.380 ⇒ 00:26:06.010 Emily Giant: see that number?
197 00:26:07.273 ⇒ 00:26:09.959 Emily Giant: But like, when I just pulled the
198 00:26:10.300 ⇒ 00:26:25.240 Emily Giant: current like production results. There were only 4 rows that have an uncommitted quantity because I fixed that join, but when you fix the join. Nothing comes through unless you add the parameters earlier on that I added to the Mar model.
199 00:26:25.870 ⇒ 00:26:32.840 Emily Giant: But like, if I were to just take the logic
200 00:26:33.170 ⇒ 00:26:36.549 Emily Giant: in the inventory adjustments, model and summit.
201 00:26:36.740 ⇒ 00:26:42.790 Emily Giant: Could we test it that way? And like, I can also query for like
202 00:26:43.850 ⇒ 00:26:46.400 Emily Giant: orders with multiple sub orders that we can pull like
203 00:26:46.640 ⇒ 00:26:52.309 Emily Giant: some examples more easily. I’m just trying to think of like the best way to Qa. This.
204 00:26:52.920 ⇒ 00:26:58.179 Emily Giant: so that you’re not like unsure of where we’re moving forward.
205 00:27:01.190 ⇒ 00:27:03.490 Demilade Agboola: Fair enough, I I think.
206 00:27:04.820 ⇒ 00:27:09.739 Demilade Agboola: can can we just find orders that have like? I don’t know how we would find them.
207 00:27:10.040 ⇒ 00:27:12.750 Emily Giant: I do. That’s that’s why you have me here.
208 00:27:14.030 ⇒ 00:27:22.799 Emily Giant: What parameter do you want like 2 lots per one order? Or is it like it? Does it not matter if it’s like lotted versus unlotted.
209 00:27:22.800 ⇒ 00:27:28.170 Demilade Agboola: Yeah, I just I just want to find out where, like an order was meant to be fulfilled with one lot.
210 00:27:28.390 ⇒ 00:27:31.930 Demilade Agboola: And then it was fulfilled another lot. But we
211 00:27:32.400 ⇒ 00:27:38.070 Demilade Agboola: like also, non, what’s it called non floral goods as well.
212 00:27:38.070 ⇒ 00:27:43.129 Emily Giant: Okay, yeah, let me put some filters because these are new.
213 00:27:44.110 ⇒ 00:27:46.020 Emily Giant: They won’t have lots yet.
214 00:27:47.720 ⇒ 00:27:54.810 Emily Giant: I hate this shopify reporting. I just like move my mouse like this like a hamster in a cage.
215 00:27:55.690 ⇒ 00:27:58.880 Emily Giant: Not 30 days, do you?
216 00:28:21.710 ⇒ 00:28:25.550 Emily Giant: Oh, this is just not at all filtering anything. Great
217 00:28:29.150 ⇒ 00:28:31.570 Emily Giant: date 13.
218 00:28:46.220 ⇒ 00:28:50.420 Emily Giant: I’ll be able to tell just from like looking at the price if they’ve got a lot of junk in them.
219 00:28:50.820 ⇒ 00:28:53.059 Emily Giant: Okay, this looks like a good one.
220 00:29:05.380 ⇒ 00:29:06.100 Emily Giant: Okay.
221 00:29:09.640 ⇒ 00:29:13.340 Emily Giant: all right, this one’s got a bunch of junk in it. So let’s use this order.
222 00:29:14.920 ⇒ 00:29:15.700 Demilade Agboola: Okay.
223 00:29:15.950 ⇒ 00:29:22.139 Emily Giant: It is unfulfilled, though, so why hold on!
224 00:29:27.440 ⇒ 00:29:30.759 Emily Giant: Oh, they just ordered it way in advance. Hold on!
225 00:29:32.550 ⇒ 00:29:35.270 Emily Giant: It’s not a good example, because we want one that’s delivered.
226 00:29:38.070 ⇒ 00:29:40.180 Emily Giant: Why are these all unfulfilled?
227 00:29:46.300 ⇒ 00:29:47.020 Emily Giant: There.
228 00:29:53.010 ⇒ 00:29:53.990 Demilade Agboola: Hyper.
229 00:29:55.640 ⇒ 00:29:56.510 perry: Oh, hey? Sorry!
230 00:29:56.510 ⇒ 00:29:57.160 Emily Giant: This!
231 00:29:57.940 ⇒ 00:29:59.009 Emily Giant: Oh! Hi!
232 00:29:59.310 ⇒ 00:29:59.650 perry: So.
233 00:29:59.650 ⇒ 00:30:00.460 Emily Giant: You’re good.
234 00:30:02.060 ⇒ 00:30:03.150 perry: What’s up?
235 00:30:03.320 ⇒ 00:30:07.500 Emily Giant: Oh, we’re just doing some, some qua, some Qa.
236 00:30:07.840 ⇒ 00:30:09.190 perry: Some qua.
237 00:30:10.625 ⇒ 00:30:12.060 Emily Giant: Yeah.
238 00:30:12.060 ⇒ 00:30:14.269 perry: You’ve decided that you want to try.
239 00:30:14.450 ⇒ 00:30:15.516 Emily Giant: Yeah, exactly.
240 00:30:16.160 ⇒ 00:30:19.520 Emily Giant: It’s a, this one. Okay? So.
241 00:30:19.520 ⇒ 00:30:21.970 perry: Summer, summer, pasta, salad, cool.
242 00:30:22.472 ⇒ 00:30:29.499 Emily Giant: Actually, that sounds delicious. We’re doing some Qa on like making sure that
243 00:30:29.670 ⇒ 00:30:34.350 Emily Giant: or accounting for like uncommitted orders, because it’s like screwing up
244 00:30:36.630 ⇒ 00:30:41.670 Emily Giant: not revenue, but just like Lot Balance. A lot of times like
245 00:30:41.930 ⇒ 00:30:47.459 Emily Giant: what shows is spoilage and shrink is actually like an order they didn’t properly claim in the system.
246 00:30:47.630 ⇒ 00:30:48.700 perry: But.
247 00:30:48.700 ⇒ 00:31:02.680 Emily Giant: Yeah, but we don’t need to do that with you per se. I think we know we’ve got a good handle on it. I can also keep investigating this for the mark model for the inventory lot. And since it’s already like
248 00:31:04.550 ⇒ 00:31:13.390 Emily Giant: written out for inventory adjustments, and I can include it in the Pr. For when I move the logic further up in the lineage
249 00:31:15.150 ⇒ 00:31:29.450 Emily Giant: but I know we’re we’re just qaing like to make sure. Correct me if I’m wrong, but that if there are 2 lots associated with a single order, that they each are associated with their own lot, and not like
250 00:31:29.580 ⇒ 00:31:34.170 Emily Giant: getting added to the aggregate of the main product. Slot.
251 00:31:36.180 ⇒ 00:31:38.220 Demilade Agboola: Yes, yes, that’s what we’re trying to do.
252 00:31:38.400 ⇒ 00:31:42.430 Emily Giant: Okay. I am pretty sure that
253 00:31:43.540 ⇒ 00:31:52.290 Emily Giant: that is how it’s working. But I’ll do some additional. Qa, demo, lada, do you want to? Is there anything specific you wanted to go
254 00:31:52.470 ⇒ 00:31:54.050 Emily Giant: over with Perry?
255 00:31:56.467 ⇒ 00:32:07.499 Demilade Agboola: I I guess, just basically showing her what the new numbers look like. How we’re able to aggregate a lot of the like adjustments into one like central location
256 00:32:09.760 ⇒ 00:32:12.800 Demilade Agboola: and just like, if there are any things that
257 00:32:12.960 ⇒ 00:32:18.029 Demilade Agboola: jump out. If there are any troublesome like lots or anything, she might want to
258 00:32:18.390 ⇒ 00:32:22.900 Demilade Agboola: point out before, like the numbers just go like live fully.
259 00:32:22.900 ⇒ 00:32:23.490 Emily Giant: Yeah.
260 00:32:24.140 ⇒ 00:32:25.090 Emily Giant: Fair.
261 00:32:25.090 ⇒ 00:32:27.909 perry: Sorry I had to grab coffee. Can you say that again?
262 00:32:29.160 ⇒ 00:32:33.009 perry: I promise. I told Emily I can’t promise that I’d be caffeinated. I’m working on it.
263 00:32:34.452 ⇒ 00:32:46.769 Demilade Agboola: No, I just basically said that. We’re just here to show you like the numbers and things have rolled up and how we’re able to show the different like adjustments that happen in every lock.
264 00:32:48.236 ⇒ 00:32:51.920 Demilade Agboola: And just hear your feedback before the numbers go like fully live.
265 00:32:52.740 ⇒ 00:32:53.320 perry: Yeah.
266 00:32:54.760 ⇒ 00:33:00.079 Emily Giant: So we did a huge deployment last week. Did you notice any issues
267 00:33:00.740 ⇒ 00:33:03.750 Emily Giant: with the inventory lots? I know that you’re experiencing same
268 00:33:03.750 ⇒ 00:33:06.016 Emily Giant: very special things with sales data. Again.
269 00:33:07.630 ⇒ 00:33:08.996 perry: Inventory lots.
270 00:33:10.320 ⇒ 00:33:11.910 Emily Giant: So I guess what I did.
271 00:33:13.620 ⇒ 00:33:19.880 perry: I said. I can’t say that I did notice anything. But
272 00:33:20.110 ⇒ 00:33:26.329 perry: I’ve been a little all in on the annual plan, so I haven’t been as close to it as usual.
273 00:33:27.430 ⇒ 00:33:33.679 perry: also, I kind of gave up at some point recently, because we’re just missing plan, and shit’s bad. So.
274 00:33:33.810 ⇒ 00:33:34.210 Emily Giant: Yeah.
275 00:33:34.210 ⇒ 00:33:36.579 perry: Wrong. I didn’t care that it was wrong.
276 00:33:37.420 ⇒ 00:33:47.163 Emily Giant: Yeah, I kind of go in and out of those kinds of feelings of despair. And then and then things will look really good for a week, and I’ll start to like care again.
277 00:33:47.450 ⇒ 00:33:53.459 perry: Like when I don’t have other stuff going on. I get like, Oh, like, this is odd. And I like, I stuff stuff is so weird that I’m like.
278 00:33:55.070 ⇒ 00:33:56.595 Emily Giant: Yeah, no, I hear that.
279 00:33:57.570 ⇒ 00:33:59.628 Emily Giant: But we’re starting the revenue.
280 00:34:00.620 ⇒ 00:34:09.380 Emily Giant: the revenue cycle with Brainforge because we’re like wrapping up inventory. So get ready to get invites.
281 00:34:10.609 ⇒ 00:34:11.389 perry: Okay.
282 00:34:11.850 ⇒ 00:34:20.069 Emily Giant: All right. So this is inventory overview by skew. Okay, this one’s built on. Let’s use either this or.
283 00:34:21.469 ⇒ 00:34:24.679 Demilade Agboola: Are these built on data, or the.
284 00:34:26.659 ⇒ 00:34:27.569 Emily Giant: What was that?
285 00:34:27.610 ⇒ 00:34:29.629 Demilade Agboola: Is built on the new data.
286 00:34:29.639 ⇒ 00:34:30.969 Emily Giant: They are. Yeah.
287 00:34:31.179 ⇒ 00:34:34.949 perry: Yeah, we switched all this out during Valentine’s day, when the new polymetric was built.
288 00:34:35.149 ⇒ 00:34:36.879 perry: Polytomic, polymetric, whatever it is.
289 00:34:36.880 ⇒ 00:34:38.080 Emily Giant: Got it? Yep.
290 00:34:38.080 ⇒ 00:34:38.870 Demilade Agboola: Chats.
291 00:34:38.870 ⇒ 00:34:41.460 Emily Giant: All right. Why is this showing? 0? No.
292 00:34:41.870 ⇒ 00:34:46.059 perry: Because we just haven’t sold any lots against it. When the quantity sold is 0, you get a null.
293 00:34:46.060 ⇒ 00:34:52.210 Emily Giant: Okay, that makes sense. I just had this like gut rock when I saw that like.
294 00:34:52.210 ⇒ 00:34:56.789 perry: No, that’s happened since we did it that way. I think it’s just whatever’s in the math. But I don’t really care that much.
295 00:34:57.060 ⇒ 00:34:57.790 Emily Giant: Okay.
296 00:34:58.393 ⇒ 00:34:59.100 Emily Giant: Let’s see.
297 00:34:59.100 ⇒ 00:35:06.100 perry: No one. No one has ever said anything to me about it, and when nowhere, no one says anything to me about it. I just at some point if I can live with it, and no one says anything.
298 00:35:06.100 ⇒ 00:35:07.529 perry: Yeah, I don’t care.
299 00:35:08.910 ⇒ 00:35:12.430 perry: I love where our standards have landed us.
300 00:35:12.870 ⇒ 00:35:22.759 perry: This report has broken so many times, and, like it goes to the huddle every day at 9 Am. And no one has said a thing to me. That’s part of the reason I’m just like, whenever you’re like, yeah, it’s gonna take some time, like, I don’t care anymore.
301 00:35:23.720 ⇒ 00:35:29.220 perry: Honestly, it’s fun when it’s broken, because then I just am like, Wow! Nobody is fucking, paying attention.
302 00:35:29.850 ⇒ 00:35:34.840 Emily Giant: Oh, my God! This is also summer! Duma laude. People check the fuck out.
303 00:35:34.840 ⇒ 00:35:38.990 perry: Yeah, this work week is really only 4 day, 4 and a half days long, mostly.
304 00:35:40.260 ⇒ 00:35:46.179 Emily Giant: Exactly. People are just like, I think we’re good here. So this one is built on inventory data.
305 00:35:46.300 ⇒ 00:35:52.529 Emily Giant: The major changes are in inventory transaction data. But what we should be able to do is like.
306 00:35:52.530 ⇒ 00:36:03.550 perry: Well, would would doing like an order, move like a pseudo order, move, pull, be a good use of inventory transactions, because that’s something that like I have to do that anyway, and that I couldn’t tell you what I would expect the results to be.
307 00:36:03.710 ⇒ 00:36:05.400 Emily Giant: Yeah, tell me, like.
308 00:36:05.950 ⇒ 00:36:31.050 perry: So generally. What I would be looking for is, I’d filter to a skew. I’d filter to an adjustment date, and I would be hoping to see the name of the skew, the skew number, the order number, the adjustment date, and the lot that it’s pulling from, and that way I would be able to figure out, and if I could, the delivery date of that skew so that I could check that, it’s using the right lot to deliver?
309 00:36:32.170 ⇒ 00:36:33.399 perry: Does that make sense.
310 00:36:33.400 ⇒ 00:36:36.100 Emily Giant: It does. Okay, so do you want.
311 00:36:36.100 ⇒ 00:36:38.759 perry: I do like every other week. Ish so.
312 00:36:39.050 ⇒ 00:36:44.079 Emily Giant: So do you want like the I feel like I’ve seen this report before. And the lot yeah.
313 00:36:44.080 ⇒ 00:36:48.690 perry: We built it during Valentine’s day, but if this is another way to do it, I feel like that’s then easy to.
314 00:36:48.690 ⇒ 00:36:53.139 Emily Giant: So we had pivoted the adjustment date and the promise delivery date right?
315 00:36:53.390 ⇒ 00:36:54.379 Emily Giant: I feel like they were.
316 00:36:54.380 ⇒ 00:36:56.330 perry: You don’t have to pivot it. No, you don’t have to pivot it.
317 00:36:57.530 ⇒ 00:37:01.940 perry: So product, queue, product, name, netsuite lot, id promise date and then adjustment date.
318 00:37:01.940 ⇒ 00:37:02.360 Emily Giant: Hmm.
319 00:37:02.360 ⇒ 00:37:13.029 perry: And I would filter it so that I’ve just used adjustment date as the filter. So I’ll let me send you a skew real quick, because I have to do this check, anyway. So this actually like saves me some work.
320 00:37:14.178 ⇒ 00:37:17.209 perry: Filter to this skew.
321 00:37:18.110 ⇒ 00:37:23.350 perry: And then for promise, delivery date is Friday hopefully.
322 00:37:27.870 ⇒ 00:37:32.779 perry: and does promise delivery date account for when we change the delivery date or no.
323 00:37:33.740 ⇒ 00:37:34.530 Emily Giant: It does.
324 00:37:34.530 ⇒ 00:37:36.250 perry: Okay. Cool. Wait. Yeah. Then.
325 00:37:36.530 ⇒ 00:37:37.400 Emily Giant: Let me think
326 00:37:41.010 ⇒ 00:37:43.510 Emily Giant: the adjustment date.
327 00:37:43.980 ⇒ 00:37:45.459 perry: Day before the delivery date.
328 00:37:45.930 ⇒ 00:37:50.130 Emily Giant: This is the prep, the date. It’s the shipment date.
329 00:37:50.380 ⇒ 00:37:54.229 Emily Giant: Right? Yeah, like, this is, okay. Okay, just making sure we’re on the same page. There.
330 00:37:54.230 ⇒ 00:37:59.409 perry: Yeah. Yeah. Sorry. So, adjustment day adjustment day is Thursday.
331 00:38:00.720 ⇒ 00:38:01.430 Emily Giant: Okay, so you.
332 00:38:01.430 ⇒ 00:38:05.000 perry: I wanna look at orders that right now are set to deliver on Friday.
333 00:38:05.740 ⇒ 00:38:11.050 Emily Giant: So it’s on a range, or it’s on a day. And if I just put Thursday like tomorrow.
334 00:38:11.050 ⇒ 00:38:11.620 perry: Yeah.
335 00:38:11.850 ⇒ 00:38:13.850 Emily Giant: Okay and run it.
336 00:38:14.100 ⇒ 00:38:16.360 perry: Yeah, or you need a quantity.
337 00:38:16.510 ⇒ 00:38:17.719 perry: You don’t have a.
338 00:38:22.590 ⇒ 00:38:24.520 perry: Do you have order? Number in there? Oh, an order number! If you could.
339 00:38:25.370 ⇒ 00:38:26.220 Emily Giant: Yeah.
340 00:38:30.250 ⇒ 00:38:31.340 Emily Giant: and then.
341 00:38:31.700 ⇒ 00:38:33.220 perry: I’m trying to think of like the best.
342 00:38:33.570 ⇒ 00:38:34.890 Emily Giant: Measure to use here, but.
343 00:38:34.890 ⇒ 00:38:36.879 perry: Total count total. It’s
344 00:38:37.250 ⇒ 00:38:44.789 perry: sale units, whichever of those units adjusted. It’s it’s I don’t really need the units. Well, actually, it should be accurate, so never mind, I take that back.
345 00:38:45.930 ⇒ 00:38:50.870 Emily Giant: So yeah, I’ll do total units adjusted. And then if you filter for like is.
346 00:38:50.870 ⇒ 00:38:52.250 perry: Spoilage, or whatever.
347 00:38:52.250 ⇒ 00:38:55.080 Emily Giant: Exactly like if it.
348 00:38:56.930 ⇒ 00:39:02.000 perry: There’s nothing that would have an adjustment date of Thursday other than a sale unit at this point.
349 00:39:03.040 ⇒ 00:39:06.120 perry: like, we can’t proactively adjust something, you know.
350 00:39:07.580 ⇒ 00:39:11.459 perry: So if it’s a Thursday adjustment date, it has to be a sale unit by definition.
351 00:39:12.050 ⇒ 00:39:13.940 Emily Giant: Okay, let’s just.
352 00:39:13.940 ⇒ 00:39:18.969 perry: Because then you know what we should filter to is sale order after this, and see if it shows the same thing.
353 00:39:18.970 ⇒ 00:39:19.600 Emily Giant: Yeah.
354 00:39:20.290 ⇒ 00:39:21.030 perry: Thanks for it.
355 00:39:21.030 ⇒ 00:39:21.550 Emily Giant: There!
356 00:39:22.070 ⇒ 00:39:32.370 perry: Adjustment is made, it’s made on a prior lot or prior date. If a Qc. Adjustment is made, it’s made like day of. If, like all those should be made outside of you. Know what I mean.
357 00:39:32.560 ⇒ 00:39:34.399 Emily Giant: Yep, although, like I can see
358 00:39:34.400 ⇒ 00:39:36.929 Emily Giant: just a mismatch, and that crap happens every day.
359 00:39:38.230 ⇒ 00:39:44.330 perry: Okay, will you filter on the lot? Id low to high because 51 is aggreghana.
360 00:39:44.500 ⇒ 00:39:46.090 perry: and I don’t want to see Aggregonna.
361 00:39:46.850 ⇒ 00:39:47.850 perry: Thank you.
362 00:39:49.600 ⇒ 00:39:51.520 perry: Is it weird that there’s 4 nulls.
363 00:39:53.935 ⇒ 00:39:57.780 Emily Giant: I’m what I’m gonna look up. Why, that would be. That’s very odd.
364 00:39:58.260 ⇒ 00:40:02.029 Emily Giant: unless they’re canceled. Because now we have to. Okay. One sec.
365 00:40:02.030 ⇒ 00:40:02.890 perry: That’s true.
366 00:40:03.060 ⇒ 00:40:06.200 perry: 65. What? The Frick is? 60. 0, that might be elite.
367 00:40:07.710 ⇒ 00:40:09.549 Emily Giant: It is Boston, I think.
368 00:40:09.550 ⇒ 00:40:10.120 perry: Yeah.
369 00:40:10.400 ⇒ 00:40:11.430 Emily Giant: Yeah, yeah, okay.
370 00:40:11.430 ⇒ 00:40:18.090 perry: That’s 1 of those things that my brain did a weird thing, that we have other elite facilities. But in my mind I was like Duh, Boston. So I just said elite.
371 00:40:18.650 ⇒ 00:40:20.650 perry: as if that answered anything.
372 00:40:21.800 ⇒ 00:40:24.004 Emily Giant: It. It got me to where you’re at.
373 00:40:26.990 ⇒ 00:40:27.860 Emily Giant: Okay.
374 00:40:31.840 ⇒ 00:40:32.830 perry: So that’s weird.
375 00:40:33.290 ⇒ 00:40:34.100 Emily Giant: It sure is.
376 00:40:34.410 ⇒ 00:40:35.180 Emily Giant: Let’s.
377 00:40:37.150 ⇒ 00:40:40.210 perry: Will you send me the order? Number for Row 5.
378 00:40:41.020 ⇒ 00:40:44.570 Emily Giant: Yeah, I’m gonna send you this whole report. If you want.
379 00:40:44.910 ⇒ 00:40:46.350 Emily Giant: Look and then
380 00:40:49.530 ⇒ 00:40:52.550 Emily Giant: and then row 1, 2, 3, 4, 5.
381 00:40:52.550 ⇒ 00:40:56.270 perry: Cause, in order to see if this lot should have gone like farm direct, or whatever.
382 00:40:56.580 ⇒ 00:40:58.770 perry: I need to look at some of these order numbers.
383 00:41:00.370 ⇒ 00:41:04.599 Emily Giant: Okay, send those in the chat. I am going to look up these null.
384 00:41:04.820 ⇒ 00:41:09.320 perry: Is purchase date in here, like, yes, yeah. Okay.
385 00:41:09.730 ⇒ 00:41:16.040 perry: I’m gonna add purchase date, because that also plays a role.
386 00:41:17.710 ⇒ 00:41:19.039 perry: Oh, thank you.
387 00:41:27.090 ⇒ 00:41:32.279 Emily Giant: On hand committed. So everything is like good to go with this order. I don’t know why.
388 00:41:36.470 ⇒ 00:41:39.269 Emily Giant: Why that lot would be null. That’s okay.
389 00:41:40.010 ⇒ 00:41:44.840 perry: Oh, that’s a lot fun! Fact.
390 00:41:47.410 ⇒ 00:41:50.110 perry: Wait! Shouldn’t this? Why did you not go?
391 00:41:50.770 ⇒ 00:41:56.550 perry: I really hate this is, I need this to be fixed, and I don’t think this is you. I think this is Alex.
392 00:41:57.670 ⇒ 00:42:03.329 perry: I need that when I look up a sub order id for it to actually still pull the main order. Id and dash.
393 00:42:04.750 ⇒ 00:42:12.199 perry: I hate that when I go to find orders and copy and paste the sub order id. It goes unable to find, just because I put it down.
394 00:42:12.380 ⇒ 00:42:14.349 Demilade Agboola: Yeah, it also has to be the.
395 00:42:14.350 ⇒ 00:42:15.759 Emily Giant: It’s a real pain in the ass. Yeah.
396 00:42:15.760 ⇒ 00:42:17.629 perry: Real pain in the ass.
397 00:42:18.250 ⇒ 00:42:21.569 Emily Giant: Yeah. 1st of all, it’s a red herring you’re like, Oh, my God! This order is not.
398 00:42:21.570 ⇒ 00:42:23.569 perry: Literally. I freak out every single time.
399 00:42:23.570 ⇒ 00:42:24.150 Emily Giant: Me too.
400 00:42:24.440 ⇒ 00:42:26.280 perry: I’m like, Oh, my God, something’s wrong!
401 00:42:27.690 ⇒ 00:42:31.220 Emily Giant: Wait. Oh, hold on! I think also
402 00:42:33.960 ⇒ 00:42:40.449 Emily Giant: one of the Prs. We have to use my staging. I need to put my staging in here, because it’s not going to show exactly
403 00:42:41.140 ⇒ 00:42:42.090 Emily Giant: what.
404 00:42:42.910 ⇒ 00:42:47.010 Emily Giant: Hold on. Sorry I’m Spain, but it’s.
405 00:42:47.570 ⇒ 00:42:49.500 Demilade Agboola: It’s in. It’s in production, right? So.
406 00:42:49.500 ⇒ 00:42:51.879 Emily Giant: No, the not the last one.
407 00:42:52.160 ⇒ 00:43:02.099 Emily Giant: Wait. That one’s yeah. You’re right, though. The 1 2 days ago was like the major change, and then just the uncommitted is what I did the Pr. For last night. So you’re right.
408 00:43:02.430 ⇒ 00:43:05.290 perry: July 20, second at 8 59.
409 00:43:06.180 ⇒ 00:43:08.810 Emily Giant: I just want to see if this support id.
410 00:43:12.250 ⇒ 00:43:15.950 perry: Oh, cause it’s the same day Duh Perry.
411 00:43:15.950 ⇒ 00:43:17.519 Emily Giant: Oh, wow!
412 00:43:17.520 ⇒ 00:43:19.629 perry: I need to do a fulfillment thing.
413 00:43:20.860 ⇒ 00:43:24.430 perry: Fulfillment, I was like, why did this order not go from direct.
414 00:43:25.730 ⇒ 00:43:27.409 Emily Giant: That makes sense. Where’s this.
415 00:43:27.410 ⇒ 00:43:32.309 perry: That’s the scenario in which adjustment, date and delivery day are the same thing.
416 00:43:34.830 ⇒ 00:43:43.890 perry: Is not Manhattan is not Washington, DC. Is not. Africana is not wheat power.
417 00:43:51.570 ⇒ 00:43:56.959 Emily Giant: I’m gonna throw a purchase date in there because it may just be like a load thing like if it was just purchased.
418 00:43:57.900 ⇒ 00:44:26.429 perry: Yeah, so well, that’s what I was. Normally, I check this for like. So there should be a 3 day discrepancy, right? If something like cut off for farm direct was 11 pm. Last night, so 90% of orders would have come in before 11 pm. So I’m looking at purchase date 7, 22. Delivery date 7, 25. Unless there’s an add on, this is just me. This is how I would actually use a report like this. So I’m just doing the work anyway, like this has a glass base. So that’s probably why this didn’t go farm direct, which is weird.
419 00:44:28.470 ⇒ 00:44:29.990 Emily Giant: Sort of understand is null.
420 00:44:30.140 ⇒ 00:44:30.770 perry: Yes.
421 00:44:30.770 ⇒ 00:44:32.980 Emily Giant: Unless it’s just like a delivery lag.
422 00:44:33.430 ⇒ 00:44:37.580 Emily Giant: That’s the only thing which is exactly what’s going on. These were all purchased just now.
423 00:44:38.460 ⇒ 00:44:56.350 perry: That would make sense that I’m okay with the only time I could foresee that becoming a problem would be during mother’s day. Because we’re real time doing it. So as long as you think that in a scenario where we’re having more constant refreshes and data is more like where the refreshes are actually timed to like 15 min versus.
424 00:44:56.350 ⇒ 00:44:56.870 Emily Giant: Standard.
425 00:44:56.870 ⇒ 00:44:58.370 perry: That would be.
426 00:44:58.820 ⇒ 00:45:00.180 perry: But is that fixed?
427 00:45:00.180 ⇒ 00:45:00.740 perry: That’s
428 00:45:00.740 ⇒ 00:45:05.699 perry: fine with me, cause in normal business that doesn’t matter. I’ll just wait a half an hour and do it in a half an hour, really doesn’t matter.
429 00:45:05.950 ⇒ 00:45:12.650 Emily Giant: Okay? Good. Yeah. Cause it looks like anything. And I mean this, I’m sure this will refresh. By the end of this meeting they will have lots.
430 00:45:12.650 ⇒ 00:45:13.060 perry: Yeah.
431 00:45:13.060 ⇒ 00:45:14.500 Emily Giant: The date exactly.
432 00:45:14.500 ⇒ 00:45:18.390 perry: So mother’s day is the only time where it would become like kind of a problem. You know what I mean.
433 00:45:18.390 ⇒ 00:45:19.670 Emily Giant: Yeah, that makes sense.
434 00:45:22.932 ⇒ 00:45:26.470 perry: I just opened my texts, not my slack. What the hell am I doing?
435 00:45:26.910 ⇒ 00:45:27.730 perry: Page.
436 00:45:31.210 ⇒ 00:45:33.879 Emily Giant: Do you want the facility or anything in here? Or does that not really matter?
437 00:45:33.880 ⇒ 00:45:47.174 perry: I did. I just filtered because I can tell for the most part by the lot, id like, which are which it doesn’t really matter as long as I filter to the Fc. I didn’t want which was Manhattan, DC. Baltimore, and all that.
438 00:45:56.830 ⇒ 00:45:58.742 perry: right. Wednesday, Thursday.
439 00:46:04.230 ⇒ 00:46:05.970 perry: I might be wrong, but whatever.
440 00:46:08.300 ⇒ 00:46:09.879 Emily Giant: Wait wrong in the data.
441 00:46:10.290 ⇒ 00:46:13.689 perry: No, no, no wrong in that. My cut off timing, and my soul.
442 00:46:14.005 ⇒ 00:46:16.844 Emily Giant: I was like, no, that’s what we’re doing here.
443 00:46:18.650 ⇒ 00:46:19.450 Emily Giant: Okay.
444 00:46:19.770 ⇒ 00:46:28.899 perry: No, I’m sending it to Jess, because I think this order should have gone farm direct as long as I’m right about when the cutoff schedule is, but I might be wrong about the cutoff schedule, and therefore the order would be right. So I’m just like.
445 00:46:29.140 ⇒ 00:46:32.249 Emily Giant: So do we need to add, cut off schedule as like a field.
446 00:46:34.570 ⇒ 00:46:36.830 perry: If you could, that would be dope.
447 00:46:37.070 ⇒ 00:46:41.450 Emily Giant: It seems like that is something that people are constantly needing.
448 00:46:41.450 ⇒ 00:46:45.529 perry: Well, and Alex has kind of taken admin access away to every everybody on it.
449 00:46:45.530 ⇒ 00:46:46.190 Emily Giant: Yeah.
450 00:46:46.190 ⇒ 00:46:48.456 perry: Which is how I normally check it.
451 00:46:50.490 ⇒ 00:46:51.569 Emily Giant: Okay, so that’s still.
452 00:46:51.570 ⇒ 00:46:55.490 perry: How you would get that in a field like in a field like this. How would that work.
453 00:46:56.432 ⇒ 00:46:58.730 Emily Giant: It would just like it would
454 00:47:00.010 ⇒ 00:47:03.850 Emily Giant: be like a case statement of like if
455 00:47:04.210 ⇒ 00:47:09.210 Emily Giant: it’s location farm direct, and it’s Thursday, then cut off is
456 00:47:09.570 ⇒ 00:47:17.319 Emily Giant: 11 Pm. Est. It would just be like real hardwired. But I do think that there’s like a cutoff schedule.
457 00:47:17.320 ⇒ 00:47:19.380 perry: Well, we change them. That’s the problem.
458 00:47:20.260 ⇒ 00:47:29.680 Emily Giant: However, Demo Lotti would probably know better how to do this, but I think we still have, like admin data in postgres, like we have that data still.
459 00:47:29.680 ⇒ 00:47:39.589 perry: Yeah, cause each delivery. It’s called delivery area. Id has a schedule and a timing on it, and it says, like, how many minutes before the delivery. What I would want to know is really the
460 00:47:39.880 ⇒ 00:47:59.620 perry: minutes before delivery. Like the way that admin phrases it is like it’s 1,120 min before delivery is the cut off. So the way that I would want to see it is whatever that is translated to like a digestible hours like. You know what I mean 4.5 h, or 3.5, whatever that math is. I don’t want to see 1,120 min. That means nothing to my dyslexic brain.
461 00:48:00.940 ⇒ 00:48:11.709 perry: But what I want to see is like, for in this report a column where it says, like your cut off is X amount of hours before delivery, so that I could say like, Oh, like, if we go back to the report.
462 00:48:12.640 ⇒ 00:48:20.419 perry: it’s an added column that just returns like a 6.5 or 4.5, and for farm direct, it’ll say some God forbid number of.
463 00:48:20.420 ⇒ 00:48:22.729 Emily Giant: Yeah, really, a lot of hours. But.
464 00:48:22.730 ⇒ 00:48:31.599 perry: Exactly. But that’ll say, like, Wow, cause that’s how you can reconcile adjustment, date and delivery date. Right like. That’s how you adjust those 2 things of saying like, what happens.
465 00:48:32.700 ⇒ 00:48:35.190 Emily Giant: Yeah, it just seems like, kind of a
466 00:48:35.600 ⇒ 00:48:38.670 Emily Giant: necessary element for people to not.
467 00:48:39.550 ⇒ 00:48:41.929 perry: If there’s just another way for people to access it. That isn’t.
468 00:48:41.930 ⇒ 00:48:42.770 Emily Giant: Yeah.
469 00:48:42.770 ⇒ 00:48:48.650 perry: I would think that’d be good, because I think eventually my sense is that Alex will get rid of admin when he doesn’t have to keep it.
470 00:48:48.650 ⇒ 00:48:49.280 Emily Giant: Yeah.
471 00:48:50.460 ⇒ 00:48:53.550 perry: Which is sad, tragic, and I will cry that day.
472 00:48:53.870 ⇒ 00:49:01.039 Emily Giant: Yeah field for cut off time. And so the acceptance.
473 00:49:01.040 ⇒ 00:49:03.630 perry: This gives me anxiety. Just looking at your screen right now.
474 00:49:04.670 ⇒ 00:49:15.839 Emily Giant: Oh, trust me, I live in a state of frenzy. This is our project plan for this week. I’m pretty sure this is like this week. Okay. So ours.
475 00:49:17.580 ⇒ 00:49:24.520 Emily Giant: That order was purchased prior to cut off right or prior to first.st
476 00:49:25.040 ⇒ 00:49:29.569 Emily Giant: Well, I mean, that’s the same thing. I’m trying to think of a way to phrase this, so that if I don’t do it.
477 00:49:29.910 ⇒ 00:49:37.670 Emily Giant: Cayo or Demo Lotte will be like that makes human sense number of hours
478 00:49:49.340 ⇒ 00:49:50.760 Emily Giant: are y’all still there.
479 00:49:51.330 ⇒ 00:49:51.685 Demilade Agboola: Yeah.
480 00:49:52.040 ⇒ 00:49:55.240 Emily Giant: You got so quiet that I was like,
481 00:49:55.790 ⇒ 00:50:00.859 Emily Giant: Bueller. Okay, so number of hours that purchase was made prior.
482 00:50:02.590 ⇒ 00:50:03.759 Demilade Agboola: To cut off.
483 00:50:04.060 ⇒ 00:50:06.110 Emily Giant: Yeah, self-fulfillment.
484 00:50:06.110 ⇒ 00:50:08.999 perry: Sorry. I was typing incredibly loudly. I’m shocked you couldn’t hear it.
485 00:50:09.000 ⇒ 00:50:10.859 Emily Giant: Not not at all. It was silence.
486 00:50:11.640 ⇒ 00:50:12.900 Emily Giant: And then
487 00:50:17.130 ⇒ 00:50:18.789 Emily Giant: I do think it’s in this like.
488 00:50:20.280 ⇒ 00:50:31.410 Emily Giant: Okay, there’s a thing called cut off them a lot in delivery area. Now, I’m quite curious what we’re gonna see in mode when we pull this. But
489 00:50:49.870 ⇒ 00:50:51.480 Emily Giant: okay, so it does look like,
490 00:50:57.090 ⇒ 00:50:59.270 Emily Giant: what am I looking at? Is this just.
491 00:51:01.180 ⇒ 00:51:03.229 perry: Those are the minutes. That’s what I’m saying.
492 00:51:03.880 ⇒ 00:51:06.540 perry: Divide that by 60. Those are the cutoffs.
493 00:51:08.380 ⇒ 00:51:10.290 perry: How it looks! That’s how it looks! An admin.
494 00:51:11.480 ⇒ 00:51:13.020 Emily Giant: Oh, okay.
495 00:51:13.020 ⇒ 00:51:18.909 perry: That’s what I’m saying. Like a hundred, 1010, 80, divided by 60 is 18 h.
496 00:51:19.460 ⇒ 00:51:26.219 Demilade Agboola: So for each. How? How would we join this? What’s the key to join to this table?
497 00:51:26.480 ⇒ 00:51:30.749 Emily Giant: It’s gonna have to be on. I think it’s on the
498 00:51:31.040 ⇒ 00:51:34.065 Emily Giant: the distribution point and the
499 00:51:36.070 ⇒ 00:51:41.200 Emily Giant: date. It’s gonna have to be like, there’s yeah.
500 00:51:41.200 ⇒ 00:51:45.679 perry: It’s different, because, like, especially for farm direct, the different days have different transit times.
501 00:51:45.680 ⇒ 00:51:49.819 Emily Giant: Yeah, by date. Fc, and
502 00:51:52.010 ⇒ 00:51:54.669 Emily Giant: I want to say transport mode.
503 00:51:55.070 ⇒ 00:51:56.150 Emily Giant: But.
504 00:51:57.350 ⇒ 00:52:01.179 perry: Could you not? Delivery area? Id. Is that id column?
505 00:52:01.720 ⇒ 00:52:02.680 perry: If
506 00:52:03.220 ⇒ 00:52:11.559 perry: when you capture an order, it goes to a specific map, so every order should have an id number on it, because it goes to a specific map.
507 00:52:14.390 ⇒ 00:52:16.509 Emily Giant: Every order should have an id on it, because it goes.
508 00:52:16.510 ⇒ 00:52:24.930 perry: Like, I’m looking at this order in dash. It’s captured. To Usab, Miami, Fedex zone 8 extended express that has a delivery area. Id.
509 00:52:26.180 ⇒ 00:52:27.310 Emily Giant: Oh, okay.
510 00:52:27.310 ⇒ 00:52:28.470 perry: So like in your order.
511 00:52:28.470 ⇒ 00:52:29.879 Emily Giant: Yeah, it makes sense like, it might.
512 00:52:29.880 ⇒ 00:52:30.210 perry: Liver.
513 00:52:30.210 ⇒ 00:52:31.160 Emily Giant: See that!
514 00:52:31.160 ⇒ 00:52:31.890 perry: Yeah.
515 00:52:32.040 ⇒ 00:52:32.450 Emily Giant: Yeah.
516 00:52:32.450 ⇒ 00:52:44.329 perry: Date and delivery area rather than you can skip the Fc. Because the delivery areas are unique in of themselves. There’s not more than like one. There’s not one in every. There’s just one for 300.
517 00:52:44.510 ⇒ 00:52:47.899 Emily Giant: That makes sense. Alright. So it would be. Where’s that linear ticket
518 00:53:05.950 ⇒ 00:53:11.680 Emily Giant: which I’m sure the delivery area Id also encapsulates the date. But I don’t.
519 00:53:11.680 ⇒ 00:53:19.099 perry: No, because there’s a delivery. There’s a delivery area Id for every day of the week, even if it doesn’t have a schedule that week or that day.
520 00:53:19.410 ⇒ 00:53:25.460 perry: So you do have to join it on date. You just don’t have to join it on distribution point, because delivery area Id is unique.
521 00:53:27.650 ⇒ 00:53:33.660 perry: or I should say, delivery area. Id is unique to the facility, not the date.
522 00:53:37.680 ⇒ 00:53:39.470 perry: I don’t know if that helped, but.
523 00:53:40.010 ⇒ 00:53:40.719 Emily Giant: It does.
524 00:53:54.440 ⇒ 00:53:55.250 Emily Giant: Okay?
525 00:53:56.270 ⇒ 00:53:59.020 Emily Giant: Oh, my gosh! How is it? 9, 55, anyway?
526 00:54:01.300 ⇒ 00:54:05.309 Emily Giant: Alright. So that’s nice. That that already exists.
527 00:54:06.670 ⇒ 00:54:08.060 perry: So I think, like in terms of.
528 00:54:08.060 ⇒ 00:54:08.940 Emily Giant: Again.
529 00:54:09.250 ⇒ 00:54:17.830 perry: This area of data is the goal that this is now what like Felipe should be using for snop call and stuff like that.
530 00:54:17.830 ⇒ 00:54:18.360 Emily Giant: Yep.
531 00:54:19.110 ⇒ 00:54:29.380 perry: Okay. So he’s probably gonna have a lot more back than I will. But I can mess around with it, cause there are some ways that I use it to like. Reconcile how much inventory we sold, and all that.
532 00:54:29.380 ⇒ 00:54:29.760 Emily Giant: Yeah.
533 00:54:29.760 ⇒ 00:54:35.059 perry: My question is, what is it’s on? What is its subscription? Accuracy.
534 00:54:35.570 ⇒ 00:54:37.119 Emily Giant: It is accurate.
535 00:54:37.120 ⇒ 00:54:37.750 perry: Okay.
536 00:54:38.040 ⇒ 00:54:55.200 Emily Giant: Yeah, so just quick. Rundown of all the new stuff in here. And then, probably later today, I’ll add, like the committed versus uncommitted but there’s a lot of stuff that’s new and we do need some feedback on like naming conventions and stuff like that. If it’s confusing.
537 00:54:55.380 ⇒ 00:55:05.199 Emily Giant: look out reconciliation quantities. That’s more Felipe than you. But like sale units does not encapsulate redeliveries and subscriptions.
538 00:55:05.200 ⇒ 00:55:06.559 perry: Okay. Cool.
539 00:55:07.240 ⇒ 00:55:07.600 Emily Giant: Yeah.
540 00:55:07.600 ⇒ 00:55:12.850 perry: Is there a order status in here? So if we ever need to get batch orders out of here, we can.
541 00:55:14.140 ⇒ 00:55:23.529 Emily Giant: Not that level. But the thing about this data set is it can be joined one to one with sales data. So I can pull over batch status.
542 00:55:23.530 ⇒ 00:55:25.200 Emily Giant: Yeah for their id.
543 00:55:25.350 ⇒ 00:55:34.280 perry: Because, especially in this scenario, especially, I’m thinking, mother’s day, like, I’m gonna want to pull. I’m gonna want to do this for anything that’s not batched already, you know, because they’re batching days and ahead.
544 00:55:34.848 ⇒ 00:55:37.641 perry: So that’s 1 that we frequently use.
545 00:55:41.270 ⇒ 00:55:43.600 perry: how does this handle forced upgrades.
546 00:55:45.340 ⇒ 00:55:46.640 Emily Giant: Right now.
547 00:55:46.640 ⇒ 00:55:48.050 perry: In sale units.
548 00:55:49.501 ⇒ 00:55:53.369 Emily Giant: Yeah, it’s it’s going to only count the item that’s sent.
549 00:55:53.800 ⇒ 00:55:58.480 Emily Giant: not the forced upgrade. And Alex is actually adding, like an indicator in
550 00:55:59.446 ⇒ 00:56:06.040 Emily Giant: netsuite itself. That will be added to the table. That’s just going to be a flag for forced upgrades, because it’s not like
551 00:56:06.190 ⇒ 00:56:10.500 Emily Giant: it’s just not efficient to build it out. There’s a way. But like.
552 00:56:10.500 ⇒ 00:56:33.179 perry: No, that’s fine. Because really like for my teams, from my team’s perspective, I I wanna be able. I need 2 things. I need to be able to see what actually went out the door, but I also need to be able to see what the customer ordered without us interfering. You know what I mean. So I kinda have to have side by sides. So as long as we build this in a way that in eventually, when that’s in there. We could get to both perspectives. That would be great. But it doesn’t have to be right now. That’s like a longer term thing.
553 00:56:33.710 ⇒ 00:56:34.410 Emily Giant: Yeah.
554 00:56:34.865 ⇒ 00:56:36.229 Emily Giant: Sorry. Go ahead.
555 00:56:36.230 ⇒ 00:56:38.942 Demilade Agboola: Because even right now we do have
556 00:56:39.865 ⇒ 00:56:43.060 Demilade Agboola: We do have like what went out the door.
557 00:56:44.350 ⇒ 00:56:48.869 Demilade Agboola: Guys? So we just basically have every single thing that went out. The door
558 00:56:49.490 ⇒ 00:56:53.650 Demilade Agboola: was the one also assigned to or not the desired lot.
559 00:56:54.360 ⇒ 00:57:05.740 Demilade Agboola: and then we have part of what we’re trying to add now is also the support ids that like tie back to the when it was uncommitted, or when it wasn’t the desired lot.
560 00:57:07.100 ⇒ 00:57:09.279 Demilade Agboola: I can easily just see, like
561 00:57:09.520 ⇒ 00:57:18.260 Demilade Agboola: what exactly happened on that order. But yes, what being able to make it like specifically 1st upgrades would be would be, you know, fantastic.
562 00:57:18.610 ⇒ 00:57:24.129 Emily Giant: Yeah, that will be it. So yeah, I have
563 00:57:24.790 ⇒ 00:57:27.780 Emily Giant: Alex also adding in netsuite, like,
564 00:57:29.320 ⇒ 00:57:39.172 Emily Giant: redelivery flag. But we have that. We tied it to sales data, tied it to sales. It’s just nice to have like 2 data sets that are like independent of one another.
565 00:57:40.000 ⇒ 00:57:41.080 Emily Giant: on such.
566 00:57:41.080 ⇒ 00:57:42.270 perry: That’s how you catch.
567 00:57:42.560 ⇒ 00:57:43.760 Emily Giant: Yeah, exactly.
568 00:57:45.190 ⇒ 00:57:52.129 Emily Giant: Yeah, exactly. So like, once I join them together, I’m like, we’re we’re getting the same issue across the board here. If one’s wrong. Yeah.
569 00:57:52.460 ⇒ 00:57:58.207 Emily Giant: Yeah. Okay. Well, yeah, play with the data set. I would say, one big miss, right now is that
570 00:57:59.120 ⇒ 00:58:02.239 Emily Giant: There’s no forced upgrade, and there’s no like.
571 00:58:02.750 ⇒ 00:58:29.990 Emily Giant: If you’re looking at a lot level, they’re so similar, the lot balance and the inventory adjustments table that people keep wanting things from one table to be in the other. So like if that comes up like while you’re building in this like, oh, you have this in the other polyatomic table, but not this one. Just make a note of that and send it over so I can see like if it does make sense. I would love to have just one table. But there’s certain use cases that I’m like. Oh, these just
572 00:58:31.120 ⇒ 00:58:32.424 Emily Giant: I just don’t know.
573 00:58:33.120 ⇒ 00:58:33.850 perry: Yeah.
574 00:58:34.070 ⇒ 00:58:41.890 Emily Giant: No? Alright. Well, I gotta hop I got another meeting. But yeah, play with it. Send us your notes, and I’ll make tickets for
575 00:58:42.130 ⇒ 00:58:45.849 Emily Giant: even if you’re like building the report, and you’re doing something like.
576 00:58:46.200 ⇒ 00:58:47.260 Emily Giant: yeah, trying to make the call.
577 00:58:47.260 ⇒ 00:58:50.099 perry: So our chat is a constant stream of conscious.
578 00:58:50.100 ⇒ 00:58:57.589 Emily Giant: Yeah, it’s helpful. That’s why we do these sessions. I’m like, it sounds like you’re having to do something that sucks. Let’s let’s make that easier.
579 00:58:58.090 ⇒ 00:58:59.020 perry: Cool.
580 00:58:59.020 ⇒ 00:59:01.320 perry: Alright. Thank you. Guys. Appreciate your time.
581 00:59:01.830 ⇒ 00:59:03.769 Demilade Agboola: Alright! I’ll talk to you all soon.
582 00:59:03.770 ⇒ 00:59:04.410 perry: Bye.
583 00:59:04.660 ⇒ 00:59:05.160 Emily Giant: Okay.