Tailor Shop Inventory Invoice Management Software Solution
STOCK (in)
Article Number
Description Color
Yards In Cost
Total Stock Available
Input of stock, is done
by Computer 1 only
STOCK (Out)
Order No.
Order Date
Article Number
Description Color
Available Yards
Yards Out
Extra Yards Remarks
CLIENT INFORMATION
Order No.
Order Date
First Name
Last Name
Reference
Address
Country
City
Email
Phone (Home,Fax,Office)
Mobile
Website
Satisfied / Unsatisfied

Computer 1 is a Supervisory Computer, therefore one can see all fields.

As for Computer 2, they will be able to view only these fields: Order No. / Order Date / Article Number / Description
Color / Available Yards / Yards Out / Extra Yards / Remarks.
First Name / Last Name / Reference / Address / Country /
City / Email / Phone (Home, Fax, Office) / Mobile / Website
Satisfied / Unsatisfied
Unless and only the supervisor grants rights.

Anyone who access Computer 1 before opening this program, it should ask for password. (The password should be able to change by the user).

STOCK (in) (input is done by Computer 1)
Example of Article Number: Shark-skin Material = BL001 (The field should allow user to type in the article number).
Cost, should also be encrypted by a password


* Article No. should not be deleted in the database even though the stock = 0 *. (Only Computer 1 can update the stock of the Article No. Please give a warning / alert, if one attempts to delete an existing Article No.

CLIENT information : It means that when a customer / client orders.

STOCK (out) : Means that the material is being cut and sent to the tailor to stitch.
Order No. should be a running number as well as it can be edited. (For example: 0001, 0002, 0003,….)
Order Date should automatically show today’s date as well as it can be modified or changed to yesterday.


CLIENT information
Reference For Example: Last year the customer bought some clothes. The salesman (who is using Computer 2), should be able to keep the all Order No. of the same customer (as a reference of what Article No. / Color / Description one ordered)
Reference: 112, 212, 312


STOCK (out) [The measurement system is usually in meters & yards.] (Example)
Yards out: 2 yd.
Extra Yard: ½ yd.
Remarks: The tailor takes 2 yd. and later comes back after 5 hrs, says this particular cloth is not sufficient. I would like another ½ yd.


* One Customer / One Order No. is able to select more than one Article No. (Multiple Article No.) *


SEARCH: CLIENT Database
First Name
Last Name
City
Country
Email
Phone
Order No. should show automatically after the details are entered.
LABEL/REPORT: CLIENT Database
First Name
Last Name
City
Country
Email
Phone
The program should allow the user to select required fields to print and the size of the paper.
(Usually a label is: 2 ½ x 1 ½ )

SEARCH : For Cloth
Article No.
Color
Total Stock Available
Description
(Customizable)
REPORT
(All fields - Customizable)
Order No.
Order Date
First Name
Last Name
Reference
Address
Country
City
Email
Phone (Home, Fax, Office)
Mobile
Website
Satisfied / Unsatisfied
Article Number Description Color
Yards In Cost
Total Stock
Yards Out
Total Stock Available
Extra Yards Remarks

Recommended Answers

All 2 Replies

Is there a question in there?

can u send me the download link

commented: Perhaps you should find some other site to cheat on your homework project. -3
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.