BambooInvoice Forums

Migration to Postgres

2010-01-25T12:08:40-05:00

Did someone has migrated bamboo invoice to postgres??

I’m doing it right now and just want to know if there are any important steps.

Rounding errors

2009-09-01T08:07:23-05:00

Hi,
I was entering historic data for the first couple of months my business was operating (before I got BI working) and it came up with the following:

Amount: $90.00
Goods and Services Tax (12.500%): $11.25
Total: $101.28
Amount Paid: $101.25
Amount Outstanding: $0.03

Obviously this invoice should be closed but now shows as overdue.
There were 6 line items, each at $15.00

0 + 25 = 28 only for extremely large values of 25!

Rounding

2009-12-02T08:39:47-05:00

Hey,

First of all great program Derek, just spent a while looking around the forum and installing everything and running tests invoices.

I am running the program in GBP £ with a tax rate of 15% currently (VAT). Was there ever a fix for the rounding problems when working out VAT? For example if you were to run the settings above and create an invoice for:

3 items at £21.99 = £65.97
3 items at £16.99 = £50.97

The total will be £116.94
VAT will be £17.54

Therefore you would think that the combined total of these would be £134.48 however it is £134.49 on the actual invoice.

On the invoice summary page it does show as £134.48 though…

If I am honest I am not concerned about whether the script rounds up or down as long as it is consistent but how can one area of the program have a total of £134.48 (invoice summary page) and another have it as £134.49 (on the invoice view page)?

Also if the total on the invoice shows as £134.49 (which it does) then is it not possible to show the VAT with the extra 1p (i.e. £17.55 instead of £17.54) So that the totals tie up? But then the total on the invoice summary page would also need to match the actual invoice total too…

Does anyone know of any other ways around this problem other than not using calculations i.e. just basically entering one line per invoice with a quantity of 1???

All answers appreciated.

Thanks.

Adjusting totals at bottom

2010-03-11T08:40:51-05:00

LOVE THIS PROGRAM!!!
Is there a way of getting the invoice total to show up at the right side under the item totals?
Currently the total is showing at the left side of the form not at the right side.

Thanks.

Problesm logging in with chrome/chromium or arora

2010-03-12T23:22:39-05:00

I don’t know if this is a bug with webkit, or something else, but for some reason none of my webkit based browsers are working with my installation of bamboo invoice.

Firefox, seamonkey, and gecko based browsers are working fine.

This could be a server configuration or webkit bug, but I don’t really know where to begin tracking this down. Cookie and session issues are not something I grok yet.

I normally just let libraries take care of the nasty details and make sure I don’t lie about my character encoding.

LOGO Missing in PDF file. (pdf.php)

2010-03-12T04:33:12-05:00

Logo is missing in the pdf file output.

After generating the invoice in to PDF file Logo is completely missing.
Some times it is visible and later it is missing…..

Why is this happening? Anybody have a clue ?

Reports showing TAX in all invoices, even in those where no TAX is selected

2010-02-09T12:59:21-05:00

First off Bamboo invoice is working like a charm, and is doing everything I want it to do. There’s only 1 little problem I am facing. I own a printing business, and in my line of work some products are taxable and some are not. In my invoice if I tick no tax, it calculates the amount perfectly fine on the invoice, but when I go to the report section over there tax is calculated on each and every invoice. Even on those where tax is not applicable. Is their any way to fix this?

Will appreciate your help, as it’ll make my life much simplier during my accounts.

Thanks

Quotation / Invoice

2010-03-07T04:11:28-05:00

Hi,
It would be useful to be able to classify the documents as quotes or invoices, If created as a quote, have the option to convert to invoice. Is there an easy way i could achieve this now by modifying the template?

Keep up the good work!

Removing the invoice name limit

2010-03-10T14:21:44-05:00

Is there a line I missed?

Currently Ive been saving them as 01 then editing the invoice title i will need for my paperwork, which normally looks like

07_05-16-2009_to_05-24-2009_CBHD

invoice number, start date, end date, business code for records searching.

Obviously it doesn’t fit the 12 or so character limit

Help! sudden database error

2010-03-10T13:40:16-05:00

Today I suddenly have the following error when I click “Invoice summary”

A Database Error Occurred

Error Number: 1030

Got error 28 from storage engine

SELECT bamboo_invoices.*, bamboo_clients.name, (SELECT SUM(amount_paid) FROM bamboo_invoice_payments WHERE invoice_id=bamboo_invoices.id) AS amount_paid, TO_DAYS(bamboo_invoices.dateIssued) - TO_DAYS(curdate()) AS daysOverdue, ROUND((SELECT SUM(bamboo_invoice_items.amount * bamboo_invoice_items.quantity + (bamboo_invoice_items.amount * bamboo_invoice_items.quantity * (bamboo_invoices.tax1_rate/100 + bamboo_invoices.tax2_rate/100) * bamboo_invoice_items.taxable)) FROM bamboo_invoice_items WHERE bamboo_invoice_items.invoice_id=bamboo_invoices.id), 2) AS subtotal FROM (bamboo_invoices) JOIN bamboo_clients ON bamboo_invoices.client_id = bamboo_clients.id LEFT JOIN bamboo_invoice_items ON bamboo_invoices.id = bamboo_invoice_items.invoice_id LEFT JOIN bamboo_invoice_payments ON bamboo_invoices.id = bamboo_invoice_payments.invoice_id WHERE `client_id` IS NOT NULL GROUP BY bamboo_invoices.id HAVING (ROUND(amount_paid, 2) < ROUND(subtotal, 2) or amount_paid is null) ORDER BY dateIssued desc, invoice_number desc LIMIT 5000