BambooInvoice Forums

JPY should have 0 decimal places.

 
Jan 16, 2010 12:51am
ussher
Total Posts: 2

Hi,

Not sure if you would call this a ‘bug’ but it is a usability issue if you deal with Japanese yen.

although the settings in the admin panel under ‘invoice settings’ allow for using the currency type of JPY and the currency symbol of ¥ the output to the invoices seams to have no way to remove the decimal places.

so you get ¥15000.00 which should just be ¥15000


A second issue also along these lines is what seams to be the upper limit of the places allowed for inputting a value for the invoice.

A value of USD$150000.00 would probably be excessive for a single invoice, but a value of JPY¥150000 is a pretty common thing. (its only about USD$1500 ) but the system seams to not want to take any more than 5 digits in the ‘enter payment’ section.  When i enter a payment value of ¥150000 the ‘amount paid’ that gets deducted is ¥99999.99

Would be great if JPY was usable.

(as a side note i too would love to see the billing clients in different currencies as i sometimes do work in USD.)

Thanks for making the software installable on our own servers and GPL. Thats awesome.

     
Jan 16, 2010 02:02am
ussher
Total Posts: 2

found the issue with the 99999.99 payment amounts.  it was the database table.

Fixed it for me by changing the `bamboo_invoice_payments` table.  currently the `amount_paid` column is set to float(7,2)  by changing this to float(9,2) i can enter payment amounts above USD$1000 into the system.

(if its of use to anyone.  you do this by going into phpmyadmin and clicking on the box to the left of the `bamboo_invoice_payments` then click on the ‘change’ icon in the `amount_paid` row.)