Ditutup

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)

Kemahiran: Pengaturcaraan C, Excel, PHP, Pengurusan Projek, Kejuruteraan Perisian

Lihat lebih lanjut: 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

Tentang Majikan:
( 13 ulasan ) Liverpool, United Kingdom

ID Projek: #14762563

11 pekerja bebas membida secara purata £297 untuk pekerjaan ini

£150 GBP dalam 3 hari
(58 Ulasan)
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] Lagi

£250 GBP dalam 15 hari
(66 Ulasan)
6.6
£222 GBP dalam 7 hari
(57 Ulasan)
6.3
£150 GBP dalam 3 hari
(41 Ulasan)
5.7
£150 GBP dalam 3 hari
(22 Ulasan)
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 Lagi

£249 GBP dalam 15 hari
(33 Ulasan)
4.5
£150 GBP dalam 3 hari
(5 Ulasan)
2.7
£150 GBP dalam 3 hari
(7 Ulasan)
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 Lagi

£1500 GBP dalam 3 hari
(1 Ulasan)
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 Lagi

£188 GBP dalam 10 hari
(0 Ulasan)
0.0
£111 GBP dalam 3 hari
(0 Ulasan)
0.0