Problem with Script Report

Frappe Framework Customization
1
Hi,

I am trying to make a script report, but for a starter I have copied the report from this link

https://github.com/frappe/erpnext/blob/develop/erpnext/selling/report/sales_person_wise_transaction_summary/sales_person_wise_transaction_summary.py

But the problem is that when I am loading the report in my test environment I am getting the following error:

http://pastebin.com/s6qRFuhP

The problem is coming in one of the query report files inside the frappe folder which I have not changed, kindly please let me know what am I doing wrong in here.

–

Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note

    —

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

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/5ebc6788-e80d-4ae3-af40-67d2594c157f%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
2
Looks like you have marked the Script Report as Standard=Yes and it is unable to find the python file for the report.

For script report, you need to have a python file that has the script.

-Anand.


On Wed, Aug 6, 2014 at 8:56 PM, Aditya Duggal <ad...@gmail.com> wrote:
Hi,

I am trying to make a script report, but for a starter I have copied the report from this link


But the problem is that when I am loading the report in my test environment I am getting the following error:


The problem is coming in one of the query report files inside the frappe folder which I have not changed, kindly please let me know what am I doing wrong in here.

–

Note:



If you are posting an issue,


  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.

  2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

  4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.



    End of Note

    —

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

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/5ebc6788-e80d-4ae3-af40-67d2594c157f%40googlegroups.com.

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


–

Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note

    —

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

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CAAQzbF1T-rL%2B_%2BS2U88aR70x1T%3Ds1kzrhWocGqtvmDgJz7xRJQ%40mail.gmail.com.

    For more options, visit https://groups.google.com/d/optout.
3

Hi Aditya,

I think in new system custom script
reports needs to be created as an app.

Kind regards,
MP
<!–[if gte mso 10]>

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-fareast-language:EN-US;}

<![endif]–>

–

Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note

    —

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

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/28dbc36f-e751-426d-a4c0-e7da26c19362%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
4
Aditya,

Please pull the latest update. That error should go.
Though it is still necessary that you need to have a python file in your app for script report. Else use query report instead.


-anand.


On Wed, Aug 6, 2014 at 9:33 PM, MP <ma…@gmail.com> wrote:

Hi Aditya,

I think in new system custom script reports needs to be created as an app.

Kind regards,
MP

–

Note:



If you are posting an issue,


  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.

  2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

  4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.



    End of Note

    —

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

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/28dbc36f-e751-426d-a4c0-e7da26c19362%40googlegroups.com.

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


–

Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note

    —

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

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CAAQzbF2Tq21pENLJTXbsNzp89v9-Df3bK%3DZX-96kL%2B5DvGN94Q%40mail.gmail.com.

    For more options, visit https://groups.google.com/d/optout.
5
Hi Anand,

I have pulled the latest updates, though it took me like an hour to pull the updates since the bench update command updates all the apps.

By the way I guess the problem was the Is Standard field only. I had marked the script report Is Standard as NO in my custom app whereas I think the system wanted me to mark the report as is standard === Yes.

I guess that has made things work.

On Wednesday, August 6, 2014 9:39:36 PM UTC+5:30, Anand Doshi wrote:
Aditya,

Please pull the latest update. That error should go.
Though it is still necessary that you need to have a python file in your app for script report. Else use query report instead.


-anand.


On Wed, Aug 6, 2014 at 9:33 PM, MP <ma…@gmail.com> wrote:

Hi Aditya,

I think in new system custom script reports needs to be created as an app.

Kind regards,
MP

–

Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.

  2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.

  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

  4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note

    —

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

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/28dbc36f-e751-426d-a4c0-e7da26c19362%40googlegroups.com.

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


–

Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note

    —

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

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/0783c330-a27f-4ac0-a078-71a4312da71a%40googlegroups.com.

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