Using Excel Macros, create an inventory management tool

Cerrado Publicado hace 3 años Pagado a la entrega
Cerrado Pagado a la entrega

We wish to create an inventory management tool, using excel macros. For this purpose, we will be maintaining a collection of excel files which will serve as data files. Some of these will be master files and some will be transaction files. There will be another interface file which will contain the menu needed to run this tool. This menu will have several buttons to carry out the following actions:

A) Masters

1) Create and edit consumable / non-consumable inventory masters

2) Create and edit vendor masters

3) Create and edit customer masters

4) Create and edit project masters

5) Create and edit finished goods inventory masters

B) Transactions

1) Create and edit entry of raw materials inward

2) Create and edit rejection of some faulty inventory from above

3) Create and edit issue of inventory for production

4) Create and edit generation of new finished goods inventory

5) Create and edit issue of finished goods to customers

As a part of this entire process, some documents get generated. They are store receipt voucher, material arrival intimation, store issue voucher, delivery challan and material gate pass. Also, some further reports may be needed which will be specified later.

Userforms need to be created to enter the data (in the data files) through the interface file. So make sure you are well-versed with the designing of the userforms. Some sample files are attached herewith.

Please issue your quote to execute this project and the expected timeline. Keep some margin in your quote for a little scope creep. Expect some iterations in the development process and a few rounds of back n forth communication till the product is finalised. Give your quote in terms of creating the project to put data into the system and generate the standard documents as indicated in the uploaded files. Give a separate quote for the reports in terms of per report development cost. Thanks!

Excel Visual Basic Visual Basic para aplicaciones

Nº del proyecto: #25839046

Sobre el proyecto

9 propuestas Proyecto remoto Activo hace 3 años

9 freelancers están ofertando un promedio de ₹26827 por este trabajo

rangav12891

Hi I have worked in Bosch ltd as Material Planner and currently as costing executive in FPI. I have good experience in Macros. My recent project was to create Hierachy chart in macros. Pls contact.

₹22222 INR en 10 días
(6 comentarios)
2.7
RequenaP

Good afternoon, I am Pedro Requena, Excel and .Net VBA Specialist, I was reading your request and I can do this work since I have an Application developed in Visual Studio 2019, which is called SYSPRIN, Production and Más

₹37000 INR en 14 días
(2 comentarios)
2.8
leoperusin

Hi! I am an Information System Enginner with 14 years of experience. I have done many projects related to Excel Macros and automations, So I have plenty experience in this area. I am new in freelancer.com, so thats why Más

₹25000 INR en 7 días
(1 comentario)
1.8
meena6214

I assure you that task will delivered meeting deadlines and accuracy. I hope to hear more about what would make your project a success for you. Thank you for your time

₹25000 INR en 7 días
(0 comentarios)
0.0
rinki9010

Dynamic, organized, action oriented, problem solver and highly motivated Senior project coordinator with 7+years of experience in Project support, Customer management, Order management, Vendor Management and Retail Ban Más

₹25000 INR en 7 días
(0 comentarios)
0.0
nagarjun6088

Data Entry Clerk with 4+ years of experience verifying complex data, inputting figures into client databases at a quick pace, and maintaining the confidentiality of sensitive material.

₹25556 INR en 5 días
(0 comentarios)
0.0
tyagiji2007

Dear San Namestay Please review my profile , I have the capability to perform any task successfully and honestly. Regards

₹25000 INR en 10 días
(0 comentarios)
0.0
sufi1994

Hello, I have an experience of tool creation for Warehouse management and Raw material risk assessment using VBA and macros. I can leverage my experience to create a tool for inventory management. Relevant Skills and Más

₹23333 INR en 10 días
(0 comentarios)
0.0
Triptitva

Expect world class delivery for sure ! Hi, I am a qualified masters in supply chain and bachelors in engineering with more than 15 years of experience in supply chain & data analytics. I am starting new in the online Más

₹33333 INR en 15 días
(0 comentarios)
0.0