This is very helpful for people like me who really wants to understand and know how to make such like this in google sheets. I am vwry much new at this. I would like to ask for more help if how to add the cost and total for each item and how to sort this or search by location? Thank you very much for giving us the opportunity to learn from you. 🙏
Thank you for this, I created a new Inventory Management using Google Sheet based on yours and have to modify a little bit to account for Cost per Item and FIFO which I needed for my accounting software.
Thank you for for this wonderful video. Please after entering the formula for the 'Opening Balance' 11:24 , it keeps showing 0. I have checked and rechecked the formula and nothing seems to be wrong, can you help me please? Your response is highly appreciated
It's a wonderful concept; however, it's restricted to viewing transactions only within the specified day requested. How can you modify and view transactions within a range of dates? ie: (week, biweekly, monthly)?
sir question, what if i have only 1 warehouse but i have 3 store / location to transfer item everyday. how i will compute the total qty transfer every month in 3 different location
13:13 - everything is fine while I am trying to add a new entry and check, in the summery sheet its not reflecting changes, please let us know what went wrong?
awesome@@NeotechNavigators . I would like to add a barcode line between the Product ID and Product name, so that the Product ID when entered will also automatically show the relative Barcode number, and I am getting an ERROR message. What do you advice?
THIS FORMULA IS NOT WORKING I MEAN I CANT SEE Any number insed the OUT CELL PLEASE HELP ME (=SUMIFS('Input sheet '!$E:$E,'Input sheet '!E:E,"Out",'Input sheet '!$B:$B,$A6,'Input sheet '!$A:$A,$B$3)
I made a sheet like yours. But date wise closing stock opening stock is not auto updating. Please help me!
This is very helpful for people like me who really wants to understand and know how to make such like this in google sheets. I am vwry much new at this. I would like to ask for more help if how to add the cost and total for each item and how to sort this or search by location? Thank you very much for giving us the opportunity to learn from you. 🙏
Thanks. Will add the more features in the next version
Great explanation....!!! Thanks for sharing
Most welcome
@@NeotechNavigators I'm getting 0 value in opening balance instead of 100
How can I solve it? There is no any mistake in formula
welldone..impressive..now create payment ledger sheet for retailers.....
Sure will create
Sir, you are fabulous it will help me a lot to do my work so easily.
Bhut khoob sir maja aa gya hindi mein bhi banya karo sir video ❤
Thanks
It is simple and has all important things for warehouse operation
Thanks for your valuable feedback
Very nice explanation
Thanks
why is my available stocks in product search not accurate? I dont understand the opening balance and closing balance
This is very good, thank you!
Most welcome
Thank you this was wonderful, could you show how to rank best customers or products, thank you
Thank you for this, I created a new Inventory Management using Google Sheet based on yours and have to modify a little bit to account for Cost per Item and FIFO which I needed for my accounting software.
Can you help me on how to add the cost and total of each item and to sort by location?
Thank you for for this wonderful video. Please after entering the formula for the 'Opening Balance' 11:24 , it keeps showing 0. I have checked and rechecked the formula and nothing seems to be wrong, can you help me please? Your response is highly appreciated
Have you solve this error?
thanks so much this is so good!
Most welcome
THANKS... I AM GOING TO USE THIS
Hi sir, how can I modify to add make and size in this sheet, and when I type product ID, size, and make want to show in stock, Vlaue can do that?
It's a wonderful concept; however, it's restricted to viewing transactions only within the specified day requested. How can you modify and view transactions within a range of dates? ie: (week, biweekly, monthly)?
sir question, what if i have only 1 warehouse but i have 3 store / location to transfer item everyday. how i will compute the total qty transfer every month in 3 different location
separate sheet for different stores will help
For some reason In & Out is not working for me
Same
How to fix this problem..?
Give a video on whether automatic salary pay slip can be done through Google Sheet
Sure. will create soon.
Hello, I'm having problem with opening balance it become zero instead of 100 i can't see which formula is not okay.
Same here bro.
Have you solve this error??
just use the link in description, im trying and fed-up and finding easy way😂
@@nuramalianadia872 I have resolved it.
@@nuramalianadia872 I have also create Google sheets like that but in a little nice way
13:13 - everything is fine while I am trying to add a new entry and check, in the summery sheet its not reflecting changes, please let us know what went wrong?
make sure date format di top left in summary sheets is formula
Nice video! But why not include the link to the already made sheet for ease of following as you explain ?
We have added the link in the video's description box.
awesome@@NeotechNavigators . I would like to add a barcode line between the Product ID and Product name, so that the Product ID when entered will also automatically show the relative Barcode number, and I am getting an ERROR message. What do you advice?
Me to @NeotechNavigators same problem here
hi, how to do product creation for same product with different sizes?
In my project an item is located in many places.
So, what formulas can be used in "19:32" a product search sheet?
Please show inventory with BOM for manufacturing firm
I could not find the link to the demo Google Sheet file?
product master data is not getting update, how to link it with input sheet
sir please suggest how to add unit in this sheet
Hello sir kya aap es sheets ka formet de sakte hai . jisse mai acchi trah se sheekh sakoo .mujhe ye sheet bahut acchi lagi hai
We have added the link in the video's description box.
Can i buy this sheet from you?
This is free of cost. Link is given in the video description box
Need Download link this format. For use
Link is in videos description box or visit our website WWW.NeotechNavigators.Com
Sir jo ap ne sheet ka link share kia h kia hum os ko edit nhe kr sakte kia .
sir footwear ka liya bhi banao
sure. will create soon
how to record ledger of daily in and out of an item
Will create a video on this soon
Can we create this in ms excel
Please watch the below video
ruclips.net/video/6kFmnt4dab0/видео.html
i want to add a return section can you guide me how i add this i try butt not get success.
Will add in next version
Good day Sir, why am I getting a zero value return at point 12:33 minutes
make sure date in summary sheets is correct formula =today()
How to include Image. Please Help
opening balace showing zero how to fix that error sir,
Im having the same problem.
can i ask for a copy of this file?
File link is in the videos description box
In and out of stock is not reflecting
THIS FORMULA IS NOT WORKING I MEAN I CANT SEE Any number insed the OUT CELL PLEASE HELP ME (=SUMIFS('Input sheet '!$E:$E,'Input sheet '!E:E,"Out",'Input sheet '!$B:$B,$A6,'Input sheet '!$A:$A,$B$3)
Same here after putting formula 0 opening balance
Can we have traceability by serial number and lot number
How I can contact with you?
Yes we can, I will try to in next version
Please let me know
Need Download link
Link is in videos description box or visit our website WWW.NeotechNavigators.Com
HOW CAN DO IN CYCLE FOR MONTH TO MONTH
Yes we can
same problem...but how can i do?
Jb hum edit krte h to Request edit Access kehta h
How I contact you?