| Article: |
SQL Subqueries | |
| Subject: | : Pending Delivery Note Details | |
| Date: | 2009-04-05 22:19:33 | |
| From: | shebus | |
|
• Details of delivery note which are not invoiced. • Views used - VW_DELIVERY_ACTUAL, VW_SALES_INVOICE • The report should be grouped by SALEPOINT,DOC_CODE • Parameters of the report (SalePoint(T1), Customer(T2), From Date(D1) & To Date(D2)) • If Customer Parameter is null then Show all. |
||
Women in Technology
Hear us Roar
