- hace 1 semana
📦 Entradas
📤 Salidas
🔄 Traslados
📈 Existencias
🏷 Número de lote
📅 Fecha de vencimiento
📊 Clasificación ABC
Todo desde una interfaz profesional, rápida y fácil de utilizar.
Ideal para:
✔ Ferreterías
✔ Farmacias
✔ Empresas Industriales
✔ Almacenes
✔ Distribuidores
✔ Empresas Comerciales
📊 Control total de tu inventario en un solo lugar.
Contacto:
wa.me/+584128375067
📤 Salidas
🔄 Traslados
📈 Existencias
🏷 Número de lote
📅 Fecha de vencimiento
📊 Clasificación ABC
Todo desde una interfaz profesional, rápida y fácil de utilizar.
Ideal para:
✔ Ferreterías
✔ Farmacias
✔ Empresas Industriales
✔ Almacenes
✔ Distribuidores
✔ Empresas Comerciales
📊 Control total de tu inventario en un solo lugar.
Contacto:
wa.me/+584128375067
Categoría
📚
AprendizajeTranscripción
00:00I receive a warm greeting, welcome to this space.
00:03We're going to make a short informative, demonstrative video.
00:06how this warehouse control application works
00:10to maintain complete traceability at the entry and exit points
00:13by batch, even by expiration dates,
00:17having automated stock alerts,
00:20simply by placing all the necessary records,
00:25even with an ABC rating,
00:28automatically.
00:31Let's go step by step in the demonstration.
00:35Okay, the first thing we have to do, like any job,
00:37like any application, like any other customization,
00:40We will have a parameter configuration section.
00:43where we will select the region we are in.
00:48For example, I get contacted by a lot of people from Peru, for example.
00:51Peru is entered here and it automatically identifies
00:54that the symbol of the monetary unit, which is the sun,
00:56and its tax identifier, which is the RUC,
01:00All that remains is to place the values for each location.
01:05For example, also if I am in Mexico,
01:07Mexico is entered and it automatically reads the values
01:11and we would only have to complete here
01:14what is appropriate for each place.
01:16For illustrative purposes, I'm going to position myself as if I were in the United States.
01:20to use the dollar monetary unit.
01:23We need to customize our units of measurement
01:25of the type of inventory we are working with.
01:28Here I have these corresponding examples in general.
01:33I can also have more than one deposit.
01:35This application keeps track of entries and exits.
01:38or knows exactly what he has, even on deposit.
01:41If I have an operation where I only have one warehouse, well then.
01:44But what if I have one or more storage tanks inside the warehouse?
01:47Or if I want to control and centralize input and output information
01:50of one or more deposits at the same time,
01:53Here I can describe them individually.
01:56We're going to have that entry and exit control.
02:00We also have the reasons for entry and exit movement.
02:04It could be due to an inventory adjustment, or an inventory control.
02:07It could be a reason for entry due to shopping, consumption,
02:10loans of artwork, returns or any other concept
02:13that suits your business operation.
02:16For the purpose of classifying the products,
02:18I can place it by its category, by its brands, model, size, by condition.
02:25All of this is part of the configuration and classification of the products.
02:28As well as the positions of the employees we will have,
02:33since traceability can also be maintained
02:37of inventory entry and exit
02:40by person or employee who is involved in the process.
02:44So let's go back to the menu
02:46And we're going to go quickly.
02:48For example, I have a supplier registry
02:50which is nothing more than a form for storing intrinsic values of the same.
02:54Supplier name, tax identification number,
02:57the type of supplier, well, email, phone, address,
03:00These are the basic facts.
03:02I want to register them, and when I register, it saves them.
03:05And here I am loading the list,
03:06I will have a list of all registered suppliers.
03:10I can double-click it and it will bring the information here.
03:14where I can modify a record
03:16or I can remove it if necessary.
03:20It's a simple form registration.
03:22Similarly, I also have the employee registration form,
03:25where you can place your DMI or ID card,
03:28your first and last name, telephone number,
03:30the position assigned to this operation
03:32and also whether it has been, whether it is active or inactive.
03:36Okay, I can also load the list.
03:38And by double-clicking it, I can access all its values.
03:42so I can modify or delete it if necessary.
03:46Okay, here I have the product registration module.
03:50This is where we categorize and classify.
03:52a product in general.
03:54I can include your name, your description,
03:56its unit of measurement, its cost,
03:59the category or family, brand, model, size,
04:02all these drop-down lists
04:03It takes them from the parameter settings
04:07automatically.
04:08For example, here I can pull units of measurement
04:10and what I put in the configuration sheet
04:12He's going to read them to me here.
04:14Obviously, if I add more, he's going to read them.
04:17All of this is personalized.
04:18Also the category or family, the brand,
04:22the model, the size, the state or condition,
04:25even a serial number, these are intrinsic values
04:27that I have to be able to configure the products.
04:31Also in a didactic and visual way
04:34I can locate the image of a product
04:37and the note must be in JPG format,
04:40which is the image format that can be read
04:43within a Visual Basic Pro Application form
04:45who works with Excel.
04:48I can give you the image location.
04:49and I'm going to the place where I have them loaded.
04:52And here I have, for example, this image
04:55and I can add them and set the values
04:58of my products.
05:00I can also assign a value to it.
05:02minimum inventory, one of maximum
05:05and one alert for the classification
05:08of KPIs and alerts.
05:10This is where I configure that part.
05:12This is where I say what the minimum is,
05:14What is the maximum?
05:15and what is the alert percentage?
05:17So, after I make all those records,
05:19I'm going to clean this up.
05:22I tell him to look.
05:24And here I tell you to load the product.
05:25I can locate the products by name,
05:28by serial number, category, brand, model.
05:30I can locate them dynamically
05:32for the didactic purpose of this exercise.
05:35I only have six products, but oh well,
05:36When I select one, for example, here,
05:38His image brings me here
05:40and brings me to my current existence.
05:42I place here, for example,
05:43nitrile gloves and I'm bringing them here
05:45and it shows me the image and the current existence.
05:48I also double-click it.
05:49By double-clicking it,
05:51He's going to bring the valuables here for me.
05:54And he's going to show me here, well,
05:56What is the minimum?
05:57What is the maximum?
05:58and what is the alert percentage?
06:00Here it tells me critical level status.
06:03Because?
06:03Well, because for educational purposes I placed
06:05that the minimum is 150
06:07and I have 110 right now.
06:09That's why it says critical level.
06:11But if I place another product here,
06:13For example, these safety boots,
06:15Double-click, it tells me optimal level
06:17because I configured it to be a minimum of 15,
06:2060 maximum and I have 20.
06:23Very good.
06:24Here I record and categorize,
06:28I assign it an image
06:28and I assign it the inventory parameters
06:30to each product.
06:33Now let's talk about traceability.
06:36Here I have the application and receipt.
06:38I press here and this module is activated.
06:40who asks me,
06:42Are we going to make a product request?
06:44or are we going to receive mechanics?
06:46First I can select,
06:48It is to make the request for the products.
06:50It's just a form, nothing more.
06:51that asks me for the date
06:54in question.
06:56Dynamically,
06:57I can locate the supplier
06:58to whom I am placing the order.
07:00And I too proceed here
07:02the list of products,
07:03to load products
07:04And I tell him,
07:05Well,
07:05I want to order safety gloves.
07:07For example,
07:08double-click
07:09And I place it here,
07:11I simply enter the amount.
07:13I can press Enter
07:15so that it generates the list for me.
07:18And down below I'm going to see
07:19the totalization
07:20in the currency
07:21that we are configured.
07:23I can also locate
07:25another product.
07:26Safety boots here.
07:28I can enter the amount
07:30And I can tell you here
07:31add
07:32and automatically
07:34It keeps me updated
07:35the list,
07:35the total product
07:36and the total cost
07:38of this request.
07:40I can do this too.
07:41add a comment
07:42if necessary
07:44And I want you to see,
07:46For example,
07:46I tell him to look here.
07:48This is the list
07:49application
07:50of orders to the supplier,
07:51where I can audit
07:52the orders
07:53by date range,
07:55by supplier,
07:55by state,
07:56I tell it to load the list
07:57And I only have three.
07:59I have three in a row,
08:00I only have three documents,
08:02I have all three
08:03so resected already.
08:04Therefore,
08:05If I save this
08:06as an example
08:07What am I doing?
08:07here in the video,
08:08when I tell you to register,
08:10Notice that he puts me
08:11order 4,
08:13that registered order
08:14successfully
08:16and my fields are cleared
08:17and it resets me
08:19the form.
08:20So,
08:20If I tell you to search again
08:21and I tell it to load the list,
08:24indeed,
08:24I already have number 4 here.
08:25and he tells me there's no reception.
08:27A request I made
08:29and I have no reception.
08:30This list
08:31application
08:31of orders to the supplier,
08:32I can segment it
08:33by a predefined range.
08:35I'm telling you today's date here,
08:37I tell it to load the list
08:38and it's only going to bring me
08:39a record.
08:40I can tell you yesterday,
08:41load list,
08:42I'm not bringing anything with me.
08:43I didn't do it yesterday
08:43And if I tell him,
08:44For example,
08:45upload the list throughout the month,
08:46It's going to bring me
08:48strictly the month.
08:49I can segment it too.
08:50by a specific supplier
08:52or by the states.
08:53I just want
08:54those without reception,
08:55load list,
08:56He only brings me one.
08:58Good,
08:59I can also export
09:00all of these,
09:01This entire report,
09:03I can export it to Excel
09:04and place it in a folder
09:05that I would like.
09:07In this case,
09:07I'm going to make a desk,
09:08For example,
09:08keep
09:10and in this case,
09:11I close the forms
09:12in order to open
09:14the other Excel.
09:15Here.
09:16Where is the file?
09:17Here.
09:18Double-click
09:19And here it is.
09:21Here's the report
09:24of this audit
09:25of purchase orders.
09:27Notice that here
09:28in the audit
09:29exports me
09:30not only
09:31the information we see,
09:33but it also brings me
09:35Look here
09:35this date
09:36of purchase order,
09:38the correlative,
09:39the supplier,
09:40the received state
09:41and it also puts me
09:42the date it was received
09:43and the invoice number
09:45and the total amount of the bill.
09:46He brings it to me.
09:47In the latter,
09:48Why isn't he here?
09:49Because it's a bill
09:50or a request
09:51which has no reception.
09:53I have a full audit
09:55in the application
09:56inventory.
09:57Let's go back here.
09:58So,
09:59What's left for me?
10:00Well,
10:00what I have left
10:00is being able to export
10:02This request.
10:03Correct.
10:04Let's place it here,
10:05Load list.
10:06I'm telling you here
10:06double-click
10:07to see it,
10:08to see it in detail
10:09and I'm going to export it
10:12And here it is,
10:13Here I am
10:14the purchase request
10:17with the data
10:18of the company
10:19that in configuration
10:20I placed it,
10:22the supplier's details
10:23in the form
10:23which we have described,
10:26the export date,
10:27the application document,
10:29the description
10:30of the products
10:31with its sum,
10:33seal and signature
10:34and any observation
10:35to the supplier.
10:36It can be customized
10:40this form
10:41or this format,
10:43Yeah,
10:44we would have to talk
10:45and obviously
10:47everyone drives
10:48a format.
10:49This is something
10:49strictly general,
10:51but if,
10:52We can talk
10:53and we can adapt it
10:54to a format
10:54pre-established
10:55that you already handle.
10:58Perfect.
10:59Then,
11:00good,
11:00We went to the reception area.
11:02of merchandise.
11:02Receiving merchandise
11:04It's nothing more than the form
11:05which allows me
11:05receive
11:07the inventory
11:08to begin with.
11:08This is already a movement
11:09who does manage me
11:10the inventory.
11:11It's an entry
11:12for inventory purchases
11:13where can I do it
11:14a direct one.
11:15I can put it here
11:16the date,
11:18I can locate
11:18dynamically
11:19to a supplier,
11:20I can place
11:21an invoice number
11:24specific.
11:25Here I have to specify
11:26in which deposit
11:27of the configuration,
11:29in which deposit
11:30inventory
11:30I'm going to receive it.
11:31For example,
11:32the main warehouse.
11:33I place it here
11:34the products
11:35from my list
11:36And I tell him,
11:37Well,
11:37I like this product
11:39I will receive it
11:40because he brought it to me
11:41This supplier
11:41on this invoice.
11:42He brought me
11:43a dozen,
11:44For example.
11:44Here I establish
11:46since the reception
11:48of merchandise
11:48or traceability
11:49of the inventory
11:50It is also defined
11:51by batch
11:52and expiration date
11:53whether it applies or not.
11:55That is to say,
11:56I can receive
11:57no batch date
11:58and expiration,
11:58of course.
11:59Can I receive
12:00with batch date
12:01and expiration date?
12:01Of course.
12:02Of course it's possible.
12:03In the case
12:05that it be general,
12:06I say yes.
12:08Yes, everyone drives
12:10the same batch
12:11and the same expiration date.
12:13It's not that
12:14on an invoice
12:15as has happened to me
12:16me
12:16in production matters
12:18in factories,
12:19a supplier
12:19can bring me
12:20raw material
12:21several
12:22on the same invoice
12:24that the raw material
12:26It has different dates
12:27expiration date
12:29and from a different batch.
12:32So,
12:32that whole scenario
12:33here
12:33It is contemplated.
12:36So,
12:36I can
12:37simply select here.
12:39I tell him to add.
12:40I tell you, general, yes.
12:41In this case, I don't have one.
12:42I tell him to add
12:43because they are products
12:44that do not correspond
12:46to a lot
12:46and to a due date.
12:47They are destroyed by use
12:49this type
12:50inventory.
12:52But we're going to do it
12:52the complete exercise
12:53since we're on the subject
12:54in the demonstration
12:55or responding
12:55the questions
12:56that I accumulated the most,
12:59that I investigated further
13:00what happens
13:00at reception
13:02inventory.
13:03Is it possible to receive
13:04Direct inventory?
13:05Yeah.
13:06Is it possible to receive
13:07by lot number
13:08and expiration date?
13:08Also.
13:09It can be received
13:10at the same reception
13:13products that have a batch number
13:15and others who don't as well.
13:16For example,
13:17This one doesn't have a lot number.
13:18But I can locate
13:19a product,
13:19For example,
13:20this,
13:21that it does have it.
13:22I double-click,
13:23Bring it here for me.
13:24I tell him,
13:24For example,
13:256 and I specify
13:26a lot.
13:27For example,
13:28ABC-01,
13:31For example,
13:34has a lot.
13:36General,
13:37This time I'm telling you
13:38no.
13:38What does no mean?
13:40That it is not general,
13:41that this one has a lot,
13:42TRUE?
13:43Expiration date,
13:44We're going to put it on,
13:45For example,
13:46November 30
13:47and I tell him no.
13:49That means
13:49that this record
13:51It has no lot
13:52nor expiration,
13:53but this record
13:54Yes, it does.
13:55So,
13:55When I'm going to add it,
13:56He places it,
13:57It puts me
13:58to this one who has no
13:59and this one who does have it.
14:00I can place
14:04all those scenarios
14:05within the same reception area.
14:08I can also specify
14:09the employee
14:10that is moving me
14:11the inventory
14:12or the one who arrived,
14:13For example,
14:13from the list,
14:14I locate it dynamically.
14:15For example,
14:16Here is José Alcántara,
14:17For example,
14:17double-click,
14:18He puts it here for me.
14:19and I can also add
14:20any type
14:21observational.
14:24Ready.
14:24I can receive
14:25This invoice,
14:27the 111th,
14:30For example.
14:31Can I give you
14:32register purchases?
14:33Yes, perfect.
14:33Look,
14:33register purchases.
14:35Ready,
14:36merchandise registration
14:37done.
14:38I already have
14:39direct purchase.
14:41Can I audit it?
14:42Yeah,
14:43I can audit it.
14:43Let's give it a try
14:44to audit purchases
14:45And here I have
14:46a list
14:47of documents
14:47purchase
14:48that like
14:48that request,
14:50I can export it
14:51to Excel.
14:52I have all
14:52the audit
14:53of the month,
14:54For example,
14:54Here I tell you
14:54the month,
14:55load list
14:56and here
14:56I'm going to get them
14:57to show.
14:58Notice that
14:58the last
14:59that drags 3
14:59This is it,
15:00the 111
15:01that I just
15:01to do
15:02live
15:03with you.
15:03I can
15:04double-click
15:04and I can
15:06See this document.
15:07If there was any mistake,
15:08I can
15:09cancel
15:09and it goes
15:11to take out
15:11of the inventory.
15:13Also
15:13I can do it
15:14export,
15:15I can export it
15:16a PDF
15:16and it brings me
15:17the data
15:17of the company,
15:18the data
15:19from the supplier,
15:20the data
15:20from the invoice,
15:21the correlative
15:22purchase,
15:22the deposit
15:24where the resection was performed
15:26their totals
15:27in the currency
15:28And of course,
15:29This is a document
15:30general that also
15:31can
15:35personalize.
15:37Very good.
15:38Can
15:39also
15:40audit
15:41a request
15:42purchase
15:42because it arrived
15:43exactly
15:44as requested,
15:45of course,
15:46Here we give it to you
15:46look for
15:47and I have a list
15:48application
15:48orders
15:49to the supplier
15:49And he tells me,
15:50Well,
15:51this correlative
15:524
15:52of equipment
15:54to the greatest
15:54It arrived
15:55exactly
15:56what I asked for.
15:57Perfect.
15:58I double-click
15:58And here it is.
16:00Which invoice did it come on?
16:02Well,
16:02It was on the bill
16:05555.
16:06I'm going to resect it
16:07in the main warehouse.
16:09Who arrived
16:10or this employee
16:12He was the one who moved her
16:13and I tell him
16:13register purchase.
16:15Ah,
16:15of course,
16:16I'm missing the date
16:17which was today.
16:17He warned me there,
16:18Look,
16:18He won't let me.
16:20He won't let me.
16:21Not here either
16:22He's going to leave me.
16:23Notice that here
16:23a date.
16:24He tells me,
16:25not allowed
16:26previous dates
16:26on a specific date.
16:28It happened to me live.
16:29He won't let me.
16:31I have to place
16:31a date
16:32valid.
16:34Register purchase.
16:35He tells me yes.
16:35Ready.
16:38I can audit it,
16:39of course,
16:40audit purchase.
16:41Here it is.
16:42Here it is
16:42the purchase.
16:45Here it is
16:46the purchase
16:48555.
16:49555.
16:49That's it.
16:50No,
16:50sorry,
16:51Not here.
16:52Here.
16:52Look for,
16:53Load list.
16:54Notice that
16:54this purchase,
16:55the 4th,
16:56I can't get it to work anymore
16:58without receiving.
16:59Now it shows me
17:01received
17:02because already the
17:05already the
17:06I already received it.
17:07And of course,
17:08I am here applying
17:09of product,
17:10If I place it here
17:11that comes out
17:11received
17:12And I want to delete it.
17:14He's going to tell me,
17:14this request
17:15It has been received.
17:16We must eliminate
17:17the purchase first.
17:18A purchase has already been made.
17:19assigned to this
17:21application,
17:22therefore,
17:22I can no longer delete it.
17:24I have to first
17:25remove it from here.
17:26In theory,
17:27I have to
17:28remove from here.
17:29I have to delete it
17:31from here
17:31in order to be able to
17:33this
17:36delete the request.
17:37What do I mean?
17:38With this?
17:38That we have
17:39total control
17:39of traceability
17:40during the purchase.
17:41Perfect.
17:43Now,
17:44this is
17:44during the purchase.
17:46Until now
17:47We've arrived here.
17:48Let's,
17:49quickly,
17:49Let's see here
17:50transfer of goods.
17:51Since this is very normal
17:52which also
17:53I've been asked that
17:54a lot
17:54because there are businesses
17:56that maintain
17:56more than one deposit
17:57within the same
17:58organizational structure.
17:59They move between sheds
18:01and they have shed A,
18:02shed B,
18:03shed C,
18:04They have a northern warehouse,
18:05They have a south warehouse.
18:06So,
18:06It's very normal.
18:07to have this type
18:08inventory
18:09and we want everything
18:09centralized
18:10in the information.
18:11Well,
18:11perfect.
18:12I can do
18:13inventory movements
18:14with expiration dates
18:15and specific batches
18:16between deposits.
18:17I say,
18:18Well,
18:18Today I want to move
18:20of main warehouse
18:21to the north warehouse,
18:22I want to move
18:23that purchase
18:24that I received,
18:24For example,
18:25audit,
18:26sorry,
18:27here,
18:27search for products
18:28and I place it here.
18:29and well,
18:30These six,
18:31These six who are here,
18:33I want to move them
18:34complete,
18:35These six,
18:36I want to move them
18:39for
18:42safety vests
18:44who have this batch
18:45and this expiration date,
18:47I want to move them completely
18:48for the north winery
18:49because I bought them
18:50there.
18:50Ah,
18:51perfect.
18:52Who's going to move them for me?
18:52For example,
18:53here,
18:54Pedro Mora,
18:56I tell him,
18:57transfer
18:58because of the question
19:01XXX,
19:01It shows me the value
19:03and I tell him
19:03keep.
19:05Ready,
19:06I already moved the inventory.
19:07I'm telling you here
19:08audit
19:09and I also have
19:10by date range,
19:11See list,
19:12I can locate him
19:12per employee
19:13by deposit
19:14And here I have
19:15the last move,
19:18Here it is,
19:18the six,
19:19I tell you to export
19:20And I'm going to have
19:21my document
19:22transfer
19:23detailed,
19:23in this case
19:24There was only one,
19:25It shows me
19:25the correlative
19:26from the document,
19:27who moved it,
19:29from where,
19:29where to
19:30and the whole
19:31of the movement
19:32that involves me
19:33both in products
19:34such as financiers.
19:36Good,
19:37Can I cancel it?
19:38Yeah,
19:38me after having it here
19:39I delete it
19:40And I'm going,
19:41the inventory
19:42It's going to fit me.
19:44Perfect,
19:45later
19:46having seen
19:47These six modules,
19:48Now let's go
19:49with the bulk,
19:50entrances and exits.
19:52Entrances and exits
19:53It's a form
19:55what he asks of me
19:56the date
19:57of the movement,
19:59the modality,
20:00whether it's an inlet or an outlet,
20:01let's say,
20:02Well,
20:02exit in this case,
20:04the reason,
20:05whether it's
20:05for whatever reason,
20:07Well,
20:07Let's say hourly consumption,
20:09I'm giving an example,
20:11the reasons
20:12for which
20:12the inventory is going to be sold,
20:14outlet deposit,
20:15For example,
20:16It's going to the north warehouse.
20:19sorry,
20:20exit deposit
20:21It is the main warehouse,
20:22I'm going to take out
20:23inventory
20:24from my main warehouse,
20:28I locate the person responsible
20:29that he's going to take
20:29that inventory,
20:31For example,
20:32here,
20:34And now, yes,
20:35I locate
20:35search for products
20:36And I have here
20:38see existence,
20:39I have everything here.
20:39the inventory
20:41classified
20:41by batch
20:43and by expiration,
20:44There are those who have
20:45lot and expiration date
20:46And then there are those who don't.
20:47They have a batch number and expiration date,
20:49good,
20:50So in this case
20:51hills,
20:51hills,
20:53this,
20:55The appropriate thing would be,
20:56hey,
20:57I want
20:58only the north warehouse,
21:01Okay,
21:01in northern warehouse
21:02I have this inventory,
21:03I have all 6 vests
21:04security
21:05what did I do
21:06from the application,
21:07Okay,
21:08These are the ones I
21:09I want to take out,
21:10that ABC01 has,
21:12Okay,
21:12perfect,
21:14double-click
21:14And he's going to bring them to me.
21:16say,
21:16There are 6 in total,
21:18But be careful,
21:19that here then
21:19It is not a main warehouse,
21:20This is the north warehouse,
21:21It is very important,
21:23because?
21:23because I can have
21:24the same inventory,
21:26different amounts
21:26in multiple
21:28deposits,
21:30depending
21:30of its expiration date
21:31or those that do not apply
21:32also,
21:33in this case
21:34one must have
21:34total control
21:35of the inventory
21:36of what arrived,
21:37I know this inventory
21:38I have it in the north warehouse,
21:39I say here,
21:40outlet deposit,
21:42North warehouse,
21:42I have this 6,
21:43I tell him to add,
21:44ready,
21:45and I place the observation,
21:47exit via XYZ,
21:50perfect,
21:51I tell you to save
21:52And he tells me,
21:52you're sure
21:53to perform the movement
21:54inventory?
21:55I say yes
21:56and he tells me, "Okay."
21:58Where can I have it audited?
21:59Well,
22:00I tell you to audit
22:01and here,
22:02This is a list
22:02inventory movements
22:04where I can audit
22:05by modality
22:06entry and exit,
22:07per inventory deposit
22:09or by date range
22:10Specifically,
22:11If I tell him
22:12See inventory list,
22:13He's going to show me
22:15all those who have left,
22:17Here is the order
22:17documentation
22:18of the exits
22:19and from the deposit
22:21from where they came,
22:22I have all of these
22:23that came out
22:24from the main warehouse
22:25And I have all these
22:26that came out
22:26from the north cellar,
22:28If I tell him
22:29Double click here
22:30and I tell it to export,
22:31He's going to show me
22:32documents
22:33of movement
22:33inventory,
22:34I'm going to get it
22:35the data
22:36of the company,
22:37the type
22:38of movement
22:38What a way out,
22:39the reason,
22:40the deposit
22:41from where it came
22:42the inventory
22:43and the person responsible
22:44of the same
22:44to move
22:45the inventory
22:46and of course
22:47the description
22:48detailed
22:48by name
22:49of the product,
22:50unit of measurement,
22:51batch,
22:52unit cost,
22:53amount
22:53and the total
22:54both in products
22:55as financial
22:56of this movement.
22:59Can I cancel it?
23:00Why did I make a mistake?
23:01Yeah,
23:02perfectly,
23:02I call it auditing,
23:04View status
23:04of movement,
23:05I double-click
23:06And if I press here
23:07I delete it
23:08without any problem
23:09and I can return it
23:10to be done.
23:12Now yes,
23:14This is the module
23:15of tickets
23:16and exits.
23:17If I say entrance,
23:18It will increase my inventory.
23:19If I log an exit,
23:21it will subtract from me
23:22the inventory.
23:23Where am I monitoring it?
23:24What type of inventory?
23:25Perfect,
23:25Let's go to the control KPIs
23:27where I am here
23:28I tell it to load the list
23:30And he's going to show me
23:31the entire inventory
23:32that I possess
23:33of different
23:36types of the same.
23:41Good,
23:42I'm telling you here,
23:43hey,
23:43I want,
23:44show me
23:45main warehouse,
23:47Here I have my main warehouse,
23:48show me
23:48North warehouse
23:49and obviously
23:50He changes me,
23:51He changes me
23:52the quantities.
23:56Here I have
23:57critical stock 7
23:58and I have one
23:59Low stock.
24:00I can locate
24:01by category
24:03or by number
24:04of a specific batch
24:05or by date
24:06expiration date.
24:06This entire report as well
24:08I can export it,
24:09For example,
24:10here,
24:10desk,
24:11keep
24:13And here it is.
24:16I have it here,
24:19I'm going to,
24:19here,
24:21I have it here.
24:23I can work on it
24:24or do anything else
24:25type of calculation.
24:27Here,
24:27Let's stay here.
24:28Then he shows me
24:29My entire inventory is here
24:30And I tell him,
24:30hey,
24:30show me
24:31North warehouse.
24:32Here it shows me,
24:33Ah,
24:33I no longer have anything from this lot,
24:35It's already at zero.
24:36Why is it at zero?
24:37Because I did 6,
24:38I received 6,
24:39I moved 6
24:40and then I took it out.
24:42I don't have it anymore.
24:43Perfect.
24:46Now,
24:46I tell him,
24:47also the main one,
24:48He shows it to me here.
24:50It shows me what I have.
24:51I still have more.
24:52Okay,
24:53perfect.
24:54Here it tells me
24:54low stock
24:55because this product
24:56It's a safety vest.
24:57If I remember correctly,
24:59we configured it
25:03150,
25:04Ah,
25:04No,
25:0410.
25:04Ah,
25:04Well,
25:05We'll put a minimum of 10.
25:07and it's 72.
25:07That's all for now.
25:08But of course,
25:09This is general.
25:10Good.
25:13Here I can see
25:14each product,
25:16how are you
25:17the level
25:18of the inventory
25:19by product,
25:20but also
25:21by batch
25:22and by expiration date.
25:23For example,
25:24O123.
25:25I tell him,
25:26hey,
25:27Just show me
25:28O123.
25:31Load list.
25:32There it is.
25:34Now,
25:34But this is a general rule.
25:36Both are in critical condition.
25:37But I want to see
25:38where they are most critical.
25:39Both are in critical condition.
25:41Main warehouse
25:42I have 14 pairs of glasses
25:45and 28 gloves.
25:46Both are in critical condition.
25:48And at Bodega Norte
25:50I have 5 pairs of glasses
25:52and I have 10.
25:54I mean,
25:54I am 5 and 10.
25:55Everyone is critical
25:56due to the type of configuration
25:57which is educational information.
25:59But if I have
26:00the same batch
26:01distributed
26:02in different warehouses,
26:03He shows it to me
26:04by deposit.
26:05Good.
26:09Clean.
26:10Go out.
26:11Now,
26:12the reports module.
26:14I have
26:14the reports module
26:16that shows me
26:17the products
26:18that I have registered
26:20with its classification.
26:21I can export them
26:23in PDF,
26:24export here.
26:26He shows them to me.
26:29It's here.
26:31And here they are
26:32all products
26:34that I have registered.
26:35The names,
26:36the description,
26:37the unit of measurement,
26:37your category,
26:38brand,
26:39model,
26:39serial.
26:39These are all the products
26:40and its intrinsic properties
26:42that we have recorded.
26:44I also have
26:45existence
26:46of the inventory.
26:47Very important.
26:48That's the one that the most
26:49It will be verified.
26:52Load inventory.
26:53It shows me
26:54the amount
26:55of the products I have,
26:56the unit of measurement,
26:57existence,
26:58the cost of inventory
26:59and the cost
27:00of each product
27:01by weighted average.
27:03He's going to show me
27:04the whole
27:04of the products
27:05and the total here
27:06of the cost of inventory.
27:07Can you show it to me?
27:09by deposit.
27:10Yeah.
27:10I tell him,
27:10Show me the main warehouse
27:11only.
27:12Load inventory.
27:13Here it is.
27:15Show it to me
27:16through the north warehouse.
27:17Here it is.
27:18Load inventory.
27:19Here it is.
27:19Show it to me in batches.
27:20For example,
27:22O123.
27:23I just want to verify
27:24existence
27:25of this batch.
27:26Carry.
27:27There it is.
27:28I have 19 gloves,
27:3238 gloves,
27:3319 lenses.
27:34Now show me
27:34that lot,
27:35but in the main warehouse.
27:36Load inventory.
27:37Here it is.
27:39I have total control
27:40about the amounts
27:42inventory
27:43that I have
27:43by batch,
27:44by deposit,
27:45by category,
27:46by expiration date.
27:47And you can export it too.
27:50I have the historical card
27:51of movements.
27:53A very important report.
27:57I tell him
27:58search for historical movements
27:59And he's going to show me here
28:00all the movements
28:01and brings an exit
28:02of all products
28:04and the inventory
28:05how it was affected
28:06then.
28:07I tell him,
28:08For example,
28:09this month,
28:10TRUE?
28:11To O123,
28:14For example,
28:15search for movements
28:16And I tell you here,
28:18For example,
28:19safety glasses.
28:20Here,
28:20in main warehouse,
28:22Find me the gloves
28:24of,
28:25safety glasses.
28:26Here it is,
28:27For example,
28:28all the movements
28:29that has had
28:31safety glasses.
28:33How was the movement?
28:34total historical
28:35of the safety glasses?
28:38In this case,
28:38This product,
28:39Look,
28:41I have to make the first move
28:43It was an entrance
28:43in purchase document 3,
28:45safety glasses,
28:46in lot 123,
28:48There were 36,
28:49existence 36.
28:51Then there was an exit
28:52of these lenses.
28:53In document 1
28:56Six units were released,
28:58There were 30 left.
28:59Then there was another exit
29:00in document 2,
29:025 units were subtracted,
29:0325 of the 30 remain,
29:0525.
29:06Then there was a transfer
29:07between deposits,
29:09There were 5.
29:10out of 25, 20 remained.
29:12And then there was another way out,
29:14in output document 4,
29:176 were subtracted from 20.
29:1914 remain,
29:20which is current existence
29:22of these lenses
29:23in this lot.
29:26Historically,
29:27It's going to give me the movements
29:28by products
29:29to find out what happened
29:30with each one.
29:31If I tell him
29:32export to PDF,
29:34He's going to show me
29:35all that data.
29:37The date range,
29:39the date range,
29:40He's going to show me
29:42the deposit
29:44which I am auditing
29:45the product,
29:46the lot
29:47of the product,
29:48the movements
29:49with document,
29:50in case I need to audit
29:51a movement
29:52in some module,
29:53the product name,
29:55its unit of measurement,
29:55your lot
29:56and the amounts
29:57how they changed
29:58over time.
30:00A report
30:01very important.
30:02This gives me
30:03yet,
30:04absolutely
30:05with everyone.
30:07Very good.
30:10I also have
30:10the report
30:12of tickets.
30:13The report
30:13of tickets
30:13It's going to bring me
30:14all the movements
30:15of tickets,
30:16tickets for transfer,
30:17refunded tickets,
30:18mostly
30:19tickets purchased
30:19inventory.
30:20For example,
30:21I can audit here
30:22the month range,
30:23I can audit here,
30:25I can audit
30:25a specific deposit,
30:27For example,
30:27store,
30:28all documents
30:29These are for sale,
30:30For example.
30:31Buy direct inventory,
30:33inventory purchase
30:34from several lots
30:35different,
30:35I can audit
30:36per product only
30:37or I can locate
30:39to a supplier
30:39Specifically,
30:40Yeah,
30:41But I mean,
30:41hey,
30:41I just want to buy.
30:42of equipment
30:43of PP,
30:44For example.
30:45See the report,
30:46Here it is,
30:46This is what I bought
30:47in July,
30:47that brought me
30:48This supplier
30:49and they all belong
30:50to the same invoice
30:51purchase,
30:52purchase 1,
30:52For example.
30:53He brought me all this,
30:55I can export it to Excel,
30:56I can export it to Excel
30:58to audit it
30:59or do anything else
31:01motion
31:02or calculation,
31:03Here it is.
31:07Here they are
31:07the movements
31:08inventory,
31:09the date,
31:10the entrance,
31:10the correlative,
31:11the supplier,
31:12the name,
31:13in these products
31:13They didn't have a lot,
31:14deposit,
31:15cost,
31:15quantity and total.
31:17Perfect.
31:18I can also
31:21place a product
31:22Specifically,
31:23For example,
31:24I say,
31:24Well,
31:24safety gloves,
31:26I want to see the movements,
31:28Here it is,
31:29He has only had two,
31:30But I'm going to look for a warehouse.
31:33has only had
31:34safety gloves,
31:36Only 12 arrived
31:37at a reception
31:38that has no lot
31:39in document 1
31:40of purchase.
31:41Ah,
31:41I want to see that document.
31:42purchase,
31:42I can audit it.
31:44Perfect.
31:45Similarly
31:46I have the exit report,
31:48the exit report
31:48I have it detailed,
31:50Here's the exit report,
31:51I have it detailed.
31:52by product,
31:54per employee,
31:55by batch,
31:55by deposit,
31:56the quantities,
31:57by document
31:58and obviously
31:58by date range.
32:00He can tell her,
32:01hey,
32:02Just analyze me
32:03this month
32:03from the outlet tank
32:05from Bodega Norte,
32:06For example,
32:06He's going to show me
32:07only one,
32:09which is the one I just finished
32:10to do during the video,
32:11because I hadn't done it.
32:12Here it shows me
32:13which was the vest
32:14security
32:14in this batch
32:15from the deposit
32:16from Bodega Norte
32:17and there were six amounts.
32:18If I tell him
32:19the main warehouse
32:20See the report,
32:21He's going to show me
32:22all documents
32:24exit
32:24from the deposit.
32:28They left.
32:30of the premises
32:31and others were
32:31due to internal transfers.
32:34He's going to show me
32:35in detail
32:35all products
32:36with your document
32:37and its lots
32:38and their quantities.
32:40I can do it too.
32:40Export to Excel
32:41or I can audit
32:42a specific product
32:43or I can audit
32:44an employee.
32:45I just want
32:46what he took out,
32:46For example,
32:47Raúl Alfredo.
32:48Double-click,
32:49See the report.
32:50Here's everything
32:50what moved
32:51Raúl Alfredo.
32:52A report
32:53that they have requested it of me
32:54a lot,
32:55that they want to see
32:55the exit
32:56totaled
32:57by an employee
32:58specifically.
32:59Not all operations
33:00They are the same,
33:00but most
33:02share
33:02that request.
33:05Perfect.
33:05And lastly,
33:07very important,
33:08ABC classification
33:10that analyzes me
33:11inventory outflows,
33:13the quantities
33:13with its costs
33:14And he tells me,
33:15Well,
33:16It's just a button,
33:18I tell him,
33:18Upload ABC classification
33:19And he tells me,
33:21Well,
33:21you have right now
33:21six unique products,
33:23no more,
33:23You have a total
33:24according to the costs
33:25of 1144,
33:27the unit of coins
33:27that we have
33:28in settings
33:29and he tells me
33:30the ABC classification.
33:32He tells me,
33:32I have two products
33:33which are Class A,
33:34a product that is class B
33:35and I have three
33:36which are class C.
33:38He tells me
33:38how many products,
33:40this sum
33:42Place it here for me,
33:43I have it right now
33:44which are two Class A classes,
33:45one class B
33:46and three C classes
33:47And here it places me
33:49which in total
33:50I have six products.
33:51Can I export
33:52This classification?
33:52Yeah,
33:53I can export it,
33:54Look.
33:55I have it here now
33:56And here it is
33:58even
34:00with
34:01segmented
34:02by color.
34:03The total,
34:04the percentage
34:05And I have this report.
34:07Good,
34:07I'm going to leave
34:08This demonstration
34:09up to this point.
34:11If you have any questions,
34:13if you want to get
34:14in contact,
34:14the numbers,
34:15discretion
34:16I'm going to quit.
34:17Any observations
34:18that you can comment on,
34:20any feedback
34:21that we can have,
34:22I have no problem with that.
34:24I am at your service
34:25and well,
34:27wait
34:28that with your observation
34:29I can improve
34:30This application
34:31or this concept
34:32which I am adding.
34:33It's been a pleasure.
34:34See you later!
34:34in a future installment.
Comentarios