I have been using this spreadsheet for a year or two now without problem. However, now whenever I add in a newly purchased item of any quantity, the "Available stock" column H says "Stocks Not Found" in worksheet "PURCHASED". This problem started to appear at Row 534 onwards. What could be the problem.... Appreciate any advise. Thanks!
@robsamtvph2331
3 жыл бұрын
check codes.. or items..
@lyseavping9818
3 жыл бұрын
click "Expand" on the Inventory tab. Cheers!
@kawakushopbusiness4298
6 жыл бұрын
This inventory sheets is very useful. And I found Cris Minas is very helpful and fast responding all my problems! Thankyou Cris Minas
@NoobGamer-qr6ej
2 жыл бұрын
Thank you so much, Medyo nalito lang ako ng kaunti sa SALE and Sales price saka yung date, sa Sale need lang talaga common sense, thank you its free and need ko talaga to start palang ng reselling thank you nag subs nadin ako
@benjieh.9680
3 жыл бұрын
How long did you create this project Madam ? Thanks for kind of response
@nafaz007
4 жыл бұрын
appreciated ur hard work. Very Helpful. God Bless U. Note.: please add credit purchase & cash purchase. In sale please add cash advance , when product ready customer will give balance amount.
@gilbertmercader1410
2 жыл бұрын
I love the effort and dedication that you put together and in making this vid, this really help small entrepreneur like me to make our life easier. It would be great to add options on inventory columns that was damaged, lost, vat, handling/freight cost. Thank you keep making template like this. Power on!!
@leetovey211
3 жыл бұрын
Hello, thank you for sharing. Would you mind telling me what “Expense” and “amount” affects on the purchased tab please? Thank you
@maryjoydapadap3850
4 жыл бұрын
Thanks a lot but my copy is missing the "Stocks Unit Price"column as seen in the Inventory sheet in your video. Any help PLEASE
@FernandaPerezanta
2 күн бұрын
This is great!! It was working amazing, but now I cannot add more sales.... Can you help please???
@rosesuam9776
6 ай бұрын
Hi Ms cris, I have an issue on your excel sheet , when I input the purchased items it says stocks not found. I tried everything, I double triple check the product code its correct but it cannot find the stocks. Eats the solution for this? Thank you
@DerickPitcher
6 жыл бұрын
Awesome Workbook Chris. I noticed you have a date picker in a few places, beware, Excel 2013 and newer does not support the date picker (DTPicker) ActiveX control. You'll get a message saying control not supported and it will remove the control from your worksheets that have the date picker when someone with Excel 2013 or newer opens your workbook. The user will need to download MSCOMCT2.OCX and put it in c:\windows\sysWOW64 and register the OCX file. Directions for this process are all over youtube. Process in my reply below......
@DerickPitcher
6 жыл бұрын
MSCOMCT2.OCX for ActiveX Controls in VBA Copy the MSCOMCT2.OCX file to c:\windows\sysWOW64 not c:\windows\system32. Register MSCOMCT2.OCX Run from the command prompt or run in the start menu regsvr32 c:\windows\sysWOW64\mscomct2.ocx and it should register although make sure that you run regsvr32 with administrator privileges. How to run that command in Administrative Mode ================================ 1. Click the Start button, then in the "Start Search" box, type CMD but DO NOT press Enter yet. 2. In the list above, under "Programs" right-click on CMD that appears above and choose "Run as Administrator" and click "Continue". 3. In the open window, type the following command and press Enter: regsvr32 c:\windows\sysWOW64\mscomct2.ocx
@normanhutchinson8512
6 жыл бұрын
Hi Cris please can you tell me if you will ever add images to your software, so when checking the inventory you can also check the image?
@ajolan81429
4 жыл бұрын
No dropdown box on item list tab beyond 8th supplier ma'am. How can I fix this?
@adobessentials5978
3 жыл бұрын
Hi Ms. Cris Minas, i am having trouble with adding new items. Whenever i am inputting an additional information it says automatically Stock not Found in Available Stocks Column.
@robo080888
2 жыл бұрын
Add more rows in inventory tab
@JJackDrenthe
6 жыл бұрын
Hey looks good thanks. Q; is there a way to see all the products that you order at a certain supplier? I was thinking about an extra column on the item list with supplier.
@deepakchopra5243
5 жыл бұрын
i downloaded this version, but in inventory its not showing total stock value, there is no column for "stock unit price" it is not calculating net profit please help
@daddyjoevlogs
5 жыл бұрын
same problem.
@chongyk6783
6 жыл бұрын
Hi Cris Minas May I know how can I get a free download for Excel Inventory System?
@pspecter09
2 жыл бұрын
Hi Cris, How can I change the Item Size, Color to other caption? Whenever I do, some infos dont appear on other sheets. Thanks
@RashedulHasanRana
5 жыл бұрын
Dear Cris Thanks for the best solution, please can you provide the password for unlock your file we need to customize. please help me. Thank You
@michaeljofersoortega2068
6 жыл бұрын
Hello Cris, thanks this is a big help. Is there any for unpaid items or borrowed items?
@sylakkayizzi8513
2 жыл бұрын
cris minas is there any plan of updating this nice system so that it can handle both product sales and services delivery for small business . then generating the clients report, and expanding on the expense entry feature, thanx so much for your wonderful services
@82220121
5 жыл бұрын
Hi Cris, I also have a bar coding question? How hard would it be to incorporate into your Excel Inventory System. I would like to streamline my inventory and I believe your design can make that happen. I hope to hear from you.
@bahoten
5 жыл бұрын
Thank You Cris Minas! Looking for something like this! Why is the file not looking for any password? Lol or is it just me.
@zeeengg
4 жыл бұрын
Can anyone help? When under sales when i select price range then unit price does not reflect that. Any suggestions?
@nonoisleem
5 жыл бұрын
Great Excel sheet, can't it be with multiple stocks? to show in which stock the item is? and show the records of the items movements between the stocks?
@cemaxvillaruel6973
3 жыл бұрын
Blessed evening Ms. Minas. How can I add add'l column for UNIT of purchased Item in Purchase Sheet?
@latosarachel1977
6 жыл бұрын
hi good morning cris ask ko lang di ba pwede mag add ng columm para sa discount at pull out items?thanks.
@bubutsmom656
4 жыл бұрын
Big help! Available stocks value won’t automatically show though. How can this be resolved? I am unable to add a manual formula also..
@hussiG
3 жыл бұрын
i have added one column "UNIT PRICE" and you can Multiply the "STOCK AVAILABLE" with "UNIT PRICE" to get stocks value.
@nadineuwitonze5638
2 жыл бұрын
@@hussiG how did you add the column mine is locked
@adochefsdechefs5232
6 жыл бұрын
Hi Cris, the product code column doesn't tells me when a code has been repeated anymore, How can i have that function back?
@karenj8689
6 жыл бұрын
Cris, I just started to populate the different sheets and was wondering why the ''Products' column on the Sales Price sheet is not populating. Where is it supposed to pull the data from?
@CrisMinas
6 жыл бұрын
When your ITEMS LIST "codes & products column" are empty the SALES PRICE "products column" also empty...
@mathayothomas6429
5 ай бұрын
HELLO!!! I have a issue when I enter Item eleven and try to purchase the same item from 11, 12, 13 ....... I get the message stock not available...... help please the system is so simple and understandable to use in my small bussness
@ranjandas4117
6 жыл бұрын
SIR PLZ HELP ME TO OPEN YOUR AUTO INVOICE XLS SOFTWARE BECAUST WHEN I OPENING THIS A MASSAGE SHOWING THAT "visual Basic complile error window can'nt find project or library" therefore plz give me a solution
@audyomictin7561
6 жыл бұрын
HI SIR CRIS, IS THERE ANY UPDATE FOR THIS EXCEL IF EVER? I ENCOUNTERED SOME UPDATE HERE, LIKE MAK., WHAT SHOULD I DO., I NEED YOUR HELP., THANKZ.,
@carmelosciabica3314
5 жыл бұрын
Dear Cris, is it possible to creat a sub-category in category. example: I would like to call a category Material and create sub-categories like glue tile, cement, tiles, door .... thanks
@AyYOisNary
3 жыл бұрын
Could someone help me where do I fix the price range drop down? My price Range drop down doesn’t work anymore unless I copied and paste. It’s doesn’t have a drop down where I can click the date
@kevinguillarte2657
4 жыл бұрын
Hi Cris! I can't access the remarks column on the inventory tab. can you help me? thank you!
@reshna90
5 жыл бұрын
Hi Ms Cris, thanks for great excel sheet. Very helpful. Just that last portion in report tab is not populating capital and purchase data even it has all the info in purchase tab. Please help.
@skystores7049
6 жыл бұрын
Hi Cris, I found a bugs, mayb...i done entering supplier, category, purchase, and stock unit price in Inventory as well....but somewhere i do sorting on Category (ITEMS sheets)...then found in Inventory sheet also sorting as well but Stock Unit price didnt doing correct sorting...stock value all goes wrong...any idea??
@CrisMinas
6 жыл бұрын
Sorting is available only on the following sheets CATEGORY, SALES PRICE and INVENTORY Sheet.
@hussiG
3 жыл бұрын
Dear, thanks for your wonderful work, its really helping me. how can i edit the inventory? as my some products are the In house Mixes of items i purchase. so i have to revise my stocks. please help
@Madpieomg
4 жыл бұрын
I am having trouble with my excel document. I used the free download and was doing my item lists and was doing good and now I am unable to go to product code column cant get my cursor to go there or to type in the column. Please help
@kevinwidjaja9615
6 жыл бұрын
Hi, really appreciate this video. What if we purchase goods and not yet have to pay the supplier? and what if we sell some goods and not yet been paid? would that messed up the accounting?
@jerrypease
6 жыл бұрын
Hey Cris, Under the "Purchase" Sheet I get a "No matchest found" in the Current Stocks collumn. That only happens once I list a product past the 16th row in the "Items" sheet and on. Any reason why that's happening? Great sheet so far!! Please help!
@CrisMinas
6 жыл бұрын
The products you are looking for are not yet added in your inventory. Go to the Inventory Sheet and click the expand button (click multiple times) untill all the items you had in the ITEMS LIST will show in your inventory.
@jerrypease
6 жыл бұрын
Cris Minas got it! Thank you for your help. I don't even think I'd consider myself a startup yet. But I do want to keep track of everything I have on hand. And this helps.
@Ramzyar
4 жыл бұрын
Great Video, i like it
@stevan191s
5 жыл бұрын
How could I add a loan category to the purchase and sales tab. could I make a special tab to see how much each person owes ?
@jjladera7806
3 жыл бұрын
Hi, can we make the Discount column exact number instead of percentage? Please help. Thanks
@bonsainitruepa5195
Жыл бұрын
Im looking for plastic pallet inventory system trucking the coded out return plastic pallet, agieng,total out and in per customer,something like that, thank you and hoping...
@ifarahluman
3 жыл бұрын
the monthly report is not working, i keep on encoding the date but the auto formula, changes the day rather than the month, your excel is great help.. thak u for that, but this part is not functioning, can u help me?
@linhchau08
6 жыл бұрын
For the discount in SALES, you have it in %, I prefer it in both % and discount amount. How can I change the discount from % to amount? I tried to change it to currency, and the total amount are all wrong. Thanks!
@bajrisheajroja5974
5 жыл бұрын
Linh Dinh I think this is not the answer who you needed, but anyway i think maybe will help you a bit. In this case you can change the amount you want to %. For example: the price is 100, the discoun in SALES you want in amount is 20, now to find in %. 20÷100=0.2 0.2×100=20% Other example: Price is 400 the SALES we want in amount is 50, now to fin in %. 50÷400=0.125 0.125×100=12.5% result: 400-50=350 400-12.5%=350
@STDTFFDGH420
6 жыл бұрын
Password 965 or bzlxt not working
@Pankaj-Verma-
6 жыл бұрын
Thanks a Ton, You are The hero of Strugglers :D , I wish you a lot of success in your Life.
@joshuamumba9736
Жыл бұрын
It's really impressive inventory management but how can we convert to automotive Systems while using part numbers and not color and size ,pls assist i want to implement this...
@mnashaat78
3 жыл бұрын
Hi when adding new category it says marco disabled, how can i enable it thanks
@lilibethgalvez9521
5 жыл бұрын
Good day po. Puede po kaya magpagawa nito para sa isang botica? Yung sa inventory po, yung may Lot NUmbers and expiry date. and yung sa sales invoice po, need lang po yung business name and address, sales invoice number. Yung sa BILL TO, Date, name and age lang po. Sa payments details, need lang po yung subtotal, cash and change. thanks po. sana po matulungan nyo po.
@daddyjoevlogs
5 жыл бұрын
Hi mam, paano po iedit yung discount? Naka percentage po kasi, gusto ko sana certain amount na lang po. like kung P100 discount etc. thanks a lot. please reply
@nasiribrahim3714
2 жыл бұрын
Thanks for your effort. by the way I have a question about, How to add Discount Colum with the amount not percentage, or How to change the existing discount percentage column into Discount amount
@adochefsdechefs5232
6 жыл бұрын
Hello again, Cris, in the category column of the Items sheet, the cells don't give me the option to choose from, I have to write manually the category. I would like to have the option in all the cells. I mean i want to have the display of the category menu on each of the cells of the column. Could you tell me how and help me??
@CrisMinas
6 жыл бұрын
Add your category in "category sheet".
@shimulakikul464
3 жыл бұрын
@@CrisMinas what is reorder point
@cireavaj8742
2 жыл бұрын
hi cris, any update of your system., i love ur system but i like to generate the stock value automaticaly...
@ersildahasa
6 жыл бұрын
Hi Cris. I can not add any new item. It says I can not run the macro because the macro may not be available on this workbook or all macros may be disable. What may the problem be? Thank you.
@sadiasadiq5627
5 жыл бұрын
U hav to enable it in excell.
@joehuang246
6 жыл бұрын
excellent sheet, can you create one for manufacturing using bill of material included in the sheet ?
@ritchierich8987
4 жыл бұрын
Can i ask for a password to unprotect the sheets to I can customize it according to my preference. Thank you
@edp.8071
4 жыл бұрын
AAAABABBAAA]
@adochefsdechefs5232
6 жыл бұрын
Hey. Thank You for the file. I'm having some issues when entering the purchase. When I write the item code ,automatically in the CURRENT STOCK column appears a NO MATCHES FOUND message. Some help please!!
@CrisMinas
6 жыл бұрын
Everytime you add new items in "items sheet" go to the "inventory sheet" and click the expand button untill all you newly add items appear.
@valgabriel1631
4 жыл бұрын
Hi Cris. I want to thank you for this tutorial and free template. It will help beginners like me to easily track my goods and finances. However, i have a minor problem with the Inventory page. The stocks value column doesn't automatically compute despite of the inputs in the other columns. Also, the report page is not working. I need your expertise regarding with this please. Or anyone in this thread. Thank you po.
@raneshmanokaran7507
6 жыл бұрын
Hi Chris, How to change the stock limit?? especially for certain and uncertain demand. Thanks ya
@CrisMinas
6 жыл бұрын
Check The "Reorder Pt" in Items Sheet it's Editable.
@darkstarrone8764
5 жыл бұрын
Thank you so much for this excellent excel file! Quick question: Is there an easy way to remove the sales "price range" and use a manual unit price instead? as I resell the same item multiple times on a same day at different prices. Basically deleting the "sales price" page and manually entering the "unit price" column in the sales page. Thanks a lot!!!
@darkstarrone8764
5 жыл бұрын
nvm I just used the "total amount" field instead on the sales page. thanks again
@eizelpalacio296
6 жыл бұрын
hi cris, i tried to send it on my email and it is asking for password, i cannot open the email. thanks for your help
@juliojuarez7795
6 жыл бұрын
THANK YOU FOR THE WORK WELL DONE, HOWEVER UNDER SALES PRICE TAB COLUM "D" IS DUPLICATED AND IT IS CAUSING SOME ISSUE, CAN I PLEASE GET THE PASSWORD TO DELETE THE DOUBLE COLUM. THANK YOU.
@ירדןמועלם-כ9ד
6 жыл бұрын
thanks for the great system and tutorial. how come that if I'm adding more them 9 items when I'm trying to enter a purchase for one of the items that is after the 9th item it says "no matches found" in it's current stock?
@adochefsdechefs5232
6 жыл бұрын
Hi, you have to expand the inventory sheet, for the items to be available in the purchase sheet.
@christiante5874
4 жыл бұрын
sir i cant click the buttons on the file. it says "cannot run the macro................" need help please
@jordanlee2262
4 жыл бұрын
Is it possible to add pictures? for the product
@stixdrones7720
5 жыл бұрын
Does not work, Cannot run macros and macro options are not available.
@SaleemMuhammd
6 жыл бұрын
Nice one. Just wondering, how to print an invoice of a particular sales order ?
@CrisMinas
6 жыл бұрын
kzitem.info/news/bejne/1mymqWGde3qZfKg
@rahmantraders42
6 жыл бұрын
HI Cris i downloaded it but the macro options do not work, when the buttone press the message appera pls help me in this situation, thanks
@CrisMinas
6 жыл бұрын
Enable your macro
@jennasvela
5 жыл бұрын
is this or any inventory system by excel compatible with Quickbooks?
@gmcreative986
6 жыл бұрын
Hi, encountered a problem. It only allows me to add 38 items. This file looked so good until I came across this problem. Any way around this?
@CrisMinas
6 жыл бұрын
If you Insert/Delete columns, If you fill in the light blue column, If you change the "sheet" password Those will stop your table to expand.
@gmcreative986
6 жыл бұрын
Thank you! it's working now.
@miacruize2556
2 жыл бұрын
this is nice but yung excel sheet mo my kulang na column sa INVENTORY tab, STOCK UNIT PRICE. hindi ko alam paano i add yunn
@victorbomowey594
4 жыл бұрын
thanks for this, can u create update to include stock card in the report portion so i can see the breakdown of purchased, sales and balance each item...thanks
@technofactx3350
4 жыл бұрын
Sir when I click on any botton in this inventory management system macro error show .....?
@josephescalante4937
5 жыл бұрын
please help i added new products and also i typed it in purchased but it shows stocks not found even i typed the qty that i ordered still stocks not found but same codes with the others. Stocks not found only in the newest product that i typed
@kaceryonline6060
5 жыл бұрын
hi , did you found any solution ? , same error here
@josephescalante4937
5 жыл бұрын
@@kaceryonline6060 just go to stocks click expand unti you see all of ur products
@venkatraman8999
5 жыл бұрын
Hi How are you. First of all I appreciate for the simple management of Purchase, sales, Expenses , Stock Valaution etc The feature of providing data by product Category and period. I come from India and we follow different date set up DD/Month/Year. Is it possible to change the date format in the format. Please provide me the procedure. Have a Wonderful day
@CrisMinas
5 жыл бұрын
Yes you can, unprotect the sheet password is crisminas
@cosa2288
5 жыл бұрын
Hi Cris Love your videos I'm looking for a excel template to track stock market investment accounts purchases, sales and market adjustments gains/losses, your spreadsheet is amazing just wondering if you have anything that is specifically for tracking investments?
@Mukeshbansal9515
4 жыл бұрын
Its showing only 23 items... I have 700 item inventory.. But not showing on report
@dianasmith3394
3 жыл бұрын
Yes you are a lifesaver. Thank you sooooo much!
@NRSHOMESOLUTION
6 жыл бұрын
Dear what is button 1 and button 4 click
@dmduga5535
6 жыл бұрын
Helpful videos for my business. Do you have templates for employee information database?
@angelbm31
5 жыл бұрын
HI bakit po disabled yung macro sa akin.. di po ako maka add ng another line..thanks po
@benlim9041
6 жыл бұрын
Hi Cris, I cannot add category, supplier or item as well, may I know how to solve this problem, TQ
@CrisMinas
6 жыл бұрын
Enable your macro, go to your •Home Office Button •Excel option •Trust Center •Trust Center Settings •Macro Setting •Enable Macro
@benlim9041
6 жыл бұрын
Thanks Cris, had tried but still not able be added, status remain...
@CrisMinas
6 жыл бұрын
Is it all the buttons are not functioning or only those 3 that you mention...?
@fazalmassfazal
5 жыл бұрын
Bro great work... It's so helpful for my business. Out of word's to thank you.
@J_Data_analyst
Жыл бұрын
Why is some columns not clickable? Please 🙏
@pauldonald2096
6 жыл бұрын
Love your Templates Cris. However, I'm from UK. I cant unprotect some worksheets to format dates etc. Can you help?
@umerzeb9018
6 жыл бұрын
965
@pauldonald2096
6 жыл бұрын
Thank you so much. Sales Price/Unit is not accepting code. All others are good. Can you help.
@yogpandey12
3 жыл бұрын
How to get rid of "Stocks Not Found" issue in your file??
@santhoshgpkn
6 жыл бұрын
the sheets not opening the sheet passwords are working,please tell me the password
@Cryptoview_1
4 жыл бұрын
there is a way for not to use your password all the time? it blocks inself every like 15 min thanks
@uotesoo0547
4 жыл бұрын
is it possible that i can do manually sales pricing? help
@mazin91
6 жыл бұрын
Password is not working. I have downloaded the file and opened it offline, upon opening it prompts me for a password. I tried: 965 bzlxt 965 or bzlxt crisminas and none of them worked. do you want to tell me what is the password please?
@CrisMinas
6 жыл бұрын
But the password is crisminas, did you open it in your excel?
@eymenhasan9412
6 жыл бұрын
Unfortunately I could not open the opening cipher
@tcruise77
2 жыл бұрын
Thank you so much for this excel inventory mngt... Looks promising... Need to do trial and error to see if it suits my mini biz.
@mohamedfahedalhazaa7693
4 жыл бұрын
i have an issue that when i enter the product name there is message that there is no matches found so how can i solve the issue thanks a lot
@CrisMinas
4 жыл бұрын
Means your item doesn't appear yet in the inventory. Go to the inventory and expand all the entry.
@kamalbenali6735
4 жыл бұрын
Cris Minas is it possible to come in contact whit you i have custome order for you if you want to do the job
@lhiknustechphilsco8273
4 жыл бұрын
Thank you very much ma'am. Its a big help for me as small business
@jeremyclimbs
5 жыл бұрын
Can a barcode scanner be used with this spreadsheet to update or input stock levels?
Пікірлер: 346