Hi dear all,
please help me i am going to desing and Planing an AutoBike Purchase and Then it’sale DataBase
Purcahse(Details_)
Sales(Details_)
Stock(How Much Is In Stock Present)
Collection(PaymentFromCustomers)
Payments(PaymentsToCompany)
Create Invoice of Sales
Create Invoice of Purchase
Search
By Customer Name
By Customer Pyament Date
By Customer Id(ID card Num)
By Bike Chaseis Num
By Bike IngineNum
By Co Model
Reports :
Monthly Sales
Monthly Payments From Customer(ID)
Monthly Payments To Co.
1. PurchaseSlip
1.1. Purchase Id
1.2. Date
1.3. BikeID
1.4. Brand Name
1.5. Price(Purchase)
2. SalesToCustomer
2.1. CustomerID
2.2. DateofSales
2.3. PriceSales
2.4. BikeID
2.5.
3. PaymentFromCustomer
3.1. PyametCustID
3.2. Amount
3.3. PayMehtod
3.4. RecivingPerson
3.5.
3.6.
4. PaymentToCo
4.1. PaymetCoID
4.2. DatePaymantCo
4.3. Amount
4.4. PayCoMethod
4.5. RecivingPerson
5. CustomerRec
5.1. CustID
5.2. CustName
5.3. CustAddress
5.4. CustContect
6. BikeInfo
6.1. BikeID
6.2. BikeColor(Red)
6.3. BikeIngineNum
6.4. BikeChasisNum
6.5. BikeBrandCo(250cc)
6.6. BikeCoName(Honda)