Number formating

Dear All,


As far as I could see, Print Format (in some parts) use function fmt_money() to display number to required format.

At the moment format is #,###.##

Can we somehow change that format to ie. #.###,#?

Best,

Zoran

Dear, Zoki!

I also need this, so I'm working on this feature right now, I believe that in a few hours, the pull request, be ready!

Att
Maxwell Morais


2013/1/18 Zoki <zo...@eu-build.com>

Dear All,


As far as I could see, Print Format (in some parts) use function fmt_money() to display number to required format.

At the moment format is #,###.##

Can we somehow change that format to ie. #.###,#?

Best,

Zoran



--


Maxwell Morais
(+55 11) 3931-1412 Ramal 31
www.realizemodulados.com.br

Great!!!

Just be aware that forms do not use mt_money() function explicitly for items print, only for totals.


On Fri, Jan 18, 2013 at 12:25 PM, Maxwell Morais <ma...@gmail.com> wrote:
Dear, Zoki!

I also need this, so I'm working on this feature right now, I believe that in a few hours, the pull request, be ready!

Att
Maxwell Morais


2013/1/18 Zoki <zo...@eu-build.com>

Dear All,


As far as I could see, Print Format (in some parts) use function fmt_money() to display number to required format.

At the moment format is #,###.##

Can we somehow change that format to ie. #.###,#?

Best,

Zoran



--




--

------------------------------------------------------------

dr Zoran Đorđević, dipl.inž.građ., PMP

Direktor

E-mail: zo...@eu-build.com





EUBuild d.o.o



Pajsijeva 3, 11 000 Beograd

Republika Srbija



Tel/Fax: 011 26 86 707

E-mail:
of…@eu-build.com

www.eu-build.com

I'm modifying fmt_money, and form fields, so that viewing and typing is based on standard currency system or hereafter informed the currency in the transaction.

In example:
- The currency of the price list, in order of sales.

This would help you?


2013/1/18 Zoran Djordjevic <zo...@eu-build.com>
Great!!!

Just be aware that forms do not use mt_money() function explicitly for items print, only for totals.


On Fri, Jan 18, 2013 at 12:25 PM, Maxwell Morais <ma...@gmail.com> wrote:
Dear, Zoki!

I also need this, so I'm working on this feature right now, I believe that in a few hours, the pull request, be ready!

Att
Maxwell Morais


2013/1/18 Zoki <zo...@eu-build.com>

Dear All,


As far as I could see, Print Format (in some parts) use function fmt_money() to display number to required format.

At the moment format is #,###.##

Can we somehow change that format to ie. #.###,#?

Best,

Zoran



--




--

------------------------------------------------------------

dr Zoran Đorđević, dipl.inž.građ., PMP

Direktor

E-mail: zo...@eu-build.com





EUBuild d.o.o



Pajsijeva 3, 11 000 Beograd

Republika Srbija



Tel/Fax: 011 26 86 707

E-mail:
of…@eu-build.com

www.eu-build.com




--


Maxwell Morais

(+55 11) 3931-1412 Ramal 31
www.realizemodulados.com.br


If you are member of ERPNext team and can change "internal" fmt_money, you are doing right thing! ž

If you have idea just to put new fmt_money in Print Form, we have problem with function print_item_table which call fmt_money internaly, and we, humble users, are not able to change that.

Good luck :)

On Friday, January 18, 2013 12:47:22 PM UTC+1, Maxwell wrote:
I'm modifying fmt_money, and form fields, so that viewing and typing is based on standard currency system or hereafter informed the currency in the transaction.

In example:
   - The currency of the price list, in order of sales.

This would help you?


2013/1/18 Zoran Djordjevic <zo...@eu-build.com>
Great!!!

Just be aware that forms do not use mt_money() function explicitly for items print, only for totals.


On Fri, Jan 18, 2013 at 12:25 PM, Maxwell Morais <ma...@gmail.com> wrote:
Dear, Zoki!

I also need this, so I'm working on this feature right now, I believe that in a few hours, the pull request, be ready!

Att
Maxwell Morais


2013/1/18 Zoki <zo...@eu-build.com>

Dear All,


