Purchase Order Items To Be Billed - urgent

Hi There,

Previously this report use to output Billed Qty, Qty To Build as more then two decimal points. After last couple of updates, it seems to show it as 2 decimal place. This is affecting our calculations. For all our items the UOM is percent and because of this we need to have accurate numbers when calculating amount. Is there any way to show all the decimal points rather than limiting it to 2 decimal points. Thanks in advance.

Kind regards,
Mayur Patel



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     

Hi Again,

I just realised that since it is a query based report, I can change the query and remove the formating bit. i.e remove Float:100<!–[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]–> from “Qty to Bill:Float:100”<!–[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]–>. Is this a correct approach?

Kind regards,

On Thursday, July 18, 2013 10:52:26 AM UTC+1, MP wrote:

Hi There,

Previously this report use to output Billed Qty, Qty To Build as more then two decimal points. After last couple of updates, it seems to show it as 2 decimal place. This is affecting our calculations. For all our items the UOM is percent and because of this we need to have accurate numbers when calculating amount. Is there any way to show all the decimal points rather than limiting it to 2 decimal points. Thanks in advance.

Kind regards,
Mayur Patel



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     
Hi Mayur,

The better approach would be to change Float precision.

Go to Setup > Global Defaults and change Float precision to more than 2.

This will make sure that all float variables follow this precision, even during calculations.

Thanks,
Anand.

On 18-Jul-2013, at 3:28 PM, MP <ma...@gmail.com> wrote:

Hi Again,

I just realised that since it is a query based report, I can change the query and remove the formating bit. i.e remove Float:100 from "Qty to Bill:Float:100". Is this a correct approach?

Kind regards,

On Thursday, July 18, 2013 10:52:26 AM UTC+1, MP wrote:
Hi There,

Previously this report use to output Billed Qty, Qty To Build as more then two decimal points. After last couple of updates, it seems to show it as 2 decimal place. This is affecting our calculations. For all our items the UOM is percent and because of this we need to have accurate numbers when calculating amount. Is there any way to show all the decimal points rather than limiting it to 2 decimal points. Thanks in advance.

Kind regards,
Mayur Patel



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     

Hi Anand,

Thanks for this. Yes. this is a better option. Also what happen to ‘Pending PO item to be billed’ report. We use it a lot and now it has disappeared. Any reason for this? Is there any way to get it back?

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 11:01:37 AM UTC+1, Anand Doshi wrote:

Hi Mayur,

The better approach would be to change Float precision.

Go to Setup > Global Defaults and change Float precision to more than 2.

This will make sure that all float variables follow this precision, even during calculations.

Thanks,
Anand.

On 18-Jul-2013, at 3:28 PM, MP <ma…@gmail.com> wrote:

Hi Again,

I just realised that since it is a query based report, I can change the query and remove the formating bit. i.e remove Float:100 from “Qty to Bill:Float:100”. Is this a correct approach?

Kind regards,

On Thursday, July 18, 2013 10:52:26 AM UTC+1, MP wrote:
Hi There,

Previously this report use to output Billed Qty, Qty To Build as more then two decimal points. After last couple of updates, it seems to show it as 2 decimal place. This is affecting our calculations. For all our items the UOM is percent and because of this we need to have accurate numbers when calculating amount. Is there any way to show all the decimal points rather than limiting it to 2 decimal points. Thanks in advance.

Kind regards,
Mayur Patel



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     
You will find the report under Accounts module named "Purchase Order Items To Be Billed"

On 18-Jul-2013, at 3:57 PM, MP wrote:

Hi Anand,

Thanks for this. Yes. this is a better option. Also what happen to 'Pending PO item to be billed' report. We use it a lot and now it has disappeared. Any reason for this? Is there any way to get it back?

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 11:01:37 AM UTC+1, Anand Doshi wrote:
Hi Mayur,

The better approach would be to change Float precision.

Go to Setup > Global Defaults and change Float precision to more than 2.

This will make sure that all float variables follow this precision, even during calculations.

Thanks,
Anand.

On 18-Jul-2013, at 3:28 PM, MP <ma...@gmail.com> wrote:

Hi Again,

