The order against my people's CCVR approval hasn't even been placed. How did you finish it? Tell me. Afghanistan. Sir, which one is this? Did you do it? Afghanistan. We haven't even received our customer's order. Why did you finish it? In export, it's the same. Our pricing. And in the case of export, one thing is that no VAT is added here for export. Nothing happens here regarding VAT. Suppose we considered an amount of ten. Why will it show here? I said that there is no work for VAT here. Okay? The one who cuts the order for this, it will be on their side. Right? Sorry, this... Does it show anything on your end? If the system was there, it would show. I can see it. In that case, give the requirement by calling your distribution manager. I can't see this thing. I can't understand it. Faria, our export user is Mahfuz or Mustafiz, I don't know the name. Whatever has been done here was done according to your requirements. I don't remember. We didn't set the requirements for anything in this system, did we? No. We are making it. You are the ones who want what we should make, right? Or your authority wants it. Yes, yes, 'another invoice pending' means the activity of the one you approved before hasn't finished yet. You have to understand from there. But it hasn't happened. Yes. Okay. If everything is opened up, we can see who eats what. Look, I have all my CST 001. Minhaj, Minhaj. This is a world of invoices. For example, this export order. Another user actually manages this. Okay. So under him, all the export customers that are there, okay? They are all on this side. For example, in your other countries, they work with customers like Ethiopia, Sri Lanka... Nairobi... works with all of them. In export, there are quite a few things, like an export order needs a title. Okay? A title that we've seen. A title is needed... unit type. How will they take it? In base or last cost? Meaning, what type will my unit SKU be? And currency. Here we provide the currency. Usually, it's in USD. Then this dispatch depot, we specify who will give me this export order. Usually, they give it from the Dhaka depot. And they specify the shipment. Okay? What type will it be? FOC. This FOC means Free of Cost. Okay? Meaning... what is called a bonus. Okay? Maybe the quantity given was 100, and out of that, ten will be a bonus. So here they mention the percentage. Maybe 10 percent of the total. Okay? As a bonus. If this is given, then it will be applied to whatever is added here. Let's go to the product. And the products for export are created in the export batch, meaning, in the code. Okay? And this is your... what's it? We have Kenya, Nairobi. Therefore, KN. KN. Look here, KN. Okay? Therefore, these have appeared. And here there will be no... what? There's no work for VAT. Okay? Yes, direct pricing. What did we use for the pricing? USD. Okay? In USD. And then what will they do? They will say that if there is some FOC here, the FOC will be applied when it's finalized, then it will happen. One hundred... well, for one, it doesn't really happen. For example, what will happen here? For example, I said this is one thousand. One thousand and... they specify the rate, that this rate is our converted TP. Okay? The converted TP of this product means we have considered a... we have kept an exchange rate by default. Okay? They... meaning... they tell us when it's needed. Okay? We change the exchange rate then. They usually don't need it. It's set to 86. And here, for example, it was said for this export product, maybe they said I will take it for one dollar. Okay? One dollar each. Meaning one thousand taka. Okay? For this one too, they said no, they will take it for point five. This too, we considered as one thousand pieces. Okay? And for this one too, they said they'll take it for point five. Okay? What need do I have for your depot? One thousand pieces. Okay? And in total, it will be two thousand USD. Okay? For which we show the BDT value, that this is the amount of the BDT value. Okay? So what will it do here? Look, here's the FOC. It's set from now on. They will get 100 each. Okay? One hundred out of a thousand. If this was five, then it would be two. Fifty extra pieces have to be given for each. Okay? That you buy a thousand tablets, and with them, fifty pieces have to be given as a bonus. Which has no pricing. Okay? This is our export screen. Okay? A separate user uses this. Okay? And this also has... it has verification. Only after the final verification... the depot that is mentioned, for example, Dhaka depot. Then it goes to the DIC of the Dhaka depot. His job is to approve that. Okay? And here too, we've kept it very simple. But in the back end, the big things are there. Okay? Because here you have currency conversion, here you have FOC management, and here... this unit rate and SKU UM changing, all of these can be controlled. Besides this, here too, additional information, attachments, etc., whatever is necessary, everything is captured here. After being captured, it finally goes to a draft order. Which waits for verification. Then after that, it goes for your approval. Okay? This is our export order. Okay? Then I think, what else is here? Then... these different orders that we talked about. The order is not only from placing from the app. It's also done from the web. Based on scenario and requirements. Because for these, we don't have a separate sales force. Therefore, it's at the depot end, for example. The person who is in export, he has a separate department. He only manages these export orders. Okay? This is our... I mean, the variation of placing an order, I showed it. I gave a demonstration. Are there any questions here? No no, it's clear. Alright. If everything is fine, then we will now move to the next session. Our Faria. Okay? Faria will... what will she do for us? We will talk about this return order. What is a return order? Whenever I have given a product to a chemist. One month, two months, three months. At the chemist's, maybe it didn't sell. Okay? The DGDA's rule here is that a company's product, okay? It cannot remain lying around in a shop after it has expired or been damaged. That company has to take it back. This process of taking it back, this is what we call return... defining as an invoice here. Sumon bhai. For the return... sorry. Okay, I have a question. I need to know. Since you are talking about the database and all, your... the test version of Oracle, has a sandbox been created for it? No no, a sandbox has not been created. Okay. If you want, can you create a sandbox version for me? For that, I will have to talk to Arif sir. Okay? I think... we were wanting a copy, to give a copy. So if we got the copy, maybe we could have created a sandbox version. Because if we want to integrate it with AI or save the version in another version, then we need to understand specifically how complex it will be to convert it or what things can be converted. Which layers, meaning, a total huge analysis is needed. Yes, I understand. I understand this. Then I will talk to Arif sir and see. Please talk. Because for me... yours is 300 GB. I have a lot of space on my server. So if I am given a copy, then I can start my next tasks with my developers, regarding AI integration or documentation or whatever tasks there are. Because I actually don't want to touch your work. I understand. Because there's a matter of trial and error here. Which can happen. Okay. If this is done, it will be better for me. Okay. I will tell Arif sir. Actually, Arif sir plus our Rasel saheb, Rasel bhai, he mainly looks after this. Okay? I will tell sir. Okay? Approximately how much longer might you take today? We are here until six o'clock. Oh, because let's finish it. Because we have... I mean, a lot of features. Okay? Among them, I... I will say again that whenever I am demonstrating some feature, then I am skipping one, two, three business processes here. Because if I go to explain those, then I will need a lot more time. Okay? I mean, I... just... what can I say? I'm trying so that I can define the 70 percent business process that is within this. Okay? Some I am skipping, some are being missed because that scene is not coming to me. Okay? For this reason. Okay? But otherwise, if I want to show it extensively, each feature will take a huge amount of time. Alright. Okay? So, let's go now. Faria, please share your screen. Okay? We already said what this return thing is. Bringing back a customer's leftover product to my company, which has been damaged or has expired. And giving them another order for free against an equivalent amount of money for the returned items. This is the life cycle of a return invoice. Okay? First, we will bring it back, we'll see that. Then we'll give what against it? An order... a free invoice. Okay? Of that equivalent amount of money. Okay. Faria, please. Please carry on. Is my screen off? Okay. Sir, you also share... You can stop it, I think. I have turned off... Haven't I stopped? No problem. I'm doing it. No problem. I'm turning off screen sharing. Today we will cover return, for products that are damaged or have expired... So before initiating a return... mainly the SR, by SR we mean Sales Representative, we also call him DA. Delivery Assistant, Delivery Associate, I'm not sure. Anyway. The DA or SR, usually our customers call them or tell them that, 'look, I have some of my products' from NJPL. You take the return. Against the return, some payment is made to them. So, the SR who will take the return, which SR will take the return from which area, that depends on the monthly delivery plan made at the beginning of the month. In the monthly delivery plan, we had assigned Rubel Mia to the Dhaka 20203 territory. So if he has delivered in a territory with such a delivery plan, then he can take returns from the customers there in that month, meaning the SR. So I am showing the return process from Rubel Mia. If Rubel Mia clicks on 'Return', he can see the return history. Another thing is there's a plus button here. If he clicks the plus button, the customer list comes up. So he can see the customers of the territories he has been assigned to. So since I... let's choose one. SN Pharmacy. For example. From SN Pharmacy, we assumed that he will return Avamys Nasal Spray. So I took Avamys Nasal Spray. Here, while returning, at the time of selecting the quantity, one has to select the batch. So if we click on the quantity in the batch, a list of the product's batches will appear. So usually we see the product, and that batch... not us, but the SR sees the product and inputs that batch. So I assumed that for batch 0022N, the expiry date is 31st December. Everything is visible here: when the manufacture date is, when the expiry date is, what the batch quantity is like. And the price, all of this can be seen. If you click here, the quantity I then... if I assume I had ten products. Then this... if I click save, it will be able to give this batch number for Avamys Nasal Spray. It's saved. We can draft this or, suppose we have another product, Starcal-D tablet. If I go to Starcal-D tablet, if I give the batch number... Say for example... let's give some more... I'm actually looking for one whose batch has not expired. Faria, everything here is expired, why? Isn't our data very old? It will show everything as expired. It detects automatically. Whenever we go to one, you'll see 'E' and 'D' are given. It detects automatically. That it's expired. Okay? If we want, we can click on the switch. Click on the switch. Make it damaged. It's damaged now. Okay? Therefore, the user can change it if they want. Either damaged or expired. But what does our system do? The product which... for example, this is from '22, 2022. Okay? Now if this was from 2025, then it would automatically be selected as 'D' for damaged. Okay? We can also take multiple batches. Here, I found it. So the main reason for showing these two was that the expired product ultimately shows as expired. Meaning, it comes automatically. And the ones that haven't expired, they automatically show as damaged. In the reason, 'E' and 'D' are for expired and damaged. So I assumed that ten of his products are expired and ten are damaged. This is in the case of Starcal-D. If I click save, it will show me that in total, he is returning twenty Starcal-D products and he is returning ten quantities of Avamys Nasal Spray. I can add by clicking 'Add New Product' here or I can change the quantity by clicking on these. If I give a draft order, a reason has to be given. I gave the reason as 'Return, Damage and Expiry'. D and E. Sir, it's not letting me return. Okay. It's done. Okay, it has been drafted. Now, as a sales representative... Sir, this... in the products... Let me take another product. No, there shouldn't be a problem with the product. Sir, in the product... One minute. In the test, which app did you take for this? Test, sir. Sir, that... in the product's pricing, if there's a problem in some column, it quotes that. Sometimes. No no, it doesn't do that. In the test data, there are some anomalies. This... in my test... Since we do so much work, there are anomalies, yes? I'm looking, please stay on the line. The last one that came, stay on the line, I'm looking. Okay. Okay, this... I am discarding this, okay? I discarded it, okay? Yes yes, if the base TP is null, it does this. Okay, just a moment. Take some other products, okay? Last time, I think the product I gave didn't have a problem. I think... Okay, let me try with Montiva. Okay, let me increase the quantity a bit more because since I want to show a replacement order, it's better if I increase it a bit. Let's see if it works with Montiva. Yes, this has been drafted. Now if we want, we can update it. Update the quantity... can be done. If we want, we can update more product batches or... After updating. Yes, multiple products can be taken here, and multiple batches of the same product can be taken. Because multiple batches of a product are sold. Okay? We have handled that thing here as well. Take another batch of Montiva then... Okay. I'll take another batch of Montiva? Okay. Let me take ten of these. That's 110. Yes. I think there's a problem with that batch, sir. It's not a problem with the batch. Just remove that batch. Take another one. I have removed that batch. We have issues like this with batches, yes? Yes. This batch, is this a technical issue on your part, or is it an institutional issue? No no, this is our data issue. Okay? A data issue. In the test, sometimes we have to tamper with some of our data a bit. Okay? And after a few days, maybe we will remove this test database. After some more days, we will bring a refreshed, fresh data. Then these problems won't be there anymore. Okay? But I can't show this thing live. Because if I initiate it right now and if it gets verified somewhere, then there's a problem. Okay? Therefore, we show this in the test. Okay. Okay, so I submitted from ASN Pharmacy. Now if I enter this, I can see that on top of ASN Pharmacy, it shows 'submitted'. If I enter here... invoice number, then it will show me the order status. In the order status, what's happening is, it shows when it was drafted, by whom, and when it was submitted, by whom. Now there is something called an approval chart. Here I can see in which layers it will go next. What the status is like, for example, next it will go to Kalipada Roy. It shows that the status hasn't gone to him yet. Then it will go to Sukhat Hossain, to Shawkat Hossain. Then it will go to Mohammad Yasir Arafat. We can see each one like this. Now, since I can see that it will go to Kalipada Roy, I am entering Kalipada Roy's profile. After making a return request, this request goes to the MR of the territory that the customer belongs to. So I'm proceeding accordingly. Meaning, when a return comes, it actually needs verification in several layers. As per policy. First, the MIO of that territory verifies it, that yes, this is correct. The MIO usually takes the customer's order. He knows and understands. Then his Area Manager will verify that. Then his RSM will verify it. After being verified by the sales force in three layers, it will go to the depot end. At the depot, there is another verification, store verification. The store person who will be there, he will look at it and verify and say yes, it's okay, fine. If I go to 'Return' from Kalipada Roy's profile here, look, his return request has appeared. ASN Pharmacy is in a 'submitted' state. In this one, I... look here, let me say something. For example, now I have gone as my MIO. Our SR for this, he placed it, and it has come to the MIO. The MIO is verifying it. During verification, look here, 100 pieces. Here, but your... our base UoM that we were talking about for so long, that a box. Whenever we are selling Montiva 10, we sell it in a box. But when we are receiving and bringing it back, we are bringing it back in pieces. Why? Because... he might have sold half a box and couldn't sell the other half. Without selling the half, it got damaged or expired. Or five pieces are left. There are five pieces in the strip. So we bring it back that way. When bringing it back, what do we do? How do we calculate the calculation value here? This is something to understand. Suppose when we are selling, during the sale, what are we giving him? We're giving an offer. Even if he doesn't get an offer, he gets a slab offer. One percent or two percent. So, the fact that I'm giving him these things... that means I won't bring this product back at the exact TP. The exact TP was 100 taka. He sold it to him on offer for 70 taka. So what does that mean? I have to bring it back from the market in that way. I have to bring it back for 70 taka each. Now the thing is, there's a life cycle for an offer, the periodic offers can vary. Maybe this Montiva 10, okay? When the business started for this, okay? I'm assuming Montiva 10 started in 1980, it came to the market. And Pharma, NJPL started selling it. So, the TP from that time and the current TP are not the same. Okay? So, the first thing is, just as it's not the same, the offers are also not the same. Sometimes less, sometimes more. So what do we do, how do we evaluate this? What is the maximum offer that has been given in its lifetime? That is what we subtract. Okay? Maybe 30 percent. Then what... maybe sometimes 10 percent, 20 percent, sometimes 30 percent. So what does that mean? When I evaluate this money for this amount of 100 return pieces of Montiva, then I will subtract the 30 percent discount and then bring it to TP. That, brother, this value is this much money he will get. He will get this much money as a return. Okay? Otherwise, the company will be the loser. Okay? So this thing is calculated here. The matter is small. But I will say again, it's a massive calculation. Beautifully and nicely handled. Okay? So now this Montiva 10, 100 pieces. It has come to an evaluation of 999.99 taka. Now this will be verified periodically. Please carry on. So if I look here again, I can see the previous screen since I haven't changed the status yet. I haven't verified it. If I verify this... I wrote the reason. Suppose I wrote MIO as the reason because then I will be able to understand where it got verified. Okay, there are no more pending here. Since I have verified this, it has gone to my next phase. The next verification layer is AM. So I'm entering his manager's profile, AM, Shawkat Hossain. Okay, on Shawkat Hossain's screen, it can be seen that if I enter 'Return' here too, many return requests have come, but at the very top, I have found mine, ASN Pharmacy. If I look here, if I show the status now, then I will see that a tick mark has appeared on Kalipada Roy's status. And in the order status, it has also appeared in the list that it's 'Verified by MIO Kalipada Roy'. And below it, it has written what... what I had given, the note I had given or the reason I had given. So I didn't actually write the reason, I had written 'MIO' since I did it with MIO. So 'MIO' has also appeared, at what time and... I think the time for this is not correct. Anyway, but here the time usually shows correctly. Now if I verify this... and I wrote the reason as 'AM' since I'm verifying with AM. I wrote it in the note. Now in 'Verify AM', it shows that the status has changed, and within 'Review Return', the status has changed to 'Verify (AM)', meaning it is in a verified state by my AM. Now if I... enter again, then I won't be able to verify it, but I will be able to see the status, that it has been verified by AM. And Mr. Yasir Arafat will go for the next verification. Now if I go to our manager's, Yasir Arafat's profile... Here too, I went to 'Return' in the same way. When I go to 'Return', I can see there is one which is 'Verified by AM'. But RSM verification hasn't been done yet. All the others are already RSM verified. I just have the history. I went here, in the same way, same as always, I verified it here. So, look, it's 'Verified by RSM' now. If I check the status bar, the 'RSM Verified' thing has a check mark on it. Now, here, up to the status of... since this status has been updated, since the RSM has verified it, my app's part is this much. After this, it goes to the storekeeper, which is in our web part. So I'm bringing it to the web part. I need two minutes to connect to the web. Please. No problem. Yes.