INC008246386 - AU SQUARE E2E capture updates-20240604 133323-Meeting Recording.docx

**INC008246386 - AU SQUARE E2E capture updates-20240604 133323-Meeting Recording** So they can do what they can do. Like for the for the SKUs having already inventory in the warehouse, yeah, yeah, in those SKUs for for those SKUs which are not having any outbound operation performed for those thing...

**INC008246386 - AU SQUARE E2E capture updates-20240604 133323-Meeting Recording** So they can do what they can do. Like for the for the SKUs having already inventory in the warehouse, yeah, yeah, in those SKUs for for those SKUs which are not having any outbound operation performed for those things they can do negative adjustment and also again they can do a positive adjustment by adding cereals, right? That can add cereals into the inventory. But in that case what happens is cereals will not get added into the Lortex ID because in Lortex ID detail the we can we can see record for inbound operation only when we receive not when we do adjustment, right? I\'m not sure you have to let let me know, yeah, like for SKUs which are not having any outbound operation for those SKUs they can do negative adjustment of the inventory present and they can again let they can enable end-to-end and again do positive adjustment by adding cereals, right? That can be good. Yeah, but they we are now we are discussed how to do DP, yeah, not adjustment. Okay, now, so the users they do not do operation so which we need to give DP for that. Yes, there is a purpose, yeah, this all the while we are discussing, yeah, how to do DP, yeah, what is your findings, yeah, what is the problem? Okay, yeah, like, okay, Namcom. So, for different scenario, yeah, okay, what me and Polo what we have seen is when for suppose let us think if the user has done negative adjustment and again positive adjustment then do you have some document to that we can follow through or each scenario what have you studied and what is the suggestion, yeah, what is the problem? Not document but what we have seen is Namcom. What have you seen? You definitely have something have reference, right, and do you have write anything, yeah, because you whatever you thought we have forgot everything, yeah, can you please now what are the thing, yeah, because tomorrow we have to discuss with the country, yeah, they have been saying that this solution have been delayed and customer have been quite annoyed, yeah, we need to feedback them by this week, yeah, so there is no time for delay, yeah, okay, okay, okay, so we have given time yesterday, yeah, what have you given, what have you studied, yeah, we need to know and what is your problem. Yes, yes, yes, I am explaining, I am explaining Namcom, like what we have seen is in lot excited detail, we get records only when we do receiving, right, so if we are going to give DP, then what we do is generally we can add the inventory which is present for the involved records, for those inventory we can add serials into the serial inventory directly. How about the adjustment, yesterday Harish has show you if we did the adjustment to the what you have suggested and we in the last yesterday meeting, you are supposed to understand what are the table is updated is we are going through this manual process, yeah and to understanding all this table what is updated, are you able to do the DP, yeah, so have you done this thing, yeah. Yes, yes, Namcom, yeah, I have seen, like for the adjustment operation when we do negative adjustment, then the inventory gets decreased in all the inventory tables and again, when we do again the positive adjustment, if we add the serials, if we add the serials, then system will increase inventory in inventory tables and also serials in the serial inventory, but not in the lot excited, not in the lot excited. Yes, you document all this what table is updated and what are the table you can do DP, yeah. The tables which we can do DP is for now, as already inventory is present in the inventory balance, the tables which we need to update is only serial inventory table, we should add the serials in the serial inventory. There is a adjustment table as well, there is a ITRAN table, why you are, why you are not talking about all this? But from the DP, no, but directly from the DP, we cannot do adding records in ITR and adjustment, because that affects more tables, like encounter table, we should also add serial keys in the tables, those things. Because you are from info, you represent info, are you recommending this thing? Are we avoid the data inequality? But I do not think we can recommend data patch, it is better if we can do operation only, that is. Okay, if you are the operation, do you think it is feasible? There are so many things need to be done, do you think it is feasible? You are the operation, now you are the operation, you are in Yasu. Do you think it can be done? My suggestion is, it is better we can go with the, we can go with the operations only, performing the operations in UI, not the DP for this case. I am saying that now you are the operation, you are the go to the, do you think you have the time to do? Okay, so how many lots are there for those queues? I think there are many lots, right? Yeah, there are many lots, around 1k lots and around 54k quantity, it means serials. Might be some serials will be available, but around 54k. Definitely, it is not do one time, but you have to be, by SKU, every SKU have to do at the same time. Paolo, I don\'t know if you have checked what have done, I don\'t see anything, just keep saying. No, no, no, you cannot say that, you cannot say that, let me share my screen, we will definitely do this test. We already worked on this, we already worked on this. I keep asking to share something, but I didn\'t see anything, he keeps talking. No, no, no, that is not the case. I try to repeat what Harish shared yesterday, right, in the webpage, right, with this I\'m using the negative and positive adjustment to try to swap or replacing the inventory, right, with the series number, right. So after the testing, I can see here, by that method, adjustment from the web UI, only this table have the changes, right, only this table have the changes, and the series inventory have the changes. You can see the edit time, right, it is today, today, I tried that. So, the lots of ID detail, which we worry about, that any relationship mapping to this kind of adjustment, but it turned out to be no. I don\'t know why it turned out to be no, you see the edit date, the latest one is 31, right, May. How about the adjustment record, right? Yeah, adjustment record, yeah, yeah, yeah, this, you can see that, yes, yes, Nangong. This adjustment, how about the iTunes? iTunes definitely have, because we can see here, right, iTunes definitely have. Yeah, that\'s also why we need to have study, this time what are the table is updated through the web UI, yeah, and what are the thing, and what is the problem if we\'re using the DP, update this, all this table, yeah. Yeah, but for iTunes, there\'s, I\'m not sure, you can correct me, but iTunes, it is trying to record something in here, in outbounding, maybe the series, if the series number in this table, maybe it works already, because according to adjustment, Harish proposed that there\'s nothing to do, only the series inventory table on series numbers, I mean, I might clear this part, I mean, because in the adjustment detail, there\'s no column to contain the series number, right, you can see, I\'m using the serial name as in 001 or 002, you can see in the adjustment detail, there\'s no column to contain the series number. But somewhere inventory will be updated, right, if you see. Yeah, yeah, yeah, so you see, you see. No, no, no, Paolo, once we, for the positive adjustment, we can get the serials, it is in ITIN serial, ITIN serial adjustment table, I\'ll say. ITIN serial, yeah, yeah, I\'m not mentioning the ITIN table or ITIN series, I mean, for the logic, I mean, service logic, if we can put the series number in this table, maybe we can select the series number, I mean, ITIN seems less important for the outbounding, right? Yeah, Paolo, you have to write down all the table affected, yeah, so tomorrow, we\'ll discuss with Gloria to see that whether we can have a special approval that we only update these few tables, but those other tables, you will not be affecting outbound, but you are affecting system integrity, in the sense that some data is not inside there, yeah, so in future, if you want to query, yeah, there are some historical logs, say that, okay, because this is a special patch, this table is not updated, yeah. So, later, if you have the same issue, the DP is going to be the workaround? What? I mean, this is a business issue, right? So, later, any warehouse have the same business issue, the DP could be the formal workaround? No, this one is volume is too high, it\'s not possible, yeah, it\'s not, that\'s why you need to have a special approval, that\'s why you all need to do a proper study, yeah, not say reject, they told me this has been delayed for six months, I don\'t know if it\'s true or not, yeah. Hey, I don\'t know if we can. Is this true, six months, yeah, if this thing, they escalate, why this thing have been, take six months to discuss, yeah, I don\'t know, is it true or not, yeah, this decade. Let me check the serious inventory, Rakesh, you have the table name, right, ITR and Serial, right? Yes, ITR and Serial. ITR and Serial, it\'s that one, right, let me go to search. That\'s why I need y\'all to help to do a proper study, yeah, and give ITR and Serial to understand the issue, yeah. Yeah, yeah, I got that, I got that, you see, I got that, definitely we have the ITR and Serial, but to try to simulate the ITR and Serial, yeah, like we can insert the records in Serial inventory table, but inserting records in both ITR and Serial could be some complex. We have to, this came. Hi, hello everyone, yeah, beside the real code about the iTunes real code, I also have another concern about this data patch, because now we need to add a source number in source inventory. Do we need to also activate the end-to-end setting of items after we add the source number? Because if we didn\'t activate the end-to-end setting, once the operation has some action, like the outbound, we will have the source discrimination issue, yeah, so my concern is that besides the source number being added into the source inventory and the other tables, do we also need to enable the end-to-end setting of related items? Because if no end-to-end setting, some discrimination, source discrimination will happen when I have some outbound activities. Need to enable end-to-end, I think need to, yeah, you can see the Serial, the Serial, ITR and Serial table contain the transaction, this is the three transactions I tried, and I think those transactions tried by RedCash. This table also need to be updated, yeah. That\'s depending on if we want ITR and RedCash or not. No, first, it\'s not whether we want or not, yeah. In terms of system integrity, this needs to be done, yeah, but if you have challenges to update this, then you have to bring out, then tomorrow we have to ask, have to present to Korea, because this issue, yeah. Can we propose something like this, you see? One of the tables will miss out, yeah. Yeah, yeah, I will do this, I will do this, definitely. I will reply the mail on the change of tables, right, scoop of tables change, right, by the adjustment, that definitely will reply. The thing is, is it possible for us to, using the circle to put some serial number only in this table, and then try from the web UI to see if all the auto-binding processes can work? What do you mean? I mean, because according to adjustment, we are, I mean, RedCash and I, we think that the only main table or critical table is this one. So, can we try to using, I mean, we\'re using the local environments to try to put some serial numbers into this table only, and then go back to the web UI to see if the auto-binding, all the auto-binding, I mean, the shipment, the order creation, pickpack, shipping, all those activities can be done. I thought this is what you have suggested, right? I thought you have studied that it will not impact, just like who told me, it will not impact the outbound. Is it right, Chris? Yeah, we want to check on that. I thought you have done that study already. Yeah, yeah, yeah, we want to do that. So, if that works. I thought you have already done, yeah. Even yesterday, we already talked about how many tables will be impacting during this activity. That\'s what Namco is already asking in the last part. No, today we just tested the adjustment and tried to summarize the impacted tables. And we can have some summarized and reply the mail. And we can propose to try this. Okay, we can try to try this. That means if this can work, then we do not need ITIN and ITIN series. Because this is really hard. I mean, we are not going to decide, but we will update the facts, right? Are you able to share with your info people? Yeah. Since you are not sure, yeah, I don\'t think we\... I don\'t know what are the things we need to test, yeah. That\'s why I just already said that, yeah, if we miss some tables to update, it will affect the system integrity, right? Yeah. Yeah, correct. And you said that it will not affect the outbound, yeah. So, if it\'s really not impacted, then we will bring to Gorilla to let her to decide whether it can be. It can be done, yeah. And what about testing a lot of functions? I don\'t know. Harith, can you list out what are the things we need to test, yeah? We are taking this solution, yeah. Yeah, yeah, yeah. I mean, at least Harith can help to conform with the warehouse, right? How they\'re going to use the outbounding, right? We just follow that, right? I know, Paolo, you cannot ask the warehouse, yeah. We are the experts, yeah. But they have the daily operation of outbounding, right? No, no, no. If we can know the outbound, then we can do it. They will only do the outbound, yeah. If we see the outbound, then they will test outbound, but that\'s how we see that it can be a lot of other functions. Other functions, other functions. If it\'s just outbound, can\'t you all test to confirm, yeah? Okay, okay, okay. At least we\'re gonna check, all right? After the manual circle to update some series into this table in local, then we can try to see created orders, pickpack, and ship, right? We can try that. Like, if we can know that outbound operation, then we can try this in dev or UAT. Like, if we don\'t update anything in Lautix IDE and ITRM, will that cause an issue or not like that? Okay, can you ask info also, yeah? If you\'re doing it for any problem, who is your supervisor or mentor? Like, I\'ll be asking KD or Narasimha like that. Mostly KD, as this is BA issue. Okay, KD is on, I don\'t know if you can reach him, yeah. Okay, let me also discuss this issue with KD, like how can we give a solution based on that we can do? Because if we know the outbound, the particular operation which they are doing, then we can test that and propose. If we don\'t know the outbound, then I\'m thinking if we get any issue in future, then\... No, outbound is just a straightforward, yeah. I\'m worried there are also other functionality. Usually, only particular for this, yeah, you can find out, but is that all? We don\'t care about others. No, like actually, when again, if users enable the end-to-end serial capture, automatically, system will think it as both inbound and outbound, right? So when doing, so now if we insert all the serials in only serial inventory, and if that inventory is getting done with outbound operation, then should see if the system sees any validation for that serial in inbound, right? Rakesh, yesterday, we already performed that activity, right? Even I performed the negative inventory, then do the positive inventory plus including the serials, after that, I create one order and do the peaking as well. After peaking, we ship out that order also. No, but how users do, for suppose, if they do some other outbound activity, you should know, right, for which it causes issue, for which it does not cause issue. Because if we complete the DP process, and if we get issue, then it will be difficult for us to rectify again, right? So what exactly you want then? Outbound process, it means which option they are using, they are doing the packing or not, like that? Like it\'s better if we know the outbound operation which they perform. So when I talked with the caller last time, they are creating the scenario like this, okay, and they perform the Shankar search peak, after that, they are trying to do the shipping. Without packing? Yeah, without packing. And in that scenario, they are found the issue, they are not able to ship the order. And also, they will perform shipping only from UI directly, action ship. Yeah, different testing they are doing from the web UI, but I\'m not sure on that. But different testing they are performing those activities. And also, Harish, I have also seen an other case, like in the 34 SKUs which was posted, some SKUs are having outbound operation as well. For those SKUs also, are they going to enable end-to-end? Yes. That is a different case again. So that\'s why we are sharing that Excel sheet. If you see in the Excel sheet, there is some quantity available, quantity in the peaks, not peak or allocated, but in the whole status, you can see. Can I share my screen to show you that Excel? Yeah, definitely. You see my screen? Yeah. You can see here, there is a 34 SKUs and this is the lot. So lot count is 949. In that Excel, the quantity is 55K, not 55K, yeah, 56K. In the allocated and peak, you can see here zero quantity. But in the whole, you can see here some quantity, 3086 quantity. But if you see, if I include the location, you can see here AU peak 2, might be that 8 lot is available, 8 lot is available in that peak 2 location, but not allocated or peak might be there unpacked that LPN. That\'s why those quantities are available in the peak 2 location. So I want to understand if SKU stock available in the peak status, then what happens? What calls will be coming? No, if the quantity is peaked, then as that is an outbound operation, we get, if that SKU, as this SKU is enabled with outbound cache data, we get outbound record in the lotxid detail. Lotxid detail. But when I perform this activity, adjustment activity by UI, in those cases, those serial are not updated in the lotxid header or detail, right? It is directly updated in the serial table and the iTRANs. Yes, yes, like after performing the outbound operation, like peaking, then only we get updated in the outbound, outbound in the lotxid detail, not for adjustment. Yeah, but our concern is my stock is available. Okay. So if you see in my location, my allocated in peak 2 is zero. Okay. In that case, if I do the adjustment for that location or that lot, what happened then? System can able to reduce the inventory and system can allow me to include the stock with the serials, right? After that, we can do the peaking as well, then packing as well, if you want and shipping as well. Yes, yes. So I want to understand what is the root problem here? Actually, we do not get any issue. Also, one more thing I want to highlight here, if my stock is in hold, okay, in that case, hold transaction will be coming in that scenario, right? So in that case, also, the hold transactions can be include the serial as well. If I see, if I see any one of the transaction, I have a elementary, the third transaction. So after adjustment and do include the serial, after that, that LPN can be a hold. In that scenario, our hold transaction or hold ITRN can be updated that serial. I\'m not sure because I don\'t know. We\'ve never tried this, right? On hold stocks, right? Yeah, because if I see the Excel, we have a stock in the hold location as well, right? So we need to be ensure that if it is hold, that quantity or that LPN, after some time, they can release from the hold and they can use it again as a normal process. So that scenario also we need to be consider. Yeah. So in this, do we consider the on hold stocks also be updated in one batch or we\'re leaving the on hold ones when they release the back to the stock again, we continue this activity. Arish, what do you think? Oh, for this, for proposed solution in that case, we need to unhold those LPN or location. Once we\'ve done our activity, they can perform again the hold as it is. No, I\'m not saying that. I mean, I\'m saying because of the hold stocks is another issue, right? Well, we did not do any adjustment test on that, right? On the hold stocks, right? So in our proposal right now, we can know the stocks. I mean, the normal stocks that can be adjustment, right? And I will summarize the result impact tables. It\'s okay. But for the on hold ones, we are not yet tested. So in this proposal, we\'re gonna test the on hold stocks and give the proposal together in one batch or we are waiting for the on hold stocks released back to the normal stock. And then we will do the turning work. Correct. Haris, we target the most first. The hold one, probably it can be on hold then do the thing. But now even the majority one, we still does not have the solution. Let us target on the normal stock first. Normal inventory. Yeah. But for normal inventory, I see they also got different scenario, right? Can you list the scenario? There\'s another sheet, right? Some with serial number, some without serial number, is it? I remember I saw that. Is it in sheet one? Can you go to the sheet one? Is it already have the serial number? No, no, no, not this one. I thought, is it the current inventory balance sheet? Is it inside here? No, I saw this one summary that, what the SQ already got some serial number, some without serial number. Here you can see in the current sheet, the new lot. Not this one, right? Not the detail. Sorry, I thought I saw in the email. They have given a summary, how many SQ, some with serial number, some without serial number, that kind of thing. Hold on, hold on. I just opened that. Are you talking about this email or Rebica one? This is the previous Excel sheet actually. And if I open this, this is the latest one, which is shared by Vignesh. That is the mail, so this is the mail, which I am referring to this Excel. So in that Excel, we can see some yellow and green. Not Harry, I am not referring to this one. Some of quantity on here. Let me see, this one. Those Are you check on Rebica\'s email on 3rd of June? 3rd of June. So in the 3rd of June. In this summary. In 3rd of June, you can see I got this email from Rebica as well and community as well. You send out one, you send out. Actually, you send out. You see in the chat, you do this story, is it? And so it\'s sent by you. You see in the chat, you got this summary. Yeah, that\'s one is the first email, which I am working on that folder. I can just share that in summary as well. This one, right? Yeah, so what that? Value of count. But that one is location category. How of item? Some of quantity on. Is this Manning? Oh my God. No, this Manning. 100 over SKU. Yeah, 96 SKU. And around. 2000 a lot. With Serum. Can you see from from this? Summary, how many cases are there? And all these cases, is it all the database is the same? Or or will be different database? So according to to the Excel, if you if we if I remove these serials. So around 97 K quantity. So it means 97000 serials need to be updated. So we want to see is it all the order? How many different scenario and? And how many are DP? Strategy that we we need. We need to have now. Or or is the DP is the same? Can you go back to that sheet? Can you quickly? I left 15 minutes. I need I have another call already. What I do here? Not not this one. The you see in the in the in the check this summary. Yeah. Oh yeah. Just also or just now you saw that list of the with the 100 SKU right? Yeah, yeah. OK, yeah, yeah. This one. No, no, you you expand the SKU with the SKU number. So I\'m just expanding the SKU so you can see the total SKU here. Yeah, yeah, correct. So 96. yeah from here can you conclude how many cases are there yeah i believe there are how many permutation is yeah that we need to do for example what does this thing mean uh this for example first sq right which we see number sum of quantity on hand here total count two this is this is a lot this is a lot this is is it this item for example item is totally without c number yeah so this one scenario yeah the other one is some item okay so we some with some without c number correct is it we only have this so is it we only have this two scenario if i see here and and follow uh is any other cases is it we only have these two two two data pairs we need to do into it i\'ve got the on hold one we we we we say we we will not look into it first yeah but without on hold is it we only have these two data pairs we are looking at yeah okay let me summarize the one Harish repeated or the first situation right i mean in the stock normal stock with adjustment we can we can i can summarize the what we we\'ve tested right and for the ones that you see with partial series number and maybe partial not we are not going to know how to do and as well as the hold stock right is another scenario right so for dp seems not so simple right but that let me try to summary what we have on the normal stock can possible right i mean i will summarize what we\'ve done on the normal stock by the adjustment but for the hold stock maybe a different scenario yeah yeah what are you going to show i\'m going to summarize what we\'ve done this two days right according to adjustment and will and after the operation i will summarize the impacted tables and try to point out what\'s the difficulty we we are not we are not easy to update it and at series table but we can update the series inventory table right so i will summarize those information yeah but can we find out uh uh if we are not updating some of the tables right what is the impact yeah is there any uh uh about able to are we able to do the up about right yeah harris can help help to to test also but you you have to this now the when you have to do one test cases for him to test now do the dp then he will try yeah whether a normal about how do you confirm with operation yeah is it a straightforward kind of about yeah picking whether we have problem with the picking and and ship right is any other loading required yeah that that i can check with the country what forces they are calling for the outbound rakesh also i think you better turn to kitty for some suggestion if we only have a serious table adding other risks in outbounding i don\'t think we get any issue because i\'m also parallelly trying the same in the demo like just i have done like now currently i have only cereals in the serial inventory um records for the cereals and logics idea i\'m trying i it is picked for now it is picked like when i do shanker search picks and again if i try the shipping operation it got worked so i mean everything is fine right for your testing right better check with the site or kedia make a backup i\'ll have a confirm with katie also so we are lack of the unholder stocks right for the for the stocks in procession i mean we saw located the picket picked that by the adjustment we can do right okay yes yes we can do right okay so the only difference is on the hold for the stock right yes but better like for each and every uh like each and every case how we get in production that i\'ll try to see in dev and prepare the dp yeah okay so rakesh basically um there there could be an option option that in order to generate it it and it and serious records in order to generate so instead of directly gave the series number into the the table maybe we can try to using dp try to simulate the adjustment operation what do you think i mean using dp to create adjustment and using dp to insert records of adjustment detail and then let the user from the web ui to perform the approval and the finalize in that case the itin and itin series will be generated by the system automatically right yes yes there could be an option right i mean instead of giving the series directly right we can using dp to give the adjustment record we can we can discuss in this later i mean no the how are you able to create adjustment record no that that can be a difficult thing like giving you can just update right here we can using web ui to create a adjustment record and then using that uh adjustment record to adding adjustment detail right the the adjustment key you can you can automatically get the the counter right yeah uh mike mike can you a voice yeah yes yeah because they they uh follow and like i said that the dp we cannot uh we cannot get the the adjustment key yeah i thought this one is part of the like that kind of like store procedure kind of things that you you can you can get the the key and update back yeah when you do do something to do a dp yeah um yes yes can be done right yeah yeah then why why rkc cannot be done you know but uh create the empty adjustment in web by web ui also can i think not not true the dp counter table to get the key that\'s difficult right i\'m showing that right you see here maybe we can create an adjustment key right with this key we try to keeping a number of adjustment detail right we can using dp try to try to insert adjustment detail with the data we want to modify and then to see if from the web page that the user can do finalize right i mean in that case all the itin table records going to be generated by the system right uh-huh you got that right rakesh right actually this could be a way i mean instead of dp inserted records into this table right no no we we have a conflict there but suppose if if we insert all the itin records but there uh no no serials should be added right they should add serials and then they should save so so you are saying to add the serials automatically into the itrn serial and adjustment detail yeah the only thing is the serial i mean in the in the into this table i i tried before and we can see the series was added here i mean in harish also right you see here is from where the serial number is yeah yeah if it is end to end then yeah yeah so the only the only missing part is here i mean in this adjustment detail this table does not contain a column to contain this part so the ui i think when we when we\'re saving the adjustment the ui just to push this serial number into the this table directly so no nothing was recorded in adjustment detail but the thing is in that case the adjustment detail table and this table gonna be two tables that we need to you know using dp to update if we want to keep the system to generate the itin am i clear i mean if we can create a big adjustment and let the user to to approve and finalize then the system will generated the itin and the series number series itin instead of manually created everything right yeah you want to follow let me confirm something uh how is that when when we do the the adjustment right you say that we have to deplete the quantity minus three first then we create a plus three do you mean we create a plus three the serial number also at the same at the detail is it at the same time at the same time yeah in this yeah is the same time even if you do not include the serial system cannot save the record but before you add the the serial number do you need to configure say that is end-to-end yes i need to yes i need to be configured end-to-end if it is end-to-end then then only this add serial option will be coming if it is not then this option is not coming to enter the serial okay so so paulo you give a i think a suggestion that uh let me we we our dp will try to create a adjustment record to to deplete the stock for operation yeah we also create a record of the serial number no no need like uh okay let me because it\'s too bad and we we can actually although the the what are the configurations are not changed to end-to-end right we can actually create the record with the serial number also right maybe you all try yeah try to create then we try because because the adjustment detail table contains those information but not contain you can see here this is why i searched the detail table but the what you guys please uh harry say that once you configure that is end-to-end the screen already display that you need to end uh capture the serial number yeah so this serial number is come from where maybe you have to check how that this serial number is it capture in where when you create the record yeah when you create the adjustment record right this serial number is stored in where yeah yeah exactly that\'s the point yeah because after executing it\'s it\'s not here right but uh in the page i don\'t know i mean that would be possible can mic check this thing okay let me check in the adjustment screen yeah i need to leave in two minutes yeah i think uh if we can do it then after we create already then then the operation will yeah we borrowed the adjustment right we don\'t need to insert the erasing we bought the system adjustment right you got what i mean right i i i prefer we can create the adjustment down the stock and also up the stock with the serial number at the same time yeah so that we don\'t need to wait no need to wait for them to to to finalize then you ask you to do the the stock because this thing has to be done within a day yeah better we we created the record but let the user to finalize from web page because this finalize may be generated at the end key yeah all right i don\'t know we will let them do the finalize but what i mean if you can do it minus stock create the minus stock adjustment and also up stock yeah no need to do that right only one one batch yes at the same time yeah then they will then they will spend the time yeah yeah only click the finalize right yeah because if we if you say that we cannot create the dp with the adjustment and the serial number then we have to wait for them yeah that\'s that\'s the way my so only only thing we can try to simulate this adjustment right yeah can you uh we can we left one hour mike i don\'t know you i have time to check we left one hour can you free check then uh tomorrow uh we have a discussion again yeah how do you arrange time first yeah we go there involve also okay when okay i can check the timing as well yes also same time late afternoon because i think the morning maybe we still need to do some alignment first yeah then to the end of the day i can check with you as well what is when we set the call for tomorrow just one more message yeah mike are you checking then uh let us know in the chat yeah then follow you follow you all and try yeah no worries yeah but but this thing you still have the same problem when you create a dp you the adjustment counter you also need to need to take from the system to to create like yeah you still face the same thing if you still cannot then you\'re checking how to do it yeah only different is we only have one adjustment key the rest are all adjustment detail right because the counter only generate once with one key so we can put everything in under this key with details no i think it should be one sku or one one i don\'t know whether you want to ask you or one location yeah yeah so you may have a multiple adjustment yeah or one sku one adjustment i don\'t know yeah yeah so so need i to reply the mail to summarize the twice adjustment process we have or i don\'t i don\'t need to reply the mail no no need i think your this approach i think it\'s good but you see rather okay okay okay okay so to avoid the confusion right let\'s let\'s working on the adjustment okay this part okay okay okay thanks thank you I just want to know where it is stored. If I know where it is stored, I can compile the data, right? I didn\'t figure it out. There are 90,000 in total. I just took a look. I don\'t know if it\'s right, because I don\'t understand. There are 90,000 XQs in total. They need to be added. The user will provide Excel to give all 90,000 corresponding XQs to us, right? It has already been given. I see that Harris has a lot of tables. Isn\'t it all empty? But he will give it. He must give it. His statistics table is made of tables. There must be a lot of data in sheet 1. I don\'t think there are all 90,000. Some parts are there, some parts are not. There are 97,000 in total. There are only more than 6,000. There are 90,000 without it. Yes. If there are 90,000 without it, I see that Excel did not list the ones that should be listed. When you start to type in coins, it must need each one. It is equivalent to this DP has 90,000. It is equivalent to this DP has 90,000. I guess 90,000 is not enough. I guess it needs to be divided into several adjustments. Yes, it needs to be divided into several adjustments. In the end, Nanguang said, if it is not enough, it needs to be divided according to the XQs. 45, 35 XQs, right? The adjustment kit is easy to find. You just need to click once, click through, and it is used. It can be used. Yes. It is easy to write in SQL. He also asked a question. Is this adjustment useful for the on-hold inventory? Is this adjustment useful for the on-hold inventory? It does not matter. It should be the same. You just need to add it. It has nothing to do with the on-hold repository. It has nothing to do with sales number. You just need to add it. He also asked if the allocated peak state is useful. It should be fine. It is just that location and LPN have changed. It does not matter to serial numbers. Next step, I think it\'s fine if we don\'t check the ITI and CLS tables. Do they need to be there? So Nanduang insists on having it. If they insist on having it, we can only throw away the one we discussed. Let\'s put the simple DP first, right? If there\'s a problem, we\'ll talk about the next step. If there\'s no problem, we\'ll talk about it later. I think ITI and CLS are the same. It\'s about the changes. Where do they move from? For example, when you save a history, what does it look like when it explodes? It\'s the same as ITI, but the SN number changes. If you can\'t save it, it will save a history in it. I\'ve never used this table for DP. This table should be\... This table shouldn\'t be used for DP. It\'s hard to get the serial number. You don\'t know how many times it\'s been operated. You can\'t do this. It doesn\'t matter. But it doesn\'t have anything to do with the source key. How do you type it in? Yeah, you can\'t type it in. There\'s another thing. The SN is already in the system. Has the user recorded it or not? SN should be unrecorded. After it receives the ASN, is it in the LotIDDetail table? Yes or no? No. If it\'s there, it feels like the user doesn\'t provide it. You have to find it from the received database. Connect it. It should be easier to write. Let\'s directly find it. Let me see if I can find it. There\'s another thing. Let\'s not talk about this alone. There\'s another thing. Nanguang said it\'s been 6 months. I think it\'s only been a few days. Why did it become 6 months? 6 months? What do you mean? Didn\'t Nanguang say it before? Oh, you didn\'t come? I was a bit late. He said it\'s been 6 months. Damn, it\'s only been a few days. The user started to activate it. It\'s been so long, but it hasn\'t been released. No wonder he was rushing me. I think that\'s what he meant. But it\'s only been a few days. What\'s the problem? They must think it\'s hard to do. So they didn\'t turn it over. And they can\'t turn it over. It\'s a demand. It was recorded in the email. The client said it was a demand. It\'s not easy to turn it over. So they can\'t find AM. They can\'t do it. If they want to provide it, they have to provide an example that includes 90,000 SQL. And it\'s not just a P number and an item. They have to give the IP and ID. They have to give them all. They have to get all the records in the sales management table. Yes, yes. Sales management table. Let me see the record. And the adjustment has to be done first. It has to have two adjustments. It doesn\'t need to do that now. Didn\'t he say that when we discussed this morning, he said he would simulate and generate the adjustment. Then the client would click on the page. Then the data would automatically go to these tables. We don\'t care about the printing relationship. Now there is a storage that needs to be added. It has to be reduced first and then added. Is that right? Or does it need to be added directly? Yes, yes. It\'s equivalent to adding two details. You delete it first and then add a detail and then add a serial number. That\'s it. Anyway, it\'s just one thing. For him, he doesn\'t dare to do it directly. But the detail has to be done twice. Does the end-to-end hook or not? If it doesn\'t hook, then the adjustment page at the bottom\... If it doesn\'t hook, it doesn\'t report an error, right? If it hooks, it doesn\'t report an error, right? If it hooks, it doesn\'t report an error. I didn\'t report an error when I tried it at noon. I can delete it. That\'s fine. I didn\'t report an error. Let\'s try it again. I remember I didn\'t report an error when I did it at noon. I actually found the table. Should I send it directly? Yes, you can send it to the group. Then Rakesh and I will go through it together. Okay. Actually, let\'s find one or two and try it on the first page. The key is that the main time is to find a tool to help Rakesh compile these circles. But Rakesh should have a tool. I think. Actually, Excel is also good. Just use Excel to pull out the necessary paragraphs. After pulling it out, just copy it directly and use a stable editor to compile the circle. How many lines are there? Let\'s divide it into a line first. How many lines are there in a line? Next time, I\'ll just write a small function to type db. I\'ll just write a small function to generate the circle function and execute it in batches. If you can do this, we can also set up an LTE network. The key is that normally, there is no such large volume. How can there be such a large volume of db? So, even if it\'s this thing, I suggest you take it apart. Let\'s do it one by one. If there is a problem, we can correct it. Don\'t do it all at once. There are a total of 2,000 SQUs. 90,000 quantities. Yes, I think this is the most. Let\'s pick an SQU and do it. Then it\'s all right. You can do it one by ten or whatever. Don\'t let us solve more than 90,000 problems at once. It\'s too risky. I\'m going to start writing db circle. I\'m going to throw up. Can you sort out 90,000 of them? He can\'t do it one by one. That\'s right. It\'s easy for him to do it. I don\'t want to do 90,000 at once. Because it\'s no use. The next day, it will change again. LPs and IPs will definitely change. You lock these 1,000 first Then you tell me you\'re done. Then you move these 1,000. Or you lock a SQU first. Don\'t move it. When you\'re done, you move the SQU. You can think about it. You have to work together. It\'s not a big problem. It\'s not a big problem. The main thing is that I\'m I\'m going to die. I\'m going to die. One SQU, one SQU. It\'s going to die. It\'s going to die. Yes. Who said DP is simple? I really can\'t understand. Who said DP? There was a country IT before that said DP could do this. Then I\'ve been thinking about DP. It\'s no use pushing it. The solution says DP. They don\'t want to type on the page. In fact, there\'s no problem typing on the page. DP is just as complicated. The premise is that we\'re going to If it doesn\'t work, it\'ll be even more troublesome. Let\'s talk to the Racket group. I think they want to know what the idea was. Adjustment detail, right? That\'s called adjustment detail. That\'s good, that\'s good. I\'ll hang up now.