make a program with excel TYPE look IN FRONT END and backend in vip for stock inventory

I have a excel file used for stock inventory used thrice in a day which my operators put in. there are four different departments and thus each department is separate from each other. my supervisors are not literate in computer or studies they don't know to read and write but know numbers and item names as they deal in it everyday.

1}they have to first enter credit details which I have a book format for which we require a summary at the bottom of every items along with a printout of the input vouchers

2} then they enter into another book the stock they received from earlier supervisor reduce from current balance get 1 total then they enter credit reduce it from present stock and get net balance {which is again opening for the next supervisor and so on} then enter rate and multiply and get the amount for this item. there are about 150 items in this some items are same with same price but I have to keep separate as it is either blue white green or some colour so option of linking the items to get in summary as 1 item only is there . we can keep heading of such item as soap1/soap2/soap3 and so on in each department .

it is not necessary all is sold in every shift. the rates should have the option of being changed for a date and if no rate change is not input it should input rate which was earlier input for that item. no discount is allowed. the opening balance has to be calculated automatically as it will be the closing balance of the earlier supervisor . after every total of each supervisor an option for removing print out should be made available wherein he has to enter as to which date / duty/ and the print out will be removed the print out can be pdf it is ok with me

a table for inputting cash given to me or every expenses incurred every now and then with details has to be added in the side so that we can calculate the difference received if there so for each shift there will be 2 print out 1 credit sheet with summary and 2 stock page

now to do this I have to depend on my data operator for input and if he doesn't come work is left pending I can keep another operator but am thinking of making a permanent software

as it is for illiterate people I want it to be user friendly wherein they just see items and put numbers.

note all items I will give codes also which also has to have a field in all reports and while entering data. all done option for report for whole day summary for myself with cash to be collected from each supervisor and money got from each cashier has to be got this has to be for higher user password.

backend you have to make in vip as I want the credit input details in 1 particular format table dbf file which I will import into another program. backup in compressed mode should be available to be mailed when and whenever to any mail id I want

Skills: Visual Foxpro

See more: excel data front end, html front end excel database, excel vba program front end example, program front end users click start excel, front end backend recruiting database, erp systems front end backend systems discuss, cms front end backend, javascript front end backend, commerce website front end backend, free matrimonial website template front end backend, typo3 front end backend, php front end backend, front end backend database mysql, connect front end backend, using front end backend, front end backend android, javascript front-end backend nodejs, how to make an excel spreadsheet look like a form, remote project in front end designing for freelancing, uk creative agency specialising in front end web design & development

About the Employer:
( 0 reviews ) mumbai, India

Project ID: #18159561

2 freelancers are bidding on average ₹41666 for this job


I have read your tender document and would like to develop and supply the application you have described using Microsoft Visual FoxPro. I have experience developing integrated Inventory applications and can show exa More

₹27777 INR in 15 days
(0 Reviews)

Hi, I understand your requirement. Forgot your problem I solved it via Desktop lanbase application. where you can get reports on live status of your entry with entry operator sign. Thanks and Regards, Rajendra

₹55555 INR in 30 days
(1 Review)