Okay. Yesterday, among the features we had, the first one was stock position. Stock position is the physical stock of a depot. That feature is there to see its current condition. For which product, in which batch, how much SKU, how much quantity is there... Will you share the screen?

This one, since we are briefing, okay, I'll go to it anyway.

Let's connect to the Dhaka depot.

Okay, my screen is visible, right?

Yes sir, it is visible.

Okay. Then after coming to this... thing, we can see which product it is, okay, and how much stock is there. And its saleable UoM, the SKU, what kind of unit it is, we show this based on which unit it is sold. And besides that, for one product, we can see which batches have stock. Okay? Initially, what we see loaded is our physical, saleable store. This is called an unrestricted store. Store means the location for keeping products. We can see a depot has four or five locations. Okay? They keep the products there. So, a product's condition, and category-wise, it is kept differently in the store. Okay? Since it's a depot, it keeps its saleable products in the unrestricted section. Besides that, there is a multi-store here: restricted, blocked, damaged, expired, transit, unreconciled, and export store.

Restricted means a certain product, a suspicious product. Okay? The one... yesterday you asked a question that if one extra is sent, then what will happen. What do we do with that? We send it to restricted. Regarding that, in our next version... in the next version, when we work with GRN, there we... this is already given but it's... I mean, it's not currently being used anywhere. But this, in our next version, we will introduce it.

Then after restricted, there is unrestricted, from where it is sold. Another one is blocked. Suppose, I have a quantity of 10 for a certain product, and perhaps an order for it has come in. Yes, with a quantity of two, and it has been invoiced. That means a quantity of two got blocked for me. Out of 10, two got blocked. Okay? That is a blocked store. The damaged/expired store is also the same. Okay? Sometimes it is seen that a product of mine, I have received it damaged or it got damaged while it was here. The location I will move it to, we have given it a separate name: Damaged and Expired Store. Okay? To manage its stock, we keep it there. Okay?

Then transit store, which is when a transfer issue occurs, when some products are going from Dhaka to CDC, okay? Going to the central location. So, at that time, we manage the transit store. And unreconciled store, okay, where we have a certain... I mean quantity, okay, for which no reference can be found. Okay? We keep that here. Then it is reconciled. And export store is for all the products we send to foreign countries, so we keep the stock of those products here.

If we want, we can see our stock here store-wise. For example, if we look at damaged/expired, then there is no stock here, meaning it's not kept now. This is in the Dhaka depot, we are watching it live, okay, for that reason. Okay? If it were there, it would be shown here, okay.

So, this is your store, stock, depot-wise, okay. We can see this, and another thing we can see is the batch. Okay? Which product has which batch, we can see that here by clicking, and we see all batches, available batches, and how many batches we have worked with so far. And yesterday we saw that there is a batch transfer; we have kept an opportunity for quantity transfer of the batch here. Perhaps it was seen that while sending, they sent a certain quantity in a different batch than intended. We can adjust that kind of quantity here. But the main stock remains the same. Okay?

Then requisition. Requisition is when my stock decreases, then I will send my demand to my central depot according to my needs. Okay? I will send a requisition. I will send it in two ways: manual and auto. Manual means I will specify that for this specific product, this much quantity needs to be sent. And for auto, we have calculated and established an algorithm from the backend here. It checks what is below the safety stock. Okay? According to that, it automatically creates a requisition. Okay? In that, we see it takes less time and it's being created automatically. Its usage is very low because so far no one provides all stock like this; they provide it manually according to their demand. Okay? We have still developed it.

And in manual requisition, when it is sent based on demand, in that case, a DM, a Depot Manager, his permission is needed. He does the verification, meaning he approves. Then it goes to the depot where I sent my demand. Before that, it doesn't appear. Then there, he checks his stock, and after checking, he verifies it. While verifying, he selects a driver who will take this product. Then what does it do? After approval, it has to get a gate pass. After getting the gate pass, it has to be dispatched. Then after dispatching, the stock from there decreases, and this comes into in-transit. And then, the one who sent the demand, after it arrives here, it needs to be GRN'd. After GRN, his stock goes up, becomes available. Okay? This is stock requisition.