I just realised that since it is a query based report, I can change the query and remove the formating bit. i.e remove Float:100 from "Qty to Bill:Float:100". Is this a correct approach?

Kind regards,

On Thursday, July 18, 2013 10:52:26 AM UTC+1, MP wrote:
Hi There,

Previously this report use to output Billed Qty, Qty To Build as more then two decimal points. After last couple of updates, it seems to show it as 2 decimal place. This is affecting our calculations. For all our items the UOM is percent and because of this we need to have accurate numbers when calculating amount. Is there any way to show all the decimal points rather than limiting it to 2 decimal points. Thanks in advance.

Kind regards,
Mayur Patel



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     

So “Pending PO item to be billed” is now called “Purchase Order Item to be Billed”? Please confirm?

With “Pending PO item to be billed”, we could select the columns that we wanted but with “Purchase Order Item to be Billed” we can’t.

Thanks. Nabin.


On Thursday, July 18, 2013 11:32:12 AM UTC+1, Nabin Hait wrote:

You will find the report under Accounts module named “Purchase Order Items To Be Billed

On 18-Jul-2013, at 3:57 PM, MP wrote:

Hi Anand,

Thanks for this. Yes. this is a better option. Also what happen to ‘Pending PO item to be billed’ report. We use it a lot and now it has disappeared. Any reason for this? Is there any way to get it back?

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 11:01:37 AM UTC+1, Anand Doshi wrote:
Hi Mayur,

The better approach would be to change Float precision.

Go to Setup > Global Defaults and change Float precision to more than 2.

This will make sure that all float variables follow this precision, even during calculations.

Thanks,
Anand.

On 18-Jul-2013, at 3:28 PM, MP <ma…@gmail.com> wrote:

Hi Again,

I just realised that since it is a query based report, I can change the query and remove the formating bit. i.e remove Float:100 from “Qty to Bill:Float:100”. Is this a correct approach?

Kind regards,

On Thursday, July 18, 2013 10:52:26 AM UTC+1, MP wrote:
Hi There,

Previously this report use to output Billed Qty, Qty To Build as more then two decimal points. After last couple of updates, it seems to show it as 2 decimal place. This is affecting our calculations. For all our items the UOM is percent and because of this we need to have accurate numbers when calculating amount. Is there any way to show all the decimal points rather than limiting it to 2 decimal points. Thanks in advance.

Kind regards,
Mayur Patel



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     
Yes, it is the same report. New one is a query report, so you have to change the query to add/remove columns.

On 18-Jul-2013, at 4:07 PM, MP wrote:

So "Pending PO item to be billed" is now called "Purchase Order Item to be Billed"? Please confirm?

With "Pending PO item to be billed", we could select the columns that we wanted but with "Purchase Order Item to be Billed" we can't.

Thanks. Nabin.


On Thursday, July 18, 2013 11:32:12 AM UTC+1, Nabin Hait wrote:
You will find the report under Accounts module named "Purchase Order Items To Be Billed"

On 18-Jul-2013, at 3:57 PM, MP wrote:

Hi Anand,

Thanks for this. Yes. this is a better option. Also what happen to 'Pending PO item to be billed' report. We use it a lot and now it has disappeared. Any reason for this? Is there any way to get it back?

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 11:01:37 AM UTC+1, Anand Doshi wrote:
Hi Mayur,

The better approach would be to change Float precision.

Go to Setup > Global Defaults and change Float precision to more than 2.

This will make sure that all float variables follow this precision, even during calculations.

Thanks,
Anand.

On 18-Jul-2013, at 3:28 PM, MP <ma...@gmail.com> wrote:

Hi Again,

I just realised that since it is a query based report, I can change the query and remove the formating bit. i.e remove Float:100 from "Qty to Bill:Float:100". Is this a correct approach?

Kind regards,

On Thursday, July 18, 2013 10:52:26 AM UTC+1, MP wrote:
Hi There,

Previously this report use to output Billed Qty, Qty To Build as more then two decimal points. After last couple of updates, it seems to show it as 2 decimal place. This is affecting our calculations. For all our items the UOM is percent and because of this we need to have accurate numbers when calculating amount. Is there any way to show all the decimal points rather than limiting it to 2 decimal points. Thanks in advance.

