Web site, Web based design to run on Mobile and Computers, build database and logical query for generating required reports

Job Description:

Need to create Web site, Web based application to run on mobile and computers, build database and table for data on our server, link with web-based application and tally.

Database which can be connected to tally and web-based application: which can scan barcode or Qr code and collect physical stock - from different user at a time in different location, brief idea provided below.

Purchase person can work on reorders linked to closing stock or reorder report from tally directly,

compare prices with last price from same vendore, with other vendore's quote and decide order based on criteria of price, availability.

third- pricing from landing cost in tally.

Points for Purchase -

Need to capture, store and update following data

Item Name, Vendore part Number, vendores linked to items in priority, last 2rates vendore wise with date of quote. qty need to buy, qty available vendore wise from latest quote. Qty decided to order based one criterias.

Maximum permisible rate. Etc

Need to receive tally generated report for processing purchase, from that float inqueries or orders( some vendore doesn’t change price frequently so we can send order directly jumping inquery step)directly to vendore.

Processing quotations from vendores - receive quotation and import necessory data from quote for Analysis.

1. Check quoted rates with last quote and report only those items having any changes.

2. Compare all quote for same items from different vendores - pruce and available qty and decide based on first pruce, second availability and third maximum permissible rate and decide order vendore wise compiling all items for same vendore related.

Update data for future process. - from tally if any changes in item master and rates from vendore recent quotes.

Points for Stock Inventory Control:

Application on mobile and Service on server as described below.

Application will have 2screens only

Once user open the application, user must login with user and password, which must be verified with server database.

User must be able to change password.

When user login, application must talk to server and update data.

Data & fields required-

Single connected to rest data- User Name, Method( Catagory wise, Complete, Random as per list received), Date & Time of start & end task, location, Catagory.

Multiple - Part number/barcode/QRcode, Part name, qty, scanned/manually.

Extra items, Remark- incase item in physical stock is not in list, can be written in Extra or Remark.

There should be button to end task to initiate report.

After login, entering Method, location, Catagory - he should be able to scan barcode/ qrcode and app will validate item from database. User can be able to enter item manually which will be selected from drawn down list derived from catagory and letters he is typing.

After selecting item he will enter physical qty in qty field. - app window shows and allow to enter item and qty one at a time. Once user end task, all data will go to server to initiate report.

In server one service need to receive request send by app, get data & qty as required and send report through email.

Random - Application will prepare daily Xnos Random item list for admin decided Users and force user to complete task daily basis.

Report - Report will mention in title Date & Time of start and end, User name, Location and Catagory if Method is catagory wise, if Complete stock will mention Complete stock. And Random if it is as per assigned be application.

During difference calculations it will use all item as per catagory/ Complete stock/Random list send and provide list down only item with difference and remarks with field/ column Qty in physical stock, Qty as per Tally and difference, Remarks. Report will be also show items found extra, which are not in list and also items not checked by user eventhough it's in list.

There is schedule running to complete catagories to finish twice in month.

One random checking going from authorised person for atleast 50/100items at a time.

Skills: PHP, MySQL, Website Design, HTML, SQL

About the Client:
( 0 reviews ) Bhavnagar, India

Project ID: #35931751

11 freelancers are bidding on average ₹41091 for this job


Hi As reading, we are sure to fulfill your requirements perfectly because we have enough skill for your project. We are professional website developers having 11 years of working experience. Cost and timeline will be More

₹35000 INR in 35 days
(242 Reviews)

Dear sir Hope you are doing great ! I can redesign your website as per your specified requirements. I will create a very creative and responsive design that make your website highly interactive and I assure that desig More

₹60000 INR in 300 days
(74 Reviews)

Greetings! I, Alok Pant, propose to deliver timely and efficient output by utilizing my 8+ years of experience in android and web development. I will be utilizing my expertise in Java, Kotlin, AngularJS, ReactJS, and o More

₹25000 INR in 7 days
(3 Reviews)

Hi mate, How are you...! I am responding to your advertisement for wwb based application job requirement. As an senior web app designer and developer. With over 6+ years of application development experience and inno More

₹120000 INR in 25 days
(2 Reviews)

Hello Sir, We have over 9+ Years in Website, Software and Mobile App Development. We also providing Web Hosting, VPS, Domain Services, SEO and Digital Marketting Services. We Completed over 250+ Projects. - 100% Clie More

₹45000 INR in 15 days
(1 Review)

I have 4 years of experience building web applications both frontend and backend in javascript technologies like NodeJS, React, HTML, CSS, Express etc. I am working in the largest fintech company of India which process More

₹35000 INR in 14 days
(0 Reviews)