Meeting Title: UrbanStems Spoilage Logic Working Session Date: 2025-07-17 Meeting participants: Emily Giant, felipefaria, Demilade Agboola
WEBVTT
1 00:01:23.430 ⇒ 00:01:25.160 Emily Giant: Hi! How’s it going.
2 00:01:26.110 ⇒ 00:01:27.930 felipefaria: Hey? Good! How are you?
3 00:01:28.620 ⇒ 00:01:30.219 Emily Giant: Good is my sound? Okay.
4 00:01:30.800 ⇒ 00:01:31.570 felipefaria: Yeah.
5 00:01:32.020 ⇒ 00:01:42.357 Emily Giant: Okay, I’m at an airport. So it’s I just don’t want to pick up too much of like the ambient noise. I know it’s super loud. Then a lot is running a little bit late. But
6 00:01:43.230 ⇒ 00:01:44.210 Emily Giant: okay.
7 00:01:44.210 ⇒ 00:01:44.880 felipefaria: Gonna mention.
8 00:01:44.880 ⇒ 00:01:45.700 Emily Giant: Started.
9 00:01:46.068 ⇒ 00:01:51.219 felipefaria: And I’ll have to hop at 1230, Emily, because I’m double booked so.
10 00:01:51.390 ⇒ 00:02:02.199 Emily Giant: Oh, no worries. So he had mentioned that yesterday you did some Qa, and the issue is still happening where, like the multiple sub orders, the
11 00:02:03.230 ⇒ 00:02:06.385 Emily Giant: they’re winding up on the wrong lot. Okay,
12 00:02:06.930 ⇒ 00:02:18.592 Emily Giant: so I’m trying to work through that today. That’s kind of like my last outstanding thing I did want to do before he gets here, because I know he’s more briefed on that. A little bit of Qa in looker on
13 00:02:19.000 ⇒ 00:02:28.930 Emily Giant: the reconciliations like spoilage and stuff, just to make sure that those are looking good. So I I wound up after like thinking about it and working on this stuff like
14 00:02:28.940 ⇒ 00:02:54.509 Emily Giant: adding the hard goods and a lot of things, and the non lot of things all to one table. But I just created like ids along the way to make sure that they don’t get like intermixed and wind up on the wrong lots. So I think, for like at the end of the day for urban stems. It’s better to have it all in one place. The thought of like if you wanted to pull sub orders and then having to go to one table to pull like
15 00:02:54.530 ⇒ 00:02:59.820 Emily Giant: non-lotted bases, and then the other to do florals that would really be a pain in the ass. So.
16 00:02:59.820 ⇒ 00:03:08.220 felipefaria: Yeah, as long as we can, we can eventually just add it that table right? And just leave the columns that we want or the filter. However, we want it.
17 00:03:08.220 ⇒ 00:03:08.850 Emily Giant: Exactly.
18 00:03:08.850 ⇒ 00:03:09.420 felipefaria: Okay.
19 00:03:09.420 ⇒ 00:03:24.689 Emily Giant: I think Demo Lot is so used to thinking about it at the lot level. And that’s because that’s the best way to Qa. And to like, make sure, on the most granular level, that things are correct. But that’s never how we really use it, like we do. But that’s not how we’re doing like
20 00:03:24.850 ⇒ 00:03:27.270 Emily Giant: the vast majority of our reporting.
21 00:03:27.960 ⇒ 00:03:32.250 felipefaria: Yeah, yeah, the majority of things that we looked at is is like
22 00:03:32.540 ⇒ 00:03:35.360 felipefaria: by by period, right? Like by like, what we saw.
23 00:03:35.740 ⇒ 00:03:45.210 felipefaria: In a particular week, and stuff like that, like the lot is. As you said, it’s more like for for validation purposes, and.
24 00:03:45.590 ⇒ 00:03:49.190 felipefaria: I think that when the lot comes into play
25 00:03:49.680 ⇒ 00:03:53.899 felipefaria: is what I mentioned in the past in terms of like assigning
26 00:03:54.330 ⇒ 00:04:04.329 felipefaria: a shrinkage, adjustment, or a splish adjustment to the correct period, because then we would have to reference to the lot to see what is the expiration date of the lot.
27 00:04:05.000 ⇒ 00:04:08.630 Emily Giant: Should know. Kind of like. Okay. The lot expires on week.
28 00:04:09.060 ⇒ 00:04:11.040 felipefaria: 19, so that.
29 00:04:11.040 ⇒ 00:04:11.360 Emily Giant: That’s.
30 00:04:11.360 ⇒ 00:04:13.729 felipefaria: Abolish for week, 19, right?
31 00:04:14.749 ⇒ 00:04:21.630 felipefaria: And stuff like this? Because, like, yeah, sometimes the the adjustments are made after
32 00:04:22.029 ⇒ 00:04:41.820 felipefaria: the fact. So it does take a little bit of time like for for the 3 piece, for example, Herman will like. If a product expires on Friday, he will make this policy adjustments on Monday. So that’s policy adjustment that he’s making on Monday is not for that damn week of Monday, right? Just for the prior week. So
33 00:04:43.340 ⇒ 00:04:44.469 felipefaria: you’re on mute.
34 00:04:44.670 ⇒ 00:04:55.900 Emily Giant: Yeah, let’s work on that in this half hour. I just wanna make sure that like that logic is panning out the way you want it to? I’m assuming that it is
35 00:04:56.730 ⇒ 00:05:16.009 Emily Giant: for some queries, and it isn’t for others like, if you were to query like spoilage by lot. Start date, then. It’s going to be correct. But if you were to say like spoilage this week, it’s not so. That’s what we need to figure out do you have an example? Or could you pull an example of
36 00:05:16.500 ⇒ 00:05:19.119 Emily Giant: oh, spoilage adjustment that was done
37 00:05:19.310 ⇒ 00:05:22.749 Emily Giant: outside of the week? If we can just pull one that we could like.
38 00:05:22.750 ⇒ 00:05:23.100 felipefaria: Yeah.
39 00:05:23.100 ⇒ 00:05:24.439 Emily Giant: Tweak the logic from that.
40 00:05:25.360 ⇒ 00:05:29.829 felipefaria: Yeah, let me let me look it up.
41 00:05:33.750 ⇒ 00:05:54.399 Emily Giant: While you’re doing that, I know I’m distracted. But I’m actually gonna see Steven, I’m going to South Carolina. And I used to live down there. Yeah. And so I’ve seen all of my like college and friends from home that when I lived there we all live there together. But then I was like, Oh, my! Gosh, Steven lives down there now. So I called him and was like, Do you want to get a beer or something? So we’re gonna meet up at some point.
42 00:05:54.400 ⇒ 00:05:54.810 felipefaria: I know.
43 00:05:54.810 ⇒ 00:05:58.310 Emily Giant: And I’m gonna shake him and say, what did you leave me
44 00:05:58.980 ⇒ 00:06:00.710 Emily Giant: asking for? Some help on stuff? But.
45 00:06:00.710 ⇒ 00:06:01.150 felipefaria: I’m excited.
46 00:06:01.150 ⇒ 00:06:02.080 Emily Giant: To see him.
47 00:06:02.080 ⇒ 00:06:04.779 felipefaria: Yeah. Yeah. Send him my regards.
48 00:06:05.190 ⇒ 00:06:05.640 Emily Giant: Oh, sorry!
49 00:06:05.640 ⇒ 00:06:08.289 felipefaria: Has been so so helpful.
50 00:06:08.410 ⇒ 00:06:09.890 Emily Giant: So yeah, he’s awesome.
51 00:06:09.890 ⇒ 00:06:17.430 Emily Giant: So I’m like, I know, people get frustrated. But like I’m not, I know how hard his job was, and he was always super helpful to me.
52 00:06:17.430 ⇒ 00:06:18.360 felipefaria: Yeah.
53 00:06:19.194 ⇒ 00:06:25.749 felipefaria: Alright. Let me see, how can I share my screen here? I usually don’t share my screen on
54 00:06:26.010 ⇒ 00:06:33.330 felipefaria: zoom there’s like, usually a little bar floating around at the bottom of your screen.
55 00:06:33.860 ⇒ 00:06:39.229 Emily Giant: And I don’t see it this time. Oh, there! Oh, so if you click on more the 3 dots and then share it at the top.
56 00:06:40.870 ⇒ 00:06:46.859 felipefaria: I do not have this option. I click on the 2 dots, but it says.
57 00:06:47.590 ⇒ 00:06:50.940 felipefaria: transcript captions, docs, notes, whiteboards.
58 00:06:51.320 ⇒ 00:06:52.110 Emily Giant: Alright!
59 00:06:52.735 ⇒ 00:07:02.189 felipefaria: Where do I share my screen? Well, well, let me, and and maybe like, let me share this document with you, and maybe you can open on on your end.
60 00:07:02.570 ⇒ 00:07:03.290 felipefaria: Okay, tell me.
61 00:07:03.290 ⇒ 00:07:07.800 Emily Giant: He can’t share screen with his like zoom permissions.
62 00:07:10.230 ⇒ 00:07:11.769 Demilade Agboola: I don’t know what’s up with that.
63 00:07:12.120 ⇒ 00:07:13.150 Emily Giant: I know.
64 00:07:15.368 ⇒ 00:07:20.280 Emily Giant: Demote. What we’re talking about right now is the spoilage logic, and just making sure that like
65 00:07:20.910 ⇒ 00:07:27.410 Emily Giant: if something spoiled the week after the lot was active, that it’s still attributed to
66 00:07:27.710 ⇒ 00:07:35.099 Emily Giant: the active week, the week that the lot was for sale that week spoilage, not the week in which the action of spoilage was made.
67 00:07:36.730 ⇒ 00:07:39.880 felipefaria: Yeah. And this would be the same thing for
68 00:07:40.660 ⇒ 00:07:50.360 felipefaria: for shrinkage, even though shrinkage shrinkage, we need to add another layer of of rationale there, because shrinkage.
69 00:07:50.360 ⇒ 00:07:50.890 Emily Giant: And.
70 00:07:50.890 ⇒ 00:07:56.189 felipefaria: Can be like on one lot. It can be.
71 00:07:56.190 ⇒ 00:07:57.330 Demilade Agboola: Can you try sharing now?
72 00:07:57.330 ⇒ 00:07:57.770 felipefaria: Introduce.
73 00:07:57.770 ⇒ 00:08:01.049 Demilade Agboola: Sorry. I think I just I think I tried to fix. I don’t see if it works.
74 00:08:03.090 ⇒ 00:08:06.439 felipefaria: Now I have another button that says, record.
75 00:08:06.910 ⇒ 00:08:11.289 felipefaria: This is new, but it just says record, like, I’m.
76 00:08:11.290 ⇒ 00:08:11.750 Demilade Agboola: Interesting.
77 00:08:11.750 ⇒ 00:08:15.400 felipefaria: I’m sharing here in just this Google, Doc Emily.
78 00:08:15.500 ⇒ 00:08:21.259 felipefaria: that just shows the this is pulled straight from Netsuite, and it’s just polished from last week. Right?
79 00:08:21.430 ⇒ 00:08:22.200 felipefaria: Okay.
80 00:08:22.480 ⇒ 00:08:30.330 felipefaria: If you scroll to column A, B.
81 00:08:31.320 ⇒ 00:08:31.670 Emily Giant: Hmm.
82 00:08:31.670 ⇒ 00:08:35.350 felipefaria: Is the date that the adjustment was created.
83 00:08:36.915 ⇒ 00:08:50.480 felipefaria: And then column a ae is the column that I added to into this, that essentially shows what is the week number for the expiration date of the product.
84 00:08:50.700 ⇒ 00:08:54.490 felipefaria: So you can see here that essentially, in a lot of instances.
85 00:08:54.800 ⇒ 00:09:00.490 felipefaria: you will see that that the date created is the same date of the spoilage. Here.
86 00:09:01.220 ⇒ 00:09:06.810 felipefaria: But if you go, for example, to the bottom of the page, you will see some examples.
87 00:09:07.230 ⇒ 00:09:11.170 felipefaria: Product that expired on 7, 12 hang on
88 00:09:11.170 ⇒ 00:09:15.670 felipefaria: adjustment was actually made on 7 14
89 00:09:15.670 ⇒ 00:09:22.599 Emily Giant: So this could maybe be really simple. Could we just use a new field called like
90 00:09:23.090 ⇒ 00:09:31.680 Emily Giant: spoilage, like we’ll think of the name. But spoilage attributed to week, and it’s just the same week as the
91 00:09:32.750 ⇒ 00:09:33.949 Emily Giant: The start date.
92 00:09:35.660 ⇒ 00:09:39.710 felipefaria: It should be the week of the expiration date.
93 00:09:39.710 ⇒ 00:09:44.400 Emily Giant: Expiration date. Okay? So like, truly, I could, yeah, okay.
94 00:09:44.630 ⇒ 00:09:49.369 Emily Giant: But holiday does that make sense? Like, I could just like, use the expiration date
95 00:09:49.580 ⇒ 00:09:53.520 Emily Giant: and say, like, this is the spoilage
96 00:09:54.350 ⇒ 00:09:59.930 Emily Giant: connected week, and that way, instead of having to use expiration date, they could
97 00:10:00.220 ⇒ 00:10:02.859 Emily Giant: pull that as kind of like a separate look.
98 00:10:03.700 ⇒ 00:10:07.139 Emily Giant: but it’s that simple like, unless they change
99 00:10:07.320 ⇒ 00:10:11.640 Emily Giant: well, that that the expiration would change if they changed it in netsuite. So.
100 00:10:11.940 ⇒ 00:10:13.010 felipefaria: With that screen.
101 00:10:13.010 ⇒ 00:10:13.780 Emily Giant: Hangs up.
102 00:10:15.940 ⇒ 00:10:20.970 Emily Giant: Would that matter if they like? I know that we often extend expiration dates. Do you want it
103 00:10:21.320 ⇒ 00:10:25.129 Emily Giant: to be extended, or do you want it to always be the original.
104 00:10:25.130 ⇒ 00:10:28.309 felipefaria: No, no, it needs to be. It needs to be the
105 00:10:32.550 ⇒ 00:10:42.510 felipefaria: actually, now that I’m thinking about it. Because and and that brings another another point that essentially there’s some discussions that if we extend the expiration date
106 00:10:43.084 ⇒ 00:10:51.080 felipefaria: but a product goes bad between the time of the original expiration date and the final expiration date
107 00:10:51.530 ⇒ 00:11:06.609 felipefaria: and they will remove, like, you know, a product goes bad. Then they will just make an adjustment, say damage and unusable. But then that increases the shrinkage, which is a kpi for scm and decreases the spoilage, which is a kpi for snop. But that’s kinda
108 00:11:07.160 ⇒ 00:11:13.860 felipefaria: tricky, because Snop is requesting for the expiration date to be extended.
109 00:11:14.300 ⇒ 00:11:15.395 felipefaria: So
110 00:11:16.790 ⇒ 00:11:25.169 felipefaria: it it like we. We had instances where we say, Hey, if a product actually goes bad between that time period.
111 00:11:25.310 ⇒ 00:11:34.170 felipefaria: less market as a spoilage adjustment instead of a shrinkage adjustment. So I’m gonna have to think about that
112 00:11:34.330 ⇒ 00:11:35.560 felipefaria: for now.
113 00:11:36.290 ⇒ 00:11:40.869 felipefaria: And I would say, because, well, sorry. Okay, well, yeah.
114 00:11:40.870 ⇒ 00:11:43.679 Emily Giant: We need a custom column for dates that are changed
115 00:11:43.850 ⇒ 00:11:47.440 Emily Giant: like we need a way in looker to say like.
116 00:11:47.650 ⇒ 00:11:52.739 Emily Giant: was this expiration date altered after this, like after the product arrives.
117 00:11:52.740 ⇒ 00:12:07.795 felipefaria: Yeah, yeah, that. And that would be great chat that. Would that would be helpful to to have for sure. But for now to keep things simple. Cause I think we would have to think about how to deal with that nuance. There.
118 00:12:08.490 ⇒ 00:12:10.949 felipefaria: yeah, yeah, we can just put it
119 00:12:11.140 ⇒ 00:12:20.210 felipefaria: by the by, the expiration date. Like the the current expiration date right? Not the original per se.
120 00:12:20.510 ⇒ 00:12:32.939 felipefaria: The one thing like the one caveat here, and this kind of goes back to the the thing that I’ll talk to you about how Steven kind of made a bunch of edits to account for shrinkage and sporash.
121 00:12:33.815 ⇒ 00:12:39.140 felipefaria: We don’t have this instance right now, but it could happen in the past that
122 00:12:39.500 ⇒ 00:12:43.230 felipefaria: a shipment can spoil on Monday.
123 00:12:43.540 ⇒ 00:12:57.780 felipefaria: right? And so, if and this is if it’s a 7 day shelf life right now, we extend it to 9 day. I don’t know if, like we just extended permanently. Right? So your pos are uploaded with a 9 day shelf life.
124 00:12:57.920 ⇒ 00:13:02.570 felipefaria: If we go back to the 70, then we need to say
125 00:13:02.810 ⇒ 00:13:06.649 felipefaria: if the expiration date is Monday.
126 00:13:07.580 ⇒ 00:13:15.669 felipefaria: then it should be considered shrinking or spoilage from the prior week. Because what happens is the expiration date
127 00:13:16.550 ⇒ 00:13:27.720 felipefaria: is the date that the product actually spoils. So so the product cannot be sold on Monday, right? So the last day of sale of a product that spoils on Monday is Sunday.
128 00:13:28.420 ⇒ 00:13:37.159 felipefaria: which Sunday is the day prior is the week prior. So it needs to have kind of like. Also caveat about this, which is
129 00:13:37.410 ⇒ 00:13:48.619 felipefaria: like, like, you know, and everything that we described in terms of just us, assigned the expert, the the Spanish, to the week based on the current expiration date.
130 00:13:50.070 ⇒ 00:13:56.400 felipefaria: except when the expiration date is Monday, in which case it should be assigned to the week prior.
131 00:13:58.150 ⇒ 00:14:08.750 felipefaria: If that makes sense, and this is why, like it does get a it does, gets a a little a little tricky with the, with spoilage and shrinkage, because of all this like
132 00:14:09.240 ⇒ 00:14:13.667 felipefaria: nuances here, and then we can discuss shrinkage if you want to, but
133 00:14:14.800 ⇒ 00:14:17.290 felipefaria: So assign spoilage to the English first.st
134 00:14:18.370 ⇒ 00:14:24.630 Emily Giant: Let’s do spoilage first.st so assign spoilage to the week of the current expiration date.
135 00:14:24.820 ⇒ 00:14:25.200 felipefaria: I’m gonna.
136 00:14:25.200 ⇒ 00:14:28.329 Emily Giant: I’m just writing this in a ticket. So, Aka.
137 00:14:28.550 ⇒ 00:14:33.839 Emily Giant: if the expiration date is extended, it should be the ex extended expiration date.
138 00:14:38.010 ⇒ 00:14:38.960 Emily Giant: It should be.
139 00:14:42.960 ⇒ 00:14:49.620 felipefaria: Yeah, cause this is if and and if we’re looking at like a table that shows like, show me this polish for the past 4 weeks, right?
140 00:14:50.030 ⇒ 00:15:05.399 felipefaria: Or the prior completed week, and then we would want to have, because if I if I go to look at right now, and I say, prior completed week. I expect to see all the data for week 28 there. And this is why, like like I,
141 00:15:05.620 ⇒ 00:15:20.340 felipefaria: I I know that in looker, it doesn’t have like week 28 week, 27 or stuff like that. But we just convert that into into week numbers. Essentially. But yeah, is exactly what you described, unless unless expiration date is Monday.
142 00:15:20.340 ⇒ 00:15:24.870 Emily Giant: Monday. Okay? And then, unless it’s the Monday of the week following.
143 00:15:25.850 ⇒ 00:15:38.330 Emily Giant: I’m writing this just in case it’s not me doing the ticket. So it would if if it was Sunday. The 1st and the expiration date was Monday, the second, then it needs to be expiry. Spoilage week attributed to.
144 00:15:38.840 ⇒ 00:15:39.310 felipefaria: To, the.
145 00:15:39.740 ⇒ 00:15:40.970 Emily Giant: First.st Week. Yep. Okay.
146 00:15:40.970 ⇒ 00:15:41.650 felipefaria: That makes sense.
147 00:15:41.650 ⇒ 00:15:46.440 Emily Giant: Perfect sense makes absolute sense to me. Yeah.
148 00:15:46.630 ⇒ 00:15:52.779 Emily Giant: okay, Demo Latte does that track. I’ll probably work on this ticket. But just in case it gets like
149 00:15:52.940 ⇒ 00:15:56.480 Emily Giant: split does that all makes sense.
150 00:15:57.637 ⇒ 00:16:06.220 Demilade Agboola: A bit, though I might have lost some parts, cause like I am in transit. So setting like things are cutting in and out.
151 00:16:06.390 ⇒ 00:16:08.540 Demilade Agboola: but most of it does track.
152 00:16:09.860 ⇒ 00:16:31.009 Emily Giant: Okay, no worries. I I definitely got it. So like, if I need to hash it out with you again, I I got this. It’s definitely like an urban stemz thing where we’re like constantly taking things that happen on Monday and shoving them to the week prior. So it’s like second nature. Okay. So I just wanna look at some recent spoilage numbers.
153 00:16:31.853 ⇒ 00:16:33.220 Emily Giant: Let’s take.
154 00:16:35.760 ⇒ 00:16:39.674 Emily Giant: Let’s look at gallery. I’m just gonna look at the 1st one. Wait. No, we were gonna look at
155 00:16:40.730 ⇒ 00:16:45.290 Emily Giant: actually, let’s just do some regular like, not complicated
156 00:16:45.510 ⇒ 00:16:48.810 Emily Giant: once 1st to see if the numbers match.
157 00:16:48.930 ⇒ 00:16:51.190 Emily Giant: So we’re going to look at the birdsong.
158 00:16:52.410 ⇒ 00:16:55.180 Emily Giant: Where are the spoilage numbers? I want to make sure.
159 00:16:55.420 ⇒ 00:16:58.520 felipefaria: Yeah, that. And that would be column. S, that’s the insane.
160 00:16:58.520 ⇒ 00:17:03.799 Emily Giant: Okay, I’m going to attempt to pull it by the Ia number and the location.
161 00:17:04.642 ⇒ 00:17:08.870 Emily Giant: Okay, I long line quantity. Let me share my screen.
162 00:17:23.530 ⇒ 00:17:37.930 Emily Giant: So I’m gonna go to mode. I have it all built out in my looker, but I haven’t tested it yet, so I I’m afraid it’s gonna be like terribly Wonky if we start in looker. But we can work that way. Okay, so this is my instance where
163 00:17:39.330 ⇒ 00:17:44.180 Emily Giant: adjustment to id equals.
164 00:17:51.240 ⇒ 00:17:54.839 Emily Giant: It might not have the Ia on it. But we’ll see. We’ll see what it pulls.
165 00:18:07.620 ⇒ 00:18:08.570 Emily Giant: Okay.
166 00:18:09.900 ⇒ 00:18:26.579 Emily Giant: So so far we got the sources I allotted. So I I broke up the sources, and this isn’t probably something you’ll use in Looker a lot, but it’s going to say either Presale lotted on hand, lauded ia lotted, or IA non lauded, or
167 00:18:27.100 ⇒ 00:18:31.299 Emily Giant: generally like sale allotted because the
168 00:18:31.610 ⇒ 00:18:34.369 Emily Giant: on hand and Presale logic doesn’t really
169 00:18:34.520 ⇒ 00:18:38.369 Emily Giant: go with the unloaded products. Okay? So
170 00:18:38.490 ⇒ 00:18:41.560 Emily Giant: first, st we want to see just that the numbers match.
171 00:18:42.890 ⇒ 00:18:50.582 Emily Giant: Yes, total adjustment, quantity, total reconciliation, quantity. They should always match.
172 00:18:51.300 ⇒ 00:18:58.187 Emily Giant: this should match this. If it’s a reconciliation. If it’s a sale, total adjustment, quantity will show the sales.
173 00:18:59.190 ⇒ 00:19:01.070 Emily Giant: and then it should be under spoilage.
174 00:19:01.620 ⇒ 00:19:02.440 Emily Giant: Yep.
175 00:19:04.170 ⇒ 00:19:04.930 felipefaria: Okay.
176 00:19:05.220 ⇒ 00:19:09.769 Emily Giant: And then let me check all the other things like the skew. Okay, the birdsong
177 00:19:10.390 ⇒ 00:19:14.340 Emily Giant: and the location is Galleria all right now. The dates.
178 00:19:14.980 ⇒ 00:19:17.589 Emily Giant: So adjustment date is 7, 9,
179 00:19:20.970 ⇒ 00:19:22.899 Emily Giant: and let me check yours.
180 00:19:25.090 ⇒ 00:19:26.629 Emily Giant: 7, 9. Okay.
181 00:19:30.550 ⇒ 00:19:32.010 Emily Giant: let’s find one.
182 00:19:32.680 ⇒ 00:19:38.979 felipefaria: Yeah. And the only thing is is like in this report we just need to
183 00:19:39.750 ⇒ 00:19:44.060 felipefaria: like, if I wanted to look at, look at it by week, right.
184 00:19:44.060 ⇒ 00:19:44.590 Emily Giant: Like.
185 00:19:44.590 ⇒ 00:19:49.969 felipefaria: What filter or field would I use? Because it wouldn’t be adjustment?
186 00:19:50.290 ⇒ 00:19:50.890 felipefaria: They.
187 00:19:50.890 ⇒ 00:19:51.290 Emily Giant: No.
188 00:19:51.290 ⇒ 00:19:52.090 felipefaria: Wouldn’t be adjustment.
189 00:19:52.560 ⇒ 00:19:53.909 felipefaria: It would have to be.
190 00:19:53.910 ⇒ 00:19:54.420 Emily Giant: Yep.
191 00:19:54.420 ⇒ 00:19:57.150 felipefaria: A custom field that you guys are gonna create or like.
192 00:19:57.620 ⇒ 00:19:58.630 felipefaria: Yeah, okay.
193 00:19:58.630 ⇒ 00:20:02.719 Emily Giant: Yeah, yeah, it’s gonna have to be that like,
194 00:20:06.310 ⇒ 00:20:10.730 Emily Giant: yeah, I’m gonna take expiration date from the lot table
195 00:20:10.960 ⇒ 00:20:23.549 Emily Giant: and you’ll be able to pull this information on the Ia level in the inventory adjustments table for now, and you’ll be able to pull it by location and product
196 00:20:23.720 ⇒ 00:20:24.715 Emily Giant: and
197 00:20:27.210 ⇒ 00:20:36.950 Emily Giant: lot. If there’s a lot in the in the one where you can’t get the suborder granularity, you can pull it with like less, and the expiration date. But in the table we’re looking at right now.
198 00:20:37.120 ⇒ 00:20:37.510 felipefaria: Not too much.
199 00:20:37.510 ⇒ 00:20:47.090 Emily Giant: So let’s let’s look at the other mark table, because that should actually have the dates you’re looking for, and they’re pretty easy to translate to one another.
200 00:20:48.110 ⇒ 00:20:54.289 felipefaria: Yeah, because the way that I look at the reports like the things that I need are
201 00:20:54.900 ⇒ 00:21:05.070 felipefaria: like, I look at a specific time period, right usually last week, but sometimes I will look by and by the month as well, and then it should be by skew, by Fc.
202 00:21:07.850 ⇒ 00:21:10.049 felipefaria: So, and it should be like columns.
203 00:21:10.190 ⇒ 00:21:16.299 felipefaria: columns for for Fcs. And then rows for 4 skews.
204 00:21:18.220 ⇒ 00:21:23.259 Emily Giant: So this, yeah, this table should only have one row, and it should be the netsuite lot.
205 00:21:23.520 ⇒ 00:21:29.770 Emily Giant: And we should now see, instead of prior when we didn’t see the non sale adjustments.
206 00:21:30.030 ⇒ 00:21:32.280 Emily Giant: We’re gonna see all those adjustments on here.
207 00:21:38.630 ⇒ 00:21:39.909 Demilade Agboola: Yeah, we would also.
208 00:21:41.870 ⇒ 00:21:45.699 Demilade Agboola: Yeah. So spoilage is that I think at the end of they will have, like
209 00:21:46.150 ⇒ 00:21:49.819 Demilade Agboola: all the adjustments and every single thing all in here.
210 00:21:50.210 ⇒ 00:21:52.209 Demilade Agboola: so it will be much easier to.
211 00:21:52.981 ⇒ 00:21:55.070 Demilade Agboola: We just have everything in one central location.
212 00:21:55.450 ⇒ 00:21:56.150 Emily Giant: Yeah.
213 00:21:57.130 ⇒ 00:22:00.669 felipefaria: Yeah, yeah, that works getting well, I know.
214 00:22:00.670 ⇒ 00:22:01.649 Emily Giant: I think you would.
215 00:22:02.360 ⇒ 00:22:19.199 felipefaria: It would be helpful guys in. Because one thing that I noticed right, and it goes back to and and what you mentioned about the shrinkage potentially being inflated, because so we know that some of those orders actually shipped. I was actually looking at a lot yesterday and
216 00:22:20.350 ⇒ 00:22:24.119 felipefaria: well, just like the the lot number Activity report in that suite.
217 00:22:24.390 ⇒ 00:22:36.609 felipefaria: And I noticed that essentially, we have a lot that, let’s say. And for that specific one had 40 units received on it. Right? So so the pos are 40 units. There was an item received for 40 units.
218 00:22:36.710 ⇒ 00:22:41.889 felipefaria: but then, if you add add up all the sales and all dias
219 00:22:42.010 ⇒ 00:22:47.130 felipefaria: that were made under that lot. The total quantity came up to 64.
220 00:22:47.820 ⇒ 00:23:04.060 felipefaria: So there’s something like now in my mind. I thought that a lot is restricted to the amount of quantity that is available in the lot, right? So like there should be a trigger there that it says, Oh, I want to make an Ia hey? You don’t have
221 00:23:04.480 ⇒ 00:23:18.100 felipefaria: available quantities to make that I? But it seems like we don’t have that safety gate in there. Right? So. And what I was gonna say is, since we have all the information there for a particular lot, it would be good to have
222 00:23:18.520 ⇒ 00:23:23.509 felipefaria: a column that is a reconciliation column, right where at the end
223 00:23:24.220 ⇒ 00:23:26.840 felipefaria: we should. Everything should be 0.
224 00:23:27.010 ⇒ 00:23:28.069 felipefaria: Everything should be 0.
225 00:23:28.070 ⇒ 00:23:28.440 Emily Giant: Yep.
226 00:23:28.440 ⇒ 00:23:34.990 felipefaria: If it’s not, then it’s an easy way for us to to check on problematic
227 00:23:35.640 ⇒ 00:23:47.010 felipefaria: lots essentially. And this would be some sort of like weekly. Q. 8. That we would do in a way to pull a report that where all the reconciliation is not equal to 0, essentially right.
228 00:23:47.010 ⇒ 00:23:47.480 Emily Giant: Hmm.
229 00:23:47.480 ⇒ 00:23:48.139 felipefaria: And some of the.
230 00:23:48.140 ⇒ 00:23:48.610 Emily Giant: So.
231 00:23:48.610 ⇒ 00:23:49.250 felipefaria: Would be.
232 00:23:49.250 ⇒ 00:23:49.630 Emily Giant: Yeah.
233 00:23:49.630 ⇒ 00:23:56.119 felipefaria: Because the adjustment still hasn’t been made. So let’s say there’s still some positive units there, and that’s because
234 00:23:56.300 ⇒ 00:23:59.370 felipefaria: they haven’t made this Polish adjustment, yet so so that makes sense.
235 00:23:59.370 ⇒ 00:23:59.760 Emily Giant: Yes.
236 00:23:59.960 ⇒ 00:24:04.200 felipefaria: But if it’s a negative adjustment, meaning that we have more
237 00:24:04.890 ⇒ 00:24:10.770 felipefaria: units in sales and adjustments than the item receipt, then we know that it’s something
238 00:24:11.030 ⇒ 00:24:26.359 felipefaria: different is something off there where shrinkage is probably inflated or sales could be inflated, and it’s double counting some suborders or something is wrong, right, but it would at least trigger, and it’s an easy way for us to look through everything.
239 00:24:27.190 ⇒ 00:24:54.390 Emily Giant: So I attempted to do that. We’re on the same page. I just added this this morning. It’s called Lot Balance, and I don’t think the math is right. But that’s funny that we’re both like just on that today. I think it’s where we’re at with the Qa. It just makes sense that, like this is our logical conclusion that, like something’s wrong with how Netsuite’s doing this, and we need a way to quantify it without us, like breaking our backs every time we’re trying to balance a lot. So if it’s negative 10, I’ll get into Dbt and see what the logic is. But spoilage is negative. 13.
240 00:24:54.520 ⇒ 00:24:59.060 Emily Giant: It should be as easy as saying, what are the total
241 00:24:59.666 ⇒ 00:25:17.489 Emily Giant: total sales plus total reconciliations. What I’m not sure of is, if it’s the negative number that’s like throwing it, if it’s like making it the absolute value or something, or if it needs to be the absolute value, and it should be like sales minus reconciliations, equals like 0.
242 00:25:18.320 ⇒ 00:25:20.640 felipefaria: Which lot is this? Let me see.
243 00:25:20.640 ⇒ 00:25:24.530 Emily Giant: Is lot. Number.
244 00:25:24.530 ⇒ 00:25:26.820 felipefaria: It’s 1, 5, 5, 1, 7, 4, right?
245 00:25:30.081 ⇒ 00:25:33.180 Emily Giant: Lot. Yeah, that’s the inventory number. Id. Here, let me send this to you.
246 00:25:33.490 ⇒ 00:25:34.220 felipefaria: Okay.
247 00:25:35.190 ⇒ 00:25:47.259 Emily Giant: I feel sometimes like I can write out logic and dbt, but then, when I have to do like really simple math, my brain just breaks there. What is the balancing math on this? It’s.
248 00:25:48.060 ⇒ 00:25:56.809 felipefaria: It should be, it should be quantity received. But but I see that in this example it says, quantity on order was 16,
249 00:25:57.090 ⇒ 00:26:00.140 felipefaria: and then received was 15.
250 00:26:00.320 ⇒ 00:26:08.490 felipefaria: I wonder if that one unit is a Qa unit, because
251 00:26:08.940 ⇒ 00:26:18.580 felipefaria: we usually the quantity like, and if the variance is kind of like, you know, a couple of units like this is usually Qa. But I see that there is no Qa. On this one right.
252 00:26:19.090 ⇒ 00:26:22.290 Emily Giant: Let’s see, there’s a column for that like received. Qa.
253 00:26:22.500 ⇒ 00:26:26.299 felipefaria: Yeah. So you see, quantity on purchase order 16. But then.
254 00:26:26.300 ⇒ 00:26:29.599 Emily Giant: Oh, yeah, there is. Qa, it’s only 15.
255 00:26:29.600 ⇒ 00:26:32.319 felipefaria: Oh, okay. So receive, good is 15. Okay.
256 00:26:32.500 ⇒ 00:26:34.929 Emily Giant: Don’t know why. That’s 0, though.
257 00:26:34.930 ⇒ 00:26:36.770 felipefaria: Let me see something.
258 00:26:37.660 ⇒ 00:26:39.400 felipefaria: 16.
259 00:26:40.190 ⇒ 00:26:43.839 felipefaria: This is, let me go to the Po itself.
260 00:26:48.740 ⇒ 00:26:50.030 felipefaria: We should make sure
261 00:26:57.810 ⇒ 00:26:59.549 felipefaria: this is the birdsong.
262 00:27:07.257 ⇒ 00:27:12.179 felipefaria: No, okay. So the other unit is a care buffer. And do we have a call.
263 00:27:12.180 ⇒ 00:27:12.700 Emily Giant: Got it.
264 00:27:12.700 ⇒ 00:27:13.729 felipefaria: And for care.
265 00:27:14.140 ⇒ 00:27:14.750 Emily Giant: Yeah.
266 00:27:15.230 ⇒ 00:27:21.630 Emily Giant: okay, that makes sense. I was like, No, where is it, though? So it’s not in presale care before.
267 00:27:22.050 ⇒ 00:27:29.249 felipefaria: Yeah, it’s not on the on hand. I wonder. I wonder if the buffer was removed at this point.
268 00:27:30.090 ⇒ 00:27:34.730 Emily Giant: It may have been, but there should be a reconciliation for that right? There should be some kind.
269 00:27:35.400 ⇒ 00:27:36.780 Emily Giant: That’s 1 thing.
270 00:27:38.080 ⇒ 00:27:40.040 felipefaria: Let me see.
271 00:27:40.420 ⇒ 00:27:46.670 felipefaria: Yeah, I’m still kinda not entirely sure how this care buffer is working netsuite
272 00:27:47.390 ⇒ 00:27:51.510 felipefaria: once they remove that care buffer if we’re able to
273 00:27:53.280 ⇒ 00:27:58.939 felipefaria: if we’re able to see it or not. Let me see.
274 00:27:59.470 ⇒ 00:28:00.740 felipefaria: Yeah, I don’t.
275 00:28:02.490 ⇒ 00:28:04.469 felipefaria: I don’t see it here.
276 00:28:06.860 ⇒ 00:28:09.140 Emily Giant: Yeah, that’s not great.
277 00:28:09.470 ⇒ 00:28:10.240 felipefaria: So 16.
278 00:28:10.240 ⇒ 00:28:10.740 Emily Giant: One.
279 00:28:10.740 ⇒ 00:28:11.500 felipefaria: And I have.
280 00:28:11.500 ⇒ 00:28:13.540 Emily Giant: Okay bottle.
281 00:28:17.350 ⇒ 00:28:20.420 Emily Giant: So yeah, that’s a weird one.
282 00:28:31.670 ⇒ 00:28:40.619 felipefaria: Oh, I see one inventory change by care here. It doesn’t really specify netsuite, but it does have a request like a
283 00:28:41.250 ⇒ 00:28:50.289 felipefaria: plus one, and then a minus one. But it doesn’t give me a lot of information on it. Just have me a document number 48 0, 5. I don’t know what that means.
284 00:28:51.870 ⇒ 00:28:54.070 Emily Giant: I’ll try to find it in the data tables.
285 00:28:54.320 ⇒ 00:28:55.170 felipefaria: But.
286 00:28:55.340 ⇒ 00:28:57.490 Emily Giant: We have an example of that now.
287 00:28:57.910 ⇒ 00:28:59.380 Emily Giant: So that’s good.
288 00:28:59.530 ⇒ 00:29:00.930 Emily Giant: Yeah, it’s like, every time we
289 00:29:00.930 ⇒ 00:29:03.949 Emily Giant: pull up a lot we find a new, a new thing.
290 00:29:04.640 ⇒ 00:29:15.259 felipefaria: Yeah, yeah, yeah. And I would wanna see exactly how this care buffer thing that’s factored into this right?
291 00:29:15.370 ⇒ 00:29:17.689 Emily Giant: In this case.
292 00:29:21.160 ⇒ 00:29:25.189 felipefaria: It’s minus 10 the balance. So let’s see where the minus.
293 00:29:25.190 ⇒ 00:29:27.710 Emily Giant: Bad math, though I have a feeling that my math is bad.
294 00:29:27.710 ⇒ 00:29:28.449 felipefaria: Yeah, because.
295 00:29:29.710 ⇒ 00:29:30.669 Emily Giant: What’s a team.
296 00:29:30.670 ⇒ 00:29:31.820 felipefaria: Received.
297 00:29:34.090 ⇒ 00:29:34.700 Emily Giant: Mine.
298 00:29:34.700 ⇒ 00:29:35.300 Emily Giant: Yes.
299 00:29:35.770 ⇒ 00:29:39.729 Emily Giant: Well, really 15, because we don’t know what the hell happened to that care bar.
300 00:29:40.650 ⇒ 00:29:41.090 felipefaria: Yeah.
301 00:29:42.690 ⇒ 00:29:43.460 Emily Giant: Minus.
302 00:29:43.460 ⇒ 00:29:44.240 felipefaria: Sales.
303 00:29:44.240 ⇒ 00:29:45.090 Emily Giant: Sales.
304 00:29:45.090 ⇒ 00:29:48.639 felipefaria: Of all the total quantity sold right. She’s 3.
305 00:29:48.640 ⇒ 00:29:50.320 Emily Giant: 3 plus 13.
306 00:29:52.190 ⇒ 00:29:52.810 Emily Giant: So.
307 00:29:53.040 ⇒ 00:30:00.079 felipefaria: To 16, which is almost there should be a minus one adjustment.
308 00:30:00.200 ⇒ 00:30:06.490 felipefaria: But what I’m thinking is that that 13, and, like what probably happened is they remove the care buffer.
309 00:30:07.250 ⇒ 00:30:12.540 felipefaria: And then it was spoiled at some point right.
310 00:30:13.600 ⇒ 00:30:18.399 Emily Giant: Probably now I can look at the different. So this is the beauty of the new table.
311 00:30:19.030 ⇒ 00:30:27.670 Emily Giant: I should be able to see every adjustment made separated in this table. Not not this one, but here.
312 00:30:33.160 ⇒ 00:30:35.960 Emily Giant: Oh, wrong one sorry. Dbt.
313 00:30:35.960 ⇒ 00:30:38.609 felipefaria: Oh, guys, I gotta. I gotta hop to another meeting.
314 00:30:38.610 ⇒ 00:30:40.030 Emily Giant: Okay. No worries.
315 00:30:40.030 ⇒ 00:30:43.919 felipefaria: But let’s connect. Are you out of office, Emily? Like starting.
316 00:30:43.920 ⇒ 00:30:54.657 Emily Giant: I’m out of office tomorrow, but I’m back on Monday, and I’ll communicate with them a lot about I I’m working all day today and then flying at night. I’m just hanging out at the airport and working
317 00:30:54.940 ⇒ 00:30:55.370 felipefaria: Yeah, but.
318 00:30:55.370 ⇒ 00:30:55.700 Emily Giant: That’s.
319 00:30:55.700 ⇒ 00:30:58.919 felipefaria: This table, and with this balance one it would be very.
320 00:30:59.270 ⇒ 00:31:06.270 felipefaria: because then I’ll be able to help with the reconciliation, and is an easy way to kind of find the issues right. The one thing that I.
321 00:31:06.270 ⇒ 00:31:06.800 Emily Giant: Yeah.
322 00:31:06.800 ⇒ 00:31:13.609 felipefaria: Out is the it’s kind of like the the care like. Why is the care like?
323 00:31:13.980 ⇒ 00:31:19.619 felipefaria: And how can we make sure that that care buffer was removed or not, essentially, from the system
324 00:31:19.890 ⇒ 00:31:32.899 felipefaria: cause. It’s still on the on the lot. If I look at the lot in that suite like the receiving lot. It still shows that one unit and the care buffer. But I don’t know if that if that unit was removed throughout the week after it was received.
325 00:31:33.500 ⇒ 00:31:35.100 felipefaria: But yeah, I’ll talk to you.
326 00:31:35.100 ⇒ 00:31:45.300 Emily Giant: The only adjustments. Yeah, the only adjustments on this lot are the 3 sales, and that one inventory adjustment. And if there was a separate one for the buffer, it would be there, so I have to look into that. But.
327 00:31:45.300 ⇒ 00:31:49.940 felipefaria: Yeah, check and check the the lot. Number activity as well.
328 00:31:50.765 ⇒ 00:32:00.550 felipefaria: And I’ll I’ll post you the in the link, because then there is one inventory status change from M. Valesa, which I believe.
329 00:32:00.550 ⇒ 00:32:00.880 Emily Giant: Okay.
330 00:32:00.880 ⇒ 00:32:01.740 felipefaria: Care.
331 00:32:01.970 ⇒ 00:32:02.760 felipefaria: Yeah.
332 00:32:02.760 ⇒ 00:32:03.290 Emily Giant: And that’s.
333 00:32:03.290 ⇒ 00:32:08.629 felipefaria: And it’s a plus one and then a minus one. I’m assuming that this is the care buffer.
334 00:32:08.940 ⇒ 00:32:09.870 Emily Giant: It is. Yeah.
335 00:32:09.870 ⇒ 00:32:11.932 felipefaria: Yeah. And I don’t know how this is
336 00:32:14.160 ⇒ 00:32:21.109 felipefaria: and and how we can make this a little clearer if there is a change from Dev in terms of how that is described in that suite.
337 00:32:21.110 ⇒ 00:32:21.490 Emily Giant: Yes.
338 00:32:21.490 ⇒ 00:32:24.880 felipefaria: So we can make it easy to translate this into into the reports.
339 00:32:25.460 ⇒ 00:32:32.886 Emily Giant: Yeah, alright. I’ll look into that. Then a lot. If you’re in transit, I can work on that. And then
340 00:32:33.430 ⇒ 00:32:39.859 Emily Giant: the deployment is like, you know, I’ve been sitting on it for like 3 days. Sleepy. I know you have to go. I’ll I’ll talk to you on Monday.
341 00:32:39.860 ⇒ 00:32:41.280 Emily Giant: Alright, and just
342 00:32:41.280 ⇒ 00:32:45.879 Emily Giant: I’m around. I’m not like, not like gone. So if you need something tomorrow, let me know.
343 00:32:45.880 ⇒ 00:32:46.690 felipefaria: Okay?
344 00:32:47.360 ⇒ 00:32:47.940 felipefaria: Bye.
345 00:32:48.100 ⇒ 00:32:49.000 Emily Giant: Bye.
346 00:32:56.900 ⇒ 00:32:58.500 Demilade Agboola: You’re you’re on mute.
347 00:33:02.358 ⇒ 00:33:05.029 Emily Giant: Okay, how many.
348 00:33:05.150 ⇒ 00:33:16.220 Emily Giant: I don’t even know how, I went on mute. I was talking so much doesn’t matter. I was saying, since you’re in transit, why don’t we? I can just work on this, and like the notes that Felipe gave me, and then
349 00:33:16.330 ⇒ 00:33:20.089 Emily Giant: I will submit that Pr. For you to look at tomorrow.
350 00:33:20.290 ⇒ 00:33:24.340 Emily Giant: and hopefully I’ll have time. Today. I don’t have any more meetings.
351 00:33:24.480 ⇒ 00:33:30.320 Emily Giant: Well, yes, I do. I have one more meeting, but hopefully, I’ll have time to figure out some more about how to like. Remove
352 00:33:30.420 ⇒ 00:33:33.180 Emily Giant: the orders that shouldn’t be on those lots
353 00:33:33.890 ⇒ 00:33:37.189 Emily Giant: from, because that seems to be like the one outstanding piece.
354 00:33:37.450 ⇒ 00:33:41.419 Emily Giant: The rest are like uncovering issues that don’t have anything to do with Dbt.
355 00:33:42.660 ⇒ 00:33:43.950 Demilade Agboola: Yeah, yeah.
356 00:33:43.950 ⇒ 00:33:44.840 Emily Giant: Okay. Yeah.
357 00:33:44.870 ⇒ 00:33:51.530 Demilade Agboola: Okay, can we integrate the the pending Prs now, so that we can.
358 00:33:51.530 ⇒ 00:33:54.300 Emily Giant: Yeah, I’ll I’ll do it right now.
359 00:33:54.300 ⇒ 00:33:55.090 Demilade Agboola: Okay.
360 00:33:55.280 ⇒ 00:33:56.129 Demilade Agboola: Okay. Sounds good.
361 00:33:56.130 ⇒ 00:33:59.240 Emily Giant: I’ll do that now. And then I’ll just ping you when it’s done.
362 00:33:59.960 ⇒ 00:34:01.130 Demilade Agboola: Alright, sounds good.
363 00:34:01.520 ⇒ 00:34:02.869 Emily Giant: Okay, I’ll talk to you later.
364 00:34:03.590 ⇒ 00:34:04.720 Demilade Agboola: Talk to you, sir. Bye.
365 00:34:05.300 ⇒ 00:34:06.210 Emily Giant: And.