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,
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.
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.
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,
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.
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.
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,
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.
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.
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.
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.
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,
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.
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.
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.
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.
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.
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,
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.
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.
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.
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.
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.
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.
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,
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.
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.
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.
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.
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.
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.
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.
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,
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.
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.
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.
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.
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.
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.
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.
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.
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:
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,
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.
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.
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.
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.
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.
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.
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.
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.
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:
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.
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,
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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:
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,
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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:
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,
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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:
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.
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,
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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:
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,
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.