Query Report For Sales between two dates

#1

I want to generate a query report between two date but where clause didn’t work,Please guide me , I am using mysql

        select  tabSales Invoice.Name,
                tabSales Invoice.Posting_Date,
                tabSales Invoice.Debit_to,
                tabSales Invoice.rounded_total
          from  tabSales Invoice,                
                tabSales Invoice Item
         Where  tabSales Invoice.name=  tabSales Invoice Item.parent
           and  tabSales Invoice.Posting_Date >=“01-01-2012”
           
           

–

You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/RoxaW_Vn7UYJ.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

#2
use posting date as yyyy-mm-dd


On 27-Dec-2012, at 10:01 AM, Stk Intl Trading IT Manager Mahr Haider <st...@gmail.com> wrote:

I want to generate a query report between two date but where clause didn't work,Please guide me , I am using mysql

        select  `tabSales Invoice`.Name,
                `tabSales Invoice`.Posting_Date,
                `tabSales Invoice`.Debit_to,
                `tabSales Invoice`.rounded_total
          from  `tabSales Invoice`,                
                `tabSales Invoice Item`
         Where  `tabSales Invoice`.name=  `tabSales Invoice Item`.parent
           and  `tabSales Invoice`.Posting_Date >="01-01-2012"
           
           

–

You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

To post to this group, send email to er…@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/RoxaW_Vn7UYJ.

For more options, visit https://groups.google.com/groups/opt_out.

 

 


–

You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

#3



On Thursday, 27 December 2012 08:31:15 UTC+4, Stk Intl Trading IT Manager Mahr Haider wrote:

I want to generate a query report between two date but where clause didn’t work,Please guide me , I am using mysql

        select  tabSales Invoice.Name,
                tabSales Invoice.Posting_Date,
                tabSales Invoice.Debit_to,
                tabSales Invoice.rounded_total
          from  tabSales Invoice,                
                tabSales Invoice Item
         Where  tabSales Invoice.name=  tabSales Invoice Item.parent
           and  tabSales Invoice.Posting_Date >=“01-01-2012”
           
           

–

You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/HdXZjPI-GccJ.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

#4