Meeting Title: Inventory Data Sync for Felipe Date: 2025-07-21 Meeting participants: Emily Giant, Demilade Agboola
WEBVTT
1 00:00:17.480 ⇒ 00:00:17.900 Demilade Agboola: Okay.
2 00:00:17.900 ⇒ 00:00:20.510 Emily Giant: Bye, not easier to hear now.
3 00:00:21.730 ⇒ 00:00:23.780 Demilade Agboola: Yeah, right? You’re much easier to hear now.
4 00:00:24.400 ⇒ 00:00:34.079 Emily Giant: Okay, good. I just wanted to go into a Starbucks down the street. I will have to figure out the Internet later. But it was not good this morning. How’s your voice doing.
5 00:00:36.730 ⇒ 00:00:42.649 Demilade Agboola: It still trails off randomly, but it’s much better than what it was on Friday, and on Friday I could barely speak.
6 00:00:43.310 ⇒ 00:00:47.060 Emily Giant: Oh, I I hate being in that position, especially when, like
7 00:00:47.170 ⇒ 00:00:53.592 Emily Giant: you have to talk all the time it works. There’s not really any way around it, but I can.
8 00:00:54.660 ⇒ 00:01:02.840 Emily Giant: I can try to do most of the like talking. And, Yada Yada, if it’s hurting just just let me know, like what you’re up for.
9 00:01:06.220 ⇒ 00:01:13.850 Demilade Agboola: Sure, I just wanted us to sync on like what data we have available for Felipe. And what else is left to
10 00:01:15.750 ⇒ 00:01:17.060 Demilade Agboola: make available to him.
11 00:01:17.790 ⇒ 00:01:19.499 Emily Giant: Okay, let me share my screen.
12 00:01:23.430 ⇒ 00:01:25.643 Emily Giant: Alright. So
13 00:01:27.440 ⇒ 00:01:31.625 Emily Giant: What we still have left is figuring out the
14 00:01:32.630 ⇒ 00:01:40.578 Emily Giant: the issue where, like orders with multiple sub orders are showing up on the wrong lot and just like parsing out
15 00:01:41.400 ⇒ 00:01:49.095 Emily Giant: where that logic or what identifier we could use to make sure that forced upgrades don’t get mixed in with
16 00:01:50.000 ⇒ 00:01:57.530 Emily Giant: with uncommitted orders and etc, etc. So I was just pulling an example in the working.
17 00:01:57.910 ⇒ 00:02:00.570 Emily Giant: the working, Doc. There we go with us.
18 00:02:00.878 ⇒ 00:02:02.110 Demilade Agboola: Quick? Question, what what?
19 00:02:02.110 ⇒ 00:02:02.440 Emily Giant: Yeah.
20 00:02:02.440 ⇒ 00:02:07.060 Demilade Agboola: Difference between what’s the difference between A forced upgrade and uncommitted order
21 00:02:07.430 ⇒ 00:02:12.610 Demilade Agboola: are all 1st upgrades on on committed orders, 1st upgrades.
22 00:02:14.208 ⇒ 00:02:17.160 Emily Giant: Did you say our all force upgrades things that are uncommitted.
23 00:02:17.770 ⇒ 00:02:23.519 Demilade Agboola: I said. All 1st upgrades, uncommitted orders, but not all uncommitted. Orders are forced, upgrades.
24 00:02:24.916 ⇒ 00:02:35.840 Emily Giant: Definitely. Not all forced upgrades are uncommitted. Some are, some aren’t, but what we’re getting is that the product that was no longer delivered
25 00:02:36.120 ⇒ 00:02:39.873 Emily Giant: is still showing up on the lot, even though.
26 00:02:41.430 ⇒ 00:02:49.129 Emily Giant: even even though it’s not sent, it’s showing as uncommitted instead of cancelled or deleted.
27 00:02:49.300 ⇒ 00:02:52.850 Emily Giant: So let me see if I can find it. Of course, upgrade. I pulled up.
28 00:02:52.960 ⇒ 00:03:07.140 Emily Giant: and I’ll send this so you can look at it, too. This is an uncommitted order that was not a forced upgrade and it should be showing on order committed because it was, I mean, on hand, committed because it was delivered. So like this is
29 00:03:07.980 ⇒ 00:03:14.170 Emily Giant: wrong, and what I was trying to do is like trace back up what point? Either
30 00:03:14.320 ⇒ 00:03:23.640 Emily Giant: the logic didn’t work or there’s something in a source table that I didn’t pull in here.
31 00:03:25.360 ⇒ 00:03:27.810 Emily Giant: and then a forced upgrade.
32 00:03:28.720 ⇒ 00:03:36.169 Emily Giant: Let’s see, I’m trying to think of the best way to find one of those.
33 00:03:37.200 ⇒ 00:03:43.990 Demilade Agboola: I think I’m just trying to ask about like, I don’t actually see. But like, just like what happens in the like, what happens that.
34 00:03:45.440 ⇒ 00:03:55.600 Demilade Agboola: How do I explain? The 1st upgrade might be like? Oh, they wanted something, they couldn’t get it. Therefore they were upgraded to something else. That’s a 1st upgrade. What would that uncommitted order be?
35 00:03:56.920 ⇒ 00:04:11.109 Emily Giant: An uncommitted order. Is this the screen that I have pulled up right now? It’s an order that was delivered to the customer as ordered, but in netsuite it doesn’t actually have a unit decremented from that lot like.
36 00:04:11.290 ⇒ 00:04:18.260 Emily Giant: For some reason this order never had a firm commitment. Once it was received at the Fc.
37 00:04:18.390 ⇒ 00:04:30.000 Emily Giant: So this is gonna cause an inventory discrepancy, because an on order committed orders like technically not
38 00:04:31.410 ⇒ 00:04:49.830 Emily Giant: consuming any units. If this is like a promise or a presale, that’s what this indicates. And then, as soon as the shipment of flowers arrives at the Xc. This should change to green and say on hand committed. And that’s why we have the logic written out in the mark. Also. That will pull in
39 00:04:50.200 ⇒ 00:04:55.675 Emily Giant: because it changes often due to our accounting. It’s like, 1st in 1st out and
40 00:04:57.960 ⇒ 00:05:07.549 Emily Giant: This will often change to a different lot to align with our accounting principles, and when it doesn’t do that, it’s going to be represented as like
41 00:05:07.660 ⇒ 00:05:18.480 Emily Giant: shrinkage. Once they try to fulfill an order, and they suddenly don’t have a unit there, and that’s gonna cause a forced upgrade. But they’re not related. The forced upgrades are
42 00:05:20.070 ⇒ 00:05:25.254 Emily Giant: there’s some lag or indicator that we’re not using.
43 00:05:26.260 ⇒ 00:05:36.229 Emily Giant: that is like a cancellation of an item, or like a line item strike through. I think once Alex adds that stuff to the Netsuite records.
44 00:05:36.380 ⇒ 00:05:43.239 Emily Giant: it will be super simple. But this, not so much the the order without commitment.
45 00:05:44.055 ⇒ 00:05:53.000 Emily Giant: There’s nothing really to add on the development side, because it’s caused by development problems
46 00:05:53.710 ⇒ 00:06:00.159 Emily Giant: like it’s gonna show wrong everywhere. But if I go to Netsuite, there’s not going to be a record of this order on that lot.
47 00:06:02.190 ⇒ 00:06:03.700 Emily Giant: And then if I pull it.
48 00:06:06.360 ⇒ 00:06:08.610 Emily Giant: just I pulled them our data and like
49 00:06:09.250 ⇒ 00:06:17.630 Emily Giant: I needed to get the Netsuite Id so that I could look at the end ag where we’re doing the uncommitted committed to see if there’s some kind of identifier that we can use.
50 00:06:17.810 ⇒ 00:06:26.140 Emily Giant: But anyway, that’s the only thing, really, that we have left and then what’s available is
51 00:06:27.160 ⇒ 00:06:36.029 Emily Giant: I mean everything. I I put everything in looker except for like 2 products id type things because they’re still a little wonky
52 00:06:36.497 ⇒ 00:06:39.000 Emily Giant: but yeah, you should be able to.
53 00:06:39.380 ⇒ 00:06:43.669 Emily Giant: And looker, see all of those. Now, let’s just check
54 00:06:57.900 ⇒ 00:07:00.999 Emily Giant: yeah. So we’ve got reconciliation. We’ve got
55 00:07:04.170 ⇒ 00:07:09.470 Emily Giant: description, adjustment details. Is there anything that you were looking for?
56 00:07:10.320 ⇒ 00:07:18.120 Demilade Agboola: I think right now, just if the numbers match what? The the models in Dvt.
57 00:07:18.390 ⇒ 00:07:20.470 Demilade Agboola: They get the numbers the same.
58 00:07:21.270 ⇒ 00:07:24.419 Emily Giant: Let’s definitely check. Okay?
59 00:07:28.030 ⇒ 00:07:29.150 Emily Giant: Oh.
60 00:07:33.300 ⇒ 00:07:36.119 Emily Giant: I need to rename these, don’t I? They’re like the same.
61 00:07:36.580 ⇒ 00:07:42.630 Emily Giant: Okay, so let’s pull an inventory number.
62 00:07:50.380 ⇒ 00:07:52.209 Emily Giant: There’s okay.
63 00:08:19.910 ⇒ 00:08:22.169 Emily Giant: Now, it’s weird, though, is that like
64 00:08:24.250 ⇒ 00:08:27.730 Emily Giant: these reconciliation quantities, those should not be
65 00:08:28.000 ⇒ 00:08:32.179 Emily Giant: dimensions. They should be measures. So that’s not right.
66 00:08:32.765 ⇒ 00:08:35.260 Emily Giant: That’s really easy to fix. But.
67 00:08:36.860 ⇒ 00:08:39.309 Demilade Agboola: All right, is it?
68 00:08:39.739 ⇒ 00:08:41.019 Demilade Agboola: Are they?
69 00:08:42.499 ⇒ 00:08:51.819 Demilade Agboola: Are they assigned a type of a data type of voucher or integers? I think that’s probably what’s causing it.
70 00:09:01.580 ⇒ 00:09:04.349 Emily Giant: Yeah, I just like Miss misnamed them.
71 00:09:04.450 ⇒ 00:09:08.160 Emily Giant: But those are not gonna aggregate correctly. I don’t think if they’re
72 00:09:08.290 ⇒ 00:09:13.890 Emily Giant: a number instead of a a measure. So let’s I mean we can test it. But I’m
73 00:09:14.240 ⇒ 00:09:20.180 Emily Giant: sincerely doubting that that would be correct if they can’t aggregate.
74 00:09:21.810 ⇒ 00:09:27.470 Emily Giant: or it will be correct for this query, but like, if you did it without inventory number Id. Probably not.
75 00:09:49.470 ⇒ 00:09:51.619 Emily Giant: I’ll tile these like side by side.
76 00:10:39.620 ⇒ 00:10:42.169 Emily Giant: Let me pull it from the the model that.
77 00:11:05.330 ⇒ 00:11:07.549 Demilade Agboola: It seems taking quite a while, too.
78 00:11:07.740 ⇒ 00:11:08.360 Demilade Agboola: It’s 1 big.
79 00:11:08.360 ⇒ 00:11:09.060 Emily Giant: Yeah.
80 00:11:53.230 ⇒ 00:11:57.540 Emily Giant: okay, this is taking a really long time. I do not know what’s going on with this
81 00:13:16.430 ⇒ 00:13:20.330 Emily Giant: here. I’ll copy this into that document, so you can see
82 00:13:20.540 ⇒ 00:13:23.029 Emily Giant: without having to like. Wait for me to scroll.
83 00:13:24.980 ⇒ 00:13:25.730 Demilade Agboola: Okay.
84 00:13:27.050 ⇒ 00:13:29.509 Emily Giant: Oops that just said the word measurable.
85 00:15:19.420 ⇒ 00:15:21.520 Emily Giant: They made to like lookers like
86 00:15:22.060 ⇒ 00:15:31.399 Emily Giant: broken, or something like it’s fanning out somewhere and going to flow because this isn’t normal.
87 00:15:32.680 ⇒ 00:15:33.580 Demilade Agboola: Our
88 00:15:34.150 ⇒ 00:15:41.119 Demilade Agboola: can we try just like using instead of like filtering? Can we just get like a regular old piece and just see if
89 00:15:41.540 ⇒ 00:15:43.179 Demilade Agboola: it can handle that.
90 00:15:43.810 ⇒ 00:15:44.480 Emily Giant: Yes.
91 00:15:47.810 ⇒ 00:15:49.220 Emily Giant: let’s do it by date.
92 00:16:11.620 ⇒ 00:16:15.559 Emily Giant: Seems to be able to handle that output when I don’t filter it for anything.
93 00:16:18.180 ⇒ 00:16:21.610 Demilade Agboola: And yeah, that’s quite weird.
94 00:16:22.200 ⇒ 00:16:23.280 Emily Giant: Yeah.
95 00:16:30.970 ⇒ 00:16:33.089 Emily Giant: yeah, it’s super weird.
96 00:16:40.360 ⇒ 00:16:47.270 Emily Giant: Alright. So if I find one, that’s I, I’m thinking that it might be because of those
97 00:16:49.510 ⇒ 00:16:54.590 Emily Giant: dimension, the measures being counted as dimensions.
98 00:16:54.920 ⇒ 00:16:59.020 Emily Giant: I’m just gonna really quickly change all these and see if that
99 00:16:59.620 ⇒ 00:17:01.969 Emily Giant: is what’s going on. Because I
100 00:17:04.079 ⇒ 00:17:11.230 Emily Giant: I took away all of the ones that still weren’t updated. And it ran. So let’s see.
101 00:18:45.650 ⇒ 00:18:52.224 Emily Giant: I mean, it wasn’t even showing this last time. So yeah, okay, well, it was that then it was that they were just
102 00:18:52.850 ⇒ 00:18:55.882 Emily Giant: incorrectly categorized as dimensions.
103 00:18:57.237 ⇒ 00:19:03.209 Demilade Agboola: Or inversion of id is a dimension, not a measure.
104 00:19:03.550 ⇒ 00:19:06.890 Demilade Agboola: If you don’t count it as 1, 5, 5 comma.
105 00:19:07.730 ⇒ 00:19:08.410 Emily Giant: Yep.
106 00:19:20.730 ⇒ 00:19:23.155 Emily Giant: okay, it’s it must be that
107 00:19:27.790 ⇒ 00:19:29.520 Emily Giant: number. It’s a string right?
108 00:19:30.530 ⇒ 00:19:31.290 Demilade Agboola: Yes.
109 00:19:45.070 ⇒ 00:19:47.090 Emily Giant: 11th sale unit.
110 00:20:02.790 ⇒ 00:20:05.069 Emily Giant: Yeah. But sorry for me on hand.
111 00:20:20.760 ⇒ 00:20:25.589 Emily Giant: You know. What I’m gonna do is not this, I’m gonna go to a different.
112 00:20:26.190 ⇒ 00:20:28.819 Emily Giant: We’re doing different explorers. There. That was my bad.
113 00:21:30.321 ⇒ 00:21:37.390 Demilade Agboola: The numbers on the right are they from dbte giants, or the analytics scheme itself?
114 00:21:42.590 ⇒ 00:21:45.999 Emily Giant: They’re. I think they’re dvte Giant. Let me do analytics.
115 00:22:34.350 ⇒ 00:22:46.670 Emily Giant: Okay. Quantity on hand is 5 on the all hands committed 0 care buffer, 0
116 00:22:49.190 ⇒ 00:22:51.380 Emily Giant: total quantity sold is 11.
117 00:22:52.450 ⇒ 00:22:55.420 Emily Giant: Correct, uncommitted is 0
118 00:22:56.020 ⇒ 00:23:01.899 Emily Giant: and then, if it’s a sale, there’s not going to be any other adjustment types. So that seems to match exactly.
119 00:23:04.390 ⇒ 00:23:10.100 Emily Giant: I kind of want to find one that it’s the uncommitted quantity
120 00:23:11.170 ⇒ 00:23:17.650 Emily Giant: a lot with an uncommitted quantity greater than 0
121 00:23:19.310 ⇒ 00:23:23.690 Emily Giant: They do appear to be aggregating correctly in this example. But
122 00:24:09.178 ⇒ 00:24:13.379 Emily Giant: These numbers look nuts, but let me go ahead, and
123 00:24:13.510 ⇒ 00:24:20.316 Emily Giant: oh, it aggregated. I was like this is, there’s no way, but it’s because I didn’t put any kind of like detail on it.
124 00:24:46.920 ⇒ 00:24:49.500 Emily Giant: One has 7 uncommitted.
125 00:24:52.290 ⇒ 00:24:54.659 Emily Giant: Well, let’s see if it matches but
126 00:25:40.510 ⇒ 00:25:43.200 Emily Giant: 88 0 0
127 00:25:47.330 ⇒ 00:25:50.259 Emily Giant: 7 total committed quantities of 30.
128 00:25:50.460 ⇒ 00:25:52.209 Emily Giant: I’m committed. 7.
129 00:25:55.960 ⇒ 00:25:58.430 Emily Giant: Okay? Doesn’t match. But
130 00:26:41.480 ⇒ 00:26:52.090 Emily Giant: alright. So one of the things that I definitely need to do is add that detail to the inventory adjustments mark for uncommitted and committed because those are right now only in the
131 00:26:52.470 ⇒ 00:27:03.308 Emily Giant: the lot balance table, and they should be available in both. Since this is how I’m like what I’m using to identify orders that don’t have commitments.
132 00:27:05.680 ⇒ 00:27:07.220 Demilade Agboola: Oh, sorry! Can you do that.
133 00:27:08.080 ⇒ 00:27:13.830 Emily Giant: Yes, so right now. There are 2. There’s still 2 mark tables for inventory.
134 00:27:13.980 ⇒ 00:27:22.010 Emily Giant: and one of them has the level of detail for uncommitted and committed, and the other doesn’t, and to do this exercise of like
135 00:27:22.150 ⇒ 00:27:38.690 Emily Giant: pulling out orders that are on the wrong lot, I should really add uncommitted and committed detail to the inventory adjustments mark, and not just the inventory lot balance, because it’s like super hard to tell which of which 7
136 00:27:38.880 ⇒ 00:27:41.589 Emily Giant: are the 7 without commitment
137 00:27:42.047 ⇒ 00:27:47.110 Emily Giant: looking at this data set and the other one, it’s it’s just not a quick
138 00:27:47.330 ⇒ 00:27:56.370 Emily Giant: way to look at this problem. So I would say, I need to create that ticket in linear for today. And I can finish it today. It’s not hard. It’s just.
139 00:27:56.700 ⇒ 00:27:58.189 Emily Giant: It was an oversight.
140 00:28:01.170 ⇒ 00:28:05.489 Emily Giant: But until I do that it’s gonna be annoying for us to do what we’re doing.
141 00:28:07.030 ⇒ 00:28:10.119 Emily Giant: we can still do it. But it’s gonna be annoying.
142 00:28:52.250 ⇒ 00:29:00.790 Emily Giant: I can put that in later. It might be better to use a lot with
143 00:29:01.610 ⇒ 00:29:07.050 Emily Giant: not so many orders in it. 30 is not that many, but if there’s like, hear it.
144 00:29:10.310 ⇒ 00:29:11.290 Emily Giant: One.
145 00:29:12.820 ⇒ 00:29:20.850 Emily Giant: Okay, this is a good one, because almost all of them are uncommitted, so little easier to find one.
146 00:29:39.010 ⇒ 00:29:43.319 Emily Giant: 1, 2, 3, 4, 5. So these are different.
147 00:29:43.500 ⇒ 00:29:48.900 Emily Giant: Different. Mark tables. But they should still like have the same.
148 00:29:49.220 ⇒ 00:29:56.070 Emily Giant: This is gonna be like the not aggregated version, and this is the aggregated version. So, on the other hand, committed is 4
149 00:29:57.480 ⇒ 00:30:00.060 Emily Giant: total committed. Quantity sold is 5.
150 00:30:01.710 ⇒ 00:30:03.929 Emily Giant: Total quantity sold is 9,
151 00:30:07.280 ⇒ 00:30:13.039 Emily Giant: so that means 4 of these should be uncommitted. However, there’s only 1, 2, 3, 4,
152 00:30:13.180 ⇒ 00:30:17.900 Emily Giant: 5 lines. So where are the 9? Where the 9? I don’t know.
153 00:30:23.960 ⇒ 00:30:25.390 Demilade Agboola: Yeah, that’s weird.
154 00:30:26.020 ⇒ 00:30:30.450 Emily Giant: It is okay.
155 00:30:35.970 ⇒ 00:30:36.750 Emily Giant: So
156 00:30:41.370 ⇒ 00:30:47.179 Emily Giant: now, what would be awesome is if, like these 2 or these 3 were the uncommitted ones.
157 00:30:47.300 ⇒ 00:30:55.010 Emily Giant: And this inventory commit thing that we’re looking at is why or the like indicator of
158 00:30:59.580 ⇒ 00:31:01.250 Emily Giant: of a bad commitment.
159 00:31:18.230 ⇒ 00:31:20.230 Emily Giant: Yep, 1, 2.
160 00:31:22.090 ⇒ 00:31:25.859 Emily Giant: Oh, these aren’t delivered yet, so they don’t need to be committed yet.
161 00:31:28.460 ⇒ 00:31:34.510 Emily Giant: It might be better to look at not so recent examples. Because that okay, that’s another thing.
162 00:31:35.910 ⇒ 00:31:37.310 Emily Giant: I’m gonna create a ticket.
163 00:31:39.130 ⇒ 00:31:44.829 Demilade Agboola: So does this table. Not work does not work so well when we’re looking at new new data.
164 00:31:46.360 ⇒ 00:31:49.059 Emily Giant: I would say it is
165 00:31:50.530 ⇒ 00:31:58.905 Emily Giant: providing the information as it is in Dbt. But that some of the logic needs to be slightly tweaked to make sure that
166 00:32:00.270 ⇒ 00:32:07.489 Emily Giant: and this might be a good one to give to you. That orders with a future delivery date. Are not
167 00:32:08.000 ⇒ 00:32:10.670 Emily Giant: counted in like uncommitted.
168 00:32:11.040 ⇒ 00:32:18.280 Emily Giant: Those should only be counted in like on order, not on uncommitted. It’s
169 00:32:18.440 ⇒ 00:32:28.199 Emily Giant: what we’re trying to identify. What Felipe needs is only orders that have been delivered and are uncommitted are what’s causing the discrepancies.
170 00:32:28.490 ⇒ 00:32:35.570 Emily Giant: So right now, it’s just pulling it, because yes, they are uncommitted.
171 00:32:35.830 ⇒ 00:32:42.870 Emily Giant: But they aren’t a problem, because those units just haven’t arrived to the Fc. Yet. So it’s like a different
172 00:32:43.390 ⇒ 00:32:46.850 Emily Giant: thing entirely than on hand.
173 00:32:48.054 ⇒ 00:32:49.109 Emily Giant: Remove.
174 00:32:50.720 ⇒ 00:33:02.490 Emily Giant: Add logic to remove orders with future delivery dates from uncommitted.
175 00:33:49.790 ⇒ 00:33:53.810 Emily Giant: Okay, does that? Does that make more sense with the description added.
176 00:34:01.850 ⇒ 00:34:03.880 Demilade Agboola: To this ticket.
177 00:34:06.440 ⇒ 00:34:08.940 Emily Giant: Yeah, the Us. 2, 2, 7
178 00:34:09.515 ⇒ 00:34:14.310 Emily Giant: and I can show you also, it’s like, in this model.
179 00:34:23.120 ⇒ 00:34:24.880 Emily Giant: where is the uncommitted.
180 00:34:27.409 ⇒ 00:34:28.769 Demilade Agboola: You you just passed it.
181 00:34:29.210 ⇒ 00:34:30.380 Emily Giant: Oh, whoops?
182 00:34:32.730 ⇒ 00:34:34.860 Emily Giant: Oh, yeah, yep, yep.
183 00:34:41.400 ⇒ 00:34:42.770 Emily Giant: okay. So
184 00:34:43.480 ⇒ 00:34:53.089 Emily Giant: for these uncommitted ones, it just needs to also have the like when Item Id is not equal to item Id and promise. Delivery. Date is
185 00:34:53.420 ⇒ 00:34:56.699 Emily Giant: less than current date.
186 00:35:01.410 ⇒ 00:35:02.330 Demilade Agboola: Oh, okay.
187 00:35:02.930 ⇒ 00:35:13.559 Emily Giant: So yeah, this there’s definitely a field called promise delivery date. It starts in transaction line.
188 00:35:15.010 ⇒ 00:35:20.880 Emily Giant: so whatever the tables are, the source tables inventory support types.
189 00:35:21.000 ⇒ 00:35:25.632 Emily Giant: Yeah, we just need to pull that in and add it to the logic. And I can also
190 00:35:26.430 ⇒ 00:35:28.340 Emily Giant: add that to the ticket.
191 00:35:28.750 ⇒ 00:35:29.500 Emily Giant: Thanks.
192 00:35:29.780 ⇒ 00:35:32.704 Emily Giant: We’re not sure who’s working on it yet.
193 00:35:38.700 ⇒ 00:35:40.090 Emily Giant: the wrong ticket.
194 00:36:57.170 ⇒ 00:36:58.389 Emily Giant: Does that make sense
195 00:37:33.710 ⇒ 00:37:34.700 Emily Giant: phone?
196 00:37:37.020 ⇒ 00:37:49.099 Emily Giant: I can look for the all of it, identify Field in polyatomic data
197 00:37:50.400 ⇒ 00:37:55.669 Emily Giant: that shows delivery status or tracking
198 00:37:55.950 ⇒ 00:38:01.730 Emily Giant: status. I am positive it exists. So got that? And then.
199 00:38:04.590 ⇒ 00:38:07.075 Emily Giant: okay, so we got that. And then
200 00:38:11.780 ⇒ 00:38:22.069 Emily Giant: Do you want to take time to like? We know that this is the case, but if I go back a couple of weeks, or there should be promise delivery, date in
201 00:38:22.810 ⇒ 00:38:30.750 Emily Giant: as a field, and continue like pulling some examples of orders that could not, or that
202 00:38:31.830 ⇒ 00:38:36.379 Emily Giant: should have been committed, but were delivered uncommitted.
203 00:38:36.790 ⇒ 00:38:39.490 Emily Giant: Because I do think like, outside of these little like
204 00:38:39.710 ⇒ 00:38:46.120 Emily Giant: tweak things. This is just the the main problem that’s gonna distort the data.
205 00:38:48.850 ⇒ 00:38:54.480 Demilade Agboola: Yeah, I can. I can see that we should definitely just have that like filtered out. So we have like.
206 00:38:54.990 ⇒ 00:38:57.039 Demilade Agboola: numbers are too useful.
207 00:38:58.320 ⇒ 00:39:04.799 Emily Giant: Yeah, so I can go and hide that in flipper until we fix it.
208 00:39:05.230 ⇒ 00:39:06.270 Emily Giant: How about that?
209 00:39:07.660 ⇒ 00:39:14.119 Demilade Agboola: But I I would do that only for the uncommitted goods sold, or are we doing that for all unlimited quantities.
210 00:39:15.540 ⇒ 00:39:16.220 Emily Giant: Okay.
211 00:39:17.570 ⇒ 00:39:18.870 Demilade Agboola: Let me do that real quick.
212 00:39:19.160 ⇒ 00:39:23.620 Demilade Agboola: So the idea is we’re doing it for all unlimited quantities. Right?
213 00:39:24.120 ⇒ 00:39:24.800 Emily Giant: Yes.
214 00:39:25.320 ⇒ 00:39:26.010 Demilade Agboola: Thanks, bye.
215 00:39:48.190 ⇒ 00:39:49.360 Emily Giant: Okay.
216 00:39:52.830 ⇒ 00:39:59.150 Emily Giant: this one we’ve used for a long time. And it’s fine. It’s just the new ones that
217 00:40:07.570 ⇒ 00:40:08.699 Emily Giant: here we go. Okay.
218 00:40:44.420 ⇒ 00:40:45.080 Emily Giant: sure.
219 00:41:16.700 ⇒ 00:41:17.410 Emily Giant: okay.
220 00:42:03.050 ⇒ 00:42:04.690 Emily Giant: those are hidden.
221 00:42:24.650 ⇒ 00:42:27.749 Emily Giant: Interesting. Why are these still showing up?
222 00:42:50.040 ⇒ 00:42:51.580 Emily Giant: Well, that’s a mystery.
223 00:42:55.840 ⇒ 00:43:00.110 Demilade Agboola: It’s still showing up in the in the look.
224 00:43:00.810 ⇒ 00:43:01.660 Emily Giant: Yeah.
225 00:43:02.870 ⇒ 00:43:10.108 Emily Giant: like refreshing. And it should. Usually it will just remove it and say, like, Yada, Yada, Yada is no longer
226 00:43:11.750 ⇒ 00:43:12.860 Emily Giant: available.
227 00:43:16.530 ⇒ 00:43:19.160 Emily Giant: So very strange.
228 00:43:25.980 ⇒ 00:43:31.060 Emily Giant: however, when I look over here they’re not there.
229 00:43:33.430 ⇒ 00:43:35.539 Emily Giant: only the ones that I left
230 00:43:35.710 ⇒ 00:43:39.409 Emily Giant: available are still there. So it worked. It’s just like.
231 00:43:39.540 ⇒ 00:43:49.190 Emily Giant: and if I cleared the cache and refreshed it, I bet you it would be correct or not.
232 00:44:01.410 ⇒ 00:44:02.830 Emily Giant: Okay, well.
233 00:44:03.680 ⇒ 00:44:17.500 Emily Giant: it’s something with like the refresh, because when I search it directly in the field picker. It’s not there. So this should be successfully hidden. I do not know why. Look, there’s not gonna be in that area, though that’s not great for stakeholders.
234 00:44:19.130 ⇒ 00:44:21.740 Emily Giant: cause this shouldn’t be there either. Right? Total committed.
235 00:44:23.390 ⇒ 00:44:26.109 Demilade Agboola: The total committed. No.
236 00:44:32.920 ⇒ 00:44:40.550 Emily Giant: And it’s not. It’s just yeah. Something’s just off here. Like, maybe if I exit development mode. And look.
237 00:45:03.080 ⇒ 00:45:08.429 Emily Giant: yeah, this is not the same thing as total committed quantity sold. It’s just giving me like the next best thing.
238 00:45:09.310 ⇒ 00:45:12.169 Emily Giant: Yes, they’re right next to each other, and
239 00:45:12.430 ⇒ 00:45:19.040 Emily Giant: it’s not there. That’s, I think. What matters? It’s just very bizarre that this is not throwing an error for a field that doesn’t exist.
240 00:45:22.620 ⇒ 00:45:28.989 Emily Giant: Anyway, that is a secondary issue, that it’s not gonna hurt the inventory mart at all. As long as like.
241 00:45:29.160 ⇒ 00:45:32.910 Emily Giant: I don’t see it in the field picker. Then they’re not gonna see it.
242 00:45:33.580 ⇒ 00:45:38.539 Emily Giant: So it’s probably just that this report like, have it on it originally.
243 00:45:54.250 ⇒ 00:45:55.340 Emily Giant: Not there.
244 00:45:55.820 ⇒ 00:45:59.082 Emily Giant: Okay, that’s good to go.
245 00:46:00.520 ⇒ 00:46:10.139 Emily Giant: let me throw some examples of orders that are not committed, but delivered
246 00:46:11.337 ⇒ 00:46:17.050 Emily Giant: to the the working Doc, or the ticket, or wherever was there anything else you wanted to check?
247 00:46:18.830 ⇒ 00:46:20.779 Demilade Agboola: No, I think that’s it, really.
248 00:46:21.170 ⇒ 00:46:28.450 Emily Giant: Okay? Yeah. Let’s let’s find some orders. Then, hey.
249 00:46:31.550 ⇒ 00:46:38.120 Emily Giant: I am like very curious about wide.
250 00:46:39.120 ⇒ 00:46:42.219 Emily Giant: This example. Only pulled these rows.
251 00:46:42.570 ⇒ 00:46:48.270 Emily Giant: That is odd when it says 9
252 00:46:49.110 ⇒ 00:46:51.607 Emily Giant: in both like it, said 9 in both
253 00:46:53.170 ⇒ 00:46:56.343 Emily Giant: looker and dbt, so it’s like everything from.
254 00:46:57.830 ⇒ 00:47:01.300 Demilade Agboola: Wondering if there’s a filter for just the adjustments alone.
255 00:47:01.660 ⇒ 00:47:02.450 Demilade Agboola: I don’t know.
256 00:47:02.450 ⇒ 00:47:03.320 Emily Giant: And
257 00:47:37.910 ⇒ 00:47:42.250 Emily Giant: only I’m on committee for quantity sold 9.
258 00:47:43.610 ⇒ 00:47:47.640 Emily Giant: Do you want to see what Dash says? Also
259 00:48:18.350 ⇒ 00:48:21.789 Emily Giant: 11 and 4. Okay. So our
260 00:48:21.900 ⇒ 00:48:30.440 Emily Giant: committed number or on hand number. Those are correct or aligned with dash. And it’s just that like uncommitted business that
261 00:48:31.830 ⇒ 00:48:33.300 Emily Giant: I’m wondering if, like.
262 00:48:33.930 ⇒ 00:48:42.859 Emily Giant: it’s actually what you just said and like it’s a vase or some other item that isn’t the floral.
263 00:48:43.800 ⇒ 00:48:44.300 Demilade Agboola: Yeah.
264 00:48:44.300 ⇒ 00:48:45.679 Emily Giant: So, yeah.
265 00:48:45.680 ⇒ 00:48:50.289 Demilade Agboola: Yeah, I noticed that we used to come back to. That’s kind of why I added the
266 00:48:51.743 ⇒ 00:48:57.660 Demilade Agboola: floral filter, I’m not sure but by mistake. Here one second.
267 00:49:14.960 ⇒ 00:49:18.270 Emily Giant: Alright. Well, just to make sense as to why, like the order, it’s
268 00:49:18.590 ⇒ 00:49:22.230 Emily Giant: 1, 2, 3. This is actually correct.
269 00:49:22.450 ⇒ 00:49:30.059 Emily Giant: One order with 3 different sub orders. So it’s 1. Order
270 00:49:30.590 ⇒ 00:49:33.740 Emily Giant: the 3 packages, and then 2,
271 00:49:35.360 ⇒ 00:49:39.749 Emily Giant: 3, which is probably just like a a data lag. Right? One.
272 00:49:41.895 ⇒ 00:49:46.769 Demilade Agboola: Something I’d like to ask you is, I noticed that this product? I have floral.
273 00:49:47.030 ⇒ 00:49:53.379 Demilade Agboola: but there are some other things like I said something I wanted to ask is, I notice that there are products. There’s product type, floral.
274 00:49:54.206 ⇒ 00:49:58.599 Demilade Agboola: But there’s also product type like plans. And I’m just wondering if
275 00:50:01.320 ⇒ 00:50:05.400 Demilade Agboola: that is the only like, not in this table, but like in the table.
276 00:50:05.400 ⇒ 00:50:06.689 Emily Giant: The other, one,
277 00:50:07.120 ⇒ 00:50:13.180 Demilade Agboola: Yeah. Cause when you said or follow is, what type is it goes to one.
278 00:50:13.740 ⇒ 00:50:14.219 Demilade Agboola: But then.
279 00:50:14.220 ⇒ 00:50:14.540 Emily Giant: You know.
280 00:50:14.540 ⇒ 00:50:17.550 Demilade Agboola: Been closer to which is, according to plants and all that stuff.
281 00:50:17.550 ⇒ 00:50:18.010 Emily Giant: Yes.
282 00:50:18.010 ⇒ 00:50:18.899 Demilade Agboola: Drinking airs.
283 00:50:20.400 ⇒ 00:50:25.460 Demilade Agboola: Floral is only floral, like there. There are no other situations where.
284 00:50:27.910 ⇒ 00:50:29.340 Emily Giant: Let’s see, and
285 00:50:51.870 ⇒ 00:50:53.160 Emily Giant: not bad.
286 00:50:55.700 ⇒ 00:50:59.970 Emily Giant: It does look like there are 2 orders that say the Margo.
287 00:51:00.390 ⇒ 00:51:03.424 Emily Giant: which isn’t the cottage core, obviously
288 00:51:07.980 ⇒ 00:51:12.740 Emily Giant: and I’m guessing they’re both doubles, which is where the 4 would come from that are uncommitted. But
289 00:51:17.040 ⇒ 00:51:21.539 Emily Giant: oh, yeah, they’re they’re just that additional freaking sub order.
290 00:51:27.970 ⇒ 00:51:32.110 Emily Giant: So yeah, that’s all correct. It’s yeah. 2 double the Margo. There’s your.
291 00:51:32.570 ⇒ 00:51:36.220 Emily Giant: and it’s correct. They’re not committed. But they’re not delivered yet. It’s just
292 00:51:36.410 ⇒ 00:51:40.300 Emily Giant: that these shouldn’t be showing up on that table at all, and I
293 00:51:40.730 ⇒ 00:51:43.120 Emily Giant: don’t get why they are like.
294 00:51:43.400 ⇒ 00:51:46.969 Emily Giant: unless Netsuite is truly doing some funky stuff like
295 00:51:48.370 ⇒ 00:52:00.069 Emily Giant: because it joins to inventory assignment on transaction line. And hmm! Maybe. Hmm! Hold on.
296 00:52:13.210 ⇒ 00:52:15.590 Emily Giant: I think it must be something with a partition
297 00:52:15.880 ⇒ 00:52:24.380 Emily Giant: like maybe I’m partitioning on something that is causing an order to
298 00:52:25.290 ⇒ 00:52:31.850 Emily Giant: pull this as a separate record for the one I think it’s going to be like in a intermediate
299 00:52:32.080 ⇒ 00:52:33.819 Emily Giant: transaction line model.
300 00:52:35.560 ⇒ 00:52:40.180 Emily Giant: But if I pull the raw data from transaction line, I wonder what like the most recent
301 00:52:41.100 ⇒ 00:52:43.470 Emily Giant: lot says for that order.
302 00:52:44.360 ⇒ 00:52:45.960 Emily Giant: And if that’s correct.
303 00:52:46.410 ⇒ 00:52:47.170 Emily Giant: Hold on.
304 00:56:48.740 ⇒ 00:56:54.330 Emily Giant: I was just talking so much on mute. You wouldn’t even believe it. Okay. So
305 00:56:55.090 ⇒ 00:57:00.780 Emily Giant: I think one of the issues is definitely that in the partition I’m using. Item Id.
306 00:57:01.050 ⇒ 00:57:06.990 Emily Giant: and that’s good for like a vase or an add on. However, when there’s a horse upgrade.
307 00:57:07.140 ⇒ 00:57:10.799 Emily Giant: it’s gonna have a new item. Id. So what’s happening is that both
308 00:57:11.380 ⇒ 00:57:21.849 Emily Giant: the force upgrade and the new order are both making it through as on that order. I didn’t
309 00:57:22.260 ⇒ 00:57:27.309 Emily Giant: think it would be a problem because of the join. But like.
310 00:57:28.880 ⇒ 00:57:32.029 Emily Giant: that’s definitely why the forced upgrades are showing up like that.
311 00:57:33.270 ⇒ 00:57:34.210 Demilade Agboola: Singapore.
312 00:57:34.360 ⇒ 00:57:40.419 Demilade Agboola: Don’t we want to be able to have them both filter them out by at the different condition.
313 00:57:41.330 ⇒ 00:57:42.100 Emily Giant: Yes.
314 00:57:42.980 ⇒ 00:57:43.350 Demilade Agboola: Okay.
315 00:57:44.955 ⇒ 00:57:47.560 Emily Giant: I’m gonna need to think on that. But
316 00:57:52.390 ⇒ 00:57:55.760 Emily Giant: I need to put that in the ticket, so you don’t have to go fishing for it
317 00:58:06.210 ⇒ 00:58:07.543 Emily Giant: alright, anyway.
318 00:58:08.720 ⇒ 00:58:13.674 Emily Giant: So yeah, there’s gonna be some criteria on here that
319 00:58:15.430 ⇒ 00:58:19.029 Emily Giant: Honestly, it might even be the join done. A lot of like it might be that like.
320 00:58:19.720 ⇒ 00:58:28.790 Emily Giant: oh, no, sorry I can’t. I can’t do just a join, because hard goods don’t have inventory assignment.
321 00:58:33.640 ⇒ 00:58:37.190 Emily Giant: Wait, wait! Wait! That shouldn’t matter, though, because these are only lauded products.
322 00:58:41.110 ⇒ 00:58:44.330 Emily Giant: Yeah, if I change this to a join instead of a left, join
323 00:58:48.110 ⇒ 00:58:48.910 Emily Giant: that?
324 00:58:51.520 ⇒ 00:58:58.470 Emily Giant: Then those orders shouldn’t come through because they shouldn’t have a lot assignment.
325 00:59:00.880 ⇒ 00:59:03.860 Emily Giant: Does that make sense? I guess we can just test it.
326 00:59:06.600 ⇒ 00:59:12.100 Emily Giant: But that would be what I would think is that the left join is
327 00:59:12.950 ⇒ 00:59:16.109 Emily Giant: allowing those lines for orders that are
328 00:59:16.310 ⇒ 00:59:20.690 Emily Giant: no longer scheduled to be fulfilled, or items
329 00:59:20.810 ⇒ 00:59:24.610 Emily Giant: still coming through, because we use a join on every other.
330 00:59:27.410 ⇒ 00:59:31.840 Emily Giant: Every other join that we use for inventory assignment is not a left. Join.
331 00:59:33.430 ⇒ 00:59:37.009 Demilade Agboola: Sure, but I think my question here is there a marker for
332 00:59:37.230 ⇒ 00:59:39.829 Demilade Agboola: transactions that are no longer going to be fulfilled?
333 00:59:45.690 ⇒ 00:59:47.829 Emily Giant: Alright, so in transaction, line.
334 00:59:48.620 ⇒ 00:59:51.329 Demilade Agboola: Is that in transaction is a marker. For
335 00:59:52.800 ⇒ 00:59:56.369 Demilade Agboola: because we could just filter out by that instead of like.
336 00:59:57.170 ⇒ 01:00:01.559 Demilade Agboola: if there’s a consistent like identifier in the transaction line table.
337 01:00:11.370 ⇒ 01:00:13.949 Emily Giant: oh, my, gosh, have we already gone over in time?
338 01:00:14.440 ⇒ 01:00:24.940 Emily Giant: How? Okay, so, let me, go from staging because, I have pulled
339 01:00:25.915 ⇒ 01:00:30.290 Emily Giant: just about every useful or accurate
340 01:00:30.490 ⇒ 01:00:34.319 Emily Giant: field, from the raw table and the raw table. Really.
341 01:00:34.530 ⇒ 01:00:36.180 Emily Giant: it’s not fun to look at
342 01:00:59.060 ⇒ 01:01:00.500 Emily Giant: at the bottom
343 01:01:55.480 ⇒ 01:01:58.670 Emily Giant: trying to sort it computer, please.
344 01:02:28.810 ⇒ 01:02:38.830 Emily Giant: Alright, yeah. So the 2 things that are used to join it to the inventory assignment are these.
345 01:02:41.620 ⇒ 01:02:46.960 Emily Giant: it’s highlighted, those just for whatever help that might be.
346 01:02:53.750 ⇒ 01:02:57.850 Emily Giant: This like this is called inventory commit. It’s gotta mean something right.
347 01:03:00.350 ⇒ 01:03:00.690 Demilade Agboola: Yeah.
348 01:03:01.330 ⇒ 01:03:08.499 Demilade Agboola: So I think my question is, if something was meant to be delivered. But it’s not anymore, is that? And then it’s a fire
349 01:03:08.830 ⇒ 01:03:10.840 Demilade Agboola: in the transaction line table.
350 01:03:12.460 ⇒ 01:03:16.243 Emily Giant: No, there’s not outside of
351 01:03:19.130 ⇒ 01:03:21.989 Emily Giant: Maybe this commit quantity committed to
352 01:03:23.301 ⇒ 01:03:29.470 Emily Giant: one of the things I noticed while looking for that kind of identifier is that that
353 01:03:29.680 ⇒ 01:03:33.300 Emily Giant: quantity committed measures will always be 0
354 01:03:33.440 ⇒ 01:03:47.419 Emily Giant: for the forced upgrades. But it’s not only for forced upgrades, it’s again the like once the delivery date has passed. Those will read 0, but that’s no good, for, like live inventory.
355 01:03:49.274 ⇒ 01:03:56.570 Emily Giant: I’ll keep looking, but I’ll should I create that as like a sub task in linear, or should I do it as its own.
356 01:04:02.560 ⇒ 01:04:03.620 Demilade Agboola: I know.
357 01:04:06.389 ⇒ 01:04:15.370 Demilade Agboola: Yeah, I know that. Yeah, you can create a ticket, but I’m not sure if it should be subtask cause. I know. Sometimes I know Amber has said subtasks and linear can be a bit weird.
358 01:04:15.990 ⇒ 01:04:18.720 Emily Giant: Okay, I’ll create a ticket. Then.
359 01:04:20.390 ⇒ 01:04:21.370 Demilade Agboola: Sounds good.
360 01:04:22.050 ⇒ 01:04:32.700 Emily Giant: Alright the find identifier for orders that are no longer getting fulfilled. Okay, I will let you. I know you probably have another meeting like 20 seconds, and I think you need a coffee. I think I need a coffee.
361 01:04:33.370 ⇒ 01:04:34.579 Demilade Agboola: Yes, I do.
362 01:04:35.284 ⇒ 01:04:42.758 Emily Giant: Alright. Well, thanks so much for switching the time. I’ll I’ll plan on working on.
363 01:04:44.090 ⇒ 01:04:50.029 Emily Giant: The this, the finding the identifier cause. That’s kind of gonna block everything. If we don’t have that
364 01:04:51.660 ⇒ 01:04:53.389 Emily Giant: and I’ll try to
365 01:04:53.560 ⇒ 01:05:04.089 Emily Giant: fix that partition to. Well, no, if we fix this, we then we don’t need to fix the partition, so never mind, I’ll I’ll work on finishing this today, though, defining the identifier.
366 01:05:06.230 ⇒ 01:05:07.959 Demilade Agboola: Okay. Alright. Sounds good.
367 01:05:08.410 ⇒ 01:05:11.969 Emily Giant: Cool alright. Well, let me know if you need anything, and I’ll talk to you soon.
368 01:05:12.580 ⇒ 01:05:13.770 Demilade Agboola: We will do. Talk to you soon.
369 01:05:13.770 ⇒ 01:05:15.190 Emily Giant: Okay? Bye.
370 01:05:15.630 ⇒ 01:05:16.260 Demilade Agboola: Fine.