As far as I could see, Print Format (in some parts) use function fmt_money() to display number to required format.

At the moment format is #,###.##

Can we somehow change that format to ie. #.###,#?

Best,

Zoran



--




--

------------------------------------------------------------

dr Zoran Đorđević, dipl.inž.građ., PMP

Direktor

 

E-mail: zo...@eu-build.com





EUBuild d.o.o



Pajsijeva 3, 11 000 Beograd

Republika Srbija



Tel/Fax: 011 26 86 707

E-mail:
of…@eu-build.com

www.eu-build.com

 




--


Maxwell Morais

(+55 11) 3931-1412 Ramal 31
 www.realizemodulados.com.br

Zoki / Max,

If you are interested, I just pushed this file yesterday (scraped from ISO and Wikipedia):

https://github.com/webnotes/wnframework/blob/master/webnotes/country_info.json

I guess I skipped the number format, but will add it too.

We will slowly integrate this deeper in the product.

best,
Rushabh


W: https://erpnext.com
T: @rushabh_mehta

On 18-Jan-2013, at 5:46 PM, Zoki <zo...@eu-build.com> wrote:


If you are member of ERPNext team and can change "internal" fmt_money, you are doing right thing! ž

If you have idea just to put new fmt_money in Print Form, we have problem with function print_item_table which call fmt_money internaly, and we, humble users, are not able to change that.

Good luck :)

On Friday, January 18, 2013 12:47:22 PM UTC+1, Maxwell wrote:
I'm modifying fmt_money, and form fields, so that viewing and typing is based on standard currency system or hereafter informed the currency in the transaction.

In example:
   - The currency of the price list, in order of sales.

This would help you?


2013/1/18 Zoran Djordjevic <zo...@eu-build.com>
Great!!!

Just be aware that forms do not use mt_money() function explicitly for items print, only for totals.


On Fri, Jan 18, 2013 at 12:25 PM, Maxwell Morais <ma...@gmail.com> wrote:
Dear, Zoki!

I also need this, so I'm working on this feature right now, I believe that in a few hours, the pull request, be ready!

Att
Maxwell Morais


2013/1/18 Zoki <zo...@eu-build.com>

Dear All,


As far as I could see, Print Format (in some parts) use function fmt_money() to display number to required format.

At the moment format is #,###.##

Can we somehow change that format to ie. #.###,#?

Best,

Zoran



--




--

------------------------------------------------------------

dr Zoran Đorđević, dipl.inž.građ., PMP

Direktor

 

E-mail: zo…@eu-build.com





EUBuild d.o.o



Pajsijeva 3, 11 000 Beograd

Republika Srbija



Tel/Fax: 011 26 86 707

E-mail:
of…@eu-build.com

www.eu-build.com

 




--


Maxwell Morais

(+55 11) 3931-1412 Ramal 31
 www.realizemodulados.com.br


Can we try something little bit simpler:

Somewhere in Setup put:

1. Date format: "dd-mm-yy", "mm-dd-yy", "yy-mm-dd",
2. Money format: "#,###.##", "#.###,##"
3. Number of decimal places for money: N

And make fmt_money() and (if exist) fmt_date() to use it.

Code for conversion between "#,###.##", "#.###,##" can be found on www.mredkj.com/javascript/nfbasic.html

Is this possible? :)


On Fri, Jan 18, 2013 at 3:18 PM, Rushabh Mehta <rm...@gmail.com> wrote:
Zoki / Max,

If you are interested, I just pushed this file yesterday (scraped from ISO and Wikipedia):


I guess I skipped the number format, but will add it too.

We will slowly integrate this deeper in the product.

best,
Rushabh


W: https://erpnext.com
T: @rushabh_mehta

On 18-Jan-2013, at 5:46 PM, Zoki <zo...@eu-build.com> wrote:


If you are member of ERPNext team and can change "internal" fmt_money, you are doing right thing! ž

If you have idea just to put new fmt_money in Print Form, we have problem with function print_item_table which call fmt_money internaly, and we, humble users, are not able to change that.

Good luck :)

On Friday, January 18, 2013 12:47:22 PM UTC+1, Maxwell wrote:
I'm modifying fmt_money, and form fields, so that viewing and typing is based on standard currency system or hereafter informed the currency in the transaction.