Kind regards,
Mayur Patel



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     

Thanks Nabin for the clarifications. I will change the query to add additional columns. As per my understanding, this query changes gets stored in a txt file called “purchase_order_items_to_be_billed.txt”. If you make any changes to this file in the future, what will happen to this txt file at my end when I purpose an update? will it get over written by your changes? Thanks.

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 11:43:05 AM UTC+1, Nabin Hait wrote:

Yes, it is the same report. New one is a query report, so you have to change the query to add/remove columns.

On 18-Jul-2013, at 4:07 PM, MP wrote:

So “Pending PO item to be billed” is now called “Purchase Order Item to be Billed”? Please confirm?

With “Pending PO item to be billed”, we could select the columns that we wanted but with “Purchase Order Item to be Billed” we can’t.

Thanks. Nabin.


On Thursday, July 18, 2013 11:32:12 AM UTC+1, Nabin Hait wrote:
You will find the report under Accounts module named “Purchase Order Items To Be Billed

On 18-Jul-2013, at 3:57 PM, MP wrote:

Hi Anand,

Thanks for this. Yes. this is a better option. Also what happen to ‘Pending PO item to be billed’ report. We use it a lot and now it has disappeared. Any reason for this? Is there any way to get it back?

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 11:01:37 AM UTC+1, Anand Doshi wrote:
Hi Mayur,

The better approach would be to change Float precision.

Go to Setup > Global Defaults and change Float precision to more than 2.

This will make sure that all float variables follow this precision, even during calculations.

Thanks,
Anand.

On 18-Jul-2013, at 3:28 PM, MP <ma…@gmail.com> wrote:

Hi Again,

I just realised that since it is a query based report, I can change the query and remove the formating bit. i.e remove Float:100 from “Qty to Bill:Float:100”. Is this a correct approach?

Kind regards,

On Thursday, July 18, 2013 10:52:26 AM UTC+1, MP wrote:
Hi There,

Previously this report use to output Billed Qty, Qty To Build as more then two decimal points. After last couple of updates, it seems to show it as 2 decimal place. This is affecting our calculations. For all our items the UOM is percent and because of this we need to have accurate numbers when calculating amount. Is there any way to show all the decimal points rather than limiting it to 2 decimal points. Thanks in advance.

Kind regards,
Mayur Patel



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     
Yes, it will be overwritten by the updates. You should copy the existing report and make a new one, mentioning "Is Standard" as "No".

On 18-Jul-2013, at 4:18 PM, MP wrote:

Thanks Nabin for the clarifications. I will change the query to add additional columns. As per my understanding, this query changes gets stored in a txt file called "purchase_order_items_to_be_billed.txt". If you make any changes to this file in the future, what will happen to this txt file at my end when I purpose an update? will it get over written by your changes? Thanks.

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 11:43:05 AM UTC+1, Nabin Hait wrote:
Yes, it is the same report. New one is a query report, so you have to change the query to add/remove columns.

On 18-Jul-2013, at 4:07 PM, MP wrote:

So "Pending PO item to be billed" is now called "Purchase Order Item to be Billed"? Please confirm?

With "Pending PO item to be billed", we could select the columns that we wanted but with "Purchase Order Item to be Billed" we can't.

Thanks. Nabin.


On Thursday, July 18, 2013 11:32:12 AM UTC+1, Nabin Hait wrote:
You will find the report under Accounts module named "Purchase Order Items To Be Billed"

On 18-Jul-2013, at 3:57 PM, MP wrote:

Hi Anand,

Thanks for this. Yes. this is a better option. Also what happen to 'Pending PO item to be billed' report. We use it a lot and now it has disappeared. Any reason for this? Is there any way to get it back?

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 11:01:37 AM UTC+1, Anand Doshi wrote:
Hi Mayur,

The better approach would be to change Float precision.

Go to Setup > Global Defaults and change Float precision to more than 2.

This will make sure that all float variables follow this precision, even during calculations.

Thanks,
Anand.

On 18-Jul-2013, at 3:28 PM, MP <ma...@gmail.com> wrote:

Hi Again,

