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?
- 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)
£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 contact number
-ask what price it was sold at
-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
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.
Everybody has there own pass card.
when i add a new employee, it need to ask
--Position in the company?
--What there hourly wage is?
-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
---What it was?
---Cost of item?
---picture of receipt? (not sure if possible)
-minus from profit.
this is for 2 purposes, Find where the stock is, and if they scan a barcode, it gives them information on that product.
--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.
- I only need to show financial information here
--So the Profit and loss.
--estimated profit on a different section
--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)