In example:
- The currency of the price list, in order of sales.

This would help you?


2013/1/18 Zoran Djordjevic <zo...@eu-build.com>
Great!!!

Just be aware that forms do not use mt_money() function explicitly for items print, only for totals.


On Fri, Jan 18, 2013 at 12:25 PM, Maxwell Morais <ma...@gmail.com> wrote:
Dear, Zoki!

I also need this, so I'm working on this feature right now, I believe that in a few hours, the pull request, be ready!

Att
Maxwell Morais


2013/1/18 Zoki <zo...@eu-build.com>

Dear All,


As far as I could see, Print Format (in some parts) use function fmt_money() to display number to required format.

At the moment format is #,###.##

Can we somehow change that format to ie. #.###,#?

Best,

Zoran



--




--

------------------------------------------------------------

dr Zoran Đorđević, dipl.inž.građ., PMP

Direktor


E-mail: zo…@eu-build.com





EUBuild d.o.o



Pajsijeva 3, 11 000 Beograd

Republika Srbija



Tel/Fax: 011 26 86 707

E-mail:
of…@eu-build.com

www.eu-build.com





--





--

------------------------------------------------------------

dr Zoran Đorđević, dipl.inž.građ., PMP

Direktor

E-mail: zo...@eu-build.com





EUBuild d.o.o



Pajsijeva 3, 11 000 Beograd

Republika Srbija



Tel/Fax: 011 26 86 707

E-mail:
of…@eu-build.com

www.eu-build.com

Zoran,

Thanks for looking this up and working it out for us :) This is surely possible - will push something on these lines soon.

As a side, you should also join our developer forum for more such suggestions.

https://groups.google.com/forum/?fromgroups#!forum/erpnext-developer-forum

best,
Rushabh


W: https://erpnext.com
T: @rushabh_mehta

On 18-Jan-2013, at 8:30 PM, Zoran Djordjevic <zo...@eu-build.com> wrote:

Can we try something little bit simpler:

Somewhere in Setup put:

1. Date format: "dd-mm-yy", "mm-dd-yy", "yy-mm-dd", 
2. Money format: "#,###.##", "#.###,##"
3. Number of decimal places for money: N

And make fmt_money() and (if exist) fmt_date() to use it.

Code for conversion between "#,###.##", "#.###,##" can be found on www.mredkj.com/javascript/nfbasic.html 

Is this possible? :)


On Fri, Jan 18, 2013 at 3:18 PM, Rushabh Mehta <rm...@gmail.com> wrote:
Zoki / Max,

If you are interested, I just pushed this file yesterday (scraped from ISO and Wikipedia):


I guess I skipped the number format, but will add it too.

We will slowly integrate this deeper in the product.

best,
Rushabh


W: https://erpnext.com
T: @rushabh_mehta

On 18-Jan-2013, at 5:46 PM, Zoki <zo...@eu-build.com> wrote:


If you are member of ERPNext team and can change "internal" fmt_money, you are doing right thing! ž

If you have idea just to put new fmt_money in Print Form, we have problem with function print_item_table which call fmt_money internaly, and we, humble users, are not able to change that.

Good luck :)

On Friday, January 18, 2013 12:47:22 PM UTC+1, Maxwell wrote:
I'm modifying fmt_money, and form fields, so that viewing and typing is based on standard currency system or hereafter informed the currency in the transaction.

In example:
   - The currency of the price list, in order of sales.

This would help you?


2013/1/18 Zoran Djordjevic <zo...@eu-build.com>
Great!!!

Just be aware that forms do not use mt_money() function explicitly for items print, only for totals.


On Fri, Jan 18, 2013 at 12:25 PM, Maxwell Morais <ma...@gmail.com> wrote:
Dear, Zoki!

I also need this, so I'm working on this feature right now, I believe that in a few hours, the pull request, be ready!

Att
Maxwell Morais


2013/1/18 Zoki <zo...@eu-build.com>

Dear All,


As far as I could see, Print Format (in some parts) use function fmt_money() to display number to required format.

At the moment format is #,###.##

Can we somehow change that format to ie. #.###,#?