There is also, I saw, transfer requisition, where some of my products, I am sending them to my central depot. For example, some of my damaged products have accumulated. Okay? I will send that to the central depot. The central depot will send it to the factory in its own way. Okay? So what has to be done? In that case, we call it depot transfer; we do a depot transfer. Okay? Which one is this? This transfer requisition, depot transfer. Okay? What do we do in a depot transfer? To whom I send it, in that case, one thing is very common, which is... from the store I will send it, the product is of that category, so the same store gets selected there. Okay? By default, it is selected, but it can be changed if desired. Okay? So, the depot transfer is also like this: an ADM's permission is needed, then since I am sending the products physically, there is a matter of transport. In that case, the transfer is verified, the transfer is approved, then it goes. Okay? After going there, it gets received. When it's received, what happens is the stock there goes up. And when I am dispatching from here, my stock then decreased by that amount of stock.

Then another one is internal transfer. For example, in one depot of mine, I have four stores. Okay? For example, the product that is in the unrestricted store, from there two of my products got damaged. Then I might have to transfer it to my damaged store. Okay? What does that mean? The stock in one store will decrease and another will increase. In that case too, we have kept a facility for internal transfer. That just gets executed when a DM approves it. Because there is no issue of transport here. Okay? It gets executed automatically. Internal transfer.

Then yesterday we saw customer create. Customer creation is done by an MIO, meaning a sales force, he does it. Okay? He creates the customer. After creating the customer, it doesn't become available in the business right away. There's a verification for that. His area manager or RSM verifies that. Then it goes to the depot end. At the depot end, verification is done. During verification, he can see duplicate issues. Even after seeing them, if he wants, he can permit and do the verification, otherwise he can reject. Then it goes to the depot manager. The depot manager also, same as, after he approves it, it finally becomes available in the business. This is in the case of customer creation. Okay? A part of customer creation is also kept on our web. If they want, they can create a customer from the depot end as well. It's visible, surely. Okay? This is how the customer can be created. Okay? So that the depot can do it, we have kept this feasibility here. Okay?

Alright. Then there is the customer update issue. That a customer's update request has come, what can be done about it, okay? In that case, the customer's update is under the depot as well. See here, when I go to the depot, okay, if I want, that permission is given to the depot manager.

Look, I have now entered the customer section as a depot manager.

Okay. Now see, the update buttons appeared here. Because the depot manager has that authority to update the customer. But the request for updating a customer should mainly come from the sales force, that's better. We have kept it in two places. Yesterday we showed it only from the app. Okay? If an update is integrated from the app, verification will be needed in various places for that. Okay? His manager will do the verification, then DIC verification, then if the DM approves, it gets updated. And here, since the DM himself is updating, it will get executed immediately. Okay? For example, here there is some basic customer information, which is... I mean, it's not related to your business. But the information after this impacts the business. For example, what his payment mode will be, how he will give us money, in cash or by cheque, whether he will get credit, whether he will take an offer, whether a receipt is needed, we saw these things when we created the customer from the app, that these things, he, the sales force, can select. Then, coming here, he can update it if he wants.

We have the same facility on the web as well. Yesterday we saw the app one; the web one is the same as the app one. In the web one, the person who is the higher manager, currently the Distribution Manager, he can do this, he is permitted to do this. Okay? Then the customer's business profile can be updated where your... his drug license, which is a very essential part, is there, that means his... is he a chemist, what kind of customer he is, we have kept that. Then sales area. Sales area is your territory. This customer, for example, is active in two territories. Okay? Two territories. Now if they want, this customer may have extended another shop, has gone to another territory. Then if they want, one can be added from here, a territory can be added. Okay? From this web, that is possible. Okay? Alright. We will see this when we see the customer profile, we will see it there. Today we will see these parts, okay? A little later. We will come here a little later, we have work here. Just a question...

Yes, yes...

...about the drug license. I saw that you've only written the number but is there any image or any reason for that?

Be it the application or drug licensing, these need to have a hard copy, meaning an image has to be there to see if it's really real or if its validation has been done, these matters. I saw that you don't have it like that here. Is there any specific reason for it or have you just not implemented what is in Bangladesh... There is no specific reason, meaning the requirement was not there. Okay? Okay. The requirement was not there. Okay, for that reason, and nothing else. Okay?

If we want to do this internationally, you have to make this session very strong. The reason is, it needs to be made strong because managing the compliance of the paperwork here is very critical. Okay, no problem, you can continue.

Yes, yes, that is... there is no problem. We can do these for you if we get the requirement, no problem.

