Query Report For Sales between two dates

13 views
Skip to first unread message

Stk Intl Trading IT Manager Mahr Haider

unread,
Dec 26, 2012, 11:31:15 PM12/26/12
to erpnext-dev...@googlegroups.com
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"
           
           

Rushabh Mehta

unread,
Dec 26, 2012, 11:47:20 PM12/26/12
to erpnext-dev...@googlegroups.com
use posting date as yyyy-mm-dd


--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer...@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.
 
 

Stk Intl Trading IT Manager Mahr Haider

unread,
Dec 27, 2012, 12:04:02 AM12/27/12
to erpnext-dev...@googlegroups.com
Reply all
Reply to author
Forward
0 new messages