Internal INC008246386 - AU SQUARE E2E capture-20240603 130305-Meeting Recording.docx

**Internal INC008246386 - AU SQUARE E2E capture-20240603 130305-Meeting Recording** So, what happened here, I taken the same scenario where inventory exists but serial is not updated. So, I have done the receiving without serialization SKU and that after that I have enabled the end to end serial se...

**Internal INC008246386 - AU SQUARE E2E capture-20240603 130305-Meeting Recording** So, what happened here, I taken the same scenario where inventory exists but serial is not updated. So, I have done the receiving without serialization SKU and that after that I have enabled the end to end serial serialization for that SKU. So, what happened I have chosen my LPN which is serial required. So, I have seen here 402 that is my LPN and I have a lotable value also and in my serial inventory my record is not available. So, what I did here I am using the adjustment screen to include serials but I cannot include directly serials. I need to be remove the inventory and then add in the inventory with the serials. So, for that I have removed this quantity, I just remove this minus 2 quantity for that SKU and locations and then add in once I save I need to be click on the finalize to done the adjustment. Once I did it I have one more adjustment to done including the serial which is you can see here I am choosing the same SKU and the LPN as well and including my two serials here. Okay, same logic with the same LPN? Yeah, with the same logic, same step I have done. No, same lot, same lot. Yeah, same lot, same lot and same LPN. Yeah, in the once I done this activity system had created the serials with the same lot attributes because I am safe using the same lot. Okay, so you can see here my lotable sinks also the same. Okay, when I trying to do this activity in the RF but I am not done it because I am getting the error here. Harish, just now your screenshot that one balance inventory is not a serial inventory is a normal inventory balance. Give you screenshot also. These two serials with the same lot and service SKU. Now you can see the inventory need to be capture catchment data as well because while end-to-end catchment data and serial also updated both tables are updated. Yeah, okay. So for this activity around 35 to 45 seconds it will be taken because we need to be remove the stock and then we need to include this stock with the serial. It depends on the user speed actually. This one don\'t have the excel outlook? Sorry, namakam? No, this operation we cannot using any excel to upload to do adjustment. Even I try to use this import feature also but here I have found one API. You can see here serial update in the adjustment and transfer. Okay, so I can just open that. Template also. Okay, this template. So it is not successful? No, no, it is not successful. I am getting error with the IO flag. I am getting error that one. I am trying to upload as well. I am showing you error as well. Invalid IO flag. Sorry, we only have half an hour. Maybe later you can find out. You can see here. I am getting this error. Invalid IO flag. Even I press I or O depending on my inventory. Like my inventory just received then I am putting here capital I. But in that case also I am getting the same issue. This is why you get the input check. Ever tried leaving here blank? IO flag. Have you tested? Yeah, I already tested. That is why I am getting error. No, blank. Blank. No I or O. Even if I put blank here. In the same scenario also I am getting the same error. IO flag. Invalid IO flag. Okay. Later you can check. Get the AM to check. See if there is anything. Can you quickly just go to the IF? What IF you want to share? For RF In the RF Using the same adjustment option. But when I include the Adjustment inventory The quantity here. But I am getting the error. Okay. I am also using the different option to include the serial. Like We have an option in the inventory control option. And there is an option Add serial to receipt. I am using that one also. But again I am pressing the error. Could not insert Into that particular Lot. So that is why From RF I could not complete the steps. Do you come across Any bug? For this? The first time I saw This error. Need to check. For this Australian request We have script to Make all these Adjustments. The only concern you have Is There are too much data. Too much data. I confirm with Rakesh. Because for the inbounding At least the serial inventory Table and the lot ID Need to be updated. So I say if that possible We are using datapack. Inventory serial table maybe we can. But for the lot ID detail We cannot know The mapping relationship Between the lot and the serial number. Because here There is no inbounding Process was performed. So they say through DP Is not the reasonable way. From Rakesh. Now it is not Say reasonable or not reasonable I want to know whether technically Can it be done. Because I see a lot of datapacks For this sort of serial Serial problem also. Cannot. Because if we have Like before the DP on the series Description. We have the Inbounding process. But this issue is We do not have any inbounding process. It is not a difference. Actually we do not have that data. We don\'t have the data. The inbounding data. We didn\'t perform inbounding. With the series number. So The datapack To upload To Pass the data. Difficult because we cannot Mapping the series number to the lot. To the lot Serial number. Do you understand? What do you mean to the lot? During receiving you already have the lot. But at that time Let\'s say The SKU has no end-to-end Enabled. Like what we have right now. So we are saving the SKU with the received. And it will generate the lot. And the series number Will be put into two tables. The inventory table And the lot ID detail table. But the thing is right now We have the series already In the system. And we cannot mapping back. Because in the past We do not have any series number. If we are using DP To add only the series number Into inventory table We cannot mapping back This lot and the series Into received detail. Because we don\'t know in which Receiving performs this Kind of series number. Also we have the Great number of series numbers If we want to put it. Which table You captured in receiving? I thought it\'s just a serial inventory. No. As well as the lot ID detail. That\'s the problem. Yeah, lot ID detail It means captured data. Haris, When you go through the adjustment Does it update back To which table? Haris, can you Write down the table that Just now Paolo mentioned? Which table? I can just quickly Go to the\... Paolo, can you put in the chat which table you say Yeah, I can. I gave the two tables Two table names One is the serial inventory And the other is Lot ID detail. Lot ID detail, right? Yeah. Also maybe lot ID header should be Taken to consider? Yeah, if it\... Lot ID detail is the one that we want to patch It\'s not\... Sorry? No, this lot ID detail Is the table we want to We need to patch We need to Do the DP What is the difficulty to update this table? DP can update The serial inventory And everybody is confident on that But when we try to use DP to update lot ID detail As well as lot ID header We cannot know The mapping relationship between The serial number and the already existing Because there is no receiving If we receiving During the receiving process The lot generated And the corresponding serial number Was mapping back to the lot At the receiving But right now, there is no receiving No, but Operation, the AU can Give us the inventory Which already have the lot And they will give us the serial number Based on this lot to update Yeah We have that information for you For us to patch They will Basically they will Provide us which SKU, which lot And what is the serial number To update They can provide? They can provide Just show you the They given the stock as well Yeah SKU, location LPN and lot And the quantity as well So here I can see the LO record is required Serial Let\'s say I have here So those Lot will required Serialization which means Around Sorry So for the column In yellow color, they can give the value To right? Yes The serial number they can provide Not ID detail Let me see the not ID detail Actually Here in the stock For required serial So here I can see 90 SKU And around 2000 lot 19 SKU 19 SKU, 2000 Lot And what is the serial number? 90000 Yeah 91000 around Too much Yeah too much Rakesh Prepare this DP Let me try to see for Rakesh Yeah Some stock is available In whole location Also If I see here The whole quantity Around 4K 4K is available In the whole We are using whole for Different location as well Hari you see total 19 SKU right? Yeah Can you do This Table Each SKU How many serial number Because The strategy is Every DP patch Must be complete For entire serial number Today I do few Tomorrow I do another few Can you check By item How many serial number Is this what they show here already For example this is 94 serial number This is 100 Correct For this SKU you can see The quantity is 94 But in the excel they require 94 serial for that SKU It can be Multiple lots Why some Serial required with serial number Some already got serial number Why some got serial number As I understand After this requirement They enable the end to end serialization For that SKU That\'s why you can see here the 86 Is available in the inventory The serial is available If some got serial number Some item didn\'t capture What does this thing mean It means Might be As I understand For this SKU Is not coming for Inverting That\'s why they cannot capture The serial for that SKU No I mean For Some they already Enable If they already enable Those Initiating capture So Will they Problem with picking No They cannot do outbounding Because If they enable end to end There is no serial for Alien picking operation To pick the serial number Because no serial number Yeah So for If before we can run out Of the inventory we enable the end to end Then they cannot perform any shipment Correct Then What they do now They will disable Again to finish Yeah that\'s what I suggest in the mail Make this two different SKU Slowly those existing SKU Gonna be run off Then from the day They can use the new SKU To import Customer SKU You can have different SKU This is not a viral solution Give me two minutes To explain Yeah I take the screen for two minutes To explain the table Just now I\'m serious Inventory table is okay Right now i search the header level This header table And this detail table The difficulty we are facing Is for each header We have a lot of ID key This key can have SKU And The IO flag The ID Also the source ASN key The receipt line So we have this information This is in mapping And also in the detail Using the lot ID key To mapping this two table So you see This is a serious number What we cannot know Except the SKU owner And lot We cannot make the relationship Between the two tables This two table using the lot ID Lot key Lot ID key to mapping each other So we cannot Simulate All this relationship In this two table Lot ID key is System generated System generated Yes This is why Hard to get all the relation Settled We cannot know Not only lot ID Yeah Lot ID header and detail That is the catch word data Right So all this data System generated during the receiving So we cannot simulate Then how about When we do Patch the serial number How we Do the patching How we do the patching For serial Serial key So Can you scroll to the left Left I am not sure There is a serial key When we do patching How we How we update the serial key Yeah We do the DP DP This table is okay We have this table Serial Yeah Only we Miss this data in this table Not the lot By ID dot Detail In this case For end to end case We need to be updated Lot ID header detail And inventory also Right Yes Yeah So How we do the DP Because we cannot You know Make the relation clear In this two table This is system generating No My question is Currently how we do DP for serial inventory Currently We don\'t do this header detail Yeah because currently The serial description Normally happen in This table And the inventory tables I mean the lot table Lot X ID Sorry Location X ID This table and SKU Location This three is inventory tables And normally the current description is Between this four table So we can say This four table is all inventory That means we are using DP Turning the quantity only in the Stock But this time different We need the DP to turning the quantity In receiving Not only in the static stock So we cannot know the relationship In this two tables basically The difficulty is here Because the mailing data In this two tables are generated System generated in the procession So we cannot know So what is the challenge Actually Paolo For the two tables Header and detail You see in this table We have this dollar SKU This is the Index or the primary Primary column for this table For relation Besides the SKU We can know this information We can even say send flag to I And the lot maybe existing According what you shared in the table As well as the IOPN And we do not know the ASN Because this table need to Also need ASN key And ASN line ASN Yeah Source ID and Source number can be Get from the lot tables Which I think We can store in the lot table 6 Right This value Source key and source line number We cannot generate From lot table Because this two value Generally refer to ASN number Or order number or adjustment number Or transfer number It\'s this number Not from the lot table Source key It means Yeah If you received the source number From ASN This source key will be ASN number But if you do adjustment To add the source number The source key will be the adjustment key Also if you ship this order The source key will be the shipment order Number Yeah But if we Using the data patch For Source key and source key number What is mean actually for If I using the data patch Is it the ASN number and ASN line During the DP ASN number ASN line is partial This table is recording All the activities like Dana explain Right Depending on what kind of activity Are performed Could be ASN Yeah In AU case We know there is no Serials right now So it will be a DP So it means my source key and source number Will be ASN number and ASN line number Here Here We don\'t capture We don\'t capture Serial number Only the detail will capture Yeah But we need to But Normal receiving the data Already captured here We don\'t need to patch this header table We need to Because in the receiving This header and the detail also Will generate the data Already have They have done receiving Only the receiving didn\'t capture the serial number Only the detail we need to capture Header already Already have Because they have done the receiving Maybe need to patch also IO flag Maybe the IO flag they need to They need to patch So do you mean that we set all the IO flag To I And make here all is ASN key And this is ASN line All is one Line one That record should be Already exist Maybe just take one example Harish we want to We want to patch We can We can know Which are source key We know which ASN Or Can you go back to This is Paolo Harish the Excel they have Did they provide the ASN number You can share the Excel Yeah I can share You know what I mean Paolo This table is This header already Have the record already Have the receiving record Maybe only the flag is not Update correctly because Initially they didn\'t capture the serial number That\'s why it\'s not there Even you can see here the lotable number It means the ASN number In the lotable 3 And to base on this lotable 3 To get the Yeah To get the This header And Corey maybe your data To check Maybe Corey this To see in the actual Table How this header and detail Look like using this Lotable 0-3 Lotable 0-3 To see the header and detail How the data look like This is only one part But anyway For the two tables They using the lot idk For relationship As the main key So this lot idk Is generated in the receiving By the system There is no this kind of information It should be in the Accessing table already right Let me try to share It means we cannot Generate the lot idk Dp We cannot generate or we can generate We cannot This is receiving system Generating we cannot know Dp is manual I think so We can use the number also Just hold on Try to write the data And count No Not by count No I don\'t think we We need to generate Can you go Go to that table Go to that database The header and detail already have the record We need to pass that To record Can you access Which table Which facility They are using Score Do you know I don\'t know right now But I can check with them Maybe you To the one that you have Do to adjustment Can you just go read That data See how it look Lotex Id Header Right I invited Rakesh into our session To see When I done the Adjustment through the Web UI In my table I could not see here See in the web For this STU Or for this LPN I have adjustment I have done the negative adjustment For two quantity and then I include The positive adjustment With the two serial So this LPN You can see in my Data I didn\'t see The system actually Update that table I see here Adjustment But in that case In that case also If I done my Adjustment in that location Or that for that LPN It should be shown here Right It should be showing here Catch data Yeah In catch data I didn\'t see for that LPN We can see the Serial directly So catch data is it Only adjust Only during receiving you show But subsequently It will not update this table If you If you don\'t see number It\'s a catch data Still show So it means In the catch weight data Whenever we do receiving or shipping That tables will be updated If I do the adjustment It means directly Adjustment in the serial inventory It means updated in directly Serial inventory tables The catch weight data Can you go If we have Serial inventory If this table It will update You have record is it When I perform the adjustment In that case This catch weight data table is not updated Yeah If you do If you do shipment Maybe later you do shipment See whether after you do adjustment Is the outbound Still able to work See whether it will fail or not Yeah So for For that LPN I can create one shipment And allocate that one I need to be check System should allow To keep the order Or not And you see the catch weight data Whether you have a record You have that means It works It didn\'t Adjust So Assuming it works You mentioned that 2 tables Is not required to patch Let\'s see If we only Update 1 table Serial inventory Adjustment table Adjustment Created adjustment Record Now you can see I have allocated that LPN I am going to Pick and after that I can Do the shipping Am I picking Here No you need to go You need to go Then you Know whether Correct I need to go to the I am using the search Picking and contrast Pick Serials Might be it\'s a full LPN that\'s why Serial is not asking DCPDQ Yeah Serial is Now I am going to Keep the order Yeah In that case system is allowed To keep the order The SQL right now status have End to end or not or outbounding Only outbounding series Right now The configuration is End to end Yeah End to end End to end Isn\'t asking for For the receiving Serial number where performance Shipping Because Whole pallet In that You will just take the whole Serial number unless you partial picking Then it will ask you to Scan the serial number Yeah system is assuming The full pallet that\'s why Not asking to scan the serial If it is Let\'s say my LPN is My LPN having a 4 serial But my order is 2 In that case system is Showing to that screen to Enter the serial number Which serial We need to pick So the way I see Maybe Ari can you List out For them to confirm What the table Is Adjusted or updated When we do the Adjustment I see that Adjustment table was Record created ITRAN created ITRAN table Then The serial Inventory updated Any More table Is it only this 4 table What I do Number List out what are the table is updated When you When you Do Adjustment Through system Is it Is it this 4 table and Rakesh also Confirm Let Rakesh know which adjustment You done Is it this 4 table And And AU give us this data Is it good enough For us to do a DP I think right now You can reply The mail marking The steps you performed To clearly You first using the adjustment To remove the inventory And the second Using the adjustment To add the inventory with series This is what we perform Totally on the webpage And then we try to Simulate all the shipping And it works only with 4 pallet shipping So this step by step Rakesh and I Gonna check The adjustment impact The tables how many tables was Impact in the adjustment Maybe only the inventory series inventory table Or other ITRAN table or anything That we need to concern in the DP According We have already passed the pallet According your Operational Rakesh So let\'s follow your operation To see the impacted Tables and To see your list in the mail To understand how many tables What are the datas maybe can be Handled only in the data patch Not refer to the Lot ID or lot header Maybe that\'s not necessary This is what we can do Yeah follow I don\'t know whether We need to check The code or through some Log to ensure that What the table is impacted From my side Can we do that? Yeah Harish share the step You let Harish Yeah Harish will show the step But I mean can Rakesh Check the back end To ensure that Because we probably know only This table will be updated But we don\'t know If any other table is updated as well To ensure the Integrity When we do a DP Because Thursday we need to feedback by them What is our plan And Wednesday Wednesday we need to Try to align with Korea Yeah This is our response So Today and tomorrow We need to do A study on this What is our What are the plan We can do Rakesh Hello Rakesh As Harish is online Actually It\'s a test That we can do the performing So do you need to Harish to repeat and go over The snapshot in the Excel Right No need to I can see the document I can understand Okay cool So right now it seems to work According to Harish operation But we need to know If this because of the number of the SKUs Or the records If this turn to a DP What related tables we need to do And what exactly the inputting data We require from the country And from the caller That\'s what we can do What we are expected to do As expected to do Rakesh Right Is that okay Nanguang, Harish, Rakesh Yeah Can we discuss tomorrow again Schedule a call to discuss Anything Harish Can provide details Yeah After this call I can share this Excel So Rakesh will know The status Okay Yeah Thank you Anything else Harish Can you ask them Some With serial number And some Some SKUs without serial number Some already with serial number Can you check those Is it have enable end to end And ask them How they If they have this type of discrepancy Some with some without During outbound shipment How they actually do the outbound shipment Is it they already Disable the flag again To allow The shipment Then enable back again Okay In current scenario right Because they have given the list Some SKU With serial number Some without serial number So You verify that SKU Is it now is enable End to end If they enable end to end So when they have shipment Definitely some Location without Without the serial number Capture So how they actually do the outbound Is it they disable The end to end To allow to do shipment first Then enable again You see what they doing now Okay You can offline chat with them Yeah Okay That\'s all