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

終了済み 投稿 6年前 着払い
終了済み 着払い

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 7-7.30pm, 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)

C プログラミング エクセル PHP プロジェクト管理 ソフトウェアアーキテクチャ

プロジェクトID: #14762563

プロジェクトについて

10個の提案 リモートプロジェクト アクティブ 6年前

10人のフリーランサーが、平均£312 で、この仕事に入札しています。

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 もっと

£188 GBP 10日以内
(0件のレビュー)
0.0