Inventory Management Template for Multiple Locations

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

I could not replace formula using find & Replace. Could you explain why?

How to contact you 6 pm

How to download file for practice so we put our nod

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?

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 :)

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?

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

With my respect, but why you made it so hard.

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?

Thank you PK ❤️

Thanks combination of inventory movements.

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

Can I download this?

Thank you!

Love it!!! Don't miss out = 'Promo SM' !

डेटा शो नही हो रहा है summary sheet व daliy मे

Ye formula mai kam nahi ho raha hai

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.

Hi PK, you have showed your expertise in creating excel templates. Congrats! Can we create MLM software database in excel vba?

Sir, can you prepare vba to put password on multiple pdf files

I was working on the same project, and you helped me a lot. Thank you so much!!

I love this work. God bless you, Sir. Can you do one that has valuation e.g. FIFO, LIFO and Average cost?

Dear sir.....im a big fan of you sir....how to contact you sir...pls help me

Hi PK, thanks a lot for wonderful job.

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?

Can you share the template?

Put highlight in "input data" Sheet when we sell negetive stock qty

excellent brother🙏👍👍👍👍👍

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

Excellent PK...

Very nice work. Thank you.

sample stock video banana

Very good sir

Thank you!