Then what did we do? We went to a customer... thing, which is customer release. Suppose this customer works in two places, is engaged in two places. Now it seems he needs to be made inactive from Kagochora Bazar, Barisal. So, the DM can do this directly. But the DM doesn't know this customer. So how will the request come? From the person who is active there, the sales force. What will he do? He will send a release request from his app. Then it will be verified. After doing that, finally, if the DIC approves the verification and the DM approves it, then it will be executed. And during release, another thing is whether he has an assignment in another place. Perhaps it was seen that his business is closed here but he has to be added to another new place. Then your assignment is given there. Okay? Area Manager. We can see that too. Let's see a bit. For example, here, I've put it in the same place. I'm releasing from this place and assigning here again, which makes no sense. Okay? They are making some mistakes like this, we had to see this. Okay? Alright.

Then your... what else did we see? Credit limit. We saw credit limit. What is credit limit like? If we want, we can give a customer credit facility. Credit facility is of two types. One is your fixed discount. Whatever product he buys, from there he might... I gave a 5% discount, he will get a 5% discount on all products. Another is based on the amount, okay, that a facility of two lakh taka was given to him. Or there can be two, both can be there. That both are in the... thing... Both, 5% discount plus a credit facility of 2 lakh taka is there. What are we keeping for the credit facility? Single invoice or multiple invoices. Maybe he will get one invoice of 2 lakh taka, or multiple, in multiple invoices of 2 lakh taka, he will do 2 lakh taka. And this has a duration. Maybe 90 days. Meaning, when his invoice is made, no money will be asked for within 90 days. What does that mean? His pending due date will be the day after 90 days from the day the invoice is made; that will be his pending due date. After that day passes, if he has a due, only then it will be considered a cash due; that will be caught in our system as a due. Then there is the payment mode. How will he give this money? Will he give it in cash, by cheque, by EFT, we are keeping that. And there is a date range there that... it is said that from this date to this date, maybe for one year, he will get a credit facility for one year. I mean, duration is a separate thing; duration is within how many days he has to make the due payment. But the credit facility, for how long he will remain as a credit customer with us, a duration is given for that. Maybe one year, two years, okay? For example, sometimes it's for a lifetime too. These things we see in the credit facility, and the credit facility is also the same; it is being verified, then it is being approved. We saw this yesterday.

This was our journey yesterday. So, in today's journey, we will talk about two big features. One is products, another is customers. Okay? So, the list of features we actually got, the features that are there, along with these features, there are some sub-features that are very big themselves. But they are not there as main features. Okay? We will now see some features like these which are not main features but are very big as sub-features. Okay? So, let's start ours today. Okay? We will see it with DM in test, okay? Better because it is basically accessible with DM. First, we will see products. Okay? Products. Okay? Today we will see everything about a product.

Here we logged in as DM and under him, all the products that are there, those products are here. All the products have types here, what kind of products he works with. For example, here there are asset items, bulk items, components, construction, engineering, IT, etc. Okay? For example, these are IT. These are... let's say, given to him. These are not saleable. Meaning, he will not sell it. This is for his various work when he brought it through requisition, those things. Okay? These are not saleable. So, what are his saleable products? Finished goods. We will only work with this here. The other ones, we will see when we see MM, or when we work with exports. From two places here, you can sell: finished goods and export. Okay? We will just see the finished goods now. Alright. There are 42 here. Searchable, plus a product can also be created here. If he wants, he can create a product. What is there on the screen for creating, let's see a bit, like the product's name, its code, its type, what kind of product we will create, an FG product, we will create the category as tablet, there can be a sub-category like OT tablet, this is optional. Then how to make the base book into a box, self-life group, etc., with its trade price, VAT, etc., we will create this. This is one of our... primarily, when we developed this system when we didn't have PP here, production planning was not there, to support that exact time, we used this place; we used this to create products. Currently, this is not used. Now the product gets created in PP itself. Okay? But this is... I mean, totally workable here. If we want, we can create a product from here too. So, without showing this, this is a good feature, a nice feature for creating products.

