Automate sales proposals for inventory

How to create outlook signature

okay this right here is an invention management system I designed and I can actually be customized to suit your business processes whatever it is that you run in your business all probably your company just wants to automate business processes so this can be customized to suit your business process and any other design that you want it can be designed for you all right now let's just take a look at how this works I have four command buttons here one user login purchase entry sales entry and I log out now how user login controls user access the controls which user sees what on this worksheet okay now purchase entry controls every purchase inventory sales entry controls every Sales inventory I'm probably at the end of EB we can choose to log out of the system all right let me just take a look at this user login equated to multiple user as a guest user and an admin user all right now let me just start with this with my guest user okay one two three four all right I log into the system uses welcome now take note of these my guest user only has privileged to three worksheets down here and are these hyperlinks that take you down to the three sheets listed down here alright so if I click on this it takes me to my stop control so this is just a sample now I log out again and then I login with my administrative user that has access to every particular data on this worksheet okay now my user and user one and look for example if I put in a an incorrect password it's gonna tell me you have entered a wrong password username or password so I just fill it incomplete right here user is a one and then you're welcome back and then notice now my administrative user has access to all the the worksheets on this workbook and you can see we have just like seven of them here okay now so let me just take samples from my purchased entry and my sales entry now for example let me just go and look at this okay my purchase entry is empty and my sales entry is also empty so now let me go back and just take samples from here all right let me take two examples first for John Doe okay which is a nameless meal and then I have my product listed down here so can be customized into your own company product and whatever it is that you have to achieve all right ro so let me look at 50 kg by track 5 it autocompletes for me from the least down here ok now my prize let's say for example I'm taking at 15,000 and then my poach is a 5 quantity okay you can see yeah my to that cost has been automated for me so I pay cash or credit whichever way and then I submit and then also I take an example very quickly from here and let's say Jane Doe ok Jane Doe the nameless female and then let me take this time I'll be takings for for Jane Doe and then possibly two liters okay you can see my autocomplete right here and then I take your 4,000 at the quantity of probably fight and then my tutor course is also automated down here and then I saw meat so I go into my purchase and then I have my two inventories listed in there and I now let me take samples for my sales now also let me take my sales also with a key for John Doe and jindo also and okay all right my first product was well I was a row so at 50 kg okay okay alright then okay let me just see I purchased these that twenty thousand so can have a profit let me put cheese three okay now I click on cash or credits now I decided to leave this blank and notice what happens right here and then it says your data is incomplete would you like to proceed yes or no if I say no then I come in now feel this but if I have no discount of you then I just probably say yes and it saves in and then I take another quick example for Jane Doe okay then I take this for for kingsfoil so I could just easily just this our dear Kings oil and then I take up my schooling to us instead of going down into my list I just think this and then price also at possibly let me 5,000 I had quantity of two okay and then probably I have a discount this time of four hundred now so you can see I've been deducted from my total cost already I click on cash or credit and and I submit and then I go into my sales and then I notice this can see my inventory has been recorded now take note everything from my purchase and sales inventory is being automatically controls of my stock control here not good to my IRA so now you can notice here my I have five quantity and I purchase five quantity I sold out three I'm left with 2 this is automated now this is my opening stock this is my closing stock likewise for Kings oil two litres I also purchased five I sold out to I'm left with three so you can see this is automated I didn't have to do anything here my opening stock has been calculated as a function of my quantity in and the cost of the item okay now also I have my other priority it in the obvious here that if my total stock available is less than ten you tell me to Lou it is greater than ten you tell me it's okay so you can see we have all those here because we have our two tasks of Olivo less than ten so for example if I change this to 11 so we can see our total stock would tell me it's okay with every other we still giving me Lou so I can tell from here if I have the total number the maximum number of products I have one in stock so I can restock my my market all right so this also is a you can see our total item so is also recorded down here my profit has been calculated automatically to for the two products that was purchased and sold out now here's my future work and choose two future and see whichever product I want to see okay now I can choose to look if I want to see just my Apple NPS product okay I can just click on this and then you can see I have just my Apple RPS product okay so if I come down here I can see just Apple up here so it's a few that I asked you to filter my worksheet to see which about I want to see I can see my ten names I just grand total Aziz and we now Sorell I know that and so this is just how basically this works so I could choose to click back upon all these and key so I can help all my products back okay yeah okay all so now here we have okay also I can just continue from here and then I have my expenditure right here and then here's where all my expenditures are being recorded and then these are the amounts and then my quantity and then these are data validations where I can have all the data that I want to be on this column so I could just click on it and then my carpets OPEX is a function of what I have here my expenditure category so if I have courage you can see your Tomatoes right here and then if I have maintenance you see the key for example so let me just take a look at this and take a restock so you can see the automated okay right here I have my analysis okay I have to refresh all this key now I have my Rosco for my seals and my quantity Kings oil also seals and quantity I have my grand total right here and then I have my filters also this is just my my dashboard to view expenditure analytics my profit charts and then my stocks chart alright so this is just my dashboard and then here's my financial statements where I have all my 2000 in stock purchase coverage perches which on closing stock rose profit on sales total expenses and my net profit now if I click on this it takes me to a breakdown of my total expenses so basically this is just how this works it can be designed to switch your business whatever it is that you run so and here's my contact right here if you need to automate business processes for your organization or you need to create an event management system a customized one yes my contacts you just contact me and thank you very much for staying with me