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)?
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?
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?
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)
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
Sir, you are fabulous it will help me a lot to do my work so easily.
welldone..impressive..now create payment ledger sheet for retailers.....
Sure will create
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?
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
It is simple and has all important things for warehouse operation
Thanks for your valuable feedback
Thank you this was wonderful, could you show how to rank best customers or products, thank you
Bhut khoob sir maja aa gya hindi mein bhi banya karo sir video ❤
Thanks
why is my available stocks in product search not accurate? I dont understand the opening balance and closing balance
Very nice explanation
Thanks
THANKS... I AM GOING TO USE THIS
This is very good, thank you!
Most welcome
I made a sheet like yours. But date wise closing stock opening stock is not auto updating. Please help me!
thanks so much this is so good!
Most welcome
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?
Please show inventory with BOM for manufacturing firm
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?
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)?
Give a video on whether automatic salary pay slip can be done through Google Sheet
Sure. will create soon.
In my project an item is located in many places.
So, what formulas can be used in "19:32" a product search sheet?
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
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
hi, how to do product creation for same product with different sizes?
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
For some reason In & Out is not working for me
Same
How to fix this problem..?
I could not find the link to the demo Google Sheet file?
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
product master data is not getting update, how to link it with input sheet
Sir jo ap ne sheet ka link share kia h kia hum os ko edit nhe kr sakte kia .
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.
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
th-cam.com/video/6kFmnt4dab0/w-d-xo.html
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()
Need Download link this format. For use
Link is in videos description box or visit our website WWW.NeotechNavigators.Com
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
In and out of stock is not reflecting
How to include Image. Please Help
opening balace showing zero how to fix that error sir,
Im having the same problem.
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
can i ask for a copy of this file?
File link is in the videos description box
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
How I contact you?
Jb hum edit krte h to Request edit Access kehta h
HOW CAN DO IN CYCLE FOR MONTH TO MONTH
Yes we can
same problem...but how can i do?
Need Download link
Link is in videos description box or visit our website WWW.NeotechNavigators.Com