This is one of the best formulas to control inventories and get alert to procure required materials. Since long I was searching for same type of inventory system but I couldn't. I'm so happy to see this formula and thank you very much for this,
This is very interesting because in place the data is inputted, and other places the data is getting updated dynamically. This is fantastic. Thank you.
Omg I did it.... thank you so much your going to have everyone at work thinking I know what I'm doing.....I do trying to make my job easier hahahahahah
@@smart-office12 *VERY NICE* 👌🏻 but EVERONE MISS OUT DAMAGE ITEM COLOUM Please make one like I mention Below: 1) Need to Add Damage Item, IF we have 10pc Total , but 1pc is damaged & 9pc are Good, THIS IS VERY IMPORTANT TO MENTION Please add that coloum of Damage but it should be like - Damage 1pc + 9pc Good = 10pc in STOCK ( Damage Item is return to Supplier & get New in Return ) 2) Need to be able to Add Full items of PURCHASE or Sales under One Invoice # not individually Eg: in one day we make Sale 10pc so need to see in Coloum = 4pc Inv#-44 / 3pc Invoice#-45 / 3pc Inv#-46 so need to know how many PC in each Invoice # Good to have Total Stock COST NEED Extra Coloum to show what's the weight of each Item Would be glad to pay for this Sheet if made according to my requirements Thanks
Wow this was one of the best tutorials I have viewed in a very long time, you have explained everything in such a excellent manner I could understand from the beginning what you were saying, thank you for your great video it helped me to successfully create my work sheet, Well Done.
Hi Sir u are a blessing to us and our comp. this is exactly what we have been looking for, for a very long time we appreciate u. Pls can u teach on closing this stock and opening it in different month, thank very much ❤
Nice But...... ▪︎ Need to make one where we make a Invoice & it should show Profit of Sale & STOCK Auto Adjust when we make Invoice ▪︎ Stock Auto Adjust & in hand Stock Total Amount ▪︎ Color Should go RED when desire Stock Amount goes LESS ▪︎ Sale to Every Customer of Item is made in Different Prices Retail Wholesale & different prices in Retail ▪︎ Add a Coloum for Damage Item to return to company Need to Add option for Different Sale Rates to Different Customers *Will Pay if you Make a Excel Sheet as per my Requirements*
This is very helpfull to control stock. Please, I would like to see how the sheet is created formated. I will really much appreciate if you Can reply to my comment and share how you build the system from begining. Thank you
Great tutorial. I enjoyed the sequential approach. It was very helpful. Please how do you handle a situation where you placed an other for two different products, say Products A and B, but had only product A delivered. If you replace the 'T' with 'R' for Product A, how do you deal with product B which you are yet to receive? Thanks.
It assumes that the transit quantity in one column is delivered together. If not, we have to keep undelivered product in another column and mark it as transit
It is a very good video. However, if you talk about the formula a bit earlier, that will be better for the members so we will be easy to understand the purpose of your system quicker.
Such an effective tutorial! I want to ask a question, Regarding R/T status. What if the orders are placed on the same date but each orders are received on different dates. Because the R/T status is right above the column. I want to put R for one order only but the other orders is still in transit. How to fix this? I would appreciate it so much if you reply to my comment sir 🥺
Thank you for this tutorial , now my question is about the formula you made mention of something like eco key while using the formular but I don't understand pls . Please kindly Explain to me better about the steps of the formula. Thanks.
Thank you for your great work just I want to inquire if the formla SUMIF can used between many pages and if yes, kindly let me know the way since I'm using your formula and adding to it '01:31'! but its showing #VALUE!
Good video. Thanks. Just a quick question do we make this inventory on a month by month. Are able to connect all months on a second separate spread sheet to show trends
Hi, thank you for this video, but my question is : it is confined to the specified boxes (14 in your video), and i want to use them throughout the month, so there are many boxes that i need, so what should i do? thanks
If you are trying to say the number of rows(14) , the row can be expanded by simply copy the row num 14 and paste them down. I have taken till row 14 just for example , it can be expanded till your requirements
Hello thank you for sharing this with us... But I want to use different sheet for stock in, and different sheet for stock out. But it's not working. Please help.
If you can do one on converting a recipe from cups to pounds. I work at a prison a lot of the recipes are in cups but I need them in pounds or the tea and tablespoons in cups due to the mass cooking we do. my average number of offenders on my unit is 800
Boss I want to know in excel suppose we have 100 item then I cell 40 then balance item shows 60. Then how can see how much percent balance. Can u make one vidio please
if fora certain date I have 200 items to stock in and 20 items stock out, All items should stay and it will be a long list. For the next date of stock in and 500 items are added, this will be a long list, is that correct. we can't minimize the stock in list.
Hi, I’m working my way through this video. I’m a novice when it comes to this so it’s taking a minute but I’ve watched the entire video once and I like the functionality of the completed spreadsheet. I have a question. At 29:20-29:30 you reference pressing a certain key to correct the formula. I can’t understand, what key are you saying?
Please assist on the formula after selecting after sumif and selected product range you said to press f4 key on the keyboard to fix selection i am pressing but not working
I hope you see this, the substraction and addition to get a balance stopped at a point, whenever i want to add or subtract stocks from a certain point, it doesnt work, i hope you can solve this for me
This is one of the best formulas to control inventories and get alert to procure required materials.
Since long I was searching for same type of inventory system but I couldn't. I'm so happy to see this formula and thank you very much for this,
Thank you for the appreciation 🙏
This is very interesting because in place the data is inputted, and other places the data is getting updated dynamically. This is fantastic. Thank you.
Thank you 🙏
Amazing Content..i remember my mentor in SAP who's Bangladesh Woman Indirah S..approved from 🇵🇭
Omg I did it.... thank you so much your going to have everyone at work thinking I know what I'm doing.....I do trying to make my job easier hahahahahah
Thanks
How did you set it up my procurement suggestions is responding
@@smart-office12
*VERY NICE* 👌🏻 but EVERONE MISS OUT DAMAGE ITEM COLOUM
Please make one like I mention Below:
1) Need to Add Damage Item, IF we have 10pc Total , but 1pc is damaged & 9pc are Good, THIS IS VERY IMPORTANT TO MENTION
Please add that coloum of Damage but it should be like - Damage 1pc + 9pc Good = 10pc in STOCK ( Damage Item is return to Supplier & get New in Return )
2) Need to be able to Add Full items of PURCHASE or Sales under One Invoice # not individually
Eg: in one day we make Sale 10pc so need to see in Coloum = 4pc Inv#-44 / 3pc Invoice#-45 / 3pc Inv#-46 so need to know how many PC in each Invoice #
Good to have Total Stock COST
NEED Extra Coloum to show what's the weight of each Item
Would be glad to pay for this Sheet if made according to my requirements
Thanks
A lesson I was looking for.
Very good & clear explanation
I 'm from sri lanka.
Thank you very mach sir,
God bless you.ok
Thank you
I've been trying to expand my knowledge in Excel and it's really helpful to me. Thank you for this.
Welcome 🙏
After Watch this Video, I immediately Subscribed your channel sir
Thank you
Very simple yet effective inventory worksheet. Thank you
Welcome 🙏
Wow this was one of the best tutorials I have viewed in a very long time, you have explained everything in such a excellent manner I could understand from the beginning what you were saying, thank you for your great video it helped me to successfully create my work sheet, Well Done.
Thank you🙏
Amazing , Excel , explained and showed in a great way!! Thank you Sir
Thank you.
Very useful thank you, ive adjusted it slightly for a project im working on and its perfect.
Excellent teaching and moved slow enough to follow. Amazing!
Thank you 🙏
A great and amazing Watch to this video from pakistan
Thank you
Hi Sir u are a blessing to us and our comp. this is exactly what we have been looking for, for a very long time we appreciate u. Pls can u teach on closing this stock and opening it in different month, thank very much ❤
Thank-you for Sharing a very useful information here. Very beneficial to my current role.
Welcome 🙏
Thank you for sharing this video.
Welcome 🙏
Awesome, very helpful information sir ,thanks for spreading knowledge... knowledge is everything.
Thank you so much 🙏
This is to the simplest way of understanding thanks
Thank you so much 🙏
Woow....It was the simply Best video I have seen on this flatform. Wish you all the best Bro
Thank you so much for your inspiring comment
Just Loved your Cheque Receipt software, regards from Noida
wow! this is really amazing, thanks for sharing.
Welcome 🙏
Wow! Amazing template, please kindly help factor in Damages and Returns in the next update video. Thanks well done.
Thank you! Exactly what I needed. I was able to follow your instructions very easily.
Welcome 🙏
Easy to follow instructions, works perfectly, cheers mate
Thank you 🙏🙏
this was extremely insightful
Thank you so much bro. I love your way to explained. ❤❤❤
Welcome 🙏
Oh my God, this is very good. It is very helpful for me. This is exactly what I was looking out for. Thank you very much.
Glad it was helpful!
it was so easy and productive,really thanks
Welcome 🙏🙏
Nice But......
▪︎ Need to make one where we make a Invoice & it should show Profit of Sale & STOCK Auto Adjust when we make Invoice
▪︎ Stock Auto Adjust & in hand Stock Total Amount
▪︎ Color Should go RED when desire Stock Amount goes LESS
▪︎ Sale to Every Customer of Item is made in Different Prices Retail Wholesale & different prices in Retail
▪︎ Add a Coloum for Damage Item to return to company
Need to Add option for Different Sale Rates to Different Customers
*Will Pay if you Make a Excel Sheet as per my Requirements*
thankyou for your useful and clear suggestion this was exactly what I want
Thank you
This is very helpfull to control stock. Please, I would like to see how the sheet is created formated. I will really much appreciate if you Can reply to my comment and share how you build the system from begining. Thank you
Hi, the template is available to download in the link given in video description
Thank you for this video, its just and exactly what i was looking for.
Welcome
Great tutorial. I enjoyed the sequential approach. It was very helpful. Please how do you handle a situation where you placed an other for two different products, say Products A and B, but had only product A delivered. If you replace the 'T' with 'R' for Product A, how do you deal with product B which you are yet to receive? Thanks.
It assumes that the transit quantity in one column is delivered together. If not, we have to keep undelivered product in another column and mark it as transit
It is a very good video. However, if you talk about the formula a bit earlier, that will be better for the members so we will be easy to understand the purpose of your system quicker.
Thank you for the valuable suggestion
Yeah anyone wanting to skip the intro... He starts at 15:00
Either way i like what they did. Thats what a good teacher does, stARTS WD intro then main subject.
Much thank you sir watching you from Kenya i am grateful, my question is, is it possible to put the month range from January to December
Yes, you can
Thank you for this video, it was reeeeaaaaly helpful.
Thanks and welcome
Such an effective tutorial! I want to ask a question, Regarding R/T status. What if the orders are placed on the same date but each orders are received on different dates. Because the R/T status is right above the column. I want to put R for one order only but the other orders is still in transit. How to fix this? I would appreciate it so much if you reply to my comment sir 🥺
Each order should be kept in separate column, once received, need to change T to R
ruclips.net/video/m6yBIQ-GQRg/видео.html@@smart-office12
I suggest using named tables and have different sheets for the stock in and out
This was extremely helpful, thank you!
Perfect.... Love the way you explained it...
Thanks a lot 😊
This is very helpful. Thanks
Great Job 👍. Thank you so much.
Most welcome 🙏
Thanks Buddy that was so helpful
Thank you for this great tutorial. Bless you.
Welcome 🙏
Really very useful and easy to use... thanks
this was a fantastice video, if possible please make this stock manangement with item price and caculations.
Okey, we will definitely work into it.
Thank you. Your template help me a lot..
Glad to hear that!! Thank you 🙏
Great video - after applying the formula my upper cells of stock out aren't working. Can you help?
Thanks for sharing 🙏
Very helpful and easy to follow.
Great to hear!
Hi im sorry. I find your video very helpful. Did you by any chance sell the template?
Hello, this template is free to download in video description
@@smart-office12 Hi Thanks!! Will this work for a large inventory? Since we are keeping track for purchase item this too will help right?
Thank you very much, this is very helpful
Thank you
very useful video thank you so much.
Glad it was helpful!
thank you.. it was very useful.
Welcome
Thank you for this tutorial , now my question is about the formula you made mention of something like eco key while using the formular but I don't understand pls . Please kindly Explain to me better about the steps of the formula. Thanks.
That is F4 key in the keyboard, to fix the cell reference in formula
very informative thank you i learned a lot
Glad it was helpful!
Pls can we update dx template with different stock items that x not part of the list of known stock items.tnk you
kindly one with the price as well thank you for this great work
Noted, thank you so much
My balance Quantity is =Opening stock +sumif()+sumif()+ total transit and it gave me the same result as yours.
It should be opening + sumif - sumif
great way!! Thank you .......
Welcome
How are you sir
This video is very very helpful sir.
But can you tell me what is the meaning of the (epro key )
F4 key
Thanks so much bother
I need your help i have 2000+ products names here is one collum 1100 spaech how i selected 2 product collum and 2 opening stock
hello sir. keep it up. thanks ❤❤
Woww it worked thanks alot!!
Welcome 🙏
Do you have another formula which product sold the most? Like a chart? Thanks in advance 🙏
Hello; What do you mean by Fix the Column. fix the sumrange
By pressing the F4 key in keyboard, that applies dollar symbols
Thank you for your great work just I want to inquire if the formla SUMIF can used between many pages and if yes, kindly let me know the way since I'm using your formula and adding to it '01:31'! but its showing #VALUE!
Good video. Thanks. Just a quick question do we make this inventory on a month by month. Are able to connect all months on a second separate spread sheet to show trends
Ya, this can be done monthly or yearly. Values can be linked to other sheets to analyze trend.🙏
Superb sir I will try
Hi, thank you for this video, but my question is : it is confined to the specified boxes (14 in your video), and i want to use them throughout the month, so there are many boxes that i need, so what should i do?
thanks
to be more clear, what should i do if i have more than 14 operation in the month?
If you are trying to say the number of rows(14) , the row can be expanded by simply copy the row num 14 and paste them down.
I have taken till row 14 just for example , it can be expanded till your requirements
Can you add a column to the “out” when inventory is sent that will track the expiration date?
Hello thank you for sharing this with us... But I want to use different sheet for stock in, and different sheet for stock out. But it's not working. Please help.
Plz visit below link
ruclips.net/video/Q9PaPMW657g/видео.html
very good.
If you can do one on converting a recipe from cups to pounds. I work at a prison a lot of the recipes are in cups but I need them in pounds or the tea and tablespoons in cups due to the mass cooking we do. my average number of offenders on my unit is 800
Boss I want to know in excel suppose we have 100 item then I cell 40 then balance item shows 60. Then how can see how much percent balance. Can u make one vidio please
what does it mean for poke i cant understand .. or dollar sign ! please reply what keys on keyboard we click
F4 key, which applies dolor sign
if fora certain date I have 200 items to stock in and 20 items stock out, All items should stay and it will be a long list. For the next date of stock in and 500 items are added, this will be a long list, is that correct. we can't minimize the stock in list.
Ya, In case of too many items, its quite inappropriate . This template best works in case we have limited number of items.
Thanks, BRO...Great Work...!!!
Thank you, this helps my inventory so much, can yiu also tell me, if im going to October, how do i bring the new opening stock to the next new sheet?
For October month, you have to create a new file, closing stock of September will go to October by copy and paste
@@smart-office12 thank you, we oways forgt the basic ehee a matter of copy paste 😁 thank you again, have a nice day frm Brunei 👍🏽
VERY USEFUL
Really great work 🙏🙏🙏
very impressive, how can access it
Thank you,
Please visit www.spreadsheetlearning.com for the template
can you please explain (the min stockto be kept) what is that for?
Please which key did you select on the keyboard after the Sumif(
F4 key
thanks very much@@smart-office12
Dherai Dhanyabad, maile kehi sike aaja.
What key did you press again at 29:22 for the range?
F4 key
What do I press instead of dollar sign? Sounds like cookie but I can’t work it out, sorry for the misunderstanding. Is it a shortcut on the keyboard?
I have adapted this for a work stock check and it works fantastic. Just wanted to clarify the above,
That is F4 key
Nice one
Pls after the range in the sum if formula ... do I hear you say press the F4 key to pin the range or what.. please I don't get that part well
Its f4 key in the keyboard, to fix range by applying dollar symbol
Many tnks boss.God bless you
how do you get the R/T to remove the Place Order under Procurement
Suggestion. Nothing happens when I put a R or T in R/T Status
just watched again and saw the steps to make this work. THANKS for the template. It is exactly what I needed!
Thanks and welcome
Very useful but I dont understand the formule when u said “Click cookie on your keyboard” part😔 help pls
Its F4 key in Keyboard
It won’t work😔 I need help
I’m using a laptop
Hi, I’m working my way through this video. I’m a novice when it comes to this so it’s taking a minute but I’ve watched the entire video once and I like the functionality of the completed spreadsheet. I have a question. At 29:20-29:30 you reference pressing a certain key to correct the formula. I can’t understand, what key are you saying?
Its F4 key in Keyboard, F4 key is used to fix the cell reference in formula, alternatively we can also write dollar sign($)
@@smart-office12 thank you!
oh yeah it was my question too, Thankyou for your reply now I got it f4
if I want for further months, how to do, please?
you have to copy the sheet and create new for new month
Hello, can you share this spread sheet? It is good tool you have build
can we get one for manufacturing business where we enter raw material, usage and product sale? along with summary page
thank you very much for nice format . Can I get template, Sir?
Please assist on the formula after selecting after sumif and selected product range you said to press f4 key on the keyboard to fix selection i am pressing but not working
If F4 key not working, you can manually apply $ symbol by typing from keyboard
I hope you see this, the substraction and addition to get a balance stopped at a point, whenever i want to add or subtract stocks from a certain point, it doesnt work, i hope you can solve this for me
Nice ♥️
Tq
If there is a video about profit and loss, can you send the link or I'm waiting for you to shoot it?
Hello you have like this for google spreadsheet?
Please watch below video tutorial for similar inventory management in Google Sheets
ruclips.net/video/aIou6GWNEH8/видео.htmlsi=LAvN-RyfX28hJ0lX