Dynamic/Expandable Inventory System Sample DOWNLOAD HERE: drive.google.c...
Пікірлер: 75
@denizkzlay37263 жыл бұрын
This rocks!!! Thank you so much for shareing this document, unlike other channels you are the BEST!
@deandagostino9305 Жыл бұрын
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!
@Therongunner3 жыл бұрын
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.
@cutiepiecreativestudio10524 жыл бұрын
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.
@myatmin46935 жыл бұрын
Thank you so much for video and excel sheet. God bless you and your job.
@mohammedrehanshaikh47422 жыл бұрын
We thank you for your thoughtfulness, sharing with us your work... perhaps if you can guide how to apply reorder
@qasimg7864 жыл бұрын
Dear Cris Bandal Of Thanks I See Your All Videos You Can Relay Doing Good Work For All Excel User's
@vic11593 жыл бұрын
Fantastic, thank you for sharing the link and video.
@indfoodbeverageaurangabd50375 жыл бұрын
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
@justjoy19553 жыл бұрын
Thank you for this video!!! Very helpful!
@SylaCha4 жыл бұрын
thank u so much i love this and this works
@pardeeppannu6565 жыл бұрын
Hii Cris thank you so much you did a wonderful work thankss bro.
@sadimohammad80413 жыл бұрын
You just earned a like and subscribe. Thanks.
@rizaatienza98643 жыл бұрын
Super thanks! This video is a life saver
@rjbramirez4 жыл бұрын
MY PROFESSIONAL HERO
@johnsonchan85322 жыл бұрын
Awesome tutorial.
@ramireddy3715 жыл бұрын
Tq.... Nice and clear concept
@sidhiqueakbar64853 жыл бұрын
very thankful to you ...
@melvinmadridano27464 жыл бұрын
NICE BRO USEFUL...THANK YOU SO MUCH
@hortonmanorllc18225 жыл бұрын
love this Video. could you do one on assembly inventory?
@shahrizkabir5594 жыл бұрын
how can i maintain an inventory for items with expiration date, hand how to set codes for items with unique expiration date
@mohamedali-bz2sx5 жыл бұрын
thank u a lot it helped me
@slantedcn6690 Жыл бұрын
Can this be done with multiple tables on the items page??
@shahbazali-qg8tm3 жыл бұрын
Good nice video sir Sir sath ma barcode bi laga ta ap wo kisa laga ga plz tel me
@anandanskumar93735 жыл бұрын
THANKYOU BROTHER!
@KonataVon9706143 жыл бұрын
Is this linkable to barcode scanner?
@upendramahla70755 жыл бұрын
THIS IS VERY USEFUL VIDEO... LIKE IT... IF ANY UPDATE THAN KINDLY INFORM ME FOR STOCK INVENTORY NOTIFICATION
@minpeaceandlove42104 жыл бұрын
Thank you!
@mahendransomu61774 жыл бұрын
FANTASTIC
@cassandraluis6944 жыл бұрын
can I use this? but if I download I cant open it in excel please help thank you
@ubaidallah90154 жыл бұрын
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..
@sarzievlog3 жыл бұрын
why the table number doesn't show when I click codes in the in tab
@lawrencesandoval35064 жыл бұрын
How can i put to whom i issued the items and how many per items did i issued in that particular person
@kdurgesh865 жыл бұрын
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.
@CrisMinas5 жыл бұрын
Hi, download the sample file the link is in the description box.
@sudenrajbhandari91584 жыл бұрын
How do you do conditional formatting in this sheet? Bit confused
@joebadang74835 жыл бұрын
hi sir, can you explain why the highlight does not work on my sheet?
@masim4t54 жыл бұрын
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????
@excademy77464 жыл бұрын
Yes u can make all data in one tab itself
@michellepomeroy59364 жыл бұрын
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.
@emmettfrancisco40913 жыл бұрын
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
@loganjalen38023 жыл бұрын
@Emmett Francisco Yup, I've been using Instaflixxer for since december myself :D
@enjoylife25425 жыл бұрын
Thank Bro ..
@jasonjulaton74114 жыл бұрын
thank you brooo!! :)
@Dredraine14 жыл бұрын
Thank you boss
@groovyandreababy4 жыл бұрын
I'm confused. This is not working for me. I followed the same steps, but it's not working
@krishnatamrakar5455 жыл бұрын
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
@hozayfa705 жыл бұрын
Hello how are you Thank you for all your videos I work in a warehouse and need your help please
@whereareyoufrom71775 жыл бұрын
hi i work in warehouse too and where are from can i know your facebook
@1TakeMilli3 жыл бұрын
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
@kesingtonadebutu73503 жыл бұрын
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.
@official_diin483 Жыл бұрын
add an extra column on the OUT section and label it as RECEIVER
@aquacolors11793 жыл бұрын
Thanks
@DonSionzon4 жыл бұрын
Thanks bro
@asimsiddiq4753 жыл бұрын
good.
@datvu49314 жыл бұрын
does this work on google sheet?
@mr.RAND55843 жыл бұрын
Order ako ng 1d scanner sa lazada para mabilis inventory. Yung sales sa out. Sana meron di print to printer reciept sa out.
@PapaVtecTv4 жыл бұрын
pano if lagyan ng price each sir then auto total sum po?
@SirJoey9183 жыл бұрын
hi. Can I edit the downloaded file? tnx
@NovitaSari-xc4iy5 жыл бұрын
Hi! What is column "REORDER PT" in sheet ITEMS (F4) mean? Thanks for your help!
@CrisMinas5 жыл бұрын
It's Reorder alert, when your stocks drop down to this qty, your items in the inventory are automatically highlighted.
@riyaza25345 жыл бұрын
Re order point at that point of inventory you need to purchase the item
@karenmichellealmendo62575 жыл бұрын
HOW YOU PUT THE "BELOW REORDER POINT" IN THE INVENTORY SHEET ?
@CrisMinas5 жыл бұрын
kzbin.info/www/bejne/o4qzgYOHZ7tmjM0
@shahanhossain23164 жыл бұрын
Why not used Vlook Up instead INDEX n MATCH, Is there any risk for function break? just want to know for more clarify. Thanks
@Therongunner3 жыл бұрын
Index Match is more powerful abd stable.
@ricks23174 жыл бұрын
What os PR REORDER MEANS
@OVERMYERS5 жыл бұрын
what does the color column represent?
@marxistflores5 жыл бұрын
I think you can change the column name to whatever you like XD
@welcomephotobook41064 жыл бұрын
How to contact you?
@massyachoharman51335 жыл бұрын
What do you mean by reorder pt?
@sensii1125 жыл бұрын
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.
@chrislane54543 жыл бұрын
Found it difficult with no monologue. Maybe be a great system but sometimes you need to SPEAK!