Decimal problems

hi,

This is mahaveer Somani from GCKC. as we do not take credit of Vat so we
have to take the whole value of material including VAT and other taxes in
our purchase cost.


so my query is that.

1. Please check the attached file.
2. now i want to make a new purchase receipt from this file therefore i
written 4002 qnty in Accepted and Received Qty field. then after i
calculated price list rate like this: (392166/4002) = 97.9925037481.

case -1 if i written price list rate = 97.9925037481 then this field accept
rate = 97.99 only.
and i will get the amount = 392155.98
case-2 If i written price list rate = 98 then i will get the amount = 392196

so in the both cases i dont want to make rounded off ledger with the
difference amount as you know that rounded off ledger is created for less
than 1 rupee.

in simply i want to get my value 392166 and the qty 4002. how can i get it?

or in other way i want to get more than 2 decimal after points.

Please resolve this query as soon as possible becoz my all purchase
receipts and purchase invoices are pending since starting of the year 2013

i hope you understand better. further if there is any pendency in query
then feel free to ask.

Regards
CA Mahaveer Somani.



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

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

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

hi,

This is mahaveer Somani from GCKC. as we do not take credit of Vat so we
have to take the whole value of material including VAT and other taxes in
our purchase cost.


so my query is that.

1. Please check the attached file.
2. now i want to make a new purchase receipt from this file therefore i
written 4002 qnty in Accepted and Received Qty field. then after i
calculated price list rate like this: (392166/4002) = 97.9925037481.

case -1 if i written price list rate = 97.9925037481 then this field accept
rate = 97.99 only.
and i will get the amount = 392155.98
case-2 If i written price list rate = 98 then i will get the amount = 392196

so in the both cases i dont want to make rounded off ledger with the
difference amount as you know that rounded off ledger is created for less
than 1 rupee.

in simply i want to get my value 392166 and the qty 4002. how can i get it?

or in other way i want to get more than 2 decimal after points.

Please resolve this query as soon as possible becoz my all purchase
receipts and purchase invoices are pending since starting of the year 2013

i hope you understand better. further if there is any pendency in query
then feel free to ask.

Regards
CA Mahaveer Somani.



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

Allowing more decimal places in rate field will bring you close to desired total. To allow more decimal places, increase Float Precision from:

Setup >> Global Settings / Default Values >> Float Precision

Hope this helps.


On Wed, Sep 18, 2013 at 2:07 PM, Mahaveer Somani <ca...@gmail.com> wrote:
hi,

This is mahaveer Somani from GCKC. as we do not take credit of Vat so we
have to take the whole value of material including VAT and other taxes in
our purchase cost.


so my query is that.

1. Please check the attached file.
2. now i want to make a new purchase receipt from this file therefore i
written 4002 qnty in Accepted and Received Qty field. then after i
calculated price list rate like this: (392166/4002) = 97.9925037481.

case -1 if i written price list rate = 97.9925037481 then this field accept
rate = 97.99 only.
and i will get the amount = 392155.98
case-2 If i written price list rate = 98 then i will get the amount = 392196

so in the both cases i dont want to make rounded off ledger with the
difference amount as you know that rounded off ledger is created for less
than 1 rupee.

in simply i want to get my value 392166 and the qty 4002. how can i get it?

or in other way i want to get more than 2 decimal after points.

Please resolve this query as soon as possible becoz my all purchase
receipts and purchase invoices are pending since starting of the year 2013

i hope you understand better. further if there is any pendency in query
then feel free to ask.

Regards
CA Mahaveer Somani.



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

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

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





Thanks and Regards,

Umair Sayyed
www.erpnext.com