There is a person, for whom is this? Okay? Then, as soon as we place it here, in our system... I mean, their users, by users I mean the employees, we search for them here. We search by mobile number. Suppose we search with a mobile number... then... here... your... suppose if I search, look... a list will appear here. Even if I don't remember the full number, if I search, a list will come up. And here, a list will appear showing whose numbers are close to this. Okay? And if I give the complete one, then what will happen? As soon as I search, it will take it, it will take it automatically. Like it has taken it here. Okay? Phone number, address, okay? And designation. Okay? So what does that mean? Now, for this customer, who is our employee, I will go to place an order for them. Then I have a territory, Nipro Pharma, which means I am with Nipro Pharma's... I'm doing it. And then... this is delivery not necessary. Okay? Now, the products that I will take, okay? By default, I will get a good discount. A 25% flat discount. Okay? Okay. The order that will be placed from here will have a flat discount. Okay? And here, for whom is it for? For Mr... But what we are seeing now is that the invoice is for the customer on the left side. Okay? Here the customer is different, but the person is also different. Okay? A single customer, multiple persons. Okay? Okay. We do this through staff sales... okay? So what happened? A note has to be given. MSD. I gave a note, MSD sale. Then it's placed. Since this type of order is not a general order, it then goes for a verification. See, if we go to order approval now, we won't find it there. We will find it in submitted. Let's go to submitted... this... okay? Now I can't do anything because this needs verification. According to their policy, if it's a staff sale, then verification is needed. Who will do this verification? Mr. Johurul's manager will check this. From his panel. Order verification... Okay, verification. And during verification, he has some controls. He can reduce it if he wants. Okay? He can delete it if he wants. 'No, this product cannot be given.' He also has the authority to do that. Okay? Finally, if he verifies it, it will then... go to the... to our VIC who was there... meaning, the depot where this will be placed, it will go to that depot's VIC. Now it will duly appear in order approval. This one... 20th... this one... issue to... which is not there in our general orders. Okay? The 'issue to' part is not there. Okay? Then if this order is approved, it will be duly approved, delivery will be scheduled, which we have done before. It will go to delivery preparation. And done. Alright. This was another type of order I placed. Now there is another order, which is free issue. What is this free issue? Suppose... Suman bhai, are you there? Your voice has been muted. Faria, can you hear? Suman bhai's voice? Hello? Hello? Yes, his suddenly stopped. Yes, yes, I think his screen also froze. It seems there's a net problem. Not a net problem... ...his computer... the laptop's charge ran out. Sometimes it happens while talking... That also happens. Yes, that can also happen. But at our office, there seems to be a big problem with the internet for a few days, sir was saying. That's why I'm guessing that the internet might have gone out. Okay, that's fine. It's... it's normal. It's normal. Okay, let's wait. He might join again. No problem, he will solve it and join. That's why he will join again. We saw quite a lot today. Sales... the local sales. We saw local sales and we also saw staff... staff sales. There are a few more things sir will show. I think free issue... ...then export orders, we might see these today. Do you specifically work on all modules, or is there a specific module you... So far, I am involved in the SD module which is being shown to you. In other modules, I join as a tester, but I know... by knowing, I mean I have been shown how it works. That one is a fairly new module, the other two. We call them PP and MM. Production Planning and Material Management. Will you return or work from home office? For now, I am working from the home office. I actually didn't ask for it. Arif sir himself offered it to me. Since the baby is still small and after he was born, he needed NICU support for some time. That's why it was a bit sensitive. Now, by the grace of God, he is fine. How old? Seven months have passed. I see, I see. I have one extra month of home office because my maternity leave was for six months. Now let's see what sir says. I said that if I can provide full support from home for testing, then maybe it won't be needed for now. If I can't, then we'll see, something like that. Yes, Suman bhai. Yes, Suman bhai. Network... yes, sorry. Actually, the network was interrupted here. Okay? The situation is terrible. Anyway, let's continue again. Okay? Yes. We will see another order. That is the free issue, which I was talking about. Sales force is given some products, and there is no valuation in this. Okay? This has zero valuation. Okay? And they mainly give these products to doctors. This is called free issue. So for this, we will go... for this, we have to declare a separate territory. Otherwise, you can't find specific customers. For example, here there is another common customer named BD Chain Pharma 2, and similarly, you have a person here. They will check this person... their MIO or MRSM, okay? Their... your... for example, here we have it in our Chairman sir's name too... Riyad is there, okay. So here... the designation is not given, meaning this is sometimes... what do you call it... ...these have come from the master data. So, one can be added here. Suppose, I couldn't find the person here. In that case, what will happen? If I give a new mobile number. 01768... Okay, let's see if this exists. If not, then what will happen? It will appear that the customer is not found, you create one. Okay? We can create the customer. I mean, it's not the customer, it's the person. Okay? Suppose a new MIO joined here. Okay? Our data comes here, but for some reason, it didn't come. This form is the same for our staff sales. Because sometimes, with staff sales, the entry for that staff is not in our system. Then, they can enter it here if they want. They will enter it once, and then for a lifetime, they can find it with that mobile number. Suppose we create this customer... let's give the name as your... gave your... a name... has to be different. Suppose we gave 'others' and gave his MIO... area name... okay? I gave it. Okay. There is no more... 0178... okay, here there is a validation. Here it didn't come. Eight... accurate number... okay? Eleven digits. Okay? Now it is enabled. Now we are saving him. Okay? Saved. Done. And see, it has appeared. Now, whenever we search for him, okay? He will be found. He can be found from our system. And then what happened? The free issue, suppose, territory... oh okay. a product... Now, the products I will give him here, okay? I gave these products. See, it's showing zero value. Okay? Zero value. But it's being calculated here, the total amount of free issue I am giving him. This will be in our accounts. Okay? But he won't have to pay anything for it. Okay? This will remain because we will need this value to reconcile our stock plus accounts, to know the value of the products I gave for free. Okay? Finally, when the free issue is submitted, it's the same as this. Suppose this also needs verification. Okay? After the verification, it will basically come to approval. And during approval, it's the same. It won't show any money, meaning zero-valued. And it will be zero-valued up to the invoice. Okay? But it remains in our records, the value of the free issue we gave him. This is one type of order that is placed here. And another order is tender sales, where you see there are tender sales. We often have tender sales from here. How will that work? For this, let's... some institution, tender... Dhaka Cantt CSD... this is a part. Okay? After coming here, you see this is a bit different. Because when it comes to tender... the pricing will be very custom. Until now, in all the orders we placed, there was no opportunity to tamper with the price. Until now they can't give an advance... Okay? Keep his note. Okay. Alright. So, coming here, we have a different... Until now, in all the orders we placed, there was no opportunity to change my price in any way. But when it's a tender, I will have the opportunity to change the price because a tender has custom pricing. Okay? I will get this opportunity. Now, I have three types of tenders here. Direct, third-party, and institutional. Okay? For now, in testing, we have kept both direct and third-party. Which one is a direct tender? The party to whom I sell directly. Okay? For example, this party is my Dhaka Cantonment. I am selling directly to them, and they will consume it directly or use it as they wish. They won't sell it anywhere else. In that case, the tender is a direct tender. A condition policy of a direct tender is that the VAT will always be 15%. The VAT will be 15% of the product's price. If my product is 100 Taka, then 15 Taka is VAT. Now, sometimes this product, whatever the price is, maybe in the tender they got it that if this product is given for 70 Taka, then they... So through this tender, they get it or they initiate it. This is in the case of a direct tender. A flat 15% VAT is being used. And when it is a third party, then I have to give the VAT that is on my product. I have to give the VAT of my product. Okay? Then you can't change... there is no opportunity to change the product's VAT. Okay? First, let's look at the direct tender. Let's get acquainted with the particulars on it. We are taking the customer, the customer's address, and the delivery address. Okay? Delivery address. The address where these products will go. Okay? This is what we mentioned earlier, that sometimes the customer's store is a bit different, it's far away. It's far from their shop, far from their institution. They can specify that this amount of my product will come, you deliver it directly to my place. So here, we can catch the delivery address. There is a title. Since this is a tender, there were some documentation matters, some government-related things. In that case, there is documentation. A title for that is set here. Maybe we put CSD 2025 T 101, meaning we are working on the 101st tender of this year. And the type is direct, and the unit type is, will we sell by base... I mean, sorry, this is your base or customs. This means, will we sell by the box or by the piece. Okay? We have put this here. If it's said base, then this product's base, for example, the product we will choose, its base is set here as a box. That means it will consider one box as one unit. And if I say customs, then what happens? Then if that product has any other units, it will appear. We can select to take it in that way. That it will take this product by the piece. Okay? And here, see the pricing. Is the pricing inclusive or exclusive? This means, the amount I will put, the price I will set, does it have VAT included with it or is it without VAT? Okay? This thing. This is captured here. So what do we do? We add a product. For our understanding, for example, let me mention one more thing here. In a tender order, we do not entertain any kind of offer. The policy doesn't allow it. If a product has a national offer, bonus, percentage, discount, that will not be applicable in a tender. Okay? And slab offers will not be applicable. Okay? No kind of offer, no kind of provisioning, no promotional things will have an impact on the tender. Okay? Suppose, like the bonus offer we have, if you click this, you get a bonus. No, he won't get it. Okay? Alright, we took one Avator 10. Okay? We took one piece. See its price, the TP is 269 Taka and 87 Paisa. We took only one. 269 Taka and 87 Paisa. This is a direct tender. Okay? The VAT percentage that is defined for it, okay? Sorry, I made a mistake here. The VAT percentage for a tender can actually be defined. Okay? That when I give the product, that product has a percentage, that when this product goes to tender, the tender had this much percent. Okay? We define that here and for this, 14.40% is considered as VAT. So what does that mean? If this is its TP, okay? Then this is its VAT. Okay? So TP plus VAT, he will pay me 317 Taka. For one piece. What is one piece unit? Box. Now, I come here and say I will take customs. If I take customs, see, the box becomes a piece. Then the price of a piece becomes 9 Taka. So what does that mean? There are 30 of them. Okay? Now if I go to box, then 30 times this is 270 Taka. Okay? Then see, mine changed. Okay? And after changing, my quantity is 30 pieces. Now if I say no, now I will take one piece. Then what will happen? See. The VAT also decreased. Now the total is 11 Taka. The price of one piece is 11 Taka. Usually, we have kept this for them. We have extensively developed and kept this, but they always take it in boxes. Okay? They take it in boxes. Okay? Alright, so what will we do? Here one box has 30 pieces. Sorry, this is your... one box. Okay? We took it to the base. Okay? Okay. So what's the result? He will buy one box of the product. Okay? And exclusive means VAT... the price I will set, the offer price I will give will be without VAT. We assumed he wants to buy this product for a total of 100 Taka. Meaning 100 Taka. I mean, whatever the VAT is, he said, 'I don't understand your VAT. You will give me one box for 100 Taka.' Then it's inclusive. He made it inclusive. Now what did I do here? I gave the offer price as 100. Okay? After giving 100, I clicked okay here. See, this has become 100 Taka. So what does that mean? The VAT on this 100 Taka, the 17.5% VAT, has come here. Okay? And what is its TP? 85 Taka and 18 Paisa. Okay? Okay. Now if I say no, exclusive. Exclusive. Even if it's exclusive, the product price is 85 Taka and 18 Paisa, and he has to pay the VAT separately. This one. That means a total of 100 Taka. Meaning, when he does the pricing, the thing that is set here is that when they do a tender, different parties do it differently. They say my price will be inclusive. They say my price will be exclusive and I will give it at this price, that I will give you this much in TP and VAT as it is. Whatever VAT your product has. For example, it's 17.40%. I will give it. No problem. Again, they say, 'I don't understand all this. I will give you this much per unit.' Okay? This is how they do the tender and get the work done. Then they set the offer here. Okay? While setting the offer, they check the price and see that the customer has said 100 Taka. So if it's 100 Taka, after deducting 17.40% VAT, the TP is this much, he will give this TP. So what does he do then? He sets the TP here. Okay? Sets the TP. And if the customer makes it inclusive, then if you click inclusive, it will be set automatically. Okay? So these calculations can be done here, and the algorithm at its back end is a massive algorithm. Okay? It took us quite a good amount of time to develop this, we designed it and did this work. It seems easy, that some easy calculations are happening on the front end. Actually, it's not. This is a very fantastic... 10 pieces 1000 Taka. Okay? Now if I say inclusive, then at once, the price of 10 pieces has become 1000 Taka. And then the VAT is as it is. Okay? Everything is fine. So, in any way, okay? However the tender is with them, our calculation here is fantastically and beautifully set up. This is a tender order. Okay? The tender order also needs a verification. Okay? After verification, the tender goes to your... to approval, as it is. It gets approved. After approval, an invoice will be generated. Everything will happen. Okay? As it is. So, in the case of a tender, some more particulars have to be given here. Additional information. In additional information, the tender number, the tender's package, what guarantee type will be given, whether there was a bank guarantee, we capture this data here. Plus, if there is any attachment on the tender, we capture that. Okay? We capture it from here. Okay? And if for some reason it seems the quantity of this tender is so large that it can't be delivered in one shipment. In that case, here is 'allow partial delivery'. Okay? If I turn it on, then what will happen? Then, as we saw in the last session, an order can be partially delivered multiple times. Okay? That thing is handled here. Okay? This was the direct part of the tender. Okay? And now if I say third party. See, if we go to this again, okay? Let's go to this... CSD... Now if I say third party, third party will come up, that CSD is my third party. In that case, it won't show its 'e' part. Okay? For this too, I gave a tender title, okay? Third Party 101... I gave a title and didn't change anything else. I mean, I just put third party here. Now if I bring an Avator 10... Now see here... okay, regarding third party, we have a... whether someone will pick up the phone or not is not a ZARP issue. Simple thing. Okay, here in our prod... production is okay. We will look into that issue. Take a note. Okay, I have a question here. For example, this module of yours, this is only for tendering, right? Tell me the customer ID. Okay. This module for tendering, it doesn't affect anything else, right? For tendering, is it separate? Tell me the customer ID. Right. For example, in your data table, suppose if a product's normal value is X amount, in a tender it becomes X plus amount or X minus amount due to VAT. So this product that you are entering here, are you maintaining it separately for the tender, or are you maintaining a relational database? If it's relational, then it will affect the normal product, and if it's not a tender, it will affect the main product. No, no, no, here we definitely have a relational database. But our architecture is so professionally tuned that we are using only one table for orders. But here, the order type is coming differently. Business unit... based on the order type, we can separate their characteristics. We can separate its pricing. But the components I'm using here, suppose a product, I come here and for it, I say in the tender its price is 100 Taka. Does that mean my product became 100 Taka? No. This product, whatever it is, will not be impacted. Okay? This is my product. It's my sellable product. I sell it to the tender people, and I also sell it to the normal chemist. Okay? But with the tender party, what am I doing? There is an opportunity to set the offer. But in any other case, there is no opportunity to change this, no authority at all. Okay?