Credit Debit Account (Report) for Individual customers

[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 Fileds.

I want to create Credit & Debit ledger for individual customers for specific
date range.

Can anyone help me out for making this report as well al building queries
related to this report?

Thanks