We will now go to a product's... this list that we are getting, see, there is the product's name and how it is recognized, by which code, that is there. And its... I mean pack size, for example, 100s means 100 pieces are there. What does that mean? This is a box of 100 pieces. Okay? And below, see, this is there, this is generic. What it is made of, the generic is given here. Plus its TP, what is the trade price and what is the value in MRP? And its product's... your class is mentioned as 'Rest Important'. Okay? And if we now, for example, priority product or cardiac or top twenty product, the one that sells more, they have classified it as top twenty. Okay? And this is with your these two generics. Alright. Let's go to the AMX 500 capsule. Let's go to this one, okay? Going here, we will see when we go into details, at the very top, we will see some things: its name, same as... its price, its TP and description, the short description. This description is actually auto-generated. Okay? This is its name plus its... your commercial description and its pack size, if you mention this, it's done. Commercial description is 5 x 10, meaning on one strip, 10 pieces, there are five strips of 10 pieces here. Okay? And in total, there will be 50 pieces. And this is a finished good and the status is given, if you want, you can turn it off and on from here. If I turn this off, then it won't appear anywhere else; it won't appear for selling. Alright. So here, see, there are various tabs: Business, Settings, Attributes. Let's go through each one a bit. First, we are in Business. In Business, its basic, some of your... here we keep information like what type it is, what is the business group, general product. This is a general product. If we go to the... thing, your... if we go to the legend, for example Avador, this is a cardiac product. Here they have generated two categories for the product: one general product and another is cardiac product. Okay? And going here, we can see that its... the information here, what is the brand, its proposed code, HS code...

I just have a query here. For example, when you do 'Create New Product', does the whole thing have to be created manually one by one? Or is there any system for bulk import here? Or is this automated with your... those who produce the drug?

This is... right now, it's being created from a PP, Production Planning. Whenever a finished good is created in Production Planning, it automatically comes to our... this product. Before, we had this, this screen was there, through which we would add a new product. We would add a new product. We have kept this screen. Now they don't need it now. But if we want, we can add products with this as well. Okay?

And for us, any bulk... any... thing for this was not needed... I mean, it was not required so far. And one thing is there, that is master data. Whenever we go into an SLA with a new company, after everything is finalized with them, we take their master data. Because he won't sit and enter thousands of products. Then they give the data in my Excel... we have a formatted Excel, they give the data in that, we... once... we upload it at once, update it. Okay? Then afterwards, one or two products come, then they can create them. Okay.

No, no, bulk... this, if they give it in my Excel, the Excel... we... I mean, it's done in our system here, in the backend, this, we do this in the backend, we handle it. Okay? Which... taking the data, it gets inserted into our main database. I see. That means you... I mean... run queries on the database. You don't have any panel for bulk uploading, am I right?

No, there is no panel because that's not needed. That just happens once. It happens once because later when he has a new product, if he has PP, then it's automatically coming here in PP. And if they create it manually, then one or two at a time, they... this screen is there, coming to that, they can work. We didn't give time separately for that screen design. Okay, okay. That's what I needed to know. Please continue.

Okay, then there is 'Advanced' here. Some advanced information like manufacturer, country of origin, launch date, product family, etc. If we want, from here we can... I mean, update those things. Then we have 'Settings'. Going into settings, we get some more information, like what type, what is the category, okay? And its commercial unit, meaning will it be sold in kits, pieces, or boxes? What will be the commercial pack? We can keep information from here. What will be the safety stock, what will be the reorder level, through which our... the auto-requisition, that comes here and sees his reorder level, within what, within how many days it will be. Then there are several ancillary... I mean, pieces of information here which we manage here. A very important part here is the attribute. For example, for this product, if we see the strength, like 500. We set that here. The generic is Amoxicillin. If this is multi, then what do we do? We might assume that with Amoxicillin, perhaps you have Amodrictin. We can give that from here. Since with two... thing... your two generics, ingredients are here. Then theraplus, okay? What type is this? Antibiotic type. Okay? Dosage form, is this a capsule or your tablet? We can choose that from here. There's an issue here. What kinds of... okay, we can take it from here. Then these four are our... I mean, some characteristics of a product, okay, which have to be seen right up to the customer. It's important for the customer.