I just realised that since it is a query based report, I can change the query and remove the formating bit. i.e remove Float:100 from "Qty to Bill:Float:100". Is this a correct approach?

Kind regards,

On Thursday, July 18, 2013 10:52:26 AM UTC+1, MP wrote:
Hi There,

Previously this report use to output Billed Qty, Qty To Build as more then two decimal points. After last couple of updates, it seems to show it as 2 decimal place. This is affecting our calculations. For all our items the UOM is percent and because of this we need to have accurate numbers when calculating amount. Is there any way to show all the decimal points rather than limiting it to 2 decimal points. Thanks in advance.

Kind regards,
Mayur Patel



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     

Thanks Nabin. I will do that. Appreciate your help.

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 12:00:45 PM UTC+1, Nabin Hait wrote:

Yes, it will be overwritten by the updates. You should copy the existing report and make a new one, mentioning “Is Standard” as “No”.

On 18-Jul-2013, at 4:18 PM, MP wrote:

Thanks Nabin for the clarifications. I will change the query to add additional columns. As per my understanding, this query changes gets stored in a txt file called “purchase_order_items_to_be_billed.txt”. If you make any changes to this file in the future, what will happen to this txt file at my end when I purpose an update? will it get over written by your changes? Thanks.

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 11:43:05 AM UTC+1, Nabin Hait wrote:
Yes, it is the same report. New one is a query report, so you have to change the query to add/remove columns.

On 18-Jul-2013, at 4:07 PM, MP wrote:

So “Pending PO item to be billed” is now called “Purchase Order Item to be Billed”? Please confirm?

With “Pending PO item to be billed”, we could select the columns that we wanted but with “Purchase Order Item to be Billed” we can’t.

Thanks. Nabin.


On Thursday, July 18, 2013 11:32:12 AM UTC+1, Nabin Hait wrote:
You will find the report under Accounts module named “Purchase Order Items To Be Billed

On 18-Jul-2013, at 3:57 PM, MP wrote:

Hi Anand,

Thanks for this. Yes. this is a better option. Also what happen to ‘Pending PO item to be billed’ report. We use it a lot and now it has disappeared. Any reason for this? Is there any way to get it back?

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 11:01:37 AM UTC+1, Anand Doshi wrote:
Hi Mayur,

The better approach would be to change Float precision.

Go to Setup > Global Defaults and change Float precision to more than 2.

This will make sure that all float variables follow this precision, even during calculations.

Thanks,
Anand.

On 18-Jul-2013, at 3:28 PM, MP <ma…@gmail.com> wrote:

Hi Again,

I just realised that since it is a query based report, I can change the query and remove the formating bit. i.e remove Float:100 from “Qty to Bill:Float:100”. Is this a correct approach?

Kind regards,

On Thursday, July 18, 2013 10:52:26 AM UTC+1, MP wrote:
Hi There,

Previously this report use to output Billed Qty, Qty To Build as more then two decimal points. After last couple of updates, it seems to show it as 2 decimal place. This is affecting our calculations. For all our items the UOM is percent and because of this we need to have accurate numbers when calculating amount. Is there any way to show all the decimal points rather than limiting it to 2 decimal points. Thanks in advance.

Kind regards,
Mayur Patel



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     

Hi Nabin,

I have created a new report by copying the existing report with Standard=NO. How will I get it to appear under Account –>Reports? Is this automatic? Or do I need to do anything?

Also, I noticed, even after select Standard=No, it saves it as Standard=Yes.

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 12:00:45 PM UTC+1, Nabin Hait wrote:

Yes, it will be overwritten by the updates. You should copy the existing report and make a new one, mentioning “Is Standard” as “No”.

On 18-Jul-2013, at 4:18 PM, MP wrote:

Thanks Nabin for the clarifications. I will change the query to add additional columns. As per my understanding, this query changes gets stored in a txt file called “purchase_order_items_to_be_billed.txt”. If you make any changes to this file in the future, what will happen to this txt file at my end when I purpose an update? will it get over written by your changes? Thanks.

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 11:43:05 AM UTC+1, Nabin Hait wrote:
Yes, it is the same report. New one is a query report, so you have to change the query to add/remove columns.

