K
knavlekar
I have following tables. I have not included all the fields and all
the tables
but the fields that I thought that are important for understanding the
database structure.
1) Orders:
Order ID (P.K)
Customer ID (F.K)
Employee ID (FK)
Order Date
Ship Address
Ship Date, PO number, Ship Name, Ship Address, Ship State, Ship Code,
Ship
Country, Freight Charge, SalesTax Rate
2) Order Details:
Order Detail ID (PK)
Order ID (FK)
Product ID (FK)
Qty .
Unit Price
3) Payments:
Payment ID (PK)
Order ID (FK)
Payment Amount
Payment Date
Payment Mode
4) Customers:
Customer ID (PK)
Company Name and other customer details fields
5) Employee:
Employee ID & other employee details fields
6) Products:
Product ID (PK) and other product details Fields.
I want to create ledger account (with opening Balance & Closing
Balance) for individual customers for specific date range.
Can anyone help me out for making this report as well as building
queries
related to this report?
or if anyone can provide any email address on which I can send entire
database.
Thanks
the tables
but the fields that I thought that are important for understanding the
database structure.
1) Orders:
Order ID (P.K)
Customer ID (F.K)
Employee ID (FK)
Order Date
Ship Address
Ship Date, PO number, Ship Name, Ship Address, Ship State, Ship Code,
Ship
Country, Freight Charge, SalesTax Rate
2) Order Details:
Order Detail ID (PK)
Order ID (FK)
Product ID (FK)
Qty .
Unit Price
3) Payments:
Payment ID (PK)
Order ID (FK)
Payment Amount
Payment Date
Payment Mode
4) Customers:
Customer ID (PK)
Company Name and other customer details fields
5) Employee:
Employee ID & other employee details fields
6) Products:
Product ID (PK) and other product details Fields.
I want to create ledger account (with opening Balance & Closing
Balance) for individual customers for specific date range.
Can anyone help me out for making this report as well as building
queries
related to this report?
or if anyone can provide any email address on which I can send entire
database.
Thanks