If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Credit Debit Account (Report) for Individual customers
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 |
Thread Tools | |
Display Modes | |
|
|