On 18-Jul-2013, at 4:07 PM, MP wrote:

So “Pending PO item to be billed” is now called “Purchase Order Item to be Billed”? Please confirm?

With “Pending PO item to be billed”, we could select the columns that we wanted but with “Purchase Order Item to be Billed” we can’t.

Thanks. Nabin.


On Thursday, July 18, 2013 11:32:12 AM UTC+1, Nabin Hait wrote:
You will find the report under Accounts module named “Purchase Order Items To Be Billed

On 18-Jul-2013, at 3:57 PM, MP wrote:

Hi Anand,

Thanks for this. Yes. this is a better option. Also what happen to ‘Pending PO item to be billed’ report. We use it a lot and now it has disappeared. Any reason for this? Is there any way to get it back?

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 11:01:37 AM UTC+1, Anand Doshi wrote:
Hi Mayur,

The better approach would be to change Float precision.

Go to Setup > Global Defaults and change Float precision to more than 2.

This will make sure that all float variables follow this precision, even during calculations.

Thanks,
Anand.

On 18-Jul-2013, at 3:28 PM, MP <ma…@gmail.com> wrote:

Hi Again,

I just realised that since it is a query based report, I can change the query and remove the formating bit. i.e remove Float:100 from “Qty to Bill:Float:100”. Is this a correct approach?

Kind regards,

On Thursday, July 18, 2013 10:52:26 AM UTC+1, MP wrote:
Hi There,

Previously this report use to output Billed Qty, Qty To Build as more then two decimal points. After last couple of updates, it seems to show it as 2 decimal place. This is affecting our calculations. For all our items the UOM is percent and because of this we need to have accurate numbers when calculating amount. Is there any way to show all the decimal points rather than limiting it to 2 decimal points. Thanks in advance.

Kind regards,
Mayur Patel



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     
If you are using "Administrator" login and in conf.py you have set "developer_mode" as 1, the system allows to create only "Standard" reports. Otherwise, for any other login (System/Report Managers), you can set "Is Standard" as "No". 

And all the custom reports will be appeared automatically under "Custom Reports" in the relevant module home page.

You have to give permission for creating report to System/Report Manager from Permission Manager.

On 18-Jul-2013, at 4:50 PM, MP wrote:

Hi Nabin,

I have created a new report by copying the existing report with Standard=NO. How will I get it to appear under Account -->Reports? Is this automatic? Or do I need to do anything?

Also, I noticed, even after select Standard=No, it saves it as Standard=Yes.

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 12:00:45 PM UTC+1, Nabin Hait wrote:
Yes, it will be overwritten by the updates. You should copy the existing report and make a new one, mentioning "Is Standard" as "No".

On 18-Jul-2013, at 4:18 PM, MP wrote:

Thanks Nabin for the clarifications. I will change the query to add additional columns. As per my understanding, this query changes gets stored in a txt file called "purchase_order_items_to_be_billed.txt". If you make any changes to this file in the future, what will happen to this txt file at my end when I purpose an update? will it get over written by your changes? Thanks.

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 11:43:05 AM UTC+1, Nabin Hait wrote:
Yes, it is the same report. New one is a query report, so you have to change the query to add/remove columns.

On 18-Jul-2013, at 4:07 PM, MP wrote:

So "Pending PO item to be billed" is now called "Purchase Order Item to be Billed"? Please confirm?

With "Pending PO item to be billed", we could select the columns that we wanted but with "Purchase Order Item to be Billed" we can't.

Thanks. Nabin.


On Thursday, July 18, 2013 11:32:12 AM UTC+1, Nabin Hait wrote:
You will find the report under Accounts module named "Purchase Order Items To Be Billed"

On 18-Jul-2013, at 3:57 PM, MP wrote:

Hi Anand,

Thanks for this. Yes. this is a better option. Also what happen to 'Pending PO item to be billed' report. We use it a lot and now it has disappeared. Any reason for this? Is there any way to get it back?

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 11:01:37 AM UTC+1, Anand Doshi wrote:
Hi Mayur,

The better approach would be to change Float precision.

Go to Setup > Global Defaults and change Float precision to more than 2.

This will make sure that all float variables follow this precision, even during calculations.