Best,

Zoran



--




--

------------------------------------------------------------

dr Zoran Đorđević, dipl.inž.građ., PMP

Direktor

 

E-mail: zo…@eu-build.com





EUBuild d.o.o



Pajsijeva 3, 11 000 Beograd

Republika Srbija



Tel/Fax: 011 26 86 707

E-mail:
of…@eu-build.com

www.eu-build.com

 




--





--

------------------------------------------------------------

dr Zoran Đorđević, dipl.inž.građ., PMP

Direktor

 

E-mail: zo…@eu-build.com





EUBuild d.o.o



Pajsijeva 3, 11 000 Beograd

Republika Srbija



Tel/Fax: 011 26 86 707

E-mail:
of…@eu-build.com

www.eu-build.com

 


Dear Rushabh!

Realized changes in my branch of format_money, as I mentioned in the previous email, I am continuing this modification to support the entry of user data to form fields of type currency.

To check this gist prepared, with the current changes, they may be of interest.

For RSD format should be #.###,## :)



On Fri, Jan 18, 2013 at 4:23 PM, Maxwell Morais <ma...@gmail.com> wrote:
Dear Rushabh!

Realized changes in my branch of format_money, as I mentioned in the previous email, I am continuing this modification to support the entry of user data to form fields of type currency.

To check this gist prepared, with the current changes, they may be of interest.




--

------------------------------------------------------------

dr Zoran Đorđević, dipl.inž.građ., PMP

Direktor

E-mail: zo...@eu-build.com





EUBuild d.o.o



Pajsijeva 3, 11 000 Beograd

Republika Srbija



Tel/Fax: 011 26 86 707

E-mail:
of…@eu-build.com

www.eu-build.com

Max,

Great!

Will incorporate this list too.

best,
Rushabh


W: https://erpnext.com
T: @rushabh_mehta

On 18-Jan-2013, at 8:53 PM, Maxwell Morais <ma...@gmail.com> wrote:

Dear Rushabh!

Realized changes in my branch of format_money, as I mentioned in the previous email, I am continuing this modification to support the entry of user data to form fields of type currency.

To check this gist prepared, with the current changes, they may be of interest.


Dear all,

Pushed some updates to number formatting. Setting of symbol is still pending.

1. Added Number Format in Global Defaults
2. Also added many fields to Country and Currency Master.

Next step is to use them in the Print Formats.

best,
Rushabh


W: https://erpnext.com
T: @rushabh_mehta

On 19-Jan-2013, at 10:35 AM, Rushabh Mehta <rm...@gmail.com> wrote:

Max,

Great!

Will incorporate this list too.

best,
Rushabh


W: https://erpnext.com
T: @rushabh_mehta

On 18-Jan-2013, at 8:53 PM, Maxwell Morais <ma...@gmail.com> wrote:

Dear Rushabh!

Realized changes in my branch of format_money, as I mentioned in the previous email, I am continuing this modification to support the entry of user data to form fields of type currency.

To check this gist prepared, with the current changes, they may be of interest.



Great work, i woud like to make a suggestion, it woud be nice if i could disable some currencies, this will make it much simpler to select currencies from a smaller list. i think most user only use 4 or 5 currencies.



On Monday, January 21, 2013 8:11:27 AM UTC-3, Rushabh Mehta wrote:
Dear all,

Pushed some updates to number formatting. Setting of symbol is still pending.

1. Added Number Format in Global Defaults
2. Also added many fields to Country and Currency Master.

Next step is to use them in the Print Formats.

best,
Rushabh



W: https://erpnext.com
T: @rushabh_mehta

On 19-Jan-2013, at 10:35 AM, Rushabh Mehta <rm...@gmail.com> wrote:

Max,

Great!

Will incorporate this list too.

best,
Rushabh


W: https://erpnext.com
T: @rushabh_mehta

On 18-Jan-2013, at 8:53 PM, Maxwell Morais <ma...@gmail.com> wrote:

Dear Rushabh!

Realized changes in my branch of format_money, as I mentioned in the previous email, I am continuing this modification to support the entry of user data to form fields of type currency.

To check this gist prepared, with the current changes, they may be of interest.