I write a sql query to calculate the profit base on only buying price and selling price and percentage profit itemwise, and total profit on base of quantity of items.
It works fine in mariadb database console.
But when I tried to build a query report it give the below error:-
My sql query is given below:--
Write a SELECT query. Note result is not paged (all data is sent in one go).To format columns, give column labels in the query. [Label]:[Field Type]/[Options]:[Width]
Make sure there is no empty space or blank line before "select..."
-Anand.
On Thu, Sep 4, 2014 at 2:42 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Everyone,
I write a sql query to calculate the profit base on only buying price and selling price and percentage profit itemwise, and total profit on base of quantity of items.
It works fine in mariadb database console.
But when I tried to build a query report it give the below error:-
My sql query is given below:--
Write a SELECT query. Note result is not paged (all data is sent in one go).To format columns, give column labels in the query.
[Label]:[Field Type]/[Options]:[Width]
Example:
Employee:Link/Employee:200
Rate:Currency:120
My sql query is given below:--
select `tabSales Invoice Item`.name,`tabSales Invoice Item`.creation,`tabSales Invoice Item`.item_name,`tabSales Invoice Item`.rate,`tabItem Price`.price_list_rate,((`tabSales Invoice Item`.rate-`tabItem Price`.price_list_rate)*100)/`tabItem Price`.price_list_rate AS "% Profit on each Item", `tabSales Invoice Item`.qty, `tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty AS "Total_Buyuing_Price",`tabSales Invoice Item`.amount,`tabSales Invoice Item`.amount-(`tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty) AS "Total Profit on no. of Items" from `tabSales Invoice Item`,`tabItem Price` where `tabSales Invoice Item`.item_name=`tabItem Price`.item_name AND `tabItem Price`.buying=1 order by `tabSales Invoice Item`.name;
Could you help me to build this query report.
Regards
Amit Bondwal
–
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
On Thu, Sep 4, 2014 at 3:11 PM, Anand Doshi <an…@erpnext.com> wrote:
Make sure there is no empty space or blank line before "select..."
-Anand.
On Thu, Sep 4, 2014 at 2:42 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Everyone,
I write a sql query to calculate the profit base on only buying price and selling price and percentage profit itemwise, and total profit on base of quantity of items.
It works fine in mariadb database console.
But when I tried to build a query report it give the below error:-
My sql query is given below:--
Write a SELECT query. Note result is not paged (all data is sent in one go).To format columns, give column labels in the query.
[Label]:[Field Type]/[Options]:[Width]
Example:
Employee:Link/Employee:200
Rate:Currency:120
My sql query is given below:--
select `tabSales Invoice Item`.name,`tabSales Invoice Item`.creation,`tabSales Invoice Item`.item_name,`tabSales Invoice Item`.rate,`tabItem Price`.price_list_rate,((`tabSales Invoice Item`.rate-`tabItem Price`.price_list_rate)*100)/`tabItem Price`.price_list_rate AS "% Profit on each Item", `tabSales Invoice Item`.qty, `tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty AS "Total_Buyuing_Price",`tabSales Invoice Item`.amount,`tabSales Invoice Item`.amount-(`tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty) AS "Total Profit on no. of Items" from `tabSales Invoice Item`,`tabItem Price` where `tabSales Invoice Item`.item_name=`tabItem Price`.item_name AND `tabItem Price`.buying=1 order by `tabSales Invoice Item`.name;
Could you help me to build this query report.
Regards
Amit Bondwal
–
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
On Thu, Sep 4, 2014 at 3:38 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Anand,
There is no extra space before "select".
Regards
Amit
On Thu, Sep 4, 2014 at 3:11 PM, Anand Doshi <an…@erpnext.com> wrote:
Make sure there is no empty space or blank line before "select..."
-Anand.
On Thu, Sep 4, 2014 at 2:42 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Everyone,
I write a sql query to calculate the profit base on only buying price and selling price and percentage profit itemwise, and total profit on base of quantity of items.
It works fine in mariadb database console.
But when I tried to build a query report it give the below error:-
My sql query is given below:--
Write a SELECT query. Note result is not paged (all data is sent in one go).To format columns, give column labels in the query.
[Label]:[Field Type]/[Options]:[Width]
Example:
Employee:Link/Employee:200
Rate:Currency:120
My sql query is given below:--
select `tabSales Invoice Item`.name,`tabSales Invoice Item`.creation,`tabSales Invoice Item`.item_name,`tabSales Invoice Item`.rate,`tabItem Price`.price_list_rate,((`tabSales Invoice Item`.rate-`tabItem Price`.price_list_rate)*100)/`tabItem Price`.price_list_rate AS "% Profit on each Item", `tabSales Invoice Item`.qty, `tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty AS "Total_Buyuing_Price",`tabSales Invoice Item`.amount,`tabSales Invoice Item`.amount-(`tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty) AS "Total Profit on no. of Items" from `tabSales Invoice Item`,`tabItem Price` where `tabSales Invoice Item`.item_name=`tabItem Price`.item_name AND `tabItem Price`.buying=1 order by `tabSales Invoice Item`.name;
Could you help me to build this query report.
Regards
Amit Bondwal
–
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
I did not put any javascript, I put the sql query in query section and left the java script blank, Then I got a error which I have pasted in my previous mail, I tested my sql query in cmmand line interface only.
I don't know how to build query report. Is there any link or example to build query report. That will be much helpful.
Regards
Amit Bondwal
On Thu, Sep 4, 2014 at 4:13 PM, Anand Doshi <an...@erpnext.com> wrote:
Can you send javascript console's output?
-Anand.
On Thu, Sep 4, 2014 at 3:38 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Anand,
There is no extra space before "select".
Regards
Amit
On Thu, Sep 4, 2014 at 3:11 PM, Anand Doshi <an…@erpnext.com> wrote:
Make sure there is no empty space or blank line before "select..."
-Anand.
On Thu, Sep 4, 2014 at 2:42 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Everyone,
I write a sql query to calculate the profit base on only buying price and selling price and percentage profit itemwise, and total profit on base of quantity of items.
It works fine in mariadb database console.
But when I tried to build a query report it give the below error:-
My sql query is given below:--
Write a SELECT query. Note result is not paged (all data is sent in one go).To format columns, give column labels in the query.
[Label]:[Field Type]/[Options]:[Width]
Example:
Employee:Link/Employee:200
Rate:Currency:120
My sql query is given below:--
select `tabSales Invoice Item`.name,`tabSales Invoice Item`.creation,`tabSales Invoice Item`.item_name,`tabSales Invoice Item`.rate,`tabItem Price`.price_list_rate,((`tabSales Invoice Item`.rate-`tabItem Price`.price_list_rate)*100)/`tabItem Price`.price_list_rate AS "% Profit on each Item", `tabSales Invoice Item`.qty, `tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty AS "Total_Buyuing_Price",`tabSales Invoice Item`.amount,`tabSales Invoice Item`.amount-(`tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty) AS "Total Profit on no. of Items" from `tabSales Invoice Item`,`tabItem Price` where `tabSales Invoice Item`.item_name=`tabItem Price`.item_name AND `tabItem Price`.buying=1 order by `tabSales Invoice Item`.name;
Could you help me to build this query report.
Regards
Amit Bondwal
–
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
We display our server-side error messages in the javascript console. Hence, check if there are any errors. Also, check the network tab for a response with an error.
-Anand.
On Thu, Sep 4, 2014 at 4:29 PM, Amit Bondwal <bo…@gmail.com> wrote:
Hi Anand,
I did not put any javascript, I put the sql query in query section and left the java script blank, Then I got a error which I have pasted in my previous mail, I tested my sql query in cmmand line interface only.
I don't know how to build query report. Is there any link or example to build query report. That will be much helpful.
Regards
Amit Bondwal
On Thu, Sep 4, 2014 at 4:13 PM, Anand Doshi <an...@erpnext.com> wrote:
Can you send javascript console's output?
-Anand.
On Thu, Sep 4, 2014 at 3:38 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Anand,
There is no extra space before "select".
Regards
Amit
On Thu, Sep 4, 2014 at 3:11 PM, Anand Doshi <an…@erpnext.com> wrote:
Make sure there is no empty space or blank line before "select..."
-Anand.
On Thu, Sep 4, 2014 at 2:42 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Everyone,
I write a sql query to calculate the profit base on only buying price and selling price and percentage profit itemwise, and total profit on base of quantity of items.
It works fine in mariadb database console.
But when I tried to build a query report it give the below error:-
My sql query is given below:--
Write a SELECT query. Note result is not paged (all data is sent in one go).To format columns, give column labels in the query.
[Label]:[Field Type]/[Options]:[Width]
Example:
Employee:Link/Employee:200
Rate:Currency:120
My sql query is given below:--
select `tabSales Invoice Item`.name,`tabSales Invoice Item`.creation,`tabSales Invoice Item`.item_name,`tabSales Invoice Item`.rate,`tabItem Price`.price_list_rate,((`tabSales Invoice Item`.rate-`tabItem Price`.price_list_rate)*100)/`tabItem Price`.price_list_rate AS "% Profit on each Item", `tabSales Invoice Item`.qty, `tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty AS "Total_Buyuing_Price",`tabSales Invoice Item`.amount,`tabSales Invoice Item`.amount-(`tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty) AS "Total Profit on no. of Items" from `tabSales Invoice Item`,`tabItem Price` where `tabSales Invoice Item`.item_name=`tabItem Price`.item_name AND `tabItem Price`.buying=1 order by `tabSales Invoice Item`.name;
Could you help me to build this query report.
Regards
Amit Bondwal
–
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
On Thu, Sep 4, 2014 at 4:36 PM, Anand Doshi <an...@erpnext.com> wrote:
Amit,
We display our server-side error messages in the javascript console. Hence, check if there are any errors. Also, check the network tab for a response with an error.
-Anand.
On Thu, Sep 4, 2014 at 4:29 PM, Amit Bondwal <bo…@gmail.com> wrote:
Hi Anand,
I did not put any javascript, I put the sql query in query section and left the java script blank, Then I got a error which I have pasted in my previous mail, I tested my sql query in cmmand line interface only.
I don't know how to build query report. Is there any link or example to build query report. That will be much helpful.
Regards
Amit Bondwal
On Thu, Sep 4, 2014 at 4:13 PM, Anand Doshi <an...@erpnext.com> wrote:
Can you send javascript console's output?
-Anand.
On Thu, Sep 4, 2014 at 3:38 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Anand,
There is no extra space before "select".
Regards
Amit
On Thu, Sep 4, 2014 at 3:11 PM, Anand Doshi <an…@erpnext.com> wrote:
Make sure there is no empty space or blank line before "select..."
-Anand.
On Thu, Sep 4, 2014 at 2:42 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Everyone,
I write a sql query to calculate the profit base on only buying price and selling price and percentage profit itemwise, and total profit on base of quantity of items.
It works fine in mariadb database console.
But when I tried to build a query report it give the below error:-
My sql query is given below:--
Write a SELECT query. Note result is not paged (all data is sent in one go).To format columns, give column labels in the query.
[Label]:[Field Type]/[Options]:[Width]
Example:
Employee:Link/Employee:200
Rate:Currency:120
My sql query is given below:--
select `tabSales Invoice Item`.name,`tabSales Invoice Item`.creation,`tabSales Invoice Item`.item_name,`tabSales Invoice Item`.rate,`tabItem Price`.price_list_rate,((`tabSales Invoice Item`.rate-`tabItem Price`.price_list_rate)*100)/`tabItem Price`.price_list_rate AS "% Profit on each Item", `tabSales Invoice Item`.qty, `tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty AS "Total_Buyuing_Price",`tabSales Invoice Item`.amount,`tabSales Invoice Item`.amount-(`tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty) AS "Total Profit on no. of Items" from `tabSales Invoice Item`,`tabItem Price` where `tabSales Invoice Item`.item_name=`tabItem Price`.item_name AND `tabItem Price`.buying=1 order by `tabSales Invoice Item`.name;
Could you help me to build this query report.
Regards
Amit Bondwal
–
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
On Thu, Sep 4, 2014 at 4:57 PM, Amit Bondwal <bo…@gmail.com> wrote:
Hi Anand,
Where can I check these logs?
On Thu, Sep 4, 2014 at 4:36 PM, Anand Doshi <an...@erpnext.com> wrote:
Amit,
We display our server-side error messages in the javascript console. Hence, check if there are any errors. Also, check the network tab for a response with an error.
-Anand.
On Thu, Sep 4, 2014 at 4:29 PM, Amit Bondwal <bo…@gmail.com> wrote:
Hi Anand,
I did not put any javascript, I put the sql query in query section and left the java script blank, Then I got a error which I have pasted in my previous mail, I tested my sql query in cmmand line interface only.
I don't know how to build query report. Is there any link or example to build query report. That will be much helpful.
Regards
Amit Bondwal
On Thu, Sep 4, 2014 at 4:13 PM, Anand Doshi <an...@erpnext.com> wrote:
Can you send javascript console's output?
-Anand.
On Thu, Sep 4, 2014 at 3:38 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Anand,
There is no extra space before "select".
Regards
Amit
On Thu, Sep 4, 2014 at 3:11 PM, Anand Doshi <an…@erpnext.com> wrote:
Make sure there is no empty space or blank line before "select..."
-Anand.
On Thu, Sep 4, 2014 at 2:42 PM, Amit Bondwal <bo...@gmail.com> wrote:
Hi Everyone,
I write a sql query to calculate the profit base on only buying price and selling price and percentage profit itemwise, and total profit on base of quantity of items.
It works fine in mariadb database console.
But when I tried to build a query report it give the below error:-
My sql query is given below:--
Write a SELECT query. Note result is not paged (all data is sent in one go).To format columns, give column labels in the query.
[Label]:[Field Type]/[Options]:[Width]
Example:
Employee:Link/Employee:200
Rate:Currency:120
My sql query is given below:--
select `tabSales Invoice Item`.name,`tabSales Invoice Item`.creation,`tabSales Invoice Item`.item_name,`tabSales Invoice Item`.rate,`tabItem Price`.price_list_rate,((`tabSales Invoice Item`.rate-`tabItem Price`.price_list_rate)*100)/`tabItem Price`.price_list_rate AS "% Profit on each Item", `tabSales Invoice Item`.qty, `tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty AS "Total_Buyuing_Price",`tabSales Invoice Item`.amount,`tabSales Invoice Item`.amount-(`tabItem Price`.price_list_rate*`tabSales Invoice Item`.qty) AS "Total Profit on no. of Items" from `tabSales Invoice Item`,`tabItem Price` where `tabSales Invoice Item`.item_name=`tabItem Price`.item_name AND `tabItem Price`.buying=1 order by `tabSales Invoice Item`.name;
Could you help me to build this query report.
Regards
Amit Bondwal
–
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.