Then another one is unit of measurement. Okay? Unit of measurement. For example, this product, okay, how will we sell this? What kind of... in which unit will its SKU be sold? For example, it's given here in a box. Like we saw earlier, this is sold in a box. Okay? So, it's in a box. And in one box, how many are there? In this box, there are 50. See here, 50. And how is it there? 5 x 10. Meaning there are five strips. There are five strips, okay? Like this. Now, this is... this is for commercial sale. But whenever we order, meaning when I order from my factory, then I... what will I do... I will order maybe 100 boxes. Then that... in how many cartons was it made, that gets calculated automatically for us. It seems 2500 is needed here. What does that mean? 500 boxes are needed. If I order 500 boxes here, then it will come in one carton. Then when we give the requisition, they will give us one carton. Because within that, we will get 2500 boxes. etc. And its minimum unit, which is non-saleable, is 'piece'. Then 'master carton', then 'carton'. In this way, we can define it here, we can change it if we want. And during the change, we have kept another thing here, maybe a new unit was introduced for us. We can create that here. For example, what might come is... that container, box, then we... what can we say... that your... a big container. Container. A container. I can create one if I want. The container has arrived. And for the container, I said this is... within one, there will be 25,000. 25,000 boxes will come in one container. The pack size is your 500 into 25,000. Meaning this is... that your 500 cartons will be there in one container, 500 cartons will be there. So, in 500 cartons, all together, I will get 25,000 boxes. If we add this here, then here, unit of measurement, here it comes. So, my minimal is one piece, then box, then master carton, then carton, then container. The largest, okay? That I can order one container. This is non-commercial. This is for internal... I mean... for the sake of... depot to depot might ask, there might be a demand, etc. Okay? So, this is unit of measurement. This is a nice... I mean, a nice feature in our... thing, through which basically, all the invoices we will see so far, this, we will see, there, this... your... the quantity's... these things we are saying, this many in a piece, this many in a box, then you can automatically calculate and find out that the total... I mean, what is the highest most unit, what is that. If I say now 25,200, then what will it do? It will say one container and four boxes. One container, four boxes. Because 200, four boxes. It will say. Okay? So, in this way... I mean, we have an opportunity to use it in a totally smart way.

Then there is 'Production'. In production, sometimes there is some information, like lead time, master code, batch weight, etc., they can input this data. And its warehouse... I mean, warehouse type and store type, where it is, that will be... I mean... done here because since this is a finished product, therefore, it will always go to unrestricted.

And finally, a nice place for this which is used a lot by us is the pricing plan. For example, let's say this product has a current price per box. Its MRP is set, COGS (Cost of Goods Sold) is set, VAT type is set, and how much VAT, weighted COGS, these are there. But here, what we actually need more, we are currently working with that: trade price, and VAT type and VAT. This is needed commercially. What happens in this is that a price... maybe a price change has come. Maybe it is 281 taka and 11 paisa. Okay? Which... maybe a new pricing comes, that is, it has to be sold for 290 taka. Okay? In that case, what has to be done? Coming here, that has to be given, that I... 290 taka is its trade price. Maybe the MRP will remain the same, and the VAT might be calculated on top of your 290 taka. It comes to 43 taka and 50 paisa. 43.5, okay? What did he do? He updated this. Then what happened? Did the price then change? No, the price will not change. A request for a price change has been made. For example, it can be seen here, a request for a price change has been made. Until this price change request is approved, the price will not change. We will work on this area, so we have kept it, okay? We have kept this, this is another feature, okay? Which one did we work on? AMX 500. Faria, please make a note. So, for 290 taka, I am saying that I will sell this. But it hasn't become 290 taka just yet. We will see this next.

The matter of procurement is also the same... in the... thing, when MM is done, okay? There, this... these are all dummy data currently here. For example, this... this product's vendor, if it's a third-party product like a semi-product or an e-product, there we can see that the product has... I mean, vendors, some... for procurement, some of our customers... your vendors, we have kept them, from whom we are taking this product and doing the work, okay?

Here, what is needed more is the offer. Suppose, for this product, now the company will give an offer. Okay? The company will give an offer. What kind? That an... your offer can be of several types. Percentage offer, flat offer, bonus offer, free offer, etc., there are several types of offers. This is one of our big internal features. We will now talk a little about this offer. Okay. Okay, I'm talking about the offer. Look here, whenever an offer comes, the DM who is there, he creates an offer, okay? After clicking on 'New Offer' for the offer, look here, there is 'Offer Type'. Percentage, Fixed, Bonus, Free. What is percentage? I said if this product is bought, then a 10% discount. First, let's create a percentage offer and show one. Percentage offer. Okay? I am giving this percentage offer and first it's asking me, for how many days will your this offer run? I have to specify that this offer will run this month itself; it will run from the 28th to the 31st. Therefore, during this time, those who will create this order, meaning place an order on this product, everyone will get it. Those customers will get it. Since this is a national offer. I am within the product; a product is a national... I mean, a national entity of Bangladesh, okay? For that reason, a national offer will be created.

Then it's being said that what is the minimum buy Qty, buy quantity, after how many will you give this offer? I said if they buy five, then I will give it. Okay? I will give it if they buy five. And within that, what percentage discount will I give? I said I will give 15%. What does that mean? On my AMX 500 capsule, I gave a percentage discount from the 28th to the 31st, I will give it if five are bought and they will get 15%. If he buys four, then he will not get the offer. We... a little... our this...