Stängt

need a stock management, wages management, and profit calculating database with barcode scanner

Hello

I need a database that can calculate how much stock i have, what i have sold, and what the profit level is.

I need it to be idiot-proof.

So i need it to be very simple. EACH QUERY FORM IS ON A SEPARATE PC.

I press one button for each product, and it prints a barcode.

-I need to be able search products

-I need to be able to add products.

I scan the barcode on one query form, it adds new stock to the database.

it needs to ask when putting new stock in:

-What price bought at (this will be in CNY, not GBP)

-What was the exchange rate from GBP to CNY was exchanged.

Shipping and Tax fees

-How many piece bought?

-What was the Shipping? (this will be in CNY)

-What was the Taxes?

-What is the Shipping tracking number?

-What box it is stored in?

-Asset Worth?

- Most important needs to be verified by only a boss.

after it has all this information with shipping and taxes, it needs to calculate shipping and taxes cost per piece.

for example I order

-100 pcs umbrellas@20 CNY.

-the exchange rate is 8.900

-the shipping is 2000 CNY for the total 100 pcs

-The tax is £30.

it needs to calculate the cost per pc for this batch.

-20 CNY/8.9=2.24719 GBP (cost of product)

-2000 CNY (DHL shipping cost)/100 pcs= 20 CNY each (for shipping)

shipping exchange rate calculation

20 CNY/8.9=2.24719 GBP (shipping)

Taxes

£30 taxes/100 pcs=0.3 GBP per pc taxes

2.24719+2.24719+0.3=4.80 total cost per pc.

I scan the barcode on a different query form, it says sold,

when a product is sold the database needs to

-minus from stock

-Customer name

-Customer address

-Customer contact number

-Ticket number

-ask what price it was sold at

-record date

-ask wether it was cash paid, bank transfer, or Trade credit.

--If trade credit it needs to ask what date they plan on paying.

-verification required by a boss

Returns

I scan on a different query it says return.

-minus from cash flow

-What box it is in?

-What is the fault

--if customer cannot pay, it must add to stock again.

--If has a problem,

---it needs to be put with returns

---What box is it in?

---(Not add to stock) to be sent to China.

---If it was replaced, or refunded.

Wages

Everybody has there own pass card.

when i add a new employee, it need to ask

--Name?

--Address?

--Position in the company?

--What there hourly wage is?

--working hours?

-I need to know what my profit is after all wages are paid, it needs to minus from profit in real time.

-need them to be able to scan there card at the start and end of each day?

--employees need to log in between 9.30 and 10am. if not requires verification from boss and ask penalty charge?.

--employees leave at [url removed, login to view], any earlier requires boss verification. and ask penalty charge?

--needs to automatically log out all employees at 7.30, if not logged out, boss needs to know.

Miscellaneous company cost

Cash needs to be claimed back, if employee spent money.

- for example petrol.

--It needs to ask

---Employee scan

---What it was?

---Cost of item?

---picture of receipt? (not sure if possible)

---Boss Verification

-minus from profit.

Simple inquiry

this is for 2 purposes, Find where the stock is, and if they scan a barcode, it gives them information on that product.

-simple search

--search for product. for example, I type umbrella, It tells me stock level and box number

The second one is barcode scan

--I scan a barcode it tells me if it is return, stock, what product it is, where it should be stored.

Partners page

- I only need to show financial information here

--So the Profit and loss.

--estimated profit on a different section

--Asset Worth

---1 day

---1 week

---30 day

---3 month

---1 year

--How many LCDs sold.

REFURBS PAGE TO CHINA

This section needs to ask:

Product. (e.g. Apple iPhone 6 LCD Cracked Outer Glass)

Price Paid GBP.

Price for refurb in CNY.

Who we buy it from?

Asset Worth after repair?

Minus cost from system.

Add Asset worth to the system. (put a note saying it is estimated)

Kompetenser: C-programmering, Excel, PHP, Projektledning, Programvaruarkitektur

Visa mer: barcode scanner program library management system, stock management software using, stock management software excel, project stock management software, need barcode scanner app log numbers, barcode scanner mysql database, store data barcode scanner mysql database, creating barcode database iphone scanner, stock management software source code, simple stock management software, stock management software net, stock management software garage, stock management software vbnet, barcode php mysql stock management system, iphone barcode scanner send database, wireless barcode scanner mysql database, Stock Management software , barcode scanner database blackberry, android barcode scanner database, stock database barcode, portable linux database barcode scanner, garage stock management software, barcode scanner database, barcode scanner access database increase quantity inventory forum, iphone barcode scanner stock

Om arbetsgivaren:
( 13 omdömen ) Liverpool, United Kingdom

Projekt-id #14762563

11 frilansare har i genomsnitt lagt bud på £297 för detta jobb

£150 GBP inom 3 dagar
(58 omdömen)
7.4
spiretech

Hello, A satisfied client is like a billion dollar smile to us!!! I have gone through the post and yes; I will help you for sure to complete the project successfully on time and with quality. Past Work – [url removed, login to view] Mer

£250 GBP inom 15 dagar
(66 omdömen)
6.6
£222 GBP inom 7 dagar
(57 omdömen)
6.3
£150 GBP inom 3 dagar
(41 omdömen)
5.7
£150 GBP inom 3 dagar
(22 omdömen)
5.1
royalcalif

Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Access. Email sending with MS Ac Mer

£249 GBP inom 15 dagar
(33 omdömen)
4.5
£150 GBP inom 3 dagar
(5 omdömen)
2.7
£150 GBP inom 3 dagar
(7 omdömen)
1.9
mobileappsites

Greetings, WE WILL DO THIS WORK AS PER YOUR REQUIREMENT AND EXPECTATIONS. With the experience of over 1600+ web development projects including ANDROID , iOS , WEBSITES , WEB APPLICATIONS AND SOFTWARES we are the fa Mer

£1500 GBP inom 3 dagar
(1 omdöme)
1.2
mmohsinzafar

I am a final year Software Engineering Student with over two years of practice in development. I would like to offer you my services. Relevant Skills and Experience I have extensive work experience with Database and M Mer

£188 GBP inom 10 dagar
(0 omdömen)
0.0
£111 GBP inom 3 dagar
(0 omdömen)
0.0