Wow, this was very useful and informative! You can also import/export Excel files to inventory management softwares for real-time inventory tracking in Multiple Locations, so check it out 🙌
Hi. Thank you for this inventory template. It has been a life saver for me at work. I have been using it for one location but as i copied your style for the second location, the formular has been returning 0 for the second location. Please can i do? Help me please.
Thank so much for putting out a very useful information, really helpful, however I followed to the T's and its not populating my "summary sheet" with entries from "input data sheet". Tried severally and took a lot of time to make sure I did it accurately but still didn't get the desired result... What do you recommend?
Very useful...bro can u upload pharmacy shop related Excel like daily stock audit based on location, category,in out,return, closing stock Work out in one excel and import data from other excel
Thank you for the informative and helpful video. I followed your instructions meticulously, but encountered a problem at the end of the process: when transferring items from one location to another, the closing stock quantity at the destination warehouse seems to be doubling. I double-checked all data in the formulas, and everything appeared correct. What's particularly puzzling is that even though it was the first transfer into that location, the opening stock was exactly the same quantity as I tried to transfer in. Consequently, the closing stock became Opening stock + Transfer IN, resulting in double the Transfer IN quantity. Where could the problem be?
Well done, PK ,for this beautiful work. I observed in the daily trend template that months that are less than 31 days fill up with immediate next months, e.g. February fills up with March 1,2,3, April fills up with May 1, June fills up with July 1, etc. Is there any way to restrict the dates to only the available days in each month chosen at a time on the daily trend? Thanks in anticipation.
great Video - i have added an OS (opening stock) drop down choice for the Opening stock column, if I have an opening amount of eg:200 for product 1, and 3 weeks later i get more stock "IN" for product 1, its adding another line on the summary instead of looking for Product1 and putting that under the IN column, how do I fix?
Great work PK, One small doubt, Is there any possible to create auto login with auto download excel with vba? Like. We are working in GST Filing Department. We are so tired to login in GST portal and downloading files also difficult. Is there any chance to solve this problem?
hi thanks for the video! I have a problem here I hope you can fix this for me :) I want to share closing stock everyday to different salesperson (for example only WH1) with composition as follows: sp1 gets 20% of the closing stock (for each product) sp2 gets 20% sp3 to sp8 gets 10% each and let's say sp1 (salesperson 1) written in a new file so how can I share this information to my friend so he can get his own stock given and also he can order only from the stock given sorry if my english is bad thank you :)
I wonder why the closing stock is Opening Stock + Stock In ...... while the Opening Stock = Stock In - Stock Out ..... from my understanding means you have "double adding Stock In" for the Closing Stock
Hi pk thanks for the great job it seems that there is a discrepency between summary and daily trend 03:37 to 03:47 you should have 34 closing inventory instead of 14 as initial was 24 stock in 20 stock out 10 so closing is 34 correct on summary but wrong calculation in daily trend
HI PK GREAT AND EDUCATING TUTORIAL. I HAVE A QUESTION AS I AM TRYING TO DO THIS SAME FORMAT ON GOOGLE SHEET AND HAD NO TROUBLES FROM THE BEGINNING UNTIL THE DAILY TREND PART AND THE DATE FORMAT WITH THE DAILY DATES AND THE DATA VALIDATED DROP DOWN "MONTH" & "YEAR" AS IT APPEAR IT DOES FINDS ERROR IN THE FORMULA "="1-"&MONTH CELL&"-"YEAR CELL" DATEVALUE... CAN YOU HELP OUT IN THIS FOR GOOGLE SHEET SYSTEM
Brother You are great! Just need some help once we transfer stock from w1 to w2 it is updated in Stock Summary but in Daily trend only W1 stock is updated ( Subtract the quantity) but it is not shown in W2 ( must be added in ) Can you please help me I have tried to make changes in the formula but failed. Looking for your response brother
I was working on the same project, and you helped me a lot. Thank you so much!!
Most welcome🙏
It's always that indian guy from UA-cam who saves you 🤩
Thanks for watching👍
@@PKAnExcelExpert Is there a way to have a documentation or tutor on how you did it. Even if it is paid for?
Thank you very much for good information that you gave to us
Most welcome
Hi PK, you have showed your expertise in creating excel templates. Congrats! Can we create MLM software database in excel vba?
Wow, this was very useful and informative! You can also import/export Excel files to inventory management softwares for real-time inventory tracking in Multiple Locations, so check it out 🙌
Glad it was helpful!
Hi. Thank you for this inventory template. It has been a life saver for me at work. I have been using it for one location but as i copied your style for the second location, the formular has been returning 0 for the second location. Please can i do? Help me please.
Thank so much for putting out a very useful information, really helpful, however I followed to the T's and its not populating my "summary sheet" with entries from "input data sheet". Tried severally and took a lot of time to make sure I did it accurately but still didn't get the desired result... What do you recommend?
Very useful...bro can u upload pharmacy shop related Excel like daily stock audit based on location, category,in out,return, closing stock
Work out in one excel and import data from other excel
will try to create a saperate video on this
@@PKAnExcelExpert thanks bro
Thank you for the informative and helpful video. I followed your instructions meticulously, but encountered a problem at the end of the process: when transferring items from one location to another, the closing stock quantity at the destination warehouse seems to be doubling. I double-checked all data in the formulas, and everything appeared correct. What's particularly puzzling is that even though it was the first transfer into that location, the opening stock was exactly the same quantity as I tried to transfer in. Consequently, the closing stock became Opening stock + Transfer IN, resulting in double the Transfer IN quantity.
Where could the problem be?
Can you explain to me ... That formula can drag to down
Thanks combination of inventory movements.
Welcome🙏
Hello it was very helpful , facing a error stock in and out date not fetching in the summary
sheet , could you help me
Great video. Can you add a feature for damaged stock. How to deal with this please. Thanks
Will add in the next version
I love this work. God bless you, Sir. Can you do one that has valuation e.g. FIFO, LIFO and Average cost?
Thanks for your valuable feedback. I will try to add this in next version.
Hi PK, thanks a lot for wonderful job.
Most welcome
Well done, PK ,for this beautiful work. I observed in the daily trend template that months that are less than 31 days fill up with immediate next months, e.g. February fills up with March 1,2,3, April fills up with May 1, June fills up with July 1, etc. Is there any way to restrict the dates to only the available days in each month chosen at a time on the daily trend? Thanks in anticipation.
in cell D7 write formula
=SEQUENCE(1,DAY(EOMONTH(C7,0))-1,C7+1,1)
@@abdulhananbaig8187 Hi Thanks for the formula. I'm struggling to implement the formula. Can you please explain how to use it in the spreadsheet?
great Video - i have added an OS (opening stock) drop down choice for the Opening stock column, if I have an opening amount of eg:200 for product 1, and 3 weeks later i get more stock "IN" for product 1, its adding another line on the summary instead of looking for Product1 and putting that under the IN column, how do I fix?
I m Interested to buy the file, i need few more columns in the input data sheet.
Thank you!
Most welcome
I may have missed this step but where/how does it highlight that you need to Re-order based on the Re-Order Level for each warehouse?
Very nice work. Thank you.
Our pleasure!
Great work PK, One small doubt, Is there any possible to create auto login with auto download excel with vba? Like. We are working in GST Filing Department. We are so tired to login in GST portal and downloading files also difficult. Is there any chance to solve this problem?
hi thanks for the video!
I have a problem here
I hope you can fix this for me :)
I want to share closing stock everyday to different salesperson (for example only WH1) with composition as follows:
sp1 gets 20% of the closing stock (for each product)
sp2 gets 20%
sp3 to sp8 gets 10% each
and let's say sp1 (salesperson 1) written in a new file so how can I share this information to my friend so he can get his own stock given and also he can order only from the stock given
sorry if my english is bad
thank you :)
excellent brother🙏👍👍👍👍👍
Most welcome🙏
I wonder why the closing stock is Opening Stock + Stock In ...... while the Opening Stock = Stock In - Stock Out ..... from my understanding means you have "double adding Stock In"
for the Closing Stock
Thanks 😊👍
Most welcome
I could not replace formula using find & Replace. Could you explain why?
Hi pk thanks for the great job it seems that there is a discrepency between summary and daily trend 03:37 to 03:47 you should have 34 closing inventory instead of 14 as initial was 24 stock in 20 stock out 10 so closing is 34 correct on summary but wrong calculation in daily trend
Yeah, it seems you're right... Have you tried and fixed it? I'm gonna try ha, ha
Hi sir, did you fix the problem to this formula?ive ben trying to fix it but still having an error pls help me
Thank you PK ❤️
Most welcome
HI PK GREAT AND EDUCATING TUTORIAL.
I HAVE A QUESTION AS I AM TRYING TO DO THIS SAME FORMAT ON GOOGLE SHEET AND HAD NO TROUBLES FROM THE BEGINNING UNTIL THE DAILY TREND PART AND THE DATE FORMAT WITH THE DAILY DATES AND THE DATA VALIDATED DROP DOWN "MONTH" & "YEAR" AS IT APPEAR IT DOES FINDS ERROR IN THE FORMULA "="1-"&MONTH CELL&"-"YEAR CELL" DATEVALUE... CAN YOU HELP OUT IN THIS FOR GOOGLE SHEET SYSTEM
Brother You are great! Just need some help once we transfer stock from w1 to w2 it is updated in Stock Summary but in Daily trend only W1 stock is updated ( Subtract the quantity) but it is not shown in W2 ( must be added in ) Can you please help me I have tried to make changes in the formula but failed.
Looking for your response brother
A am also facing this problem
Hi ,did you already find the solution to this problem?
thank you
You're welcome
Very good sir
Thank You!
How do you download this file? The site that it directs me to is full of fake downloads that are really ads. Why can't it be simpler?
In youtube only this video is available for multi store..and another little much sahab islam ka
Thanks🙏
How to download file for practice so we put our nod
Daily trend not updating from input data sheet
Put highlight in "input data" Sheet when we sell negetive stock qty
I will try to add this in next version
How do you input data and then to become like that.. like all the data can search automatically.
Will create in next version
Excellent PK...
Thanks
How to download this file
Visit www.PK-AnExcelExpert.Com
i have trouble with transfer in, anyone can help me ?
Can you share the template?
Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com
How to download practice file in excel sheet format
Download link is in description box or visit our website WWW.PK-AnExcelExpert.Com
The template isn't free :(
Sir, can you prepare vba to put password on multiple pdf files
With my respect, but why you made it so hard.
@@ovskihouse5270 is there any alternative brother
GRAND TOTAL KO DAILY TREND MI Kise dikahye
Will add in the next version
How to contact you 6 pm
डेटा शो नही हो रहा है summary sheet व daliy मे
sample stock video banana
We will try
My formula is not working. please help me out
Download this file and check the formula in it. Download link has been given in videos description box
Ye formula mai kam nahi ho raha hai
I have the solution. if you need let me know
Dear sir.....im a big fan of you sir....how to contact you sir...pls help me
Can I download this?
Love it!!! Don't miss out = 'Promo SM' !
Thank you!
You're welcome!