Thank you very much for this inventory management tool.I searched for something like this and nothing found any other good one than this.Thank you very much for your excellent work
Please I need your help. On the inventory management system after calendar insertion, and I click on the calendar it appears alright but the date in the textbox do not change rather the current date that will be there. Thanks
Thanks for this video it's very helpful for me. but i have one Question - i want delete only date row which is i selected not a Entire Row. can it possible, if possible please tell me how.
@PK This is amazing, I really like it. Qn: Is it possible to add a bar code reader onto this inventory management system, If so kindly guide on how it can be done. Thank you
very nice but i think you should track prices through time rather than updating them.For example, you may need to seperate the profit growth based on its cause(price vs quantity).Value indexes (Paasche and Laspreyes indexes) are in line with that
Thanks a lot, amazing Boss @PK: An Excel Expert . also please note that one error during product_master "product name" update time, our stock qty become zero
great. thanks for sharing this template to me. i just started small business. could you please show how to delete purchase or sale transaction? thank you
@@PKAnExcelExpert this is an amezing work out . Sir could you please share the updated sheet . It can be better if you add expenses(electeicity,tax,salaries ...) and income money
In my Problem, How to Create that System with Long Unit Description like the Lenses where it's has description Power minus Such Sv. Essilor Blue -1. 00 C-0. 50 etc
sir this is amazing . Could you learn us to enter purchases like bill select supplier side also. Then we can see supplier outstanding supplierwise and billwise. I think if it is can add here total outstanding also
Thanks a lot Boss @PK: An Excel Expert. I have learnt a lot from you. But I have one suggestion. Can there be a portion of creating invoice incase you are printing stocks sold to a particlar person in the Inventory Management System?
Sir any method fo reset current day profit, loss, purchase, sale log? I deleted all product so inventory went 0 but purchase and sale is still shown in label
Great sir.... Please add template batch no. , expiry date , supplier name, packing. .. As per product... I will be more helpful for pharmacy inventory management
Excellent tool created, thanks for creating such a great tool. Please can you add customer details entry provision and one more button for restocking products if customers returned the product back, Final changes to all the inventory details in main form. Thanks in advance for your informative and great videos.
Dear Sir, Show Inventory Management Form Button on setting page is not working Please help, as in video when ever you are clicking on it, its showing Inventory Management Form . Kindly help
Sir , I have a small doubt... If I download this template and try to make what I need .. do I need to make a dinamic calendar 📆 as you had shown in your previous videos ... Or we can edit that template... Cz I want to make my inventory system of tires ... I have a small shop of tires ..
Why I try to put condition on Start Date and End Date (Start Date < End Date), I got mixed results. Sometime, I chose Start Date which is smaller than End Date but the result showed it's bigger. Can you solve?
Thanks so much for this value template. I really love it. I have 1 more question to ask. Please help me sir.. => I have updated the Product Name in Product Master then the stock also updated, Combobox Product also updated, but it has not updated on the Sale_Purchase Transaction. So the summary in Available Stock Qty is wrong because of Product Name different between Product Master and Sale_Purchase. If I double click to update it, it show MISTAKE to END the VBA. I don't know how to solve it. Appreciate your help sir.. Thank you.
Great Presentation and awesome creativity but required uploading multiple items by Sales/Purchase voucher at a once time as usually in enterprise software.
Dear PK Sir, It's so beautifully made that I have no words to say, and it is so amazing inventory management file, really I like your all tutorials.. I'm telling you I have some requests, If you can add them then we will all be a little better. 1:- It would have been better if it had the option of GST invoicing the customer. 2:-If the stock adjustment was automatic after invoice create. 3:- It would be nice to have the option to product add or purchase multiple items. 4:- It would have been better if there was a Re-order level. 5:- It would have been better if the Report tab had Profit and Loss and Sale Summary Monthly. Sir, this is my personal opinion if these points were in this software then the software would be more complete and better for us. Thank You 🙏🙏.
Great Presentation and awesome creativity. Have you made any production tracker which is shared, means to say multiple user using one tracker and could see others production with auto save. And 2nd one is the appointment tracker. So it's my humble request you to please make a video on both, I know you are a genius in this so that requesting you. Thanks for sharing. Truly appreciated. Happy Learning 😊
Many thanks for this PK. I want to please ask of there's a short and quick way to upload the purchase product data in bulk rather than one at a time. Is there a way to do this from a table containing all the required data? Having a product list of over 500 units is a huge job. Thanks thanks.
This is the message that I receive every time I open this file on french version "Impossible de définir la propriété ColumnWidths. Le type ne correspond pas."
Hi pk, this is only one part of account. Please add billing system in which we input sale data. Which have party details , item hsn code, rate and other details.
A new look this video ADD . OPENINGS STOCKS (PRODUCT / ITEM ) DATE , AVERAGE RATE IN STOCKS IN SHOW AVAILABLE STOCKS IN HAND . THAN UPDATE & SAVE THEN PRINT IT
This we can update like we have stations same product we have 30 box a4 box 30 like that and I have 2 sub branch show from one branch to another branch I have to send it will not come on sales it's just transfer items to another branch pls do some updates
I would be great ful fi you could make the correction,s . New Look this video AS A POSSIBLE ... Plz ADD .this point OPENINGS STOCKS (PRODUCT / ITEM ) DATE , AVERAGE RATE IN STOCKS IN SHOW AVAILABLE STOCKS IN HAND . THAN UPDATE & SAVE THEN PRINT IT
Many thanks, PK, you have made my work far easier
Thanks for your valuable feedback
Thank you very much for this inventory management tool.I searched for something like this and nothing found any other good one than this.Thank you very much for your excellent work
Thanks Pk greate teaching god bless you From gopalganj Bihar
Really, I like your tutorial Many Many Thanks
Most welcome
Thank you for add this button.. If you add day Costing list, it will helpful for us.
Thanks!!
Excellent Program. Keep it up bro.
Thanks for your valuable feedback
do you have POS, where it will show the customer name and his/her purchases?
Thanks sir, from Bangladesh
Most welcome
Sir u done the great job sir. I am looking for this type of inventory management system.
This is very helpful for my inventory project. Can I request putting color and size for the product?.
Yes, sure, I will try to keep it in the next version.
PK, Thanks for sharing your genius.
how to add print invoice option on sale purchase display, then we can add thermal printer.?
Good morning sir...how to one data sheet to multiple data sheet only stock maintain
Please I need your help.
On the inventory management system after calendar insertion, and I click on the calendar it appears alright but the date in the textbox do not change rather the current date that will be there. Thanks
Hi bose this same thing is possible to Google sheet?
its great,but can you please put some option under purchase section like suppliers detail,DR or CR????
Thanks for this video it's very helpful for me. but i have one Question - i want delete only date row which is i selected not a Entire Row. can it possible, if possible please tell me how.
hi
want to somethinng
once the product this delete from product master then the product detail must get delete from Frm_Inventory_Management
If u add vendor or which supplier at the button it will be greats . Anyway amazing tutorial from others .. great n goodjob bro
Thank you so much for this tutorial.
Most welcome
@PK This is amazing, I really like it.
Qn: Is it possible to add a bar code reader onto this inventory management system, If so kindly guide on how it can be done. Thank you
When I have modify the excel sheet or use the template 'show inventory management form ' disappear and I can not find it again
can u please explain about macros and how u added launch page
Hi PK, thanks for the great work. Will this work if used on a French version MS Excel
Amazing. Very helpful teacher PK. Im hoping to include location per item.. Then having print preview for sales and purchases with date ranges.
hi , how can you add decimal points in quantity and description in product.. thanks
will try to add in next version
Very nice, i downloaded the template but it doesnt work for me. Is there something i should do first?
Thanks for the good work. Please can you make it possible to delete multiple items at the same time?
very nice but i think you should track prices through time rather than updating them.For example, you may need to seperate the profit growth based on its cause(price vs quantity).Value indexes (Paasche and Laspreyes indexes)
are in line with that
Thanks a lot, amazing Boss @PK: An Excel Expert . also please note that one error during product_master "product name" update time, our stock qty become zero
Sir this version 2.0 is awesome, only sale Invoice button is missing , can we expect in version 3.0 ?
Yeha i think yes!
@@vishalkushwah4154 waiting eagerly :-)
great. thanks for sharing this template to me. i just started small business. could you please show how to delete purchase or sale transaction? thank you
So nice first comment
Many many thanks
@@PKAnExcelExpertsir pls add opening stock also. Without opening feeling something incomplete..
@@PKAnExcelExpert this is an amezing work out . Sir could you please share the updated sheet . It can be better if you add expenses(electeicity,tax,salaries ...) and income money
This is awesome I love thank you very much
Thanks for your valuable feedback
So nice brother 🙏💜💜
Thanks
please add sale and purchase delete option
Perfect, Thank You Very Much.👍
Thanks for your valuable feedback
it's so amazing such a file with vba code, thank you PK for sharing it
Thanks for your valuable feedback
how about any adjustments like spoilage/breakage where can we input the details
and how about price changes of products SRP and cost
The update is great.
Thanks for your valuable feedback
In my Problem, How to Create that System with Long Unit Description like the Lenses where it's has description Power minus Such Sv. Essilor Blue -1. 00 C-0. 50 etc
Dear need out of stock item & reorder options
Thank you so much Sir
Thanks for your valuable feedback
HI How I can order on it?
This is helping me, but can i add Warning dialogue when I sale but the stock is running out instead minus. Thank You.
How can add product code(sku) option pls help me
sir this is amazing . Could you learn us to enter purchases like bill select supplier side also. Then we can see supplier outstanding supplierwise and billwise. I think if it is can add here total outstanding also
Yes plz
Thanks a lot Boss @PK: An Excel Expert. I have learnt a lot from you. But I have one suggestion. Can there be a portion of creating invoice incase you are printing stocks sold to a particlar person in the Inventory Management System?
Great suggestion! I will try to add in next version.
Sir any method fo reset current day profit, loss, purchase, sale log? I deleted all product so inventory went 0 but purchase and sale is still shown in label
any format for Vendor master please
this is amazing.
Thanks
It's good work so I want to purchase this software for my small business
it can be possible to make quotations?
hello sir,
how can i add purchase return and sales return button in user form
Please watch below video. It can be helpful:
th-cam.com/video/yd5BDFjFyxA/w-d-xo.html
Great sir.... Please add template batch no. , expiry date , supplier name, packing. .. As per product... I will be more helpful for pharmacy inventory management
Sir plz tell if we want to add name of purchaser or supplier ?
Your file is not opening in my excel.. Please help me.
What is the error?
Thank you for this tool sir... Really helpful.. Is there any way I can share you my suggestion for future tools by just altering your tools
Excellent tool created, thanks for creating such a great tool.
Please can you add customer details entry provision and one more button for restocking products if customers returned the product back,
Final changes to all the inventory details in main form.
Thanks in advance for your informative and great videos.
Dear Sir, Show Inventory Management Form Button on setting page is not working
Please help, as in video when ever you are clicking on it, its showing Inventory Management Form .
Kindly help
Is there item movement report?
Sir , I have a small doubt... If I download this template and try to make what I need .. do I need to make a dinamic calendar 📆 as you had shown in your previous videos ... Or we can edit that template... Cz I want to make my inventory system of tires ... I have a small shop of tires ..
is not running user form after clik the botton? how to resolve this poblem?
Thanks Sir
Welcome
Why I try to put condition on Start Date and End Date (Start Date < End Date), I got mixed results. Sometime, I chose Start Date which is smaller than End Date but the result showed it's bigger. Can you solve?
woow,....amazing......
I want Stock Inventory In Out Report with VBA Excel for Monitoring Record In Out per Days
I want warehouse simple inventory in which simple add-in out the record of the product with remark column.
Sir, Add multiple item selling and buying with master of buyer and seller.
Excellent work. Can you also add fields for expiry date.and Inventory location
Nice idea. Will include in next version
bro, gracias por el video,sos un capo
Good work sir
I am beginner to learn VBA and user form...
I Will try to understand this.
Please make school management user form in Excel VBA.
hlo sir i need your help for report
Thanks so much for this value template. I really love it.
I have 1 more question to ask. Please help me sir..
=> I have updated the Product Name in Product Master then the stock also updated, Combobox Product also updated, but it has not updated on the Sale_Purchase Transaction. So the summary in Available Stock Qty is wrong because of Product Name different between Product Master and Sale_Purchase. If I double click to update it, it show MISTAKE to END the VBA.
I don't know how to solve it.
Appreciate your help sir.. Thank you.
Same problem, did you fund a solution ?
Download link is not working. please help.
Great Presentation and awesome creativity but required uploading multiple items by Sales/Purchase voucher at a once time as usually in enterprise software.
Sir , if I delete product master data , transaction is not deleted but I want to delete from both site
You can unhide the relevent sheet to delete the data.
But sir if you add biling system for sales. then will be better for us also.
I have a problem running " ColumnWith type mismatch"
Thank you very much
Please add Expenses options
so user can see their profits and costs.
Thank you @PK
I will try to add in the next version
@@PKAnExcelExpert Thanks PK.
Dear PK Sir,
It's so beautifully made that I have no words to say, and it is so amazing inventory management file, really I like your all tutorials..
I'm telling you I have some requests, If you can add them then we will all be a little better.
1:- It would have been better if it had the option of GST invoicing the customer.
2:-If the stock adjustment was automatic after invoice create.
3:- It would be nice to have the option to product add or purchase multiple items.
4:- It would have been better if there was a Re-order level.
5:- It would have been better if the Report tab had Profit and Loss and Sale Summary Monthly.
Sir, this is my personal opinion if these points were in this software then the software would be more complete and better for us.
Thank You 🙏🙏.
Great Presentation and awesome creativity. Have you made any production tracker which is shared, means to say multiple user using one tracker and could see others production with auto save.
And 2nd one is the appointment tracker.
So it's my humble request you to please make a video on both, I know you are a genius in this so that requesting you.
Thanks for sharing. Truly appreciated. Happy Learning 😊
Sir when we expect new version
Nice and very helpful template, can you please include treatment for Inventory damages/theft/shortages and also sales representative if possible
Many thanks for this PK. I want to please ask of there's a short and quick way to upload the purchase product data in bulk rather than one at a time. Is there a way to do this from a table containing all the required data? Having a product list of over 500 units is a huge job. Thanks thanks.
This is the message that I receive every time I open this file on french version "Impossible de définir la propriété ColumnWidths. Le type ne correspond pas."
Hi pk, this is only one part of account. Please add billing system in which we input sale data. Which have party details , item hsn code, rate and other details.
Can you also please create petty cash template with userform
A new look this video
ADD . OPENINGS STOCKS (PRODUCT / ITEM ) DATE , AVERAGE RATE IN STOCKS IN SHOW AVAILABLE STOCKS IN HAND . THAN UPDATE & SAVE THEN PRINT IT
How to download it?
Below is the webpage link for this:
www.pk-anexcelexpert.com/inventory-management-system-2-0
Hello Friend, How to fix Run-time error 13. type mismatched. I cannot open my file anymore. please help
I have totally failed to download you files, pliz guide me
We want to video of access though it is contradictory with your channel name.
Plz add billing customers name expenses list sir plzzzz. Thank u
This we can update like we have stations same product we have 30 box a4 box 30 like that and I have 2 sub branch show from one branch to another branch I have to send it will not come on sales it's just transfer items to another branch pls do some updates
Sir is softtware price
Please visit the link given in the description or www.pk-anexcelexpert.com
@@PKAnExcelExpert sir im indian purchase payment?
I would be great ful fi you could make the correction,s . New Look this video AS A POSSIBLE ...
Plz ADD .this point OPENINGS STOCKS (PRODUCT / ITEM ) DATE , AVERAGE RATE IN STOCKS IN SHOW AVAILABLE STOCKS IN HAND . THAN UPDATE & SAVE THEN PRINT IT
I like it sir thank you sir
Sir, add also GST rate and party name.
HOW TO DELETE SALE OR PURCHASE ENTRY ??
Same prob..