I need a system which can handle Sale order.
I got the Product and Customer database ready in MS ACCESS
The system flow as a follow:-
1. Import the order from Excel format (daily)
2. User can create the order
3. Print out the picking slip from order.
4. User can modify the order when the picking slip come back
5. print the invoice with auto invoice number
6. User able to modify the invoice.
7. User update the invoice for payment. eg. Paid or Outstanding...
*** User able to search the customer or product when they input or modify infomation
u have to create or design the table as the system requst. depend on your design
Sale report by date
customer order report
*** both report can show on screen or print out ****
If any one interest, I will give you more detail.
Backend ACCESS database on run on server and client will access the database at the same time.
Time fram 5 days