This gives me the basics for EXACTLY what I was looking for. I wish you had a voiceover explaining what you're doing to give a better understanding though. I do really appreciate you sharing this!
Just writing to say than you! I have managed to integrate this system with an Excel POS using SUMIFS. I also improved on the Index Match formula to make longer tables.
Hi Cris Minas, You did it awesome thanks that was very helpful. I'm looking for one more array in this sheet that is Sales return how to input that data? Could you please help me in this or if you have another video please share. Thanx
Thank you, very helpful. I've created the tables and formulas, however, my information is returning the previous column info instead of the exact column info? Any suggestions as to what I have wrong? I'm using 0 for exact match code.
you prolly dont care but if you guys are stoned like me atm then you can stream pretty much all the new series on InstaFlixxer. Have been watching with my gf for the last couple of days xD
Dear sir can you make like tally software all in on where we can get all the accounting book keeping sales entry, purchase entry , inventory PL A/C trail balance balance sheet ,thnak
Sir, first i would like to appreciate to you making for this vedio. It is very useful who interest in inventory or do work in inventory department.please will you share me excel formula of material purchase report date wise , issued report date wise and balance report pls.
Good morning, I’m trying to see if anyone knows how to get the inventory out to reflect different people taking items? Example I have drivers that take product and I’d like to have them all on their own out tab in order to keep track of who’s taking what
add an extra column in the "'OUT" SECTION and rename it "requester" OR "receiver"........that way after the codes are used to enter a particular item, you can type the name of the receiver as a column has been created for it.
Mas Syacho Harman reorder point means the level of inventory which trigger an action to replenish your stock. You can get it by calculating: Average daily demand * lead time(shipping time) For example. You have a 5 units average demand per day then the shipping time is usually 5 days. 5x5=25 The reorder point here is 25. It means when there are 25 stocks left, you should order your next batch of stock.
This rocks!!! Thank you so much for shareing this document, unlike other channels you are the BEST!
This gives me the basics for EXACTLY what I was looking for. I wish you had a voiceover explaining what you're doing to give a better understanding though. I do really appreciate you sharing this!
Your video had no sound, but still I didn't have any problem to understand. Thanks for the tutorial. Keep making this type of videos for us.
Just writing to say than you! I have managed to integrate this system with an Excel POS using SUMIFS.
I also improved on the Index Match formula to make longer tables.
We thank you for your thoughtfulness, sharing with us your work... perhaps if you can guide how to apply reorder
Thank you so much for video and excel sheet. God bless you and your job.
Fantastic, thank you for sharing the link and video.
Dear Cris Bandal Of Thanks I See Your All Videos You Can Relay Doing Good Work For All Excel User's
Hi Cris Minas, You did it awesome thanks that was very helpful. I'm looking for one more array in this sheet that is Sales return how to input that data? Could you please help me in this or if you have another video please share. Thanx
You just earned a like and subscribe.
Thanks.
Thank you for this video!!! Very helpful!
Hii Cris thank you so much you did a wonderful work thankss bro.
thank u so much i love this and this works
Super thanks! This video is a life saver
Awesome tutorial.
Thank you, very helpful. I've created the tables and formulas, however, my information is returning the previous column info instead of the exact column info? Any suggestions as to what I have wrong? I'm using 0 for exact match code.
you prolly dont care but if you guys are stoned like me atm then you can stream pretty much all the new series on InstaFlixxer. Have been watching with my gf for the last couple of days xD
@Emmett Francisco Yup, I've been using Instaflixxer for since december myself :D
Can this be done with multiple tables on the items page??
MY PROFESSIONAL HERO
NICE BRO USEFUL...THANK YOU SO MUCH
love this Video. could you do one on assembly inventory?
Tq.... Nice and clear concept
how can i maintain an inventory for items with expiration date, hand how to set codes for items with unique
expiration date
Is this linkable to barcode scanner?
FANTASTIC
Good nice video sir
Sir sath ma barcode bi laga ta ap wo kisa laga ga plz tel me
thank u a lot it helped me
can I use this? but if I download I cant open it in excel please help thank you
why the table number doesn't show when I click codes in the in tab
How do you do conditional formatting in this sheet? Bit confused
very thankful to you ...
hi sir, can you explain why the highlight does not work on my sheet?
How can i put to whom i issued the items and how many per items did i issued in that particular person
Is it compulsory to make tables on separate tabs to carry out this process or we can do it by making all tables in one tab????
Yes u can make all data in one tab itself
Hello how are you
Thank you for all your videos
I work in a warehouse and need your help please
hi i work in warehouse too and where are from can i know your facebook
Mr. i make my own sheet for thread store but the formula is not working on it . kindly solve my problem by giving ur precious time..
THANKYOU BROTHER!
Hi! What is column "REORDER PT" in sheet ITEMS (F4) mean? Thanks for your help!
It's Reorder alert, when your stocks drop down to this qty, your items in the inventory are automatically highlighted.
Re order point at that point of inventory you need to purchase the item
Dear sir can you make like tally software all in on where we can get all the accounting book keeping sales entry, purchase entry , inventory PL A/C trail balance balance sheet ,thnak
THIS IS VERY USEFUL VIDEO... LIKE IT... IF ANY UPDATE THAN KINDLY INFORM ME FOR STOCK INVENTORY NOTIFICATION
Thank you!
Sir, first i would like to appreciate to you making for this vedio. It is very useful who interest in inventory or do work in inventory department.please will you share me excel formula of material purchase report date wise , issued report date wise and balance report pls.
Hi, download the sample file the link is in the description box.
Good morning,
I’m trying to see if anyone knows how to get the inventory out to reflect different people taking items? Example I have drivers that take product and I’d like to have them all on their own out tab in order to keep track of who’s taking what
add an extra column in the "'OUT" SECTION and rename it "requester" OR "receiver"........that way after the codes are used to enter a particular item, you can type the name of the receiver as a column has been created for it.
add an extra column on the OUT section and label it as RECEIVER
I'm confused. This is not working for me. I followed the same steps, but it's not working
does this work on google sheet?
Thank Bro ..
HOW YOU PUT THE "BELOW REORDER POINT" IN THE INVENTORY SHEET
?
th-cam.com/video/mYPPPQ2V3Vk/w-d-xo.html
Order ako ng 1d scanner sa lazada para mabilis inventory. Yung sales sa out. Sana meron di print to printer reciept sa out.
hi. Can I edit the downloaded file? tnx
Thank you boss
pano if lagyan ng price each sir then auto total sum po?
what does the color column represent?
I think you can change the column name to whatever you like XD
Thanks bro
good.
Thanks
What do you mean by reorder pt?
Mas Syacho Harman reorder point means the level of inventory which trigger an action to replenish your stock. You can get it by calculating:
Average daily demand * lead time(shipping time)
For example. You have a 5 units average demand per day then the shipping time is usually 5 days. 5x5=25
The reorder point here is 25. It means when there are 25 stocks left, you should order your next batch of stock.
What os PR REORDER MEANS
How to contact you?
Why not used Vlook Up instead INDEX n MATCH, Is there any risk for function break? just want to know for more clarify. Thanks
Index Match is more powerful abd stable.
Found it difficult with no monologue. Maybe be a great system but sometimes you need to SPEAK!
Sobrang labo po
Hi, sa internet connection niyo po yan.