Hello, I need a help to make a customized Inventory software for our newly setup business, In which we required 2 login id's, 1. is for Local User and other is Admin (both need to be password protected).
Firstly we need to make the master Item Sheet having the details like Item Code, Item description, Unit of Measures(UOM), Price/Unit, Type of Tax(VAT or CST), Tax %age, Vendor Name. In Local User Id 1. we want to enter the material which we are getting from our Vendors with all the details automatically come from Item Master Sheets, when we type Item Description, after that we will add Quantity we received, Bill Number, Bill Date and it will automatically calculate the Amount and Tax in that form, when we click the submit button it well add the details in Main Store Sheet.(FIFO- First in First Out to be maintained in the all the store sheets for example if X sheet is come 10 times with different bill numbers we can able to view all the 10 bill numbers in that sheet.) 2. Now as required we want to shift the material from Main Store to different sub store locations, there should be another form to do the same and vice versa (but for this these locations must have the physical quantity>0). 3. In case of rejection or wrong part received we need to send a Debit Note cum Defective Challan to be send to vendor, with all the same details as we entered for material entry including vendor invoice details against which we are sending the material. Then after entering all rejected material in one screen we need to save the same in different sheet with and run the report to print the same. In Admin User ID 1. Any modification in any sheet can be done but remarks in that line why we need to change or do the modification. 2. He can run any report like consumption of any material, how many times we purchase X material, how many times and when we send the rejections, daily rejection challans, daily consumption details etc. Thanks and Regards, Hitesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
