create new entry form and report (on existing pos system)

1. Create x1 logistic entry form and x5 reports (reports must be able to export to excel)
2. New logistic form must allow user to select stock code to transfer from warehouse to branch office.
3. the new logistic will update the new db table from the current pos db.
4. reports must be export to excel.
type of report,, (all reports must support by date range, monthly and yearly)
a)warehouse overiew report...show the stock movement = total stock in, stock out, stock rotate, stock write off, stock transfer.
b) branch overview report ...show stock code movement = stock in -total stock consumed & sales -stock rotate -stock write off - stock transfer.
c) Product sales report ....(for each branch) balance stock code = stock in -stock sale,-stock rotate,-stock write off -stock transfer
d) Product service used report .. balance stock code = stock in -stock sale -stock rotate - stock write off-stock +transfer stock
e) Product colour used report ..balance stock code = stock in -stock sale -stock rotate - stock write off-stock +transfer stock
f) stock rotate for product sales and product used report
g) stock write off for product sale and product service used report
expect to finish the report within 4days. and plus 2 days help in small technical issues.

the product sales and product services report already exist. the new report can copy some of the codes and generate a balance..

db table name and information, guide will be provide...make sure you have continue of 4 to 5days to work, else dont take the project. thanks ck