Thanks,
Anand.

On 18-Jul-2013, at 3:28 PM, MP <ma...@gmail.com> wrote:

Hi Again,

I just realised that since it is a query based report, I can change the query and remove the formating bit. i.e remove Float:100 from "Qty to Bill:Float:100". Is this a correct approach?

Kind regards,

On Thursday, July 18, 2013 10:52:26 AM UTC+1, MP wrote:
Hi There,

Previously this report use to output Billed Qty, Qty To Build as more then two decimal points. After last couple of updates, it seems to show it as 2 decimal place. This is affecting our calculations. For all our items the UOM is percent and because of this we need to have accurate numbers when calculating amount. Is there any way to show all the decimal points rather than limiting it to 2 decimal points. Thanks in advance.

Kind regards,
Mayur Patel



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     

Thanks Nabin. This was very useful.

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 2:34:10 PM UTC+1, Nabin Hait wrote:

If you are using “Administrator” login and in conf.py you have set “developer_mode” as 1, the system allows to create only “Standard” reports. Otherwise, for any other login (System/Report Managers), you can set “Is Standard” as “No”. 

And all the custom reports will be appeared automatically under “Custom Reports” in the relevant module home page.

You have to give permission for creating report to System/Report Manager from Permission Manager.

On 18-Jul-2013, at 4:50 PM, MP wrote:

Hi Nabin,

I have created a new report by copying the existing report with Standard=NO. How will I get it to appear under Account –>Reports? Is this automatic? Or do I need to do anything?

Also, I noticed, even after select Standard=No, it saves it as Standard=Yes.

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 12:00:45 PM UTC+1, Nabin Hait wrote:
Yes, it will be overwritten by the updates. You should copy the existing report and make a new one, mentioning “Is Standard” as “No”.

On 18-Jul-2013, at 4:18 PM, MP wrote:

Thanks Nabin for the clarifications. I will change the query to add additional columns. As per my understanding, this query changes gets stored in a txt file called “purchase_order_items_to_be_billed.txt”. If you make any changes to this file in the future, what will happen to this txt file at my end when I purpose an update? will it get over written by your changes? Thanks.

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 11:43:05 AM UTC+1, Nabin Hait wrote:
Yes, it is the same report. New one is a query report, so you have to change the query to add/remove columns.

On 18-Jul-2013, at 4:07 PM, MP wrote:

So “Pending PO item to be billed” is now called “Purchase Order Item to be Billed”? Please confirm?

With “Pending PO item to be billed”, we could select the columns that we wanted but with “Purchase Order Item to be Billed” we can’t.

Thanks. Nabin.


On Thursday, July 18, 2013 11:32:12 AM UTC+1, Nabin Hait wrote:
You will find the report under Accounts module named “Purchase Order Items To Be Billed

On 18-Jul-2013, at 3:57 PM, MP wrote:

Hi Anand,

Thanks for this. Yes. this is a better option. Also what happen to ‘Pending PO item to be billed’ report. We use it a lot and now it has disappeared. Any reason for this? Is there any way to get it back?

Kind regards,
Mayur Patel

On Thursday, July 18, 2013 11:01:37 AM UTC+1, Anand Doshi wrote:
Hi Mayur,

The better approach would be to change Float precision.

Go to Setup > Global Defaults and change Float precision to more than 2.

This will make sure that all float variables follow this precision, even during calculations.

Thanks,
Anand.

On 18-Jul-2013, at 3:28 PM, MP <ma…@gmail.com> wrote:

Hi Again,

I just realised that since it is a query based report, I can change the query and remove the formating bit. i.e remove Float:100 from “Qty to Bill:Float:100”. Is this a correct approach?

Kind regards,

On Thursday, July 18, 2013 10:52:26 AM UTC+1, MP wrote:
Hi There,

Previously this report use to output Billed Qty, Qty To Build as more then two decimal points. After last couple of updates, it seems to show it as 2 decimal place. This is affecting our calculations. For all our items the UOM is percent and because of this we need to have accurate numbers when calculating amount. Is there any way to show all the decimal points rather than limiting it to 2 decimal points. Thanks in advance.

Kind regards,
Mayur Patel



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     




